Announcement

#1 2012-03-14 22:56:20

samli
Translation Team
Hungary (Budapest)
1970-01-01
67

mysql error 1064

Hi,
What is wrong?
Batch Manager
Warning:  [mysql error 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 'LIMIT 20 OFFSET 0' at line 5

SELECT id,path,tn_ext,file,filesize,level,name
  FROM piwigo_images
  WHERE id IN (178,179,180,181,182,183,184,185,186,187,190)
  ORDER BY
  LIMIT 20 OFFSET 0
; in /home/pb/httpdocs/include/dblayer/functions_mysql.inc.php on line 767


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pb/httpdocs/include/dblayer/functions_mysql.inc.php on line 153

Piwigo 2.3.3
PHP: 5.2.17
mysql: 5.0.92
Graphics Library: GD bundled (2.0.34 compatible)


Ubuntu 10.04 (Lucid Lynx)
XUbuntu 12.04 (Precise Pangolin)

Offline

 

#2 2012-03-14 23:32:24

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13791

Re: mysql error 1064

Hi samli,

What is the default photos sort order on [Administration > Configuration > Options] ?

Offline

 

#3 2012-03-14 23:44:42

samli
Translation Team
Hungary (Budapest)
1970-01-01
67

Re: mysql error 1064

Hi plg
Rank (descending)


Ubuntu 10.04 (Lucid Lynx)
XUbuntu 12.04 (Precise Pangolin)

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact