Author Topic: Can anyone help me?  (Read 4244 times)

0 Members and 1 Guest are viewing this topic.

Offline tellme

  • Pre-Newbie
  • Posts: 2
    • View Profile
Can anyone help me?
« on: May 28, 2002, 08:18:28 PM »
4images is nice. I am a hobby webdesigner. The older version worked without problems, version 1,5 Beta gave me a tough time. My major problem now is the solution to the below "DB ERROR":

DB Error: Bad SQL Query: SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, u.user_name, c.cat_name FROM 4images_images i, 4images_users u, 4images_categories c WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND u.user_id = i.user_id AND c.cat_id = i.cat_id ORDER BY RAND()
You have an error in your SQL syntax near 'RAND()' at line 4

Plz. help me out
Tellme
I  like try every script i lay my hands on.

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
Can anyone help me?
« Reply #1 on: May 28, 2002, 08:41:31 PM »
Hi,

i guess your MySQL version is not 3.23 or higher.
To solve this, change the lines who are here described:

http://www.4homepages.de/forum/viewtopic.php?p=1165#1165
http://www.4homepages.de/forum/viewtopic.php?p=1186#1186
http://www.4homepages.de/forum/viewtopic.php?p=1203#1203

I hope you will understand it. Bold is the file you have to edit. First code is the the line you have to find, second is the code you have to raplace with it.

Greets Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline tellme

  • Pre-Newbie
  • Posts: 2
    • View Profile
Can anyone help me?
« Reply #2 on: May 29, 2002, 06:42:53 PM »
Thnx. 4 ur tips. It is working fine now.
 :)
I  like try every script i lay my hands on.