Database/Table error

Forum for general requests for support for players. Both staff members and veteran players can help new players with problems they encounter. No chatting in this forum, please.

Moderators: Public Relations Department, Players Department, Programming Department

Post Reply
User avatar
N-Aldwitch
Posts: 1771
Joined: Thu Mar 16, 2006 1:48 am
Contact:
Contact N-Aldwitch

Database/Table error

Postby N-Aldwitch » Sat Jun 16, 2007 12:59 am

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.
Nakranoth's "evil" character says:
"Thief! That's terrible! *shakes his head* That would hurt people's feeling if I did that."


http://www.sylorn.com - Free MMORPG in development.. need help.
Top
User avatar
Chris Johnson
Posts: 2903
Joined: Wed Dec 01, 2004 3:26 pm
Location: East Sussex, United Kingdom
Contact:
Contact Chris Johnson

Postby Chris Johnson » Sat Jun 16, 2007 1:06 am

That should be fixed now
Top
pipok
Posts: 397
Joined: Tue Oct 31, 2006 6:45 am

Postby pipok » Sat Jun 16, 2007 7:03 am

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)".
Top
User avatar
Chris Johnson
Posts: 2903
Joined: Wed Dec 01, 2004 3:26 pm
Location: East Sussex, United Kingdom
Contact:
Contact Chris Johnson

Postby Chris Johnson » Sat Jun 16, 2007 7:39 am

That should also be fixed now
Top
User avatar
N-Aldwitch
Posts: 1771
Joined: Thu Mar 16, 2006 1:48 am
Contact:
Contact N-Aldwitch

Postby N-Aldwitch » Sat Jun 16, 2007 8:28 am

Thankyou chris. :)
Nakranoth's "evil" character says:

"Thief! That's terrible! *shakes his head* That would hurt people's feeling if I did that."





http://www.sylorn.com - Free MMORPG in development.. need help.
Top
User avatar
SumBum
Posts: 1903
Joined: Fri Jan 05, 2007 10:57 pm

Postby SumBum » Sat Jun 16, 2007 1:35 pm

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.
Last edited by SumBum on Sat Jun 16, 2007 1:36 pm, edited 1 time in total.
Top
User avatar
BarbaricAvatar
Posts: 3489
Joined: Wed Mar 09, 2005 5:01 pm

Postby BarbaricAvatar » Sat Jun 16, 2007 1:36 pm

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
(\__/)
(='.'=) This is Bunny. Copy and paste bunny into your
(" )_(" ) signature to help him gain world domination.
Top
User avatar
dinallt
Posts: 33
Joined: Sat May 14, 2005 11:06 am

Postby dinallt » Sat Jun 16, 2007 1:53 pm

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
Top
Reindeer^
Posts: 113
Joined: Wed May 30, 2007 12:50 pm
Location: Northern Finland

Postby Reindeer^ » Sat Jun 16, 2007 2:02 pm

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
You get attacked by a human losing 42 percent of your strength.
Top
User avatar
SekoETC
Posts: 15526
Joined: Wed May 05, 2004 11:07 am
Location: Finland
Contact:
Contact SekoETC

Postby SekoETC » Sat Jun 16, 2007 2:03 pm

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.
Not-so-sad panda
Top
User avatar
Sicofonte
Posts: 1781
Joined: Fri Feb 17, 2006 5:01 pm
Location: Into your Wardrobe

Postby Sicofonte » Sat Jun 16, 2007 2:09 pm

http://www.cantr.net/forum/viewtopic.ph ... 889#261889


The game is broken.
Tyche es una malparida. Espero que Ramnus y Pluto intervengan... o no :P
Top
User avatar
Chris Johnson
Posts: 2903
Joined: Wed Dec 01, 2004 3:26 pm
Location: East Sussex, United Kingdom
Contact:
Contact Chris Johnson

Postby Chris Johnson » Sat Jun 16, 2007 2:20 pm

The problem with objects and inventories should be fixed now
Top
User avatar
Sicofonte
Posts: 1781
Joined: Fri Feb 17, 2006 5:01 pm
Location: Into your Wardrobe

Postby Sicofonte » Sat Jun 16, 2007 2:24 pm

Thanks!
Tyche es una malparida. Espero que Ramnus y Pluto intervengan... o no :P
Top
Post Reply

Return to “General Support”

Who is online

Users browsing this forum: No registered users and 1 guest