Posted on: 04/11/06 02:40pm
By: markf
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
1.4.0sr2 Problem with Inmemoriam.
Posted on: 04/11/06 02:49pm
By: Dirk
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.
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
1.4.0sr2 Problem with Inmemoriam.
Posted on: 04/11/06 03:12pm
By: machinari
[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[/QUOTE]yes yes.. but I'm planning on it--eventually
1.4.0sr2 Problem with Inmemoriam.
Posted on: 04/11/06 03:24pm
By: markf
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?
1.4.0sr2 Problem with Inmemoriam.
Posted on: 04/11/06 03:34pm
By: machinari
you know that there is a version out for gl1.4... find it at my site. it is being rewritten at the moment.
1.4.0sr2 Problem with Inmemoriam.
Posted on: 04/12/06 11:54am
By: markf
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.
1.4.0sr2 Problem with Inmemoriam.
Posted on: 04/12/06 12:36pm
By: machinari
geeklog/sql/sql_install.php
1.4.0sr2 Problem with Inmemoriam.
Posted on: 04/12/06 03:25pm
By: markf
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.