Testing Coppermine on my PC Testing Coppermine on my PC
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Testing Coppermine on my PC

Started by sam0, December 29, 2005, 02:09:52 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

sam0

Hello,
I want to make my own theme for Coppermine so I really have to do this offline.
I installed latest version of XAMPP and ImageMagick but I keep getting some weird MySQL Errors when I try to install Coppermine. Like this :

mySQL Error: Invalid default value for 'mtime' on query ' CREATE TABLE cpg140_pictures ( pid int(11) NOT NULL auto_increment, aid int(11) NOT NULL default '0', filepath varchar(255) NOT NULL default '', filename varchar(255) NOT NULL default '', filesize int(11) NOT NULL default '0', total_filesize int(11) NOT NULL default '0', pwidth smallint(6) NOT NULL default '0', pheight smallint(6) NOT NULL default '0', hits int(10) NOT NULL default '0', mtime datetime NULL default '', ctime int(11) NOT NULL default '0', owner_id int(11) NOT NULL default '0', owner_name varchar(40) NOT NULL default '', pic_rating int(11) NOT NULL default '0', votes int(11) NOT NULL default '0', title varchar(255) NOT NULL default '', caption text NOT NULL, keywords varchar(255) NOT NULL default '', approved enum('YES','NO') NOT NULL default 'NO', galleryicon int(11) NOT NULL default '0', user1 varchar(255) NOT NULL default '', user2 varchar(255) NOT NULL default '', user3 varchar(255) NOT NULL default '', user4 varchar(255) NOT NULL default '', url_prefix tinyint(4) NOT NULL default '0', randpos int(11) NOT NULL default '0', pic_raw_ip tinytext, pic_hdr_ip tinytext, lasthit_ip tinytext, PRIMARY KEY (pid), KEY owner_id (owner_id), KEY pic_hits (hits), KEY pic_rate (pic_rating), KEY aid_approved (aid,approved), KEY randpos (randpos), KEY pic_aid (aid), position INT(11) NOT NULL default '0', FULLTEXT KEY search (title,caption,keywords,filename) ) TYPE=MyISAM'

When I created DB in phpMyAdmin I used (default) Collation, was I suppose to choose something else ?
Can someone please help, I really need this and I don't know much about PHP/MySQL :(
I installed Textpattern and it's working without problems.

Nibbler

Install the latest stable version, currently 1.4.3

sam0

it works now, thanks :)
the best gallery script, keep up the good work  8)