1
irmtfan
[resolved] cbb 3.0.4 final: after upgrade from mysql 4.0.27 to 4.1.19 its not show any post
  • 2006/6/29 14:46

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


ok i just had a corrupt table, repair it and now all is ok
---------------------------------------
the error when i click on a forum:
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 > 0 OR t.topic_sticky=1) AND t.forum_id = 2 AND t.approved = 1 AND p.approved = 1 ORDER BY t.topic_sticky DESC, p.post_time DESC


what can i do now?

Login

Who's Online

272 user(s) are online (182 user(s) are browsing Support Forums)


Members: 0


Guests: 272


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits