My problems have all centered on the COM_olderstuff function in lib-common.php.
Thus far I've narrowed it down to two issues:
//DB_delete($_TABLES['blocks'],'title',"''");
//DB_save($_TABLES['blocks'],'title,blockorder,content',"'','','$string'");
DB_delete('blocks','title','Older Stories');
DB_save('blocks','title,blockorder,content',"'Older Stories','7','$string'");
Has anyone run across similar issues? If so how did you correct the problem?
Thanks,
Danny
The lib-common.php code included in the 1.3.3 distribution has the following SQL query in the COM_olderstuff function:
$result = DB_query("SELECT sid,title,comments,unix_timestamp(date) AS day FROM "
. $_TABLES['stories'] . " WHERE draft_flag = 1 ORDER BY date desc LIMIT , ");
$nrows = DB_numRows($result);
As I stated in the first issue, all of my stories have a draft_flag = 0. You also pointed out that this is correct. Why is the SQL looking for draft_flag = 0?
As for my install, I am running Geeklog 1.3.3 on RedHat 7.2 with Apache 1.3.23 and PHP 4.1.1.
Thanks,
Danny
-----
The reason people blame things on previous generations is that there's only one other choice.
$_CONF['olderstuff'] = 1; //1 = on 0= off
The block is created for you. The code for the block is in lib-common.php.