FUDforum: Bug Reports » More troubles

Home » FUDforum Development » Bug Reports » More troubles - splitting topic

Show: Today's Messages :: Polls :: Message Navigator

More troubles - splitting topic [message #27090]

Thu, 25 August 2005 21:09

Crimson

Messages: 51
Registered: June 2005
Location: Phoenix, AZ

Karma: 0

Member

In addition to my other polls bug (which I am still experiencing after applying a couple of patches you have posted, most recently the one where I removed addslashes() from a serialize() operation), I just experienced another bug (or support issue if I did something wrong I guess).

I clicked the "split topic" link at the top of the page, gave the new thread a name and a different forum for its home, selected the posts that needed to be moved, then clicked 'split selected posts'. I got a MySQL error which I will paste below. As a result, the posts were removed from the original thread, but the new thread was never created.

(/htdocs/renforums.com/index.php:76
/htdocs/renforums.com/index.php:136
/htdocs/renforums.com/theme/Renegade_Forums/split_th.php:399
/htdocs/renforums.com/theme/Renegade_Forums/split_th.php:528
/htdocs/renforums.com/index.php:1166
) 1100: Table 't' was not locked with LOCK TABLES
Query: SELECT t.last_post_id FROM fud_thread t INNER JOIN fud_msg m ON t.root_msg_id=m.id WHERE t.forum_id=1 AND t.id!=15962 AND t.moved_to=0 AND m.apr=1 ORDER BY t.last_post_date DESC LIMIT 1
_GET: array ( 'rid' => 'rid=', 't' => 'split_th', )
_POST: array ( 'SQ' => '3a4d27ddbc946f99e66119efe0504130', 'th' => '15962', 'new_title' => 'Spam from another thread', 'forum' => '10', 'btn_selected' => 'Split selected messages', 'sel_th' => array ( 0 => '167642', 1 => '167666', 2 => '167671', 3 => '167675', 4 => '167676', 5 => '167677', 6 => '167678', 7 => '167682', 8 => '167683', 9 => '167684', 10 => '167685', 11 => '167686', 12 => '167688', 13 => '167689', 14 => '167692', 15 => '167693', 16 => '167695', 17 => '167696', 18 => '167709', ), )
Server Version: 4.1.12-standard
[Referring Page] http://www.renegadeforums.com/index.php/stt/15962/rid=8

In case it's relevant, last night I created a new "template set" called "RenForumsNew", then I created a new theme called "Renegade_Forums", based on path_info from the default set. I edited forums.css.tmpl to change my colors up, and I edited header.tmpl (I think that's the name) to add a logo to the top of the site.

Also, I just remembered it would be smart to do consistency check. That brought the new thread back into existence.

Report message to a moderator