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.

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.