14
Recently, my host upgraded php and MySQL on the server. Ever since the upgrade, my forums have been broken.
At first I had this problem whenever I clicked on a forum or subforum...
Quote:
SELECT t.*, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id, p.uid, p.post_karma, p.require_reply, pt.post_text FROM xoops_bb_topics t LEFT JOIN xoops_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN xoops_bb_posts_text pt ON pt.post_id = t.topic_last_post_id WHERE (p.post_time > 1151094710 OR t.topic_sticky=1) AND t.forum_id = 1 AND t.approved = 1 AND p.approved = 1 ORDER BY t.topic_sticky DESC, p.post_time DESC
When i disabled "Post excerpt on forum page" in the cbb options, i no longer get the error message.
However, now, when i click on a topic none of the posts are there... just the quick reply box and the page numbers, etc.
see HEREAlso, I get this error when trying to create a new topic:
Quote:
Insert object error (queryF):INSERT INTO xoops_bb_posts_text (post_id,post_text) VALUES (137466,'asdffasdfasdfasdf')
I've tried "repairing" my database in cpanel. Also, i tried reloading my templates and updating the system and forum module.
I'm using XOOPS 2.2.4 with cbb 3.08
Operating system FreeBSD
Kernel version 5.4-RELEASE
Apache version 1.3.37 (Unix)
PERL version 5.8.6
Path to PERL /usr/bin/perl
Path to sendmail /usr/sbin/sendmail
Installed Perl Modules Click to View
PHP version 5.2.1
MySQL version 5.0.33
cPanel Build 10.9.0-RELEASE 9808
Any help would be most appreciated!!!!
Thanks,
Mantooth
...
I hate Mortal Kombat
