Page 1 of 7

Post-relaunch errors

Posted: Fri Nov 19, 2010 9:29 pm
by Wolf
I've so far encountered a few time-outs that were reported in the browser as soon as I clicked a button (but only three or four on a bunch of pages/buttons that I clicked).
And just now, after the last time-out, I hit a MySQL error when hitting the refresh button (because that loaded the pages fine at the other time-outs):
"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/index.php on line 523"

At that error I simply went to the main page (the one with the log-in link) and logged in again, and that seemed to work.

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 12:02 am
by Glup
<offtopic>A huge congratulations and thanks to all the wizards!</offtopic>

My character spotted a new species of exaggeratedly strong animal. It resembles a bear, but a single snap of its jaws maked my character almost dead.
Poor victim is (still) a skilled hunter and fighter, fully equipped and prepared to live in the wilderness.
He tried to block the beast using his reliable shield with 45% efficiency. However, the killer bear took him 90% of health.

Alarmed citizens are asking: Is this a new secret security force against the terrorists of the green world?

loc=6283, char=294513, time=3083-6.13

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 1:36 am
by Cdls
Got this error when speaking:

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

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 1:37 am
by SekoETC
I think someone (probably the hacker) may have messed with the bears since it says attack chance 100%, attack 120 and strength 200. I'll compare it to other animals but those numbers seem out of line. So probably good that the clock ain't running. Edit: lol, and it drops a huge bunch of gold when you kill it. I'm changing it now. Edit 2: Other animals seem okay, and strength 200 was probably ok too, but the attack chance and power were certainly far greater than for other bears. Edit 3: I gave Glup's character most health back and other people who have been attacked by insanely strong bears can report here.

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 2:01 am
by joo
SekoETC wrote:attack chance 100%, attack 120 and strength 200. ... lol, and it drops a huge bunch of gold when you kill it.

You should have kept it. :D

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 2:06 am
by SumBum
*ahem* but change that gold drop to iron or steel. ;) Obviously the hacker was clueless about what has value in Cantr.

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 2:12 am
by Wolf
No time-outs or MySQL errors this time around (have logged on for a few minutes), but one of my chars handed some healingfood to another char, who was awake at the time and ate it... and while that person ate them or might have been typing a reply, I was seeing several "undefined" lines (undefined something-something in line something-something) stack up among the other events, but they vanished when this person's reply hit the events screen.
I'd say they stacked up with about one line a second, maybe two a second... it wasn't much that stacked up and the reply was posted before I could really read the "undefined" lines.
They did seem to be in a smaller font size than the regular text and didn't get timestamped.

Edit:
Maybe also worth noting; at the time that happened, I myself was also typing a line, but haven't been able to replicate the "undefined" lines by typing afterwards.
So I'm not sure if that actually has anything to do with it... possibly (my best uneducated-ish guess at least at this time) it might have had to do with the passed healingfoods being consumed by the other character and this somehow showing up on my events as the undefined thing... which obviously shouldn't normally happen.
Although, for that to happen, the character would have to be taking small portions of the two different healingfoods in rapid succession... so that doesn't really make much sense either as it would mean (1) click eat button, (2) enter ammount, (3) the inventory page reloading, in under a second, repeatedly.

Edit 2:
After seeing something similar occur on an entirely different website, I should add that there is a chance that the "undefined" thing might have been related to me using the Konqueror browser, which might be having some funky effects on AJAX.
I say a chance, because there's no way for me to be entirely certain that it is either on my end, or on the Cantr end.
It hasn't happened to me again on Cantr since I posted about it here though.

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 8:47 am
by oxyquan
SekoETC wrote:I think someone (probably the hacker) may have messed with the bears since it says attack chance 100%, attack 120 and strength 200. I'll compare it to other animals but those numbers seem out of line. So probably good that the clock ain't running. Edit: lol, and it drops a huge bunch of gold when you kill it. I'm changing it now. Edit 2: Other animals seem okay, and strength 200 was probably ok too, but the attack chance and power were certainly far greater than for other bears. Edit 3: I gave Glup's character most health back and other people who have been attacked by insanely strong bears can report here.


It's a little strange to me. Didn't you retrieve code from backups/revision control system? Didn't you diff some tables in database to check if he hadn't mess up with something like properties of animals, etc. (don't know what you're storing in files, and what in database)?

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 10:11 am
by EchoMan
oxyquan wrote:It's a little strange to me. Didn't you retrieve code from backups/revision control system? Didn't you diff some tables in database to check if he hadn't mess up with something like properties of animals, etc. (don't know what you're storing in files, and what in database)?


We chose not to restore a backup of the database (and lose several hours of events), but rather to revive the characters that was messed with, and change a few other things we knew was tampered with. What do you suggest we should have compared with? A lot of the 137 database tables change very often. "Properties of animals" wasn't exactly the first thing we bothered to check when we suspected the hacker had gained access to admin passwords.

And we did retrieve the code, as well as rewriting most of it. I fail to see what that has to do with anything though.

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 11:32 am
by BarbaricAvatar
No project progression.

Neither newly set-up nor pre-crash projects are progressing.

I'm pretty sure boat travel isn't working either.

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 11:32 am
by oxyquan
Don't get me wrong. I want to thank you guys for your work, I realize how it could be difficult to fix everything and review and how big the database is. I also don't know the architecture of Cantr. But I assume that some tables aren't so often modified, like tables with properties of objects, animals and something like that. So you can diff this tables or even replace them, if backup is fresh enough. But now, we could only draw conclusions for the future.

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 11:56 am
by EchoMan
BarbaricAvatar wrote:No project progression.

Neither newly set-up nor pre-crash projects are progressing.

I'm pretty sure boat travel isn't working either.

Time doesn't advance, so neither does projects, travelling etc.

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 4:22 pm
by Chris
Players' "Time left" is going down as we play. Normally that isn't an issue because it resets every game day. However, with game time standing still, some players may run out of playing time before the time bug is fixed.

Re: Post-relaunch errors

Posted: Sat Nov 20, 2010 4:41 pm
by EchoMan
I have stopped the count-down. (It should probably be removed at some point, as it is meaningless with the 2000 setting)

Re: Post-relaunch errors

Posted: Sun Nov 21, 2010 4:01 pm
by gejyspa
Cutting and pasting from notes to text boxes now produces an "rn" where carriage returns were in the note. Bug or misfeature?

EDIT: Actually, ALL uses of carriage return in large text box is producing this.