unable to upgrade to v1.1.1

sairuh

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.)

TheBLIONCorp

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.

sairuh

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...

sairuh

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