Welcome to Geeklog, Anonymous Thursday, May 02 2024 @ 09:56 pm EDT
Geeklog Forums
1.4.0sr2 Problem with Inmemoriam.
Greetings all,
Am trying to install Inmemoriam on my home test system. I run Geeklog 1.4.0sr2 Apache 2.2.0 along with 5.0.19 MySQL, and PHP 5.1.2. The Inmemoriam distribution I have is Inmemoriam_1.0.1_1.3.11.
Ah, 1.3.11 indicates it is tested with and works with GL1.3.11, correct? Anyway onto my problem.
I get it all set up and I hit the install button on the plugin and the install fails. The log indicates a table creation statement fails.
===============================================
Tue 11 Apr 2006 13:09:47 CDT - executing CREATE TABLE gl_inm_albums (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
aid VARCHAR(128 ) NOT NULL,
path VARCHAR(255) NOT NULL,
name VARCHAR(64) NOT NULL,
description TEXT,
date_created DATETIME NOT NULL default 'NOW()',
date_lastadd DATETIME NOT NULL default '0000-00-00 00:00:00',
INDEX aid(aid),
. . .
UNIQUE aid_pid (aid,pid)
) TYPE=MyISAM
Tue 11 Apr 2006 13:09:47 CDT - 1067: Invalid default value for 'date_created'. SQL in question:
Tue 11 Apr 2006 13:09:47 CDT - Error Creating table
===============================================
Now, how important is that default date? Is there any code that relies on that date being all zeros? Could one replace it with a very early date such as "0001-01-01 00:00:01" or similar?
Thanks
Mark
http://www.wi-ski.com/
http://www.ustomas.com/
http://www.newbayanihan.org/
BTW the shortness & pudginess in my pic is exagerated by scaling!
Am trying to install Inmemoriam on my home test system. I run Geeklog 1.4.0sr2 Apache 2.2.0 along with 5.0.19 MySQL, and PHP 5.1.2. The Inmemoriam distribution I have is Inmemoriam_1.0.1_1.3.11.
Ah, 1.3.11 indicates it is tested with and works with GL1.3.11, correct? Anyway onto my problem.
I get it all set up and I hit the install button on the plugin and the install fails. The log indicates a table creation statement fails.
===============================================
Tue 11 Apr 2006 13:09:47 CDT - executing CREATE TABLE gl_inm_albums (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
aid VARCHAR(128 ) NOT NULL,
path VARCHAR(255) NOT NULL,
name VARCHAR(64) NOT NULL,
description TEXT,
date_created DATETIME NOT NULL default 'NOW()',
date_lastadd DATETIME NOT NULL default '0000-00-00 00:00:00',
INDEX aid(aid),
. . .
UNIQUE aid_pid (aid,pid)
) TYPE=MyISAM
Tue 11 Apr 2006 13:09:47 CDT - 1067: Invalid default value for 'date_created'. SQL in question:
Tue 11 Apr 2006 13:09:47 CDT - Error Creating table
===============================================
Now, how important is that default date? Is there any code that relies on that date being all zeros? Could one replace it with a very early date such as "0001-01-01 00:00:01" or similar?
Thanks
Mark
http://www.wi-ski.com/
http://www.ustomas.com/
http://www.newbayanihan.org/
BTW the shortness & pudginess in my pic is exagerated by scaling!
7
23
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Sounds like the problem is actually MySQL 5 which has a new "strict" mode that complains about things that earlier versions happily accepted. You can switch these new checks off, e.g.
These things should be fixed eventually, of course. I guess Machinari didn't test with MySQL 5 yet (and his is not the only plugin having that problem).
bye, Dirk
Text Formatted Code
set global sql_mode='ALLOW_INVALID_DATES';These things should be fixed eventually, of course. I guess Machinari didn't test with MySQL 5 yet (and his is not the only plugin having that problem).
bye, Dirk
6
8
Quote
Status: Banned
machinari
Forum User
Full Member
Registered: 03/22/04
Posts: 1512
Quote by Dirk: I guess Machinari didn't test with MySQL 5 yet (and his is not the only plugin having that problem).
bye, Dirk
yes yes.. but I'm planning on it--eventually bye, Dirk
8
6
Quote
My Bad,
The install is complaining about the NOW() function used to populate the date_created column.
Searching about the NGs shows other ways to specify the current date & time are those okay?
http://www.wi-ski.com/
http://www.ustomas.com/
http://www.newbayanihan.org/
BTW the shortness & pudginess in my pic is exagerated by scaling!
The install is complaining about the NOW() function used to populate the date_created column.
Searching about the NGs shows other ways to specify the current date & time are those okay?
http://www.wi-ski.com/
http://www.ustomas.com/
http://www.newbayanihan.org/
BTW the shortness & pudginess in my pic is exagerated by scaling!
7
8
Quote
Status: Banned
machinari
Forum User
Full Member
Registered: 03/22/04
Posts: 1512
you know that there is a version out for gl1.4... find it at my site. it is being rewritten at the moment.
9
7
Quote
Where is the code for the table creation located? I've grepped and grepped and can not find anything that looks like the offending table create statement.
http://www.wi-ski.com/
http://www.ustomas.com/
http://www.newbayanihan.org/
BTW the shortness & pudginess in my pic is exagerated by scaling!
http://www.wi-ski.com/
http://www.ustomas.com/
http://www.newbayanihan.org/
BTW the shortness & pudginess in my pic is exagerated by scaling!
6
9
Quote
Status: Banned
machinari
Forum User
Full Member
Registered: 03/22/04
Posts: 1512
geeklog/sql/sql_install.php
7
6
Quote
Status: offline
markf
Forum User
Newbie
Registered: 07/25/05
Posts: 13
Location:Appleton
Got it!
I went into the SQL source and removed all default NOW() clauses as searching code it does look like all insert statements insert NOW() to those fields.
So I have Inmemoriam up and running and like its seamless look with my custom hacked theme! Cool!
However, I have to setup the GD libs, as I see text links to my photos but not the photos and my apache error log is telling me Call to undefined method PEAR_Error::load() fails. I saw the litle discussion on that one here and am taking the required steps. However, I wonder if I will be able to install such libraries on the my production web host servers.
Thanks.
http://www.wi-ski.com/
http://www.ustomas.com/
http://www.newbayanihan.org/
BTW the shortness & pudginess in my pic is exagerated by scaling!
I went into the SQL source and removed all default NOW() clauses as searching code it does look like all insert statements insert NOW() to those fields.
So I have Inmemoriam up and running and like its seamless look with my custom hacked theme! Cool!
However, I have to setup the GD libs, as I see text links to my photos but not the photos and my apache error log is telling me Call to undefined method PEAR_Error::load() fails. I saw the litle discussion on that one here and am taking the required steps. However, I wonder if I will be able to install such libraries on the my production web host servers.
Thanks.
http://www.wi-ski.com/
http://www.ustomas.com/
http://www.newbayanihan.org/
BTW the shortness & pudginess in my pic is exagerated by scaling!
4
7
Quote
All times are EDT. The time is now 09:56 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content