Polls killed by upgrade. Please help :( Anyone please????

[oooooh]

Hi

I upgraded to .16 but all of my polls have died. Below is the error they all give when you click the post which they are in.

Could not obtain vote data for this topic

DEBUG MODE

SQL Error : 1030 Got error 28 from table handler

SELECT vd.vote_id, vd.vote_text, vd.vote_start, vd.vote_length, vr.vote_option_id, vr.vote_option_text, vr.vote_result FROM phpbb_vote_desc vd, phpbb_vote_results vr WHERE vd.topic_id = 80 AND vr.vote_id = vd.vote_id ORDER BY vr.vote_option_id ASC

Line : 688
File : viewtopic.php

[indaleco]

Are you using a mod that changed your polls in any way.

[oooooh]

Hi

The only mod I have stops mods from viewing the IP of users.

[Snowboardalliance]

Post the code at line 688 and around it.

[oooooh]

Sorry dont understand

[indaleco]

Open viewtopic.php and using notepad -> click Goto. Enter the number 688 and copy approximately 5-10 lines above and below that line.

[oooooh]

There are no line numbers

[indaleco]

That is why you use notepad. It has a GOTO (ctrl = G) which allows you to enter a line number.

[Wo1f]

Hi ooooh!

Just for your info. I have updated to .16 a couple of days ago, and seeing this thread I went to check a few existing polls. There all ok and displayed as should be.

Regards,
Wolf

[oooooh]

The control G is greyed out and notepad turns the file into a jumble

[oooooh]

if ( count($tracking_topics) >= 150 && empty($tracking_topics[$topic_id]) )
{
asort($tracking_topics);
unset($tracking_topics[key($tracking_topics)]);
}

$tracking_topics[$topic_id] = time();

setcookie($board_config['cookie_name'] . '_t', serialize($tracking_topics), 0, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']);
} ( THIS IS 668 )

//
// Load templates
//
$template->set_filenames(array(
'body' => 'viewtopic_body.tpl')
);
make_jumpbox('viewforum.'.$phpEx, $forum_id);

//
// Output page header
//
$page_title = $lang['View_topic'] .' - ' . $topic_title;
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

//
// User authorisation levels output

[indaleco]

Open it in wordpad first and save it. Then open it in notepad.

[oooooh]

Or this


POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'] . '">', '</a>');

$topic_mod .= "<a href=\"modcp.$phpEx?" . POST_TOPIC_URL . "=$topic_id&mode=delete&sid=" . $userdata['session_id'] . '"><img src="' . $images['topic_mod_delete'] . '" alt="' . $lang['Delete_topic'] . '" title="' . $lang['Delete_topic'] . '" border="0" /></a>&nbsp;';

$topic_mod .= "<a href=\"modcp.$phpEx?" . POST_TOPIC_URL . "=$topic_id&mode=move&sid=" . $userdata['session_id'] . '"><img src="' . $images['topic_mod_move'] . '" alt="' . $lang['Move_topic'] . '" title="' . $lang['Move_topic'] . '" border="0" /></a>&nbsp;';

$topic_mod .= ( $forum_topic_data['topic_status'] == TOPIC_UNLOCKED ) ? "<a href=\"modcp.$phpEx?" . POST_TOPIC_URL . "=$topic_id&mode=lock&sid=" . $userdata['session_id'] . '"><img src="' . $images['topic_mod_lock'] . '" alt="' . $lang['Lock_topic'] . '" title="' . $lang['Lock_topic'] . '" border="0" /></a>&nbsp;' : "<a href=\"modcp.$phpEx?" . POST_TOPIC_URL . "=$topic_id&mode=unlock&sid=" . $userdata['session_id'] . '"><img src="' . $images['topic_mod_unlock'] . '" alt="' . $lang['Unlock_topic'] . '" title="' . $lang['Unlock_topic'] . '" border="0" /></a>&nbsp;';

$topic_mod .= "<a href=\"modcp.$phpEx?" . POST_TOPIC_URL . "=$topic_id&mode=split&sid=" . $userdata['session_id'] . '"><img src="' . $images['topic_mod_split'] . '" alt="' . $lang['Split_topic'] . '" title="' .

[espicom]

SQL Error : 1030 Got error 28 from table handler

Your polls were NOT killed by the upgrade, they are dead because the MySQL server has a serious problem... It can not allocate any space to insert the information you want to insert. Call your host and have them fix it.

[Lumpy Burgertushie]

Open it in wordpad first and save it. Then open it in notepad.

wordpad is better to use than notepad anyway, it doesn't show all the junk characters and it has line numbers.

why open in wordpad and save it and then open it in notepad? what is that supposed to do?


robert