Author Topic: problem  (Read 2710 times)

0 Members and 1 Guest are viewing this topic.

Offline popmart68

  • Pre-Newbie
  • Posts: 3
    • View Profile
problem
« on: January 11, 2008, 05:48:27 PM »
when i try to post a pic at my 4images i get this error when i logon

DB Error: Bad SQL Query: SELECT 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, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id LIMIT 1586, 1
Unknown column 'i.user_id' in 'on clause'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /bigdisk/home/nylonvri/public_html/foto/includes/db_mysql.php on line 116

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: problem
« Reply #1 on: January 11, 2008, 05:58:24 PM »
This is so ask now ... please use forum search for: Unknown column 'i.user_id' in 'on clause' .
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?