MySQL error reports

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
marol
Posts: 3728
Joined: Sun Jul 17, 2005 11:45 am
Location: Kraków, PL
Contact:
Contact marol

Postby marol » Sat Apr 19, 2008 2:14 am

It's 4 am here, but don't worry, I've just finished my date ;) Let's play.
(SRVPRC)
Image
Top
sky
Posts: 86
Joined: Sat May 06, 2006 5:33 pm

Postby sky » Sat Apr 19, 2008 3:07 am

I see all sorts of sq l errors on the main character page. :

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

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

Warning: Division by zero in /home/httpd/vhosts/cantr.net/httpdocs/locations.inc.php on line 484

Warning: Division by zero in /home/httpd/vhosts/cantr.net/httpdocs/page.player.inc.php on line 220



One of my Characters I'm guessing is in Limbo land somewhere. She was traveling last night, today she apparently arrived into town but her status is still traveling from to .....0% and instead of on land the location appears to be in water?? I'm guessing marol or someone is working on it.

errors for this character:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/cantr.net/httpdocs/locations.inc.php on line 476

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

Warning: Division by zero in /home/httpd/vhosts/cantr.net/httpdocs/locations.inc.php on line 484
You have 191 minutes left to play this turn. Make sure you log out when not playing for a while.





If you need more details I can pm them.
Top
fallenval
Posts: 40
Joined: Sun Feb 03, 2008 8:41 pm

Postby fallenval » Sat Apr 19, 2008 4:39 am

My situation is very similar

Characther page:

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

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

Warning: Division by zero in /home/httpd/vhosts/cantr.net/httpdocs/locations.inc.php on line 484

Warning: Division by zero in /home/httpd/vhosts/cantr.net/httpdocs/page.player.inc.php on line 220


I also have someone in water I'm pretty sure he was travellling to Quillanoi. same thing with Sky I can PM more info.
RPG
Rocket Propelled Grenade
Top
User avatar
mtm21
Posts: 474
Joined: Sat Feb 18, 2006 8:24 am
Location: Australia

Postby mtm21 » Sat Apr 19, 2008 10:12 am

As I was selecting a project to use my iron on.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/cantr.net/httpdocs/tags.inc.php on line 382
""""Beauty is within the heart"""""

http://shezzatopia.myminicity.com
Top
User avatar
sanchez
Administrator Emeritus
Posts: 8742
Joined: Thu Jan 26, 2006 6:37 pm

Postby sanchez » Sun Apr 20, 2008 1:43 am

I also have a char lost at sea. She was walking on a road from Cechowice to Port Rzemiosl and arrived at PR but was then transported to the middle of the sea with location reported as 'traveling from to' at 0%, and I get the following sql errors when viewing her chardesc page:

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

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

Warning: Division by zero in /home/httpd/vhosts/cantr.net/httpdocs/locations.inc.php on line 484

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

Warning: Division by zero in /home/httpd/vhosts/cantr.net/httpdocs/locations.inc.php on line 223
Top
toon
Posts: 948
Joined: Wed Nov 07, 2007 11:00 pm

Postby toon » Sun Apr 20, 2008 3:00 am

I too have a character that was traveling that is now lost at sea. I have the same errors too.

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

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

Warning: Division by zero in /home/httpd/vhosts/cantr.net/httpdocs/locations.inc.php on line 484

Warning: Division by zero in /home/httpd/vhosts/cantr.net/httpdocs/page.player.inc.php on line 220
Top
User avatar
marol
Posts: 3728
Joined: Sun Jul 17, 2005 11:45 am
Location: Kraków, PL
Contact:
Contact marol

Postby marol » Tue Apr 22, 2008 2:48 pm

Travel problems has been fixed.
(SRVPRC)

Image
Top
marginoferror
Posts: 154
Joined: Wed Mar 12, 2008 7:16 pm

Lost at sea?

Postby marginoferror » Sat Jun 28, 2008 11:54 pm

I was docking to Olipifirovash West (the town itself) from the lake. After a few hours of docking I finally received a "2307-1.19: (my ship name) docks at ." message and now I can't see anything but water and the following SQL error happens when I access the location screen:

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

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

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

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

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


Please advise.
Top
marginoferror
Posts: 154
Joined: Wed Mar 12, 2008 7:16 pm

Postby marginoferror » Tue Aug 05, 2008 8:26 pm

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

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



On player page. No obvious problems other than the warnings.
Top
User avatar
Spider
Posts: 923
Joined: Thu Dec 04, 2003 8:15 am
Location: Cali

Postby Spider » Tue Aug 05, 2008 8:51 pm

marginoferror wrote:Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/cantr.net/httpdocs/page.player.inc.php on line 147

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



On player page. No obvious problems other than the warnings.


I don't think characters are lighting up when something happens...I think.

And probably, each one of those errors is per character you have...maybe.
Last edited by Spider on Tue Aug 05, 2008 8:53 pm, edited 1 time in total.
Top
User avatar
Skulty
Posts: 740
Joined: Thu May 05, 2005 4:05 pm
Location: Portugal

Postby Skulty » Tue Aug 05, 2008 8:53 pm

Actually, I think there's a problem besides the warning. The char's name are always dark even if there are new events. That only happened once to me so I might be wrong about it, but that'd be consistent with the line where the error occurred (I've taken a look at the source marol sent me to check this :P )

P.S: Your post confirms my guess, thanks Spider :D
Top
Helmaroc
Posts: 106
Joined: Sat Apr 19, 2008 12:16 am

Postby Helmaroc » Tue Aug 05, 2008 9:10 pm

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

I get this 15 times on the player page above the player info. When it came up first this morning, all my characters with new events went gray, so I'm having to go through them separately to check.
Top
User avatar
Darkle-ish
Posts: 396
Joined: Sun Jun 03, 2007 2:12 am
Location: ~-~A. Texas~-~

Postby Darkle-ish » Tue Aug 05, 2008 9:25 pm

I'm getting the same thing as Helmaroc.
"Gee, I sure would like to set those people on fire over there. But I'm way to far away to get the job done. If only I had something that would throw flame on them." -George Carlin, an amazing man.
Top
rconley
Posts: 4375
Joined: Sun Aug 28, 2005 8:24 am

Postby rconley » Tue Aug 05, 2008 9:33 pm

It does seem as a game issue and not just single players. Characters are currently not lighting up even if new events are posted. Seems the game is playable still though.
<Viktor> someone asks my career my answer is "full time cantriian"
Top
User avatar
Solfius
Posts: 3144
Joined: Wed Jul 16, 2003 5:31 pm

Postby Solfius » Tue Aug 05, 2008 9:57 pm

I have 3 characters, and 3 of these errors:

Code: Select all

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


So it would seem linked to the characters lighting up for events.

I think I normally see the "supplied argument is not a valid MySQL result resource" error when a database query fails for some reason and the non-existent result is used in subsequent operations
Top
Post Reply

Return to “General Support”

Who is online

Users browsing this forum: No registered users and 1 guest