Page 1 of 1

Database/Table error

Posted: Sat Jun 16, 2007 12:59 am
by N-Aldwitch
Could not update private message new/read status (2) for user

DEBUG MODE

SQL Error : 1194 Table 'phpbb_privmsgs' is marked as crashed and should be repaired

UPDATE phpbb_privmsgs SET privmsgs_type = 5 WHERE privmsgs_type = 1 AND privmsgs_to_userid = 100722

Line : 1876
File : privmsg.php

______________________________________

This is the message I get when I try to go into my mailbox.

Posted: Sat Jun 16, 2007 1:06 am
by Chris Johnson
That should be fixed now

Posted: Sat Jun 16, 2007 7:03 am
by pipok
Wiki is broken:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

(SQL query hidden)

from within function "MediaWikiBagOStuff::_doquery". MySQL returned error "145: Table './cantr_wiki/cw_objectcache' is marked as crashed and should be repaired (localhost)".

Posted: Sat Jun 16, 2007 7:39 am
by Chris Johnson
That should also be fixed now

Posted: Sat Jun 16, 2007 8:28 am
by N-Aldwitch
Thankyou chris. :)

Posted: Sat Jun 16, 2007 1:35 pm
by SumBum
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/cantr.net/httpdocs/page.char.info.inc.php on line 41

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/cantr.net/httpdocs/page.objects.inc.php on line 102


This showed up when I clicked on 'objects' for a char, but no objects would show in the list. After that, errors appeared on every char page.

Posted: Sat Jun 16, 2007 1:36 pm
by BarbaricAvatar
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/cantr.net/httpdocs/page.char.info.inc.php on line 41

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/cantr.net/httpdocs/objects.inc.php on line 67

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/cantr.net/httpdocs/objects.inc.php on line 75

Result: All objects and possessions have disappeared

Posted: Sat Jun 16, 2007 1:53 pm
by dinallt
Same for me. All my characters have lost all their possessions and all are now carrying 0g. All objects at the location have disappeared as well

Posted: Sat Jun 16, 2007 2:02 pm
by Reindeer^
I have that problem, too.
But only this text:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/cantr.net/httpdocs/page.char.info.inc.php on line 41

Posted: Sat Jun 16, 2007 2:03 pm
by SekoETC
It looks rather spooky. I think it's due to the objects table being disconnected, stuff can't just disappear randomly. Unless someone accidentally deleted everything.

Posted: Sat Jun 16, 2007 2:09 pm
by Sicofonte

Posted: Sat Jun 16, 2007 2:20 pm
by Chris Johnson
The problem with objects and inventories should be fixed now

Posted: Sat Jun 16, 2007 2:24 pm
by Sicofonte
Thanks!