Patch problem Post.php

[proenski]

YaBB SE Version: 1.5.5
PHP Version: 4.3.4
MySQL Version: 4.0.x
Server Platform: Unix, Linux, or BSD
Link to Forum: http://www.depechemodeforum.com/yabbse/index.php

Problem Description:
I've downloaded the latest patch but the new Post.php is giving me this error:

Code Select Expand

Unknown column 'b.isSupport' in 'field list'
File: /home/.jasper/proenski/depechemodeforum.com/yabbse/Sources/Post.php
Line: 84

The old Post.php version doesn't have this...

What to do



For now I put the old Post.php back ....

[oldiesmann]

Please post the code from the "old" post.php and the new post.php from line 84 to wherever that query ends.

[proenski]

new Post.php

Code Select Expand

   # Determine what category we are in.
   $request = mysql_query("
      SELECT b.ID_BOARD as bid, b.name as bname, c.ID_CAT as cid, c.memberGroups, c.name as cname, b.isAnnouncement, b.isSupport
      FROM {$db_prefix}boards as b, {$db_prefix}categories as c
      WHERE (b.ID_BOARD = $board
         AND b.ID_CAT=c.ID_CAT)") or database_error(__FILE__, __LINE__);


Old Post.php

Code Select Expand

   # Determine what category we are in.
   $request = mysql_query("
      SELECT b.ID_BOARD as bid, b.name as bname, c.ID_CAT as cid, c.memberGroups, c.name as cname, b.isAnnouncement
      FROM {$db_prefix}boards as b, {$db_prefix}categories as c
      WHERE (b.ID_BOARD = $board
         AND b.ID_CAT=c.ID_CAT)") or database_error(__FILE__, __LINE__);

   if (mysql_num_rows($request) == 0)
      fatal_error($txt['yse232']);

   $bcinfo = mysql_fetch_array($request);
   $curcat = $bcinfo['cid'];
   $cat = $bcinfo['cname'];
   $currentboard = $bcinfo['bid'];
   $boardname = $bcinfo['bname'];

Line 84 in the old Post.php is the line after this last line $boardname = $bcinfo['bname']; and is blank...

[proenski]

No one on this

[[Unknown]]

I don't see isSupport there anywhere.

-[Unknown]