Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Error on installing.  (Read 4861 times)

0 Members and 1 Guest are viewing this topic.

tobyc

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Error on installing.
« on: October 02, 2005, 02:32:53 pm »

PHP Version :  5.0.4
MySQL Version : 5-04 Beta
OS: Windows XP SP2

When installing coppermine 1.4 on the above platform I get the following error message, I pressume it has something to do with the part in red any ideas?:

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'
« Last Edit: October 03, 2005, 07:24:45 am by GauGau »
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Error on installing.
« Reply #1 on: October 02, 2005, 11:31:20 pm »

There is no support for the beta version.  There are no known problems when installing 1.4.x, so I don't think this is a valid bug report.

If you want support, please use the stable (1.3.5) version.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

tobyc

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Error on installing.
« Reply #2 on: October 03, 2005, 11:19:29 am »

I would say its a valid bug, downgraded mysql to 4.1 and it works fine...
Logged

artistsinhawaii

  • VIP
  • Coppermine addict
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 856
    • evj art and photography
Re: Error on installing.
« Reply #3 on: October 03, 2005, 11:28:44 am »

I would say its a valid bug, downgraded mysql to 4.1 and it works fine...

Ah, but a bug with which? Beta Mysql? or Beta Cpg1.4.x?

I think it was Confusius who said, "Mo' beta to avoid judgin' beta on a beta."

Sounds more like backward compatibiity issues with mysql5.x, maybe a register_long_arrays = On type error?  <shrug>  Seems to be a lot of that going on even with 1.3.x.

Dennis
Logged
Learn and live ... In January of 2011, after a botched stent attempt, the doctors told me I needed a multiple bypass surgery or I could die.  I told them I needed new doctors.

DJMaze

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 831
    • Dragonfly CMS
Re: Error on installing.
« Reply #4 on: October 03, 2005, 02:14:40 pm »

I thought there was a rule as well to only report bugs on the latest beta, MySQL is at version 5.0.13 :P
Logged
There are 2 kinds of users in this world: satisfied and complainers.
Why do we never hear something from the satisfied users?
http://coppermine-gallery.net/forum/index.php?topic=24315.0

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Error on installing.
« Reply #5 on: October 03, 2005, 02:22:02 pm »

Using mysql beta versions is not recommended at all unless you really, really know your way around in mysql extremely well. Posting a bug report on the coppermine forums is completely invalid. Report your bug @ mysql if you like.
Logged

Andi

  • VIP
  • Coppermine regular visitor
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 85
  • Join the Future
    • www.pragmamx.org
Re: Error on installing.
« Reply #6 on: October 28, 2005, 08:07:29 pm »

Hi :)

a Betatester of our pragmaMx-Port has the same Problem.
He uses MySQL-Version: 5.0.6.

Here is the fast and easy solution:
Edit file sql/schema.sql at line #118
change
Code: [Select]
  mtime datetime NULL default '',
to:
Code: [Select]
  mtime datetime NULL default NULL,

the complete sql-statement is then:
Quote
CREATE TABLE CPG_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 NULL,
  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;
Logged
hope, I could help you... :)
Pages: [1]   Go Up
 

Page created in 0.032 seconds with 19 queries.