DB error on admin only

[kozmick]

Greetings:

I've just moved zen from localhost win XP Pro SP2 server to shared linux server(godaddy.com):

http://kozmick.com/store

1. Did a fresh install of zen as a available add-on app on the linux server which created the DB with no db_ prefix...2. Uploaded/overwrote all the files from localhost EXCEPT inlcudes/configure.php and admin/configuration.php
3. Exported the DB from localhost(mysql ver 4.1)
4. "Successfully" imported the DB(mysql ver 5.0) to the Linux DB...all field names, table count and number of records are identical to localhost DB.

Btw, any known issues exporting 4.1 to 5.0? Mysql support says shouldn't be a problem as long as going up and not backwards(?:)

Anyway...everything looks good...all images and products are displayed correctly so DB is connected etc.

...verified includes/configure.php is correct (made db_ prefix nul)

Here's the rub...when I invoke kozmick.com/store/admin and ONLY when invoke admin, I get:

1146 Table 'koz0805306243218.zen_project_version' doesn't exist
in:
[select * from zen_project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Searched the forum...up, down continuous and often...can't seem to find this situation only occuring when invoking admin(?)

Any help greatly appreciated.

Thanks, Mick

[DrByte]

1146 Table 'koz0805306243218.zen_project_version' doesn't exist
in:
[select * from zen_project_version WHERE project_version_key = 'Zen-Cart Database' ]

koz0805306243218 = the name of the database it's looking at, according to your /admin/includes/configure.php file
zen_ = the DB_PREFIX setting that it's finding in your /admin/includes/configure.php file.

Are you sure the upload of changes to the file worked correctly? Or did it fail because the file was read-only and needs to be made writable in order to upload, and then read-only again when done?

[kozmick]

Thanks Doc...

Well here's the error message I now get when I invoke .../store/admin.

Seen this one before?

Thanks, Mick

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/content/k/o/z/kozmick/html/store/admin/includes/configure.php:183) in /home/content/k/o/z/kozmick/html/store/includes/functions/sessions.php on line 108

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/content/k/o/z/kozmick/html/store/admin/includes/configure.php:183) in /home/content/k/o/z/kozmick/html/store/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/content/k/o/z/kozmick/html/store/admin/includes/configure.php:183) in /home/content/k/o/z/kozmick/html/store/admin/includes/init_includes/init_templates.php on line 36

Warning: Cannot modify header information - headers already sent by (output started at /home/content/k/o/z/kozmick/html/store/admin/includes/configure.php:183) in /home/content/k/o/z/kozmick/html/store/admin/includes/functions/general.php on line 21

[DrByte]

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/content/k/o/z/kozmick/html/store/admin/includes/configure.php:183) in ...

FAQ: https://www.zen-cart.com/tutorials/index.php?article=87

[kozmick]

Thanks Doc...yeap...that did it....everything up and running.

It appears that my text editor was configured incorrectly re CR/LF plus the fact that I somehow inadvertently added some CR/LFs at the very end of the file...dumb...

FWIW, The culprit that was causing all the mischief was in fact 2 CR/LFs after the terminating "?>" at the very end of the file, which the debug error message pointed to the line no. right after the file name...impressive...hmmm...very touchy this Mr. Php.

Cheers, Mick