Geeklog Forums

Ensure that the category to which you added the quote is enabled. Categories are disabled by default when they are created while adding a quote.

Okay...I've read thru all of this so far and came across this in the log...any ideas?

06/09/06 04:50:51 - Success - Created table
06/09/06 04:50:51 - Inserting default data into dailyquote_settings table
06/09/06 04:50:51 - Success - inserting data into dailyquote_settings table
06/09/06 04:50:51 - Inserting default data into dailyquote_phpblock table
06/09/06 04:50:51 - Success - inserting data into dailyquote_phpblock table
06/09/06 04:50:51 - Inserting default data into dqmenu_phpblock table
06/09/06 04:50:51 - Success - inserting data into dqmenu_phpblock table
06/09/06 04:50:51 - Attempting to create dailyquote admin group
06/09/06 04:50:51 - 1062: Duplicate entry 'dailyquote Admin' for key 2. SQL in question:
06/09/06 04:50:51 - Attempting to unregister the Daily Quote plugin from Geeklog

I assume that you don't have the plugin installed... and that upon installation you received the "plugin not installed" message.. Is that right?

My guess is that you've previously attempted to install the plugin, it failed, and was not given a chance to back out properly, which left a rogue entry in the db.

See the last post in this thread for a possible solution. It deals with a different plugin, but the idea is the same, ie, that you need to manually clean the db of the relevant plugin data.

Okay great...it worked. I found an entry in the gl_groups table that was not deleted when the plugin backed out. Went in there and blew it out and it installed perfectly after the previously needed adjustments to the install script. BTW, I am using 1.40sr3 with the Register_Globals=off. So with these minor changes, I think it could be set for the latest GL vers.

my thing worked too, thanks for the input and the plugin

I've made all the changes as discussed above, however when another user adds a quote and I select the moderate option to approve their entry I'm getting the following error in my error.log

Mon 12 Jun 2006 06:57:27 CDT - 1052: Column 'Status' in where clause is ambiguous. SQL in question: SELECT ID, Quotes, Quoted, Title, Source, Sourcedate, Date, q.UID, username FROM gl_dailyquote_quotes q, gl_users gl WHERE (Status='0' AND q.UID=gl.uid)

I fixed this one a while back in another thread, but I'm in Alaska at the moment and don't have time to find it.. be back next week.

GL 1.4x has introduced a status column in the users table thus the ambiguity.

Find the following at about lines 56-58 or so in public_html/dailyquote/moderate.php:
and replace it with the following:Note the change in the where clause.

Hi, I've read this string and tried (i think) all of the possible resolutions but, I'm still getting this error when trying to install the dailyquotes plugin:


Mon 31 Jul 2006 23:41:54 CDT - Inserting default data into dailyquote_phpblock table
Mon 31 Jul 2006 23:41:54 CDT - 1136: Column count doesn't match value count at row 1. SQL in question:
Mon 31 Jul 2006 23:41:54 CDT - Error inserting default data into dailyquote_phpblock table
Mon 31 Jul 2006 23:41:54 CDT - Attempting to unregister the Daily Quote plugin from Geeklog



Am I missing something from a prior reply?

---

Jamie Robinson

replace 56 and 57 of install.php with the following:

mach, thanks

I tried again just now with the same error.

I checked my db files dont see anything resembling a remnent DQ table. all folders and pages are writable. the unpacked .tar file was moved according to install instructions.....

I just keep hitting this stupid wall...
and now my head kinda hurts...

---

Jamie Robinson

Give this one a try. The edits are made for you.

Trying it now

I'll let ya know in a few minutes...

Thanks, mach

---

Jamie Robinson

Mach, you rock...

I don't know what you did but first try it installed.

Thanks

---

Jamie Robinson

Hi- The plug in would not install without error, until I modified the lines 56&57 as I found in a previous post. I changed it to:


Then the install worked, however when I clicked on the daily quote link on the menu I received a SQL error of: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1. SQL in question: SELECT DISTINCT q.ID, Quotes, Quoted, Title, Source, Sourcedate, Date, q.UID FROM gl_dailyquote_quotes q, gl_dailyquote_lookup l WHERE q.Status='1' AND l.Status='1' AND l.QID=q.ID ORDER BY Date DESC LIMIT 0,

Im using geeklog 1.4.0sr3

Any suggestions??

thanks!