[mtha]

Originally Posted by mrcancel

When i integration 4images with vbulletin , i have a error :

DB Error: Bad SQL Query: SELECT COUNT(*) as users FROM user WHERE user_id <> 0
Unknown column 'user_id' in 'where clause'

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.username FROM music_images i, music_categories c LEFT JOIN user u ON (u.userid = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY DESC LIMIT 1
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 'DESC LIMIT 1' at line 5

from the error, you DID NOT setup field names for user table right. You may have installed an OUT OF DATE version of this integration.

Here is my post right above yours, I hope you dont mind reading it again:

Here's the UPDATED version. I CANNOT support an out_of_date version.

https://vborg.vbsupport.ru/showthread.php?t=66335