SQL-Error: SELECT images.imageid

klaush · March 27th, 2006, 11:26 AM

Anyone help me with this issue?

---

Invalid SQL:

SELECT images.imageid
FROM vb3_adv_gallery_images AS images

LEFT JOIN vb3_adv_gallery_customfields_entries AS customfields ON (images.imageid = customfields.imgid)
WHERE () AND () AND valid = 1;

MySQL-Fehler : 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 ') AND () AND valid = 1' at line 5
Fehler-Nr. : 1064
Datum : Monday, March 27th 2006 @ 06:09:11 PM
Skript : http://www.xxxxxxx.de/gallery/search.php
Referrer : http://www.xxxxxxx.de/gallery/search.php?

-----

Thanks!

KW802 · March 27th, 2006, 12:13 PM

Klaush,

Where & when exactly is that error occuring for you?

klaush · March 27th, 2006, 12:24 PM

Quote:

Originally Posted by KW802

Klaush,

Where & when exactly is that error occuring for you?

Thanks for your fast reply.

I don´t know, because it ist not reproducable. I got this message twice today!

How can i get more information from the script?

Zachariah · March 27th, 2006, 01:03 PM

Hello:

gallery/search.php

Find:

Code:

Content visible to verified customers only.

Replace:

Code:

Content visible to verified customers only.

Let me know of progress. Please.

klaush · March 27th, 2006, 02:23 PM

Quote:

Originally Posted by Zachariah

Hello:

gallery/search.php

Find:

Code:

Content visible to verified customers only.

Replace:

Code:

Content visible to verified customers only.

Let me know of progress. Please.

Thanks, my dear friend! :-)

Changed the code and will inform you and the users here!