Member
Member
sairuh   2007-11-08, 20:33
#1
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.)
Member
Member
TheBLIONCorp   2007-11-08, 21:11
#2
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.
Member
Member
sairuh   2007-11-09, 01:37
#3
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...
Member
Member
sairuh   2007-11-09, 01:39
#4
Yep, that did the trick! Guess the table name is simply options, not zenphoto_options. Smile
  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.