hello friends!

am trying to setup a new installation of zenphoto and the table creation is failing.

you can see it here ::

http://avaviolette.com

any help is much appreciated!

Just taking a wild guess: I think tonight's build (assuming you're installing 1.1.7!!!) includes the fix for your problem. I had table problems with updating and saw notation on trac. sbillard said it's for new installs. So, look for 15-Jul build to be released. <nightly build>

You can either wait for tonight's nightly build or you can run setup with `?debug` after the URL. Both these will give us diagnostic information on why the tables were not created. The nightly will display the information on the setup screen. The `?debug` creates a file named setup_log.txt in your zp-core folder. In that folder is a log of everything setup attempted and the result of the attempt.

But more than likely, the MySQL Admin user you gave setup does not have permissions to create database tables.

thank you so much for your very quick responses! excellent!

will try tonight's build, but in the meantime, here are the results of the debug ::

Zenphoto Setup v1.1.7[1842]
Begin table creation
MySQL Query ( CREATE TABLE IF NOT EXISTS `zp_options` (
`id` int(11) UNSIGNED NOT NULL auto_increment,
`ownerid` int(11) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE (`name`, `ownerid`)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci; ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 8
MySQL Query ( CREATE TABLE IF NOT EXISTS `zp_tags` (
`id` int(11) UNSIGNED NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE (`name`)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci; ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 6
MySQL Query ( CREATE TABLE IF NOT EXISTS `zp_obj_to_tag` (
`id` int(11) UNSIGNED NOT NULL auto_increment,
`tagid` int(11) UNSIGNED NOT NULL,
`type` tinytext,
`objectid` int(11) UNSIGNED NOT NULL,
PRIMARY KEY (`id`)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci; ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 7
MySQL Query ( CREATE TABLE IF NOT EXISTS `zp_administrators` (
`id` int(11) UNSIGNED NOT NULL auto_increment,
`user` varchar(64) NOT NULL,
`password` text NOT NULL,
`name` text,
`email` text,
`rights` int,
PRIMARY KEY (`id`),
UNIQUE (`user`)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci; ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 10
MySQL Query ( CREATE TABLE IF NOT EXISTS `zp_admintoalbum` (
`id` int(11) UNSIGNED NOT NULL auto_increment,
`adminid` int(11) UNSIGNED NOT NULL,
`albumid` int(11) UNSIGNED NOT NULL,
PRIMARY KEY (`id`)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci; ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 6
MySQL Query ( CREATE TABLE IF NOT EXISTS `zp_options` (
`id` int(11) UNSIGNED NOT NULL auto_increment,
`name` varchar(64) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE (`name`)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci; ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 7
MySQL Query ( CREATE TABLE IF NOT EXISTS `zp_albums` (
`id` int(11) UNSIGNED NOT NULL auto_increment,
`parentid` int(11) unsigned default NULL,
`folder` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`desc` text,
`date` datetime default NULL,
`place` varchar(255) default NULL,
`show` int(1) unsigned NOT NULL default '1',
`closecomments` int(1) unsigned NOT NULL default '0',
`commentson` int(1) UNSIGNED NOT NULL default '1',
`thumb` varchar(255) default NULL,
`mtime` int(32) default NULL,
`sort_type` varchar(20) default NULL,
`subalbum_sort_type` varchar(20) default NULL,
`sort_order` int(11) unsigned default NULL,
`image_sortdirection` int(1) UNSIGNED default '0',
`album_sortdirection` int(1) UNSIGNED default '0',
`hitcounter` int(11) unsigned default 0,
`password` varchar(255) default NULL,
`password_hint` text,
PRIMARY KEY (`id`),
KEY `folder` (`folder`)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci; ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 24
MySQL Query ( CREATE TABLE IF NOT EXISTS `zp_comments` (
`id` int(11) unsigned NOT NULL auto_increment,
`ownerid` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`website` varchar(255) default NULL,
`date` datetime default NULL,
`comment` text NOT NULL,
`inmoderation` int(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `ownerid` (`ownerid`)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci; ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 12
MySQL Query ( CREATE TABLE IF NOT EXISTS `zp_images` (
`id` int(11) unsigned NOT NULL auto_increment,
`albumid` int(11) unsigned NOT NULL default '0',
`filename` varchar(255) NOT NULL default '',
`title` varchar(255) default NULL,
`desc` text,
`location` tinytext,
`city` tinytext,
`state` tinytext,
`country` tinytext,
`credit` tinytext,
`copyright` tinytext,
`commentson` int(1) NOT NULL default '1',
`show` int(1) NOT NULL default '1',
`date` datetime default NULL,
`sort_order` int(11) unsigned default NULL,
`height` int(10) unsigned default NULL,
`width` int(10) unsigned default NULL,
`mtime` int(32) default NULL,
`EXIFValid` int(1) unsigned default NULL,
`hitcounter` int(11) unsigned default 0,
`total_value` int(11) unsigned default '0',
`total_votes` int(11) unsigned default '0',
`used_ips` longtext,
PRIMARY KEY (`id`),
KEY `filename` (`filename`,`albumid`)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci; ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 27
MySQL Query ( ALTER TABLE `zp_images` ADD CONSTRAINT `zp_images_ibfk1` FOREIGN KEY (`albumid`) REFERENCES `zp_albums` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
Begin table updates
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `sort_type` varchar(20); ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `sort_order` int(11); ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `sort_order` int(11); ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `height` INT UNSIGNED; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `width` INT UNSIGNED; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `parentid` int(11) unsigned default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `mtime` int(32) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `mtime` int(32) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_options` DROP `bool`, DROP `description`; ) Failed. Error: Table 'ava_zenphoto.zp_options' doesn't exist
MySQL Query ( ALTER TABLE `zp_options` CHANGE `value` `value` text; ) Failed. Error: Table 'ava_zenphoto.zp_options' doesn't exist
MySQL Query ( ALTER TABLE `zp_options` DROP INDEX `name`; ) Failed. Error: Table 'ava_zenphoto.zp_options' doesn't exist
MySQL Query ( ALTER TABLE `zp_options` ADD UNIQUE (`name`); ) Failed. Error: Table 'ava_zenphoto.zp_options' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `commentson` int(1) UNSIGNED NOT NULL default '1'; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `subalbum_sort_type` varchar(20) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `location` tinytext; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `city` tinytext; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `state` tinytext; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `country` tinytext; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `credit` tinytext; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `copyright` tinytext; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `date` datetime default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFValid` int(1) UNSIGNED default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `hitcounter` int(11) UNSIGNED default 0; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFOrientation` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFMake` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFModel` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFExposureTime` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFFNumber` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFFocalLength` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFFocalLength35mm` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFISOSpeedRatings` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFDateTimeOriginal` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFExposureBiasValue` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFMeteringMode` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFFlash` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFImageWidth` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFImageHeight` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFContrast` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFSharpness` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFSaturation` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFGPSLatitude` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFGPSLatitudeRef` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFGPSLongitude` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFGPSLongitudeRef` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFGPSAltitude` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `EXIFGPSAltitudeRef` varchar(52) default NULL; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `image_sortdirection` int(1) UNSIGNED default '0'; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `album_sortdirection` int(1) UNSIGNED default '0'; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `total_value` int(11) UNSIGNED default '0'; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `total_votes` int(11) UNSIGNED default '0'; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `used_ips` longtext; ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `password` varchar(255) NOT NULL default ''; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `password_hint` text; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `hitcounter` int(11) UNSIGNED default 0; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_comments` ADD COLUMN `type` varchar(52) NOT NULL default 'images'; ) Failed. Error: Table 'ava_zenphoto.zp_comments' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `total_value` int(11) UNSIGNED default '0'; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `total_votes` int(11) UNSIGNED default '0'; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `used_ips` longtext; ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `custom_data` text default NULL ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `custom_data` text default NULL ) Failed. Error: Table 'ava_zenphoto.zp_images' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` CHANGE `password` `password` varchar(255) NOT NULL DEFAULT '' ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_comments` DROP FOREIGN KEY `zp_comments_ibfk1` ) Failed. Error: Table 'ava_zenphoto.zp_comments' doesn't exist
MySQL Query ( ALTER TABLE `zp_comments` CHANGE `imageid` `ownerid` int(11) UNSIGNED NOT NULL default '0'; ) Failed. Error: Table 'ava_zenphoto.zp_comments' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `dynamic` int(1) UNSIGNED default '0' ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `search_params` text default NULL ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `album_theme` text default NULL ) Failed. Error: Table 'ava_zenphoto.zp_albums' doesn't exist
MySQL Query ( ALTER TABLE `zp_comments` ADD COLUMN `IP` text default NULL ) Failed. Error: Table 'ava_zenphoto.zp_comments' doesn't exist
MySQL Query ( ALTER TABLE `zp_comments` ADD COLUMN `private` int(1) UNSIGNED default 0 ) Failed. Error: Table 'ava_zenphoto.zp_comments' doesn't exist
MySQL Query ( ALTER TABLE `zp_comments` ADD COLUMN `anon` int(1) UNSIGNED default 0 ) Failed. Error: Table 'ava_zenphoto.zp_comments' doesn't exist
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `user` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci default '' ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci default ''' at line 1
MySQL Query ( ALTER TABLE `zp_tags` CHARACTER SET utf8 COLLATE utf8_unicode_ci ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 1
MySQL Query ( ALTER TABLE `zp_tags` CHANGE `name` `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 1
MySQL Query ( ALTER TABLE `zp_administrators` CHARACTER SET utf8 COLLATE utf8_unicode_ci ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_unicode_ci' at line 1
MySQL Query ( ALTER TABLE `zp_administrators` CHANGE `name` `name` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci ) Failed. Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 1
MySQL Query ( ALTER TABLE `zp_options` ADD COLUMN `ownerid` int(1) UNSIGNED default 0 ) Failed. Error: Table 'ava_zenphoto.zp_options' doesn't exist
MySQL Query ( ALTER TABLE `zp_options` DROP INDEX `name` ) Failed. Error: Table 'ava_zenphoto.zp_options' doesn't exist
MySQL Query ( ALTER TABLE `zp_options` ADD UNIQUE `unique_option` (`name`, `ownerid`) ) Failed. Error: Table 'ava_zenphoto.zp_options' doesn't exist
Done with database creation and update

--

any thoughts?

Looks like a MySQL version incompatibility. What version of MySQL are you running?