Simple Machines Community Forum

I created a sandbox in my PC, to test the SMF before publishing in the WEB. (of course)

Database error

LainaaColumn ' c.can_collapse' unknown in ' field list'
C:\Program Files\EasyPHP 3.0\www\smf\Sources\Subs-BoardIndex.php
Line: 82 

Please, is a SMF bug or is only subs-BoardIndex.php corrupt?

Fragment here of this archive:
Above and below of line 82 where the error is presented          

// Start with an empty array.
if ($boardIndexOptions['include_categories'])
$categories = array();
else
$this_category = array();

// Run through the categories and boards (or only boards)....
while ($row_board = $smcFunc['db_fetch_assoc']($result_boards))
{
if ($boardIndexOptions['include_categories'])
{
$ignoreThisBoard = in_array($row_board['id_board'], $user_info['ignoreboards']);
$row_board['is_read'] = !empty($row_board['is_read']) || $ignoreThisBoard ? '1' : '0';
// Haven't set this category yet.
if (empty($categories[$row_board['id_cat']]))
{
$categories[$row_board['id_cat']] = array(
'id' => $row_board['id_cat'],
'name' => $row_board['cat_name'],
'is_collapsed' => isset($row_board['can_collapse']) && $row_board['can_collapse'] == 1 && $row_board['is_collapsed'] > 0,
'can_collapse' => isset($row_board['can_collapse']) && $row_board['can_collapse'] == 1,
'collapse_href' => isset($row_board['can_collapse']) ? $scripturl . '?action=collapse;c=' . $row_board['id_cat'] . ';sa=' . ($row_board['is_collapsed'] > 0 ? 'expand' : 'collapse;') . '#c' . $row_board['id_cat'] : '',
'collapse_image' => isset($row_board['can_collapse']) ? '<img src="' . $settings['images_url'] . '/' . ($row_board['is_collapsed'] > 0 ? 'expand.gif" alt="+"' : 'collapse.gif" alt="-"') . ' border="0" />' : '',
'href' => $scripturl . '#c' . $row_board['id_cat'],
'boards' => array(),
'new' => false
);
$categories[$row_board['id_cat']]['link'] = '<a name="c' . $row_board['id_cat'] . '" href="' . (isset($row_board['can_collapse']) ? $categories[$row_board['id_cat']]['collapse_href'] : $categories[$row_board['id_cat']]['href']) . '">' . $row_board['cat_name'] . '</a>';
}

// If this board has new posts in it (and isn't the recycle bin!) then the category is new.
if (empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $row_board['id_board'])
$categories[$row_board['id_cat']]['new'] |= empty($row_board['is_read']) && $row_board['poster_name'] != '';

// Collapsed category - don't do any of this.
if ($categories[$row_board['id_cat']]['is_collapsed'])
continue;

// Let's save some typing.  Climbing the array might be slower, anyhow.
$this_category = &$categories[$row_board['id_cat']]['boards'];



Any solutions?

Regards

What version of SMF are you using? Beta 4 or RC1?

Sorry, I'm Stupid. ::)

2.0rc1.

Weird. Can you show more of that? It doesn't include the actual query.

I perceived that after the order of update of templates, it was that this error occurred.
I go to make upgrade again and I go to jump the template edition and  post  More detailed results here. OK

Is this with the default 2.0 RC1 theme?

The issue is above these lines. it must be query related.

Can you attach your Sources/Subs-BoardIndex.php file please.

Are you using mysql/sqlite or postgresql?
What page were you on when you go this error?
What were you doing?
Were you logged in? or guest?
Normal user or admin?

Any mods?