hello friends!
am trying to setup a new installation of zenphoto and the table creation is failing.
you can see it here ::
any help is much appreciated!
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?