Welcome to Geeklog Saturday, November 27 2021 @ 04:04 am EST

Geeklog Forums

1.4.0sr2 Problem with Inmemoriam.


Status: offline

markf

Forum User
Newbie
Registered: 25/07/05
Posts: 13
Location:Appleton
determined
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!
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/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.
PHP 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
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 22/03/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 Wink
 Quote

Status: offline

markf

Forum User
Newbie
Registered: 25/07/05
Posts: 13
Location:Appleton
embarrassed
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!
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 22/03/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.
 Quote

Status: offline

markf

Forum User
Newbie
Registered: 25/07/05
Posts: 13
Location:Appleton
curious
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!
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 22/03/04
Posts: 1512
geeklog/sql/sql_install.php
 Quote

Status: offline

markf

Forum User
Newbie
Registered: 25/07/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!
 Quote

All times are EST. The time is now 04:04 am.

  • 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