ZenphotoCMS Forum
unable to upgrade to v1.1.1 - 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: unable to upgrade to v1.1.1 (/thread-1774.html)



unable to upgrade to v1.1.1 - sairuh - 2007-11-08

Hallo!

I've got a local installation of ZenPhoto 1.0.8 (under MAMP 1.6.1 on Mac OX Tiger), and was thrilled to hear about v1.1.1. I tried to run upgrade.php, but got the following error:

MySQL Query ( SELECT ``name, value FROM options ) Failed. Error: Table 'zenphoto.options' doesn't exist

Sure enough, there's no table called zenphoto.options. What workarounds are for this?

Some server info:

  • Apache 2.0.59
  • MySQL 5.0.37
  • PHP 5.2.1

Thanks in advance! (I'm hoping to replace Gallery2, and ZenPhoto looks like a great candidate.)




unable to upgrade to v1.1.1 - TheBLIONCorp - 2007-11-08

Try to create it manually:

CREATE TABLE zenphoto_options (
id int(11) unsigned NOT NULL auto_increment,
name varchar(64) NOT NULL,
value text,
PRIMARY KEY (id),
UNIQUE KEY name (name)
) ENGINE=MyISAM ;

It should work better after that...
There is a bug about the install script.




unable to upgrade to v1.1.1 - sairuh - 2007-11-09

Thanks for your response, TheBLIONCorp --however, I still get the error. Unless the table name should have a period in the middle, instead of the underscore? I'll try that out...




unable to upgrade to v1.1.1 - sairuh - 2007-11-09

Yep, that did the trick! Guess the table name is simply options, not zenphoto_options.