SubBoards 1.6

[Valconeye]

YaBB SE Version: 1.5.4
PHP Version: <= 4.1.0
MySQL Version: <= 3.21.x
Server Platform: Unix, Linux, or BSD
Link to Forum:

Problem Description:
SubBoards 1.6,

Everything runs fine on the install, when i load up my forum it says, parent table is ambiguis in boardindex line 153

[Shadow's Pawn]

You should post this under the topic for that mod.

[Valconeye]

i would, but its in german. so yeah  

[[Unknown]]

PHP Version: <= 4.1.0
MySQL Version: <= 3.21.x

W00T??  And YaBB SE runs?!?

Anyway, post lines 150 - 155 and I'll look at them...

-[Unknown]

[Valconeye]

heh, wasnt really thinking when i selected php version and mysql version  
Maybee i was off on the line, but here is the error

Column: 'parent' in field list is ambiguous
File: /home/warcraft/public_html/forums/Sources/BoardIndex.php
Line: 157

and here are the lines 147 - 157

    $result_boards = mysql_query ("
      SELECT DISTINCT parent, parent1, c.catAllowCollapse AS isCollapsable, c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.description, b.moderators, b.numPosts, b.numTopics, c.memberGroups, m.posterName, m.posterTime, m.subject, t.ID_TOPIC, t.numReplies, IFNULL(mem.realName, m.posterName) AS realName, IFNULL(lb.logTime, 0) AS boardTime, IFNULL(lmr.logTime, 0) AS markReadTime, IFNULL(mem.ID_MEMBER, -1) AS ID_MEMBER
      FROM {$db_prefix}categories AS c
         LEFT JOIN {$db_prefix}boards AS b ON (b.ID_CAT=c.ID_CAT)
         LEFT JOIN {$db_prefix}topics AS t ON (t.ID_TOPIC=b.ID_LAST_TOPIC)
         LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG=t.ID_LAST_MSG)
         LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER=m.ID_MEMBER)
         LEFT JOIN {$db_prefix}log_boards AS lb ON (lb.ID_BOARD=b.ID_BOARD AND lb.ID_MEMBER=$ID_MEMBER)
         LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD=b.ID_BOARD AND lmr.ID_MEMBER=$ID_MEMBER)
      WHERE $condition
      ORDER BY c.catOrder, c.ID_CAT, b.boardOrder, b.ID_BOARD") or database_error(__FILE__, __LINE__);

[[Unknown]]

Find:
parent, parent1

Replace:
b.parent, b.parent1

-[Unknown]

[Valconeye]

heh, got past 1 milestone, here is another error. This error happens when i try to make the board available to subboards.

2: yymain(/home/warcraft/public_html/forums/Sources/SubBoard.php): failed to open stream: No such file or directory
(/home/warcraft/public_html/forums/index.php ln 327)

Line 321 330 in index.php

Code Select Expand

   if (isset($actionArray[$action]))
   {
      $includeFile = $actionArray[$action][0];
      $executeFunction = $actionArray[$action][1];
      unset($actionArray);

      include_once $includeFile;
      if ($executeFunction != "")
         $executeFunction();
   }

[[Unknown]]

Make sure you created the SubBoard.php in Sources.

-[Unknown]

[Valconeye]

wow i surprised i forgot that   thanks