1146 Table 'configuration' doesn't exist

[Friedrich72]

Hello, Dr. Byte, I have a very similar problem that I have been diligently searching to fix but have reached an end.
Maybe our problems are the same.

Seems very simple, I am doing a fresh install but I get a blank screen when clicking the "begin install" link.
I have installed multiple Zen Cart stores on various servers and results are always positive. And the installation is always the easiest part of ZC.

This is the second store on this server that I am installing. Created a new database for it. I want to eliminate the other store once this one is running. I am sure that I am not crossing my info in the config files.

Zen Cart vrersion 1.3.9e
PHP 5.0
Clean install.
No addons.
No customization.

The Error I get is "1146 Table 'db336628037.palmco_configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from palmco_configuration]"

You can see it here http://www.palmco.com/palmco_site/

Well, of course it doesn't exist! It's a clean install.

I have tried uploading the entire contents multiple times, deleting then uploading again, leaving the config files unchanged, and adding info to the config files.

I have faq'ed and searched forums and found that it may be the "strict mode" of mySQL on my server.
I went to disable "strict mode" with SQL query but I was not authorized.
Called hosting suppport and they indicated to change "my.ini" to disable the "strict mode."

I also found something in the Zen Cart Wiki that said to change the strict mode by altering "query_factory.php" and "install.php" but my code looked different than the wiki example so I didn't want to make it worse by changing it.

That's where I am now. I can't find any "my.ini" file to alter for strict mode.

Is that what I need to do? Can you tell me where to find the "my.ini" file?

Thank you very much for your help!

[Friedrich72]

in addition, I found 5 files in the cache folder that I put direct path to in the config files.

they showed this error.

[08-Aug-2010 17:33:45] PHP Fatal error: Call to undefined function: date_default_timezone_get() in /.../.../.../.../.../zc_install/includes/application_top.php on line 52

Also, very strange, some of the file sizes in filezilla do not match on the server. They appear to be lower by a few bytes. And when I go to overwrite they dont change.

Starting to look like an ftp error.
Any idea?

[Friedrich72]

update: spoke with hosting service about file size discrepancy and they asked me to remove my files, close filezilla and check back in 30min.

[Friedrich72]

update: file size discrepancy is normal when loading from windows OS to Linux concerning php files. image files are the same file size.

So I am back to my original request.
Any thoughts on the "strict mode" and the my.ini file?

Thank you in adv. for taking a look.

[DrByte]

Is your MySQL actually running in STRICT_TRANS mode?

[Friedrich72]

Not sure. How can I check?
Hosting provider indicated that php 5.0 is in Strict Mode by default and that I would have to change it in the my.ini file.

Is that synonymous with "strict trans" mode?

[Friedrich72]

Update: Deleted all files from server. Uploaded 1.3.8a and it seems to work fine.
No blank page.

I would really prefer to use 1.3.9 considering the changes I would have to make to do the upgrade.

What do you recommend?

[DrByte]

http://www.zen-cart.com/forum/showpo...23&postcount=5

[Friedrich72]

thank you. worked just fine.