[warden]

My webhost moved to a new server and in the process upgraded from php 4.x to 5.1.x. This error message displayed on a site running DF 9.0.6.1 using the forum last 10 scrolling posts block. Would someone who knows more about this than I please explain what this means and possibly request a fix? This site was working just fine with php 4.x.

Quote:

includes/db/db.php

* CMS Warning line 51: On /index.php While executing query "SELECT t.topic_id, t.topic_last_post_id, t.topic_title, f.forum_name, f.forum_id, u.username, u.user_id, p.poster_id, p.post_time FROM cms_bbtopics t, cms_bbforums f LEFT JOIN cms_bbposts p ON (p.post_id = t.topic_last_post_id) LEFT JOIN cms_users u ON (u.user_id = p.poster_id) WHERE t.forum_id=f.forum_id ORDER BY t.topic_last_post_id DESC LIMIT 10" the following error occured: Unknown column 't.topic_last_post_id' in 'on clause' In: /home/account-name/public_html/blocks/block-Forums_scroll_Last_posts.php on line:

Thanks.

[Phoenix]

dragonflycms.org/Forum...ostid.html

Normally we don't advise mixing CVS files but in this instance you should be okay to use,
dragonflycms.org/cvs/h...php?g=9.10

[warden]

Aha... so it was the upgrade to mysql 5.x and not the upgrade to php 5.x that did it.

Thanks Phoenix! It works now.

[Jeruvy]

Yup I have verified this also. PHP 5 update is no problem, but upgrading MySQL from 4.0.x to 5.x mysql does cause this. I'm not certain about 4.0 to 4.1