ZenphotoCMS Forum
Database error after setup - Printable Version

+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Database error after setup (/thread-1241.html)



Database error after setup - sasole - 2007-03-03

Something went wrong whith the installation. I'm getting the following database error:

MySQL Query ( SELECT folder, sort_order FROM db2_albums ORDER BY sort_order ) Failed. Error: Table 'lionheartn2.db2_albums' doesn't exist

What can I do?
Thanks, sasole




Database error after setup - AlexWilson - 2007-03-03

Is this after pointing your browser at /gallery/zen/setup.php, and did that complete without any errors?




Database error after setup - sasole - 2007-03-03

yes it was after and without errors...




Database error after setup - sasole - 2007-03-03

I checked the database whith phpmyadmin and saw no tables for zenphoto at all.




Database error after setup - AlexWilson - 2007-03-03

Strange... if you look in config.php you can see the SQL it is trying to run to create the tables and indicies -- you could try running them from phpmyadmin.




Database error after setup - sasole - 2007-03-03

I tried it again this time yet on another server and it works!
Thank anyway for your quick support.
sasole




Database error after setup - Chilifrei64 - 2007-03-03

not that I guess I should have or anything but I logged in using the information you provided(which i will removed after this post) and logged onto your installation.
http://webdingen.com/zenphoto/

You hadn't run setup.php
I ran through the setup.php and the error is gone. Now you just need to add some photos to make sure the rest works.




Database error after setup - AlexWilson - 2007-03-03

In your first message, it appears your database prefix is db2_, in the script you posted it's zen, did you switch it between installs?




Database error after setup - sasole - 2007-03-03

Yes it were different ones but you were right and I replaced my previous topic (cause of security) before I saw your answer. Thanks again for the quick support!