Home› General support

Error when creating tables

Chief Member
in General support
When I try the standard 1.6 build it gives an error message about gettext on whatever line it is and won't even bring up the setup.php page when trying to install. If I use the nightly builds (I've tried several) it won't progress past the set up page.

http://mark.thelatchofficial.com/zenphoto/zp-core/setup.php

As you can see it ticks all the approrpriate boxes but when I hit GO I get the following error

'
Zenphoto Error
MySQL Query ( SELECT * FROM `zp_albums` ) Failed. Error:Table 'mark_chief.zp_albums' doesn't exist
It looks like your zenphoto tables haven't been created.You may need to run the setup script.'

The user has "all" access to the database.

Thanks for any help and taking the time to read this.
Mark

Comments

  • sbillard Member
    The error messages you got from setup are `warnings` since we do not know if they may cause you problems. The `gettext()` one would only be a problem if you wish a language other than English. (But be aware that the standard 1.1.6 `gettext()` substitution library has a flaw in it for some servers so you may get error messages about a missing function.)

    The MySQL permissions is potentially more serious. In your case it is a show stopper. Setup must be able to create database tables in your database for the program to work. In your case it apparently cannot.

    You will need to insure that the user you assigned for zenphoto has complete database permissions. It apparently does not have the permissions to at least create database tables.
  • Chief Member
    The server im using uses Cpanel as its admin options for my particular bit of the websapce. I create a database which is as simple as creating a name and entering it. I then create a user i.e. name and password, it then has an option to link it to a database so I select the user then the database and have a tick box for all permissions. I have tried it in other combinations by clicking seperate boxes for delete, update, add etc etc.

    Ive had an older version working before so am confused as to why this is happening.
  • Express Member
    I'm having some problems creating two tables as well when I click 'GO'. I am using MySQL 5.x. Here is a snip from the debug log. Let me know if you want more.

    Begin table creation
    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` text NOT NULL default '',
    `desc` text,
    `date` datetime default NULL,
    `place` text default NULL default '',
    `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: BLOB/TEXT column 'title' can't have a default value
    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` text NOT NULL default '',
    `desc` text,
    `location` text,
    `city` tinytext,
    `state` tinytext,
    `country` tinytext,
    `credit` text,
    `copyright` text,
    `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: BLOB/TEXT column 'title' can't have a default value
  • Express Member
    Sorry, after doing a lot more reading it looks like this was fixed. I downloaded the lastest nightly and the problem went away.
  • sbillard Member
    Always faster to do the research first:)
  • Express Member
    New error when adding a new alblum. I'm not sure how to move past this one.

    Zenphoto Error
    MySQL Query ( INSERT INTO `zp_albums` (`folder`, `title`) VALUES ('family', 'family'); ) failed. Error: Field 'place' doesn't have a default value
  • sbillard Member
    What is the field type of your `place` field in the albums table? It should be TEXT, which is not allowed to have a default value (at least in the newer MySQL versions.)
  • Express Member
    I really don't know how to tell. This is the first time I have ever used mysql. I could delete the database and let setup recreate it. Its a brand new install.
  • Express Member
    I removed the entire install + database, recreated the database, dropped the latest install on the web server and ran the setup. Below is a snip of the error log.

    MySQL Query ( CREATE TABLE IF NOT EXISTS `zp_captcha` (
    `id` int(11) UNSIGNED NOT NULL auto_increment,
    `ptime` int(32) UNSIGNED NOT NULL,
    `hash` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
    ) CHARACTER SET utf8 COLLATE utf8_unicode_ci; ) Failed. Error: Can't create table '.\zenphoto\zp_captcha.frm' (errno: 121)
    MySQL Query ( CREATE TABLE IF NOT EXISTS `zp_options` (
    `id` int(11) UNSIGNED NOT NULL auto_increment,
    `ownerid` int(11) UNSIGNED NOT NULL DEFAULT 0,
    `name` varchar(255) NOT NULL,
    `value` text NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE (`name`, `ownerid`)
    ) CHARACTER SET utf8 COLLATE utf8_unicode_ci; ) Failed. Error: Can't create table '.\zenphoto\zp_options.frm' (errno: 121)
    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: Can't create table '.\zenphoto\zp_tags.frm' (errno: 121)
    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: Can't create table '.\zenphoto\zp_obj_to_tag.frm' (errno: 121)
    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: Can't create table '.\zenphoto\zp_administrators.frm' (errno: 121)
    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: Can't create table '.\zenphoto\zp_admintoalbum.frm' (errno: 121)
    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: Can't create table '.\zenphoto\zp_options.frm' (errno: 121)
    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` text NOT NULL,
    `desc` text,
    `date` datetime default NULL,
    `place` text,
    `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: Can't create table '.\zenphoto\zp_albums.frm' (errno: 121)
    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: Can't create table '.\zenphoto\zp_comments.frm' (errno: 121)
    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` text NOT NULL,
    `desc` text,
    `location` text,
    `city` tinytext,
    `state` tinytext,
    `country` tinytext,
    `credit` text,
    `copyright` text,
    `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,
    `thumbX` int(10) unsigned default NULL,
    `thumbY` int(10) unsigned default NULL,
    `thumbW` int(10) unsigned default NULL,
    `thumbH` 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: Can't create table '.\zenphoto\zp_images.frm' (errno: 121)
  • sbillard Member
    Sorry, I have no idea what this error means.
  • Express Member
    Cool. I will play with it a little more. If I can't get it...
  • Express Member
    OK. I downloaded the new Nightly and used the defaul database 'mysql' and was able to get past the setup. When I tried to upload the first pic I received this error again.

    MySQL Query ( INSERT INTO `zp_albums` (`folder`, `title`) VALUES ('family', 'family'); ) failed. Error: Field 'place' doesn't have a default value

    I figure out how to check whats in the table and the defaul value is NULL. Any ideas?

    Also, I have been negligent in saying thanks for your time so far in helping me get this setup.
  • sbillard Member
    The `place` column should be of typt TEXT which does not get a default. Check to see if it is TEXT. If not make it so.
  • Express Member
    I checked the table and the datatype is TEXT, it is a requried field, the default value is NULL.
  • sbillard Member
    Well, then I certainly do not understand the error message which is saying that there "'place' doesn't have a default value". How is that possible if as you say hte default value is NULL?
Sign In or Register to comment.