Session Error on Admin/index.php page - local server

[DavidC3084]

Fatal error: Call to a member function Execute() on a non-object in C:\WebSites\zen-cart-v1.3.5-full-fileset-09042006\zen-cart-v1.3.5-full-fileset-09042006\includes\functions\sessions.php on line 74

Get the above error msg. Have isolated error to $db->Execute($qid) command in the function _sess_write(..). Have viewed sql statement via echo ($qid) and pasted in MySQL query browser and executed successfully. Below is an example of sql statement that is failing

insert into sessions values ('76h3k9d1itsmkiod2d9hm78tl3', '1159907571', 'language|s:7:\"english\";languages_id|s:1:\"1\";languages_code|s:2:\"en\";selec ted_box|s:13:\"configuration\";html_editor_preference_status|s:4:\"NONE\";')

This is a new install w/ php 5 and mysql 5. Thanks.

[dbltoe]

If you are hosting yourself, you might want to back off on the mysql.

http://www.zen-cart.com/wiki/index.php/Installation

[DavidC3084]

locally installed for now. can you be more specific on 'backing off' are you implying that I should user an earlier version of mySQL?

[dbltoe]

The link I sent talks about the various combinations of PHP and MySQL and how they interact.
Since Zen versions below 1.3.x don't work with MySQL 5 and Zen 1.3.x and up don't use the advanced features of MySQL 5, I've had better luck backing off of 5 to a more useable 4.x.
I've found that the Zen developers are Very good about keeping as close as possible to the latest PHP and MySQL. Most other programs either lag farther behind or blindly jump to the latest version without testing.
Hats off to the team for their measured constraint.

[BlindSide]

I think you searching "too deep." Look at your URL...

C:\WebSites\zen-cart-v1.3.5-full-fileset-09042006\zen-cart-v1.3.5-full-fileset-09042006\includes\functions\sessions.php

You have the folder nested within itself. Did you intend to do that?

[DavidC3084]

re-installed mysql to version 4 and re-installed zen cart w/ different naming convention. unfortunately still getting same errors on session.php.

Fatal error: Call to a member function Execute() on a non-object in C:\WebSites\zen-cart-v1.3.5\zen-cart\includes\functions\sessions.php on line 61

This is really confusing, because some of the db->execute commands are working, but certain ones fail. Admin

Store works fine. Can create a new login (customer) saves record, etc. so its something about session creation process that is failing.

[DrByte]

PHP5 has done some things differently with sessions. Not sure exactly the rest of your configuration in order to comment.

If you put it up on a traditional webserver, you'll find it works properly.

You might try downgrading to PHP4. At least to narrow down whether your PHP configuration is the issue or not.

Or you could post a link to your zc_install/techsupp.php or at least its output ...

[bugmenot]

I'm also experiencing this (Windows, PHP 5.2.0RC4, MySQL 5.0.18). As a workaround during the installation you can select to store the sessions in a file instead of the in the database.

[BlindSide]

Downgrading PHP to v4 is definitely your best bet. Like most PHP-based software, Zen is not fully compatible with PHP 5 just yet.