• Registered: 2005-05-30
  • Posts: 3

Topic: Problem with mysql 5.0.19

When I upgrade mysql from 5.0.18 to 5.0.19, my punBB forum stops working.  I tracked it down to this line crashing, but I don't understand why:

index.php, line41:

$result = $db->query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name,
f.forum_desc, f.redirect_url, f.moderators, f.num_topics, f.num_posts,
f.last_post, f.last_post_id, f.last_poster FROM '.$db->prefix.'categories AS c
INNER JOIN '.$db->prefix.'forums AS f ON c.id=f.cat_id LEFT JOIN
'.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND
fp.group_id='.$pun_user['g_id'].') WHERE fp.read_forum IS NULL OR
fp.read_forum=1 ORDER BY c.disp_position, c.id, f.disp_position', true);

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Problem with mysql 5.0.19

And what error message does the database report?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2006-07-02
  • Posts: 2

Re: Problem with mysql 5.0.19

i have such problem sad

after installing links like http://x-generation.org/forum and http://x-generation.org/forum/index.php not works but http://x-generation.org/forum/viewforum.php?id=1 and  http://x-generation.org/forum/viewtopic.php?id=1 works without problems

/Sorry for my bad english