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:
Text 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!