Database Error after Installation

[matthewb]

I have installed ZC and I cannot access the admin pages

zc_install determines

System Inspection Results

• Webserver = Apache/2.0.59 (FreeBSD) PHP/5.2.0
• HTTP Host = www.phskhockey.org.au
• Path_Translated = /home/phskhockey/public-html/zen-cart/zc_install_done/index.php(SCRIPT_FILENAME)
• Server Free Disk Space = 210.49 GB
• PHP O/S = FreeBSD
• PHP API Mode = apache2handler
• PHP Max Execution Time per page = 60
• Register Globals = OFF
• MySQL Support = ON
• MySQL Version = 5.0.27 Click here for more info
• PHP Version = 5.2.0
• PHP Safe Mode = OFF
• PHP Sessions Support = ON
• PHP Session.AutoStart = OFF
• PHP session.use_trans_sid = OFF
• Current SQL Cache Folder = /home/phskhockey/public-html/zen-cart/cache -->Writeable
• Suggested SQL Cache Folder = /home/phskhockey/public-html/zen-cart/cache
• PHP magic_quotes_runtime setting = OFF
• PHP GD Support = ON
• GD Version = GD bundled (2.0.28 compatible)
• PHP ZLIB Compression Support = ON
• PHP cURL Support = OFF Click here for more info
• PHP Upload Support = ON upload_max_filesize=8M; post_max_size=8M
• PHP Upload TMP dir =

The error occurs when I attempt to admin login

Fatal error: Call to a member function Execute() on a non-object in ... /zen-cart-v1.3.6-full-fileset-10272006/includes/functions/sessions.php on line 61

I included some debugs in sessions.php which indicate that the database factory object $db does not exist at that point.

problem occurs in includes/functions/sessions.php


$qid = "select count(*) as total
from " . TABLE_SESSIONS . "
where sesskey = '" . zen_db_input($key) . "'";


>> $total = $db->Execute($qid);


I added some echos in sessions.php


$qid = "select count(*) as total
from " . TABLE_SESSIONS . "
where sesskey = '" . zen_db_input($key) . "'";

echo "DEBUG query = <BR>\n" . $qid . "<br>\n" ;

echo "DEBUG isset(\$db)=" . isset($db) . "<BR>\n" ;

$total = $db->Execute($qid);


When running in admin login they show

the admin login box and
DEBUG query =
select count(*) as total from zen_sessions where sesskey = '084871d5163abc9d8da5753de018917e'
DEBUG isset($db)=

Running from ZC shows a similar problem has occured but the ZC default page looks well formed and highly functional

[DrByte]

Matthew,
Welcome to Zen Cart

You've stumbled on a problem related to changes introduced by PHP in their 5.2.0 release.

Here's a workaround:

http://www.zen-cart.com/forum/showpo...7&postcount=26

[matthewb]

THat was quick !!

Good One

Has fixed the problem . . . ( and why didn;t I think of that approach myself :)

MB