| |
Haven't registered yet? Do it here now!
|
keymaster
Joined: 01 May 2007
Posts: 15
|
|
|
 |
|
 |
|
 Posted: Sat May 05, 2007 4:35 pm Post subject: Query to MySQL Failed |
 |
|
|
 |
|
 |
|
|
|
|
I use MySQL 4.1.20 when i posting on remote blog MySQL shows the message on a error " Query to MySQL Failed: 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 " order by RAND () limit 1 ' at line 1 ".
Thanks. |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Sat May 05, 2007 6:04 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
hm, thats strange. Have this always been happening, or it just happened now? Also have something on server being changed recently?
Check also if the "magic_quotes_gpc" setting is enabled in your php configuration.
Let me know..
_________________
Thanks,
Kaktusan
 |
|
|
|
|
|
|
|
keymaster
Joined: 01 May 2007
Posts: 15
|
|
|
|
|
|
|
| Posted: Sat May 05, 2007 7:37 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
| You absolutely right "magic_quotes_gpc" is switched off, i switched on and now all ok. Thanks. |
|
|
|
|
|
|
|
keymaster
Joined: 01 May 2007
Posts: 15
|
|
|
|
|
|
|
| Posted: Sat May 05, 2007 8:47 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
| I have hurried, error appears if I use this function " This blog plus the following percentage of random blogs within this category " |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Sun May 06, 2007 11:54 am Post subject: |
|
|
|
|
|
|
|
|
|
|
ok, so after turning the magic_quotes_gpc, the problem still exists when you are adding new post and clicking on option "This blog plus the following percentage of random blogs within this category" , right?
Will be looking now at that part..
_________________
Thanks,
Kaktusan
|
|
|
|
|
|
|
|
keymaster
Joined: 01 May 2007
Posts: 15
|
|
|
|
|
|
|
| Posted: Sun May 06, 2007 4:48 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
| Atanasis wrote: | ok, so after turning the magic_quotes_gpc, the problem still exists when you are adding new post and clicking on option "This blog plus the following percentage of random blogs within this category" , right?
Will be looking now at that part.. |
Yes, right. |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Mon May 07, 2007 12:43 am Post subject: |
|
|
|
|
|
|
|
|
|
|
hi there, okay i located the problem, it was a small typo in the code. I fixed it, you may download the upgrade package from the software owners lounge, unpack and replace ONLY file "/bo/index.php".
Let me know on any more problems..
_________________
Thanks,
Kaktusan
|
|
|
|
|
|
|
|
keymaster
Joined: 01 May 2007
Posts: 15
|
|
|
|
|
|
|
| Posted: Mon May 07, 2007 9:42 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
| Good job Atanasis, thanks. Script works normally. |
|
|
|
|
|
|
|
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 vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|
 |
|
 |
| |
