Geeklog Forums

Hello, if anyone is familiar I have a small problem with the journal plugin I get this error on installation ?
I am sure its really simple any help most appreciated.
Thanks.
Sun 17 Sep 09:22:19 2006 - Attempting to install the Journal Plugin
Sun 17 Sep 09:22:19 2006 - Attempting to create table journal for Journal plugin
Sun 17 Sep 09:22:19 2006 - 1067: Invalid default value for 'jrn_id'. SQL in question:

Any suggestions ?...

Does anyone have a working version of Journal that works with the latest stable release of geeklog and are they willing to share it ? Cos I can't get it to work & I really want this feature...

I would assume the problem is more with MySQL than with Geeklog. I.e. newer versions of MySQL may be more picky about certain values.

In the admin/install.php, find the line and try removing the "DEFAULT '0'" bit, since this is what it seems to complain about.

bye, Dirk

Just that line ? or all lines what about" "DEFAULT " " "

That seems to have patially done it,
I have this problem now, ?
Any suggestions ?
Once done I will post a working copy of this plugin back up here for people to use.

Sat 23 Sep 11:37:56 2006 - Attempting to install the Journal Plugin
Sat 23 Sep 11:37:56 2006 - Attempting to create table journal for Journal plugin
Sat 23 Sep 11:37:57 2006 - ...success
Sat 23 Sep 11:37:57 2006 - Attempting to create table journal_type for Journal plugin
Sat 23 Sep 11:37:57 2006 - 1146: Table 'donate.gl_journal_type' doesn't exist. SQL in question: INSERT INTO gl_journal_type (jt_name) VALUES ('Personal Journal')
Sat 23 Sep 11:38:01 2006 - Attempting to install the Journal Plugin
Sat 23 Sep 11:38:01 2006 - Attempting to create table journal for Journal plugin
Sat 23 Sep 11:38:01 2006 - 1050: Table 'gl_journal' already exists. SQL in question:
Sat 23 Sep 11:38:18 2006 - Attempting to install the Journal Plugin
Sat 23 Sep 11:38:18 2006 - Attempting to create table journal for Journal plugin
Sat 23 Sep 11:38:18 2006 - 1050: Table 'gl_journal' already exists. SQL in question:

Ok I got that working Fine, I'll post the code back up here,