SQL Errors
Filter
Show Official Posts OnlyReplies
The past few (3 I believe?) days I've occasionally received several errors while being on the site- this usually coincides with the site running very slowly for me, and after that error the browser I am in has to be closed because it keeps coming up with variations of that
SQL Error 1
Warning: mysqli_connect(): (HY000/1040): Too many connections in /var/app/current/include/class/database.new.php on line 8 Warning: mysqli_set_charset() expects parameter 1 to be mysqli, boolean given in /var/app/current/include/class/database.new.php on line 18
SQL Error
connection[/spoiler]
[spoiler=SQL Error 2]SQL Error SELECT COUNT(1) AS cnt FROM stocked_items WHERE itemid=LIMIT 1
Edited 1/6 More Error Messages:
Forbidden
Forbidden
You don't have permission to access / on this server.
Not Found
Not Found
The requested URL /shop.php was not found on this server.
And all of these are also interspersed with errors of the host site timing out
504
Error 504 Ray ID: 3d90d3002c3e6c8e • 2018-01-06 18:44:39 UTC
Gateway time-out
A lot of these originate out of the Free Shop and carry over to other parts- I didn't see a post with these errors yet so I wanted to make sure someone was aware!
If you love trading items, and keeping your sP, come check out Lets Trade!
I can confirm lag, timeouts, white pages, cloudflare and SQL
Right now I have been trying to use a Tome on one of my pets.
Just to see/prove, if/what eventually goes through.
My pets current stats: Level: 1,274
Strength: 3,632
Defense: 3,636
Speed: 3,183
Health: 3,185
HP: 3,122/3,185
Intelligence: 1,187
first try:
SQL Error UPDATE pets SET level='1277', strength='3635', defence='3638', intelligence='1189', health='3187', speed='3185' WHERE petid=355840 LIMIT 1
Tome fortunately still there.
second try:
SQL Error UPDATE pets SET level='1275', strength='3633', defence='3637', intelligence='1189', health='3186', speed='3185' WHERE petid=355840 LIMIT 1
Naturally I'd prefer the first result.
3rd try finally went though: Amoun-Ra gained: 2 level(s) 2 strength 3 defense 1 intelligence 3 health points 1 speed points
Great, thank you 😠 . Now of course I only gained one Intelligence point instead of 2!!!! And I'm using the tomes to boost intelligence. Not funny.
Same here. The lag and errors today, especially this afternoon, has been awful.
I updated my main post with other errors I've been receiving sporadically since yesterday
If you love trading items, and keeping your sP, come check out Lets Trade!
If you didn't receive a stat that you should have, please file a ticket. :)
Well, it rolled the dice each time, but the stats didn't come through. The 3rd try, that finally did work, simply was the worst. It is weird that it is doing the calculation but nothing more. Had it not shown me the possible outcome, I would only have been half as annoyed. I don't think this justifies a ticket, because I didn't lose the tome altogether.