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

User avatar
EchoMan
Posts: 7768
Joined: Fri Aug 26, 2005 1:01 pm
Location: Stockholm, Sweden

Re: MySQL error reports

Postby EchoMan » Mon Mar 12, 2012 11:39 am

Do you click CantrSpy to go to the game, or do you open FireFox and manually type the address?
User avatar
Rebma
Posts: 2898
Joined: Tue Aug 12, 2008 6:47 am
Location: London, ON
Contact:

Re: MySQL error reports

Postby Rebma » Mon Mar 12, 2012 11:57 am

In these SPECIFIC instances, I click cantr spy. However, cantrspy as I understand it to be, is set to take you to your PLAYER page. So it's not an issue of cantr spy having the old login page link or something that opens for you to get in by.
kronos wrote:like a nice trim is totally fine. short, neat. I don't want to be fighting through the forests of fangorn and expecting treebeard to come and show me the way in
User avatar
EchoMan
Posts: 7768
Joined: Fri Aug 26, 2005 1:01 pm
Location: Stockholm, Sweden

Re: MySQL error reports

Postby EchoMan » Mon Mar 12, 2012 12:04 pm

Can you please try to open the browser, type in the address manually and see if you still get the same errors?
User avatar
Rebma
Posts: 2898
Joined: Tue Aug 12, 2008 6:47 am
Location: London, ON
Contact:

Re: MySQL error reports

Postby Rebma » Mon Mar 12, 2012 1:11 pm

Sure. It worked fine with typing manually, and no characters lit up. But I think it's important to point out that it doesn't happen EVERY time I use cantrspy to get there. Just some of the time. I tried it a few times now, being already logged in, being logged out, and with no character activity, and couldn't recreate it.

However if I have any characters lit up, that's when it seems it is more likely to happen. I'll test it a few more times when I have activity later today, if you want, just to verify that. It seems to be the pattern I notice though.
kronos wrote:like a nice trim is totally fine. short, neat. I don't want to be fighting through the forests of fangorn and expecting treebeard to come and show me the way in
User avatar
Addicted
Posts: 973
Joined: Thu Apr 08, 2010 2:42 pm
Location: Australia

Re: MySQL error reports

Postby Addicted » Mon Mar 12, 2012 2:21 pm

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 836 Questions, suggestions or comments? Check the out-of-character department

followed by

ERROR: You followed an outdated link or bookmark, please remove it and create a new one.=

when i got back in.
User avatar
Rebma
Posts: 2898
Joined: Tue Aug 12, 2008 6:47 am
Location: London, ON
Contact:

Re: MySQL error reports

Postby Rebma » Mon Mar 12, 2012 2:34 pm

9:23am- Was logged out of cantr.
Cantrspy lit up
selected open player page>got login screen.
Logged in, clicked CharacterA, got error.


9:27am- Was logged out of cantr.
Cantrspy lit up
selected open player page>got login screen.
Logged in, clicked CharacterA, got error.


9:32am- Was logged out of cantr.
Cantrspy lit up
selected open player page>went to player page
clicked CharacterA, got error.

9:35am- Was logged out of cantr.
Cantrspy lit up
selected open player page>went to player page
clicked CharacterA, got error.

9:59am- Was logged out of cantr.
Cantrspy lit up
selected open player page>went to player page
clicked CharacterA, got error.


10:29am- Was logged out of cantr.
Cantrspy lit up
selected open player page>went to player page
clicked CharacterB, got error.


I think it's safe to say I've found the pattern.
kronos wrote:like a nice trim is totally fine. short, neat. I don't want to be fighting through the forests of fangorn and expecting treebeard to come and show me the way in
User avatar
psychowico
Posts: 1732
Joined: Wed Mar 02, 2011 9:57 am
Contact:

Re: MySQL error reports

Postby psychowico » Mon Mar 12, 2012 3:01 pm

selected open player page>went to player page

What exacly you mean?
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."

https://www.kinkykitty.pl
User avatar
Rebma
Posts: 2898
Joined: Tue Aug 12, 2008 6:47 am
Location: London, ON
Contact:

Re: MySQL error reports

Postby Rebma » Mon Mar 12, 2012 3:27 pm

psychowico wrote:
selected open player page>went to player page

What exacly you mean?

It means on cantrspy I selected the button to open the player page > and it brought me to the player page.
kronos wrote:like a nice trim is totally fine. short, neat. I don't want to be fighting through the forests of fangorn and expecting treebeard to come and show me the way in
User avatar
Hedgedhogst
Posts: 305
Joined: Thu Oct 20, 2011 10:54 pm
Location: London, England

Re: MySQL error reports

Postby Hedgedhogst » Fri Apr 20, 2012 11:38 pm

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /home/http/www.cantr.net/lib/database.inc.php on line 182

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/http/www.cantr.net/lib/database.inc.php on line 182
Access denied for user 'www-data'@'localhost' (using password: NO)\n

My world has vanished, and I'm hoping it's not my end... Again. :cry:
Image
3431-5.19: You novicely kill a badger using a bare fist.
4037-4.03: You expertly kill an elephant using a crumbling bone spear.
User avatar
Misato
Posts: 864
Joined: Thu Jan 11, 2007 5:51 am
Location: USA

Re: MySQL error reports

Postby Misato » Sat Apr 21, 2012 12:21 am

Hedgedhogst wrote:Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /home/http/www.cantr.net/lib/database.inc.php on line 182

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/http/www.cantr.net/lib/database.inc.php on line 182
Access denied for user 'www-data'@'localhost' (using password: NO)\n

My world has vanished, and I'm hoping it's not my end... Again. :cry:

Same for me...do the backups usually take this long? :(
ImageImage
"Two things are infinite: the universe and human stupidity; and I'm not sure about the universe."
User avatar
the_antisocial_hermit
Posts: 3695
Joined: Thu Sep 23, 2004 4:04 pm
Location: Hollow.
Contact:

Re: MySQL error reports

Postby the_antisocial_hermit » Sat Apr 21, 2012 1:33 am

That page doesn't necessarily mean it's backing up. It comes up when there are backups at their regular time and when the game is simply down. Right now the game is simply down due to unknown reasons, since lots of people seem to be having an issue. Usually if the game is going down for an abnormal backup or whatever, we get some warning. Hopefully someone can look into it and get it fixed soon.
Glitch! is dead! Long live Glitch!
Remember guys and gals, it's all Pretendy Fun Time Games!
User avatar
Cdls
Posts: 4204
Joined: Sat May 14, 2005 7:09 pm

Re: MySQL error reports

Postby Cdls » Sat Apr 21, 2012 3:08 am

There is this:
(Can't contact the database server: Too many connections (localhost))


When viewing the wiki, which does give a better idea as to what is going on.
User avatar
EchoMan
Posts: 7768
Joined: Fri Aug 26, 2005 1:01 pm
Location: Stockholm, Sweden

Re: MySQL error reports

Postby EchoMan » Sat Apr 21, 2012 9:52 am

The server was restarted a while ago. Everything should be back to normal.
User avatar
Cdls
Posts: 4204
Joined: Sat May 14, 2005 7:09 pm

Re: MySQL error reports

Postby Cdls » Fri Apr 27, 2012 11:16 pm

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /home/http/www.cantr.net/lib/database.inc.php on line 182

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/http/www.cantr.net/lib/database.inc.php on line 182
Access denied for user 'www-data'@'localhost' (using password: NO)\n


Basically a copy/paste of the exact same thing that happened a week ago, nearly to the same time?
User avatar
Cheshierekat
Posts: 1114
Joined: Sun Nov 23, 2003 4:40 am
Location: Somewhere in the Amazon

Re: MySQL error reports

Postby Cheshierekat » Sat Apr 28, 2012 12:55 am

Is this going to be an every Friday thing? :( Just asking, not trying to complain
When people tell me that great minds think alike, all I can do is look at them and think "oh you dirty, dirty bastard"

Return to “General Support”

Who is online

Users browsing this forum: No registered users and 1 guest