Home› General support

Installation Unable to Create Tables

vavrek Member
in General support
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!

Comments

  • macalter Member
    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>
  • sbillard Member
    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.
  • vavrek Member
    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?
  • sbillard Member
    Looks like a MySQL version incompatibility. What version of MySQL are you running?
Sign In or Register to comment.