Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Message Rebuilder SQL error (table is not locked)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Message Rebuilder SQL error [message #184713] Sat, 18 January 2014 15:16 Go to next message
RussianE39 is currently offline  RussianE39
Messages: 4
Registered: January 2014
Location: Russia
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
FudForum 3.0.6RC1, DB Engine: Mysql
When using Message Rebuilder, there is SQL error about not locked table:
Rebuilding normal messages:

Fatal error: Uncaught exception 'Exception' with message '(/usr/local/well/include/theme/default/db.inc:110<br /> /usr/local/www/ww/adm/compact.php:125<br /> /usr/local/www/ww/adm/compact.php:203<br /> ) 1100: Table 'fud30_replace' was not locked with LOCK TABLES<br /> Query: SELECT with_str, replace_str FROM fud30_replace WHERE replace_str IS NOT NULL AND with_str IS NOT NULL AND LENGTH(replace_str)&gt;0<br /> _POST: array ( 'replace' =&gt; '1', 'conf' =&gt; 'Yes', 'SQ' =&gt; '972a26d61ee1022a170fadf93f653acc', )<br /> Database version: 5.5.35-log<br /> [Referring Page] http://home.v12.su/ww/adm/compact.php?&amp;SQ=972a26d61ee1022a170fadf93f653acc<br /> ' in /usr/local/well/include/core.inc:264 Stack trace: #0 /usr/local/well/include/theme/default/db.inc(110): fud_sql_error_handler('SELECT with_str...', 'Table 'fud30_re...', 1100, '5.5.35-log') #1 /usr/local/www/ww/adm/compact.php(125): uq('SELECT with_str...') #2 /usr/local/www/ww/adm/compact.php(203): write_body_copy('?????????? ????...', '965', '0', '40000', '4') #3 {main} thrown in /usr/local/well/include/core.inc on line 264
Re: Message Rebuilder SQL error [message #184770 is a reply to message #184713] Sat, 01 February 2014 01:25 Go to previous message
naudefj is currently offline  naudefj   
Messages: 3680
Registered: December 2004
Karma: 19
Senior Member
Core Developer
add to buddy list
ignore all messages by this user
Fixed @ http://sourceforge.net/p/fudforum/code/5761/
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Forum datadump fatal error
Next Topic: admdump.php in 3.0.6RC1
Goto Forum:

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 22 05:19:54 EDT 2018

Total time taken to generate the page: 0.00625 seconds