MySQL error reports

[EchoMan]

Sure, if you give me 8 ticks on my wood gathering project.

[BZR]

I uploaded a fix, if you need wood to check if it's ok now I can summon some for you:)

[EchoMan]

Sure give me a gram. PM'ing details.

Edit: Cantr seems to be dead at the moment though ...

Edit2: Back up again ...

[BZR]

Fixed.

[EchoMan]

Yay, no more errors. Verified.

[BZR]

btw nice char. *coughs* You gambled with wood I gave you

[EchoMan]

Lol! I had another batch coming, so it would have been fine anyways.

Ps. Noone's gonna beat my score anyways.

[Dudel]

Action: Wear Leather Apron

Code: Select all

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1\n
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/http/www.cantr.net/www/locations.inc.php on line 325
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND type=0' at line 1\n
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/http/www.cantr.net/www/locations.inc.php on line 471

Fatal error: __clone method called on non-object in /home/http/www.cantr.net/www/locations.inc.php on line 473

But I fixed the issue, myself.

Simply equipped the apron twice (or tried). Came from trying to wear multiple pieces of clothes very quickly, which gave an odd error that I was wearing and still holding the items. But there is the error, anyway... just in case.

[viktor]

so yesterday a char of mine was transporting resources, at one point, i clicked to drop some tomatoes, had a wierd mysql error that i didn't copy in time, it registered that i held 0g but the amount of the tomatoes was filled in correctly, so i clicked to drop and, was kicked to player page, i went back and the tomatoes were not in my hands nor did events show them dropping, i could not be sure if they were added to the pile or not.
a little while ago, i was moving some propane, when i clicked to drop it did, the same thing, i am assuming it was the same mysql error so i just backed out instead of losing the stuff, this is the report i saw.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND type != 1 AND weight > 0' at line 1\n
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/http/www.cantr.net/www/form.drop.inc.php on line 20

[BZR]

I fixed it or at least I hope so. Please report if such situation happens again.

[notsure]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1\n
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/http/www.cantr.net/www/form.amount.use.inc.php on line 48



While trying to make rope or string.

It also said "You can only make . grams."

Edit: I went back and now I can't start a project on it at all. The project button isn't even there.


ns

[EchoMan]

What used to result in haveing to log in again when trying to give another character a name or description, now gives me this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1\n
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/http/www.cantr.net/www/page.events.inc.php on line 21
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1\n
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/http/www.cantr.net/www/locations.inc.php on line 325
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND type=0' at line 1\n
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/http/www.cantr.net/www/locations.inc.php on line 471

Fatal error: __clone method called on non-object in /home/http/www.cantr.net/www/locations.inc.php on line 473


Anything I do after that gives the same error, and then I have to log in again.


Edit: There is a way out of this without logging back in. If I hit the back button and wait until the event page refreshes, and then click the Events button, it seems to be all fine again. But it's still annoying. Especially when I have to write the descriptions of a character all over from scratch again.

[Indigo]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1\n
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/http/www.cantr.net/www/locations.inc.php on line 325
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND type=0' at line 1\n
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/http/www.cantr.net/www/locations.inc.php on line 471

Fatal error: __clone method called on non-object in /home/http/www.cantr.net/www/locations.inc.php on line 473

[Ice-Man]

Have the same error as above. Trying to put some clothes on.

[EchoMan]

Have the same error as above. Trying to put some clothes on.

Does it happen every time you try to put some clothes on? What happens if you hit the back button until you come to the events page, let it auto refresh and try again?