1064: You have an error in your SQL syntax. Check the manua

aavdberg
aavdberg's picture

Joined: 2002-09-29
Posts: 100
Posted: Thu, 2004-04-08 18:08

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
'-1' at line 12

adodb_mysqlt._execute(
SELECT
g2_UserGroupMap.g_userId,
g2..., false) % line 767,
file: adodb.inc.php

adodb_mysqlt.execute(
SELECT
g2_UserGroupMap.g_userId,
g2..., Array[1]) % line 438,
file: adodb-mysql.inc.php
adodb_mysqlt.selectlimit(
SELECT
g2_UserGroupMap.g_userId,
g2..., -1, -1, Array[1]) %
line 1044, file: DatabaseStorage.class
mysqldatabasestorage.search(
SELECT
[GalleryUserGroupMap::userId],
..., Array[1], Array[1]) % line
203, file: Gallery.class
gallery.search(
SELECT
[GalleryUserGroupMap::userId],
..., Array[1], Array[1]) % line
173, file: GalleryUserGroupHelper_medium.class

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Fri, 2004-04-09 05:03
aavdberg wrote:
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
'-1' at line 12...
adodb_mysqlt.execute(

I see this problem has not gone away. :-/ The error should have been accompanied by a stack trace. Can you post that here, please? Thanks!

 
aavdberg
aavdberg's picture

Joined: 2002-09-29
Posts: 100
Posted: Sat, 2004-04-17 14:47

Hello Bharat,

I have solved the problem, i had installed MySQL 4.1.1 and just a couple of minutes ago i did remove MySQL 4.1.1 and Installed 4.0.18 and now it working like a charm.

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Thu, 2004-04-22 08:18

Hrm. I'll install MySQL 4.1.1 somewhere and see if I can reproduce your problem. Thanks for the update!