For quite some time now I've been trying to get the Older Stories Block to work on my Geeklog install. My first attempt was on version 1.3, then 1.3.1, and now on 1.3.3. All attempts have failed!
My problems have all centered on the COM_olderstuff function in lib-common.php.
Thus far I've narrowed it down to two issues:
The select statement returns no rows. For some reason all of my stories have a draft_flag = 0 and not = 1.
The second problem is in the DB_delete and DB_save function calls. The SQL generated results in an error. Specifically the title value appears in double quotes, “Older Stories” and not single quotes ‘Older Stories’. This breaks the SQL statements. To fix the problem I resorted to the following hack:
Has anyone run across similar issues? If so how did you correct the problem?
In a world without walls and fences, who needs Windows and Gates?