It is currently 28 Mar 2024, 10:51

All times are UTC [ DST ]




 Page 1 of 1 [ 3 posts ] 
Author Message
 Post subject: Can't add new titles with apostrophes!
PostPosted: 20 Feb 2017, 21:58 
Serious fan
Serious fan
User avatar

Joined: 05 Jan 2005, 21:37
Posts: 202
Location: Lexington, Ky, United States
Has thanked: 1 time
Been thanked: 37 times
ARRRGGGHHH! The apostrophe problem which we all thought was finally dead and buried has risen from the grave yet again! :twisted: I have two new titles I was trying to submit, but am unable to do so, apparently because they both contain apostrophes! Everything seems totally normal during the submission process right up until the very last moment. When I click on the last button to submit all of the information I have entered, I keep getting an error message. The two titles are Hong Kong releases of "Smilla's Sense of Snow" and "Daddy's Girl". The message I keep getting on the latter is as follows: 1064: 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 's Girl', 'ULV3734', '1', '3', NULL, NULL, '-', '-', '0116003', '1996', '2', '1', ' at line 1. This is exactly what keeps appearing when I try to submit this title. Has anyone else experienced this recently? Julien, please help us! :problem:

Thanks,
David :wave:
Offline
 Profile  
 
 Post subject: Re: Can't add new titles with apostrophes!
PostPosted: 21 Feb 2017, 16:40 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
laserking wrote:
ARRRGGGHHH! The apostrophe problem which we all thought was finally dead and buried has risen from the grave yet again! :twisted:


Well, we did upgrade from PHP 5.2.x to 5.6.x so we might have some growing pains again!

Let me try to reproduce the problem ASAP in the test environment.

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: Can't add new titles with apostrophes!  Topic is solved
PostPosted: 14 Mar 2017, 04:07 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
Should be back to normal now!

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 3 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: