Forums
First  << 1 >>  Last
Forum Main>>Bugs & Issues>> Database error when saving event
redguoguo

ID: 1532848
Level: 48
Posts: 64
Score: 116
SMTH redguoguo [1532848]Reply | Quote | Report

Thread created on Sat Jan 21, 2012 03:39:02
Last replied to on Sun Jun 02, 2013 16:03:42
I was trying to save an event, then it happened like this:

Error - Database Error - Please retry or if this happens often email george@torn.com with detailsYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Liquid Body Armour items from you.','1532848','193634814') /* Script /events.p' at line 1


Please check.

Last Edited: Sat Jan 21, 2012 03:39:28
Super secret reinforced spam barrier 2.0
RatedR

ID: 72498
Level: 75
Posts: 19240
Score: 12075
RatedR [72498]Reply | Quote | Report

Posted on Sat Jan 21, 2012 12:05:08
I just tried to save my events and didnt encounter this issue. Is this still happening?



Super secret reinforced spam barrier 2.0
redguoguo

ID: 1532848
Level: 48
Posts: 64
Score: 116
SMTHredguoguo [1532848]Reply | Quote | Report

Posted on Sat Jan 21, 2012 13:25:58
I can save some events, but cannot save this certain event.
When I tried to save it, same info appeared.
Maybe it's a bug on certain type of event.

I have two more events that caused the same problem.

Event:
20/01/12
10:50:27 PM IrishDevil has retrieved one of the faction's Flame Thrower items from you.

Info:
Error - Database Error - Please retry or if this happens often email george@torn.com with detailsYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Flame Thrower items from you.','1532848','193634756') /* Script /events.php */' at line 1

Event:
20/01/12
10:50:39 PM IrishDevil has retrieved one of the faction's Kodachi Swords items from you.

Info:
Error - Database Error - Please retry or if this happens often email george@torn.com with detailsYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Kodachi Swords items from you.','1532848','193634767') /* Script /events.php *' at line 1

Super secret reinforced spam barrier 2.0
Link

ID: 1413750
Level: 50
Posts: 5024
Score: 4469
MnCLink [1413750]Reply | Quote | Report

Posted on Sat Jan 21, 2012 13:38:28
Error - Database Error - Please retry or if this happens often email george@torn.com with detailsYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Rusty Sword items from you.','1413750','193690687') /* Script /events.php */' at line 1

21/01/12
1:34:42 PM TheJudge has retrieved one of the faction's Rusty Sword items from you.



Error - Database Error - Please retry or if this happens often email george@torn.com with detailsYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Rusty Sword items from the faction armoury.','1413750','193690577') /* Script ' at line 1

21/01/12
1:33:27 PM TheJudge has lent you one of the faction's Rusty Sword items from the faction armoury.


Events that have an apostrophe get that error and are not saved. Other events save fine.

tinyurl.com/torn-crime-enhancers

Done: GTA1, Working on: Mayor Kidnap
Super secret reinforced spam barrier 2.0
Marc

ID: 24377
Level: 64
Posts: 5553
Score: 3442
JUXMarc [24377]Reply | Quote | Report

Posted on Sat Jan 21, 2012 13:57:36
Confirmed for Chedburn - the apostrophe is breaking the mysql query

Super secret reinforced spam barrier 2.0
Chedburn

ID: 1
Level: 35
Posts: 7240
Score: 12650
Chedburn [1]Reply | Quote | Report

Posted on Mon Jan 23, 2012 13:10:26
Fixed and tested, thanks.

Ched.jpg
Super secret reinforced spam barrier 2.0
InaPomer

ID: 1601867
Level: 54
Posts: 114
Score: 15
TuSInaPomer [1601867]Reply | Quote | Report

Posted on Fri May 17, 2013 18:44:57
I was taking candies before a workout and received this error.


DB error - please report session ba1d9dbcefbe1d26d4be6cc2d80f2839 to george@torn.com

Also received it droning beer for nerve increase

Super secret reinforced spam barrier 2.0
Vinny187

ID: 1211171
Level: 35
Posts: 15
Score: 2
Vinny187 [1211171]Reply | Quote | Report

Posted on Sat May 25, 2013 17:47:09
i keep getting this error randomly, usually when in faction interface or viewing a profile

DB error [memcache] - please report session 7969d6524bacfe76996139e229974181 and page 51a0e999bfef4 to george@torn.com

Super secret reinforced spam barrier 2.0
Mercust3

ID: 1739316
Level: 27
Posts: 3
Score: 0
Mercust3 [1739316]Reply | Quote | Report

Posted on Sun Jun 02, 2013 16:01:11
Mercust3

T3
Super secret reinforced spam barrier 2.0
Mercust3

ID: 1739316
Level: 27
Posts: 3
Score: 0
Mercust3 [1739316]Reply | Quote | Report

Posted on Sun Jun 02, 2013 16:03:42
Mercust3

T3
Forum Main>>Bugs & Issues>> Database error when saving event
First  << 1 >>  Last