+- 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: I have a MySQL error anyone know? (/thread-2340.html)
I have a MySQL error anyone know? - squirrel83 - 2008-03-05
Just installed all connections are fine except . . .
Zenphoto Error
MySQL Query ( INSERT INTO zp_options (name, value) VALUES ('zenphoto_release','1219') ) Failed. Error: Table 'squirre_zp.zp_options' doesn't exist
It looks like your zenphoto tables haven't been created. You may need to run the setup script.
I have a MySQL error anyone know? - sbillard - 2008-03-06
can you post a link to your site? The error says that the options table did not get created. That should have happened when you ran setup before it tries to update the release option. So, can you look at your database and see if there is a table zp_options?
I have a MySQL error anyone know? - squirrel83 - 2008-03-06
yeah
by the way I get the following . . No tables found in database
http://www.asnd16.com/eye/zenphoto/
I have a MySQL error anyone know? - sbillard - 2008-03-06
Well, there should have been tables creted in the database by setup. There is nothing indicated that would cause that problem. Maybe Tris will have an idea.
I have a MySQL error anyone know? - squirrel83 - 2008-03-07
Could the following be an issue?
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ~/eye/zenphoto/zp-core/setup.php on line 51
I have a MySQL error anyone know? - sbillard - 2008-03-07
That is more of a symptom. The problem is that the tables were not created the way they should have been.