MySql Errors...
0
Hey guys, I;ve been getting these errors, when searching for a file
[code:1]Error in query: $mangacount. 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 '2 FREEZE!!')' at line 2[/code:1]
I understand that the file servers are being updated, but this happened when the server had just came up too. However, it did not happen when the downloads were off.
Could the MySql be updating to compensate for the downloads being re-added?
-Grim3
[code:1]Error in query: $mangacount. 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 '2 FREEZE!!')' at line 2[/code:1]
I understand that the file servers are being updated, but this happened when the server had just came up too. However, it did not happen when the downloads were off.
Could the MySql be updating to compensate for the downloads being re-added?
-Grim3
0
ZOMG it hurts my head! We need a programmer.... MINSC! or you can ask Jacob! hes really smart too!
0
Nikon
FAKKU Old Guard
grim3 wrote...
Could the MySql be updating to compensate for the downloads being re-added?
-Grim3
That would be a good assumption.
0
The cause of this error is that apostrophe is a reserved character in SQL, so the name "darlin'2 freeze!!" causes an error when included in the SQL query. To escape the apostrophe (that is, to fix the query), you need to include two apostrophes, one after the other. This tells the database that you are trying to write an apostrophe, rather than trying to end the query string. Thus, the following link searches correctly:
https://www.fakku.net/mangasearchgo.php?searchterm=Darlin%27%272+FREEZE%21%21
However, I seem to be unable to either download the zip file or view the gallery--both options get me a 404 error.
https://www.fakku.net/mangasearchgo.php?searchterm=Darlin%27%272+FREEZE%21%21
However, I seem to be unable to either download the zip file or view the gallery--both options get me a 404 error.