Geeklog Forums

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!

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

yes yes.. but I'm planning on it--eventually

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!

you know that there is a version out for gl1.4... find it at my site. it is being rewritten at the moment.

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!

geeklog/sql/sql_install.php

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!