Hi all, I have installed ZenPhoto countless times before without any issues at all. However, just went to install v1.2.1 again (yup, it worked last time I did this, same server configuration etc...) and it gave the following:

`
About to create tables...
Table creation failure: BLOB/TEXT column 'title' can't have a default value
Table creation failure: BLOB/TEXT column 'title' can't have a default value
Table creation failure: Table 'gallery.zp_images' doesn't exist
Zenphoto Error
MySQL Query ( SELECT * FROM [code]zp_albums[/code] ) failed. Error: Table 'gallery.zp_albums' doesn't exist
It looks like your zenphoto tables haven't been created. You may need to run the setup script.
`
Anyone got any ideas? - I'm running php v5.2.6 and MySQL v5.0.51a all locally using Apache v2.0.63.

Ta in advance, CR

This is corrected in the nightly builds. You probably changed versions of MySQL.

Ahh more than likely - in fact if memory serves I think I was running MySQL v4.x.x before. Where can I download the latest nightly from again? I did have it in an email but you know...

Cheers once again

CR

http://www.zenphoto.org/files/nightly/

Lol just found it from the Wiki and was about to post it here

Thanks matey, I'll install now and lt you know if it works correctly or not - might also be an idea to update the main v1.2.1 download on the site to reflect the installation changes/updates to save others the same issues that are running MySQL v5.x.x

Thanks again,

CR

And now I get the following:

`
About to create tables...
Table creation failure: BLOB/TEXT column 'place' can't have a default value
Zenphoto Error
MySQL Query ( SELECT * FROM [code]zp_albums[/code] ) failed. Error: Table 'gallery.zp_albums' doesn't exist
It looks like your zenphoto tables haven't been created. You may need to run the setup script.
`
This is running the latest nightly build, namely 'zenphoto-2008-11-05-trunk.zip 05-Nov-2008 23:00 2.6M'.

I assume ZenPhoto works with my version of MySQL?

Any help would be great

CR

UPDATE

For the time being I have managed to find a backup from my old installation of version 1.2 [2213] - this installed fine... So, the question is, whats the difference to this and the latest nightly...?

The definition of the fields.

The bit with the 'place' column was really screwed up. It will be corrected in the next nightly build. MySQL must be getting more particular since these have not caued problems on previous versions. (Even if they are incorrect!)