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

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.

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.

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

Sorry, after doing a lot more reading it looks like this was fixed. I downloaded the lastest nightly and the problem went away.

Always faster to do the research first

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

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.)

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.

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)

Sorry, I have no idea what this error means.

Cool. I will play with it a little more. If I can't get it...

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.

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.

I checked the table and the datatype is TEXT, it is a requried field, the default value is NULL.

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?