SQL Error - functions.inc on line: 563

[xkorex]

Woops. Thanks a lot.

I'm going to try it now.

Regards

[profago]

Hi,
i've got Dragonfly 9.2.1 with functions.inc 9.46 but i recive every day mails like that:

Quote::

On /index.php?name=coppermine&file=displayimage&meta=random&album=32&pid=601&slideshow=5000 While executing query "SELECT pid, filepath, filename, p.title, keywords, url_prefix, filesize, pwidth, pheight, ctime, p.aid, p.aid FROM cms_cpg_pictures AS p INNER JOIN cms_cpg_albums AS a ON (p.aid = a.aid AND visibility IN (0,3) AND a.aid = 32) WHERE approved='YES' GROUP BY p.pid ORDER BY RAND() LIMIT -1" the following error occured: 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 1 In: /membri2/distrutti/includes/coppermine/functions.inc on line: 563 Guest information: User id: 1 Username: Anonimo Admin: No IP: 66.249.71.85 Host: crawl-66-249-71-85.googlebot.com

What may I do? Thank You.

[NanoCaiordo]

You don't have an original 9.46 for sure. If you believe you really have 9.46 please download it again.

As far I can tell you are using a version number equal or lower then 9.21

[profago]

I have put "new" functions.inc in my includes/coppermine/ directory, i have deleted files in my cache directory but nothing has changed...

Quote::

On /index.php?name=coppermine&file=displayimage&meta=random&album=22&pid=352&slideshow=5000 While executing query "SELECT pid, filepath, filename, p.title, keywords, url_prefix, filesize, pwidth, pheight, ctime, p.aid, p.aid FROM cms_cpg_pictures AS p INNER JOIN cms_cpg_albums AS a ON (p.aid = a.aid AND visibility IN (0,3) AND a.aid = 22) WHERE approved='YES' GROUP BY p.pid ORDER BY RAND() LIMIT -1" the following error occured: 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 1 In: /membri2/distrutti/includes/coppermine/functions.inc on line: 563 Guest information: User id: 1 Username: Anonimo Admin: No IP: 66.249.71.83 Host: crawl-66-249-71-83.googlebot.com

What i may do?

[NanoCaiordo]

Contact your system administrator and ask them if they are using any PHP accelerator.
If so tell them that the accelerator is failing to stat the new file.

[profago]

My problem persist because i have contacted my hosting service but they told me that they aren't use any PHP accelerator.
Any other idea?
Thankyou

[profago]

Now i have done oneother control about

www.distrutti.it//inde...eshow=5000

directly with phpmyadmin and i have seen that there isn't any image with
aid=33 and pid=788
this should be the answer of the problem?

[profago]

The final answer is no...
i have lot of error notification also for existing pictures as

www.distrutti.it/index...33&pid=609

www.distrutti.it/index...13&pid=170

www.distrutti.it/index...16&pid=325

and so on...
Any suggestion?
Thank you

[NanoCaiordo]

NanoCaiordo wrote:

You don't have an original 9.46 for sure. If you believe you really have 9.46 please download it again. As far I can tell you are using a version number equal or lower then 9.21

And as far i can tell you are using a mix of 9.0.6 and 9.1.x files ... no one single error you reported tell me you using 9.2.x

[profago]

Ok,
now i have re-download Dragonfly9.2.1.zip un-compressed it.

Deleted:
/includes/coppermine/*.*
/modules/coppermine/*.*

Pasted from compressed file:
/includes/coppermine/*.*
/modules/coppermine/*.*

and than updated /includes/coppermine/functions.inc to 9.46 version.

Now I'm waiting.

[NanoCaiordo]

DragonflyCMS 9.2.1 is already shipped with includes/coppermine/function.inc v9.46

[profago]

I have also now the same 563 problem...
Any suggestion?

[profago]

108 more problems...