Welcome to Geeklog Tuesday, December 07 2021 @ 10:14 pm EST

Geeklog Forums

DailyQuote Plugin

Page navigation


Status: Banned

machinari

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

ironmax

Anonymous
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
 Quote

Status: Banned

machinari

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

ironmax

Anonymous
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.
 Quote

Status: offline

ranma

Forum User
Newbie
Registered: 03/06/06
Posts: 6
my thing worked too, thanks for the input and the plugin
 Quote

marciasteeves@yahoo.com

Anonymous
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)

 Quote

mach

Anonymous
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.
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 22/03/04
Posts: 1512
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:
PHP Formatted Code
    $sql = "SELECT ID, Quotes, Quoted, Title, Source, Sourcedate, Date, q.UID, username";
    $sql .= " FROM {$DQ_TABLES['dailyquote_quotes']} q, {$_TABLES['users']} gl";
    $sql .= " WHERE (Status='0' AND q.UID=gl.uid)";


 

and replace it with the following:
PHP Formatted Code
    $sql = "SELECT ID, Quotes, Quoted, Title, Source, Sourcedate, Date, q.UID, username";
    $sql .= " FROM {$DQ_TABLES['dailyquote_quotes']} q, {$_TABLES['users']} gl";
    $sql .= " WHERE (q.Status='0' AND q.UID=gl.uid)";


 
Note the change in the where clause.
 Quote

Status: offline

5jays217

Forum User
Junior
Registered: 29/07/06
Posts: 21
Location:Illinois
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
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 22/03/04
Posts: 1512
Quote by 5jays217:
Am I missing something from a prior reply?
replace 56 and 57 of install.php with the following:
PHP Formatted Code
$DEFVALUES['dailyquote_phpblock'] = "INSERT INTO {$_TABLES['blocks']} SET is_enabled='0', name='dailyquote', type='phpblock', title='Quote of the Day', tid='all', blockorder='255', phpblockfn='phpblock_random_quote'";
$DEFVALUES['dqmenu_phpblock'] = "INSERT INTO {$_TABLES['blocks']} SET is_enabled='0', name='dqmenu', type='phpblock', title='DailyQuote', blockorder='10', onleft='1', phpblockfn='phpblock_dqmenu'";

 
 Quote

Status: offline

5jays217

Forum User
Junior
Registered: 29/07/06
Posts: 21
Location:Illinois
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.....

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

Jamie Robinson
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 22/03/04
Posts: 1512
Give this one a try. The edits are made for you.
 Quote

Status: offline

5jays217

Forum User
Junior
Registered: 29/07/06
Posts: 21
Location:Illinois
Trying it now

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

Thanks, mach
Jamie Robinson
 Quote

Status: offline

5jays217

Forum User
Junior
Registered: 29/07/06
Posts: 21
Location:Illinois
Mach, you rock...

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

Thanks
Jamie Robinson
 Quote

Status: offline

hopeace

Forum User
Junior
Registered: 28/09/05
Posts: 16
Location:Victoria, BC, Canada
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:
PHP Formatted Code
$DEFVALUES['dailyquote_phpblock'] = "INSERT INTO {$_TABLES['blocks']} SET is_enabled='0', name='dailyquote', type='phpblock', title='Quote of the Day', tid='all', blockorder='255', phpblockfn='phpblock_random_quote'";
$DEFVALUES['dqmenu_phpblock'] = "INSERT INTO {$_TABLES['blocks']} SET is_enabled='0', name='dqmenu', type='phpblock', title='DailyQuote', blockorder='10', onleft='1', phpblockfn='phpblock_dqmenu'";
 


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!
 Quote

Page navigation

All times are EST. The time is now 10:14 pm.

  • 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