Posted on: 09/17/06 04:35am
By: trampoline
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:
Journal Plugin SQL Prob
Posted on: 09/18/06 04:26pm
By: trampoline
Any suggestions ?...
Journal Plugin SQL Prob
Posted on: 09/22/06 06:58pm
By: Anonymous (Trampoline)
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...
Journal Plugin SQL Prob
Posted on: 09/23/06 03:58am
By: Dirk
[QUOTE BY= trampoline] Sun 17 Sep 09:22:19 2006 - 1067: Invalid default value for 'jrn_id'. SQL in question:[/QUOTE]
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
. "jrn_id mediumint(8) DEFAULT '0' NOT NULL auto_increment,"
and try removing the "DEFAULT '0'" bit, since this is what it seems to complain about.
bye, Dirk
Journal Plugin SQL Prob
Posted on: 09/23/06 05:04am
By: Anonymous (trampoline)
[QUOTE BY= Dirk] [QUOTE BY= trampoline] Sun 17 Sep 09:22:19 2006 - 1067: Invalid default value for 'jrn_id'. SQL in question:[/QUOTE]
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
. "jrn_id mediumint( DEFAULT '0' NOT NULL auto_increment,"
and try removing the "DEFAULT '0'" bit, since this is what it seems to complain about.
bye, Dirk[/QUOTE]
Just that line ? or all lines what about" "DEFAULT " " "
Journal Plugin SQL Prob
Posted on: 09/23/06 06:43am
By: Anonymous (Trampoline)
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:
Journal Plugin SQL Prob
Posted on: 09/23/06 07:51am
By: Anonymous (Trampoline)
Ok I got that working Fine, I'll post the code back up here,