FUDforum: FUDforum Installation Issues » DELETE FROM fud26_msg

Home » FUDforum » FUDforum Installation Issues » DELETE FROM fud26_msg_store (Cannot login to forum)

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

DELETE FROM fud26_msg_store [message #35657]

Mon, 29 January 2007 16:33

lloydm

Messages: 20
Registered: April 2006

Karma: 0

Junior Member

I cannot login my forum after upgrading to 2.7.6 for I get this message.

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /FUDforum/include/core.inc on line 188

and I see this message below in sql_error log.

) 1100: Table 'fud26_msg_store' was not locked with LOCK TABLES 
Query: DELETE FROM fud26_msg_store WHERE id=455 

Any ideas

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35658 is a reply to message #35657]

Tue, 30 January 2007 00:58

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

On what page did you get this error message?

FUDforum Core Developer

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35661 is a reply to message #35658]

Tue, 30 January 2007 02:57

lloydm

Messages: 20
Registered: April 2006

Karma: 0

Junior Member

I get this message within browser after atempting a login to the forum. I also have users e-mail me for their getting the message also.

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /FUDforum/include/core.inc on line 188

and this comes from sql_error log file..

?748 ?1170125169?(/public_html/forum/index.php:75 
/FUDforum/include/theme/default/private.inc:257 
/FUDforum/include/users_adm.inc:47 
/public_html/forum/theme/default/login.php:476 
/public_html/forum/index.php:1194 
) 1100: Table 'fud26_msg_store' was not locked with LOCK TABLES 
Query: DELETE FROM fud26_msg_store WHERE id=455

[Updated on: Tue, 30 January 2007 02:58]

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35665 is a reply to message #35661]

Tue, 30 January 2007 14:11

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Fixed in CVS.

FUDforum Core Developer

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35671 is a reply to message #35665]

Tue, 30 January 2007 17:04

lloydm

Messages: 20
Registered: April 2006

Karma: 0

Junior Member

Sorry to be a bother, but how to I apply the patch. have never done this before. Do I just copy over the older file.

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35677 is a reply to message #35671]

Wed, 31 January 2007 01:30

lloydm

Messages: 20
Registered: April 2006

Karma: 0

Junior Member

Applied the fix, but still does not work. Now I am getting this message in sql_error.

?664 ?1170201935?(/public_html/forum/index.php:75 
/FUDforum/include/users_adm.inc:25 
/public_html/forum/theme/default/login.php:476 
/public_html/forum/index.php:1194 
) 1100: Table 'fud26_mod' was not locked with LOCK TABLES 
Query: DELETE FROM fud26_mod WHERE user_id IN(61)

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35681 is a reply to message #35671]

Wed, 31 January 2007 15:38

lloydm

Messages: 20
Registered: April 2006

Karma: 0

Junior Member

Applied patch, but still did not resolve the issue, for now I am getting a different sql_error message.

?664 ?1170201935?(/public_html/forum/index.php:75 
/FUDforum/include/users_adm.inc:25 
/public_html/forum/theme/default/login.php:476 
/public_html/forum/index.php:1194 
) 1100: Table 'fud26_mod' was not locked with LOCK TABLES 
Query: DELETE FROM fud26_mod WHERE user_id IN(61)

[Updated on: Wed, 31 January 2007 15:39]

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35683 is a reply to message #35681]

Wed, 31 January 2007 23:26

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Once you've applied the patch, did you rebuild the theme?

FUDforum Core Developer

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35693 is a reply to message #35683]

Thu, 01 February 2007 20:45

lloydm

Messages: 20
Registered: April 2006

Karma: 0

Junior Member

I tried rebuilding the themes and now I get this message.

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /FUDforum/include/compiler.inc on line 708

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /FUDforum/include/compiler.inc on line 708

and during forum consistency I get.

Warning: Invalid argument supplied for foreach() in /public_html/forum/adm/consist.php on line 438

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35695 is a reply to message #35693]

Thu, 01 February 2007 23:53

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

lloydm wrote on Thu, 01 February 2007 15:45

What version of the forum are you running?

FUDforum Core Developer

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35700 is a reply to message #35695]

Fri, 02 February 2007 02:54

lloydm

Messages: 20
Registered: April 2006

Karma: 0

Junior Member

PHP built On: SunOS media4 5.8 Generic_117350-18 sun4u
Database Version: 4.0.27
PHP Version: 5.0.5-20051114
Web Server: Zeus/4.3
WebServer to PHP interface: cgi
WebServer User/Group: 2520 / 2520
Forum Version: 2.7.7RC1
Relavent PHP Settings: Safe Mode: OFF
Open basedir: none
Display Errors: ON
File Uploads: ON
Maximum File Upload Size: 2097152
Magic Quotes: ON
Register Globals: OFF
Output Buffering: No
Disabled Functions: none
PSpell Support: No
Zlib Support: Yes

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35713 is a reply to message #35700]

Sun, 04 February 2007 16:45

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Ok, both issues are now resolved in CVS.

FUDforum Core Developer

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35756 is a reply to message #35713]

Wed, 07 February 2007 20:56

lloydm

Messages: 20
Registered: April 2006

Karma: 0

Junior Member

Thanks Guys that did fix my issue. One minor issue which I was able to handle myself.

When rebuilding themes you get error message.

cannot copy "/FUDforum/thm/default/i18n/english/img/tree_view.gif" to "/public_html/forum/theme/default/images//tree_view.gif"

I was able to copy the files myself.

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35764 is a reply to message #35756]

Thu, 08 February 2007 00:11

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

I suspect the destination file already existed and was owned by YOU, so when webserver tried to overwrite it (as web server user) it got a permission error.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Can't get any email to work
Next Topic:	Where is WWW Root stored?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 20:20:12 GMT 2024

Total time taken to generate the page: 0.02721 seconds