Messages

1

Discussion & Troubleshooting / Re: query problems with MySQL 5.0.x

« on: December 10, 2005, 05:07:25 PM »

i reinstalled xampp
http://www.apachefriends.org/en/xampp.html

for me the best, because completely configuered

2

Discussion & Troubleshooting / Re: query problems with MySQL 5.0.x

« on: December 10, 2005, 04:18:23 PM »

after installing the server completely new, i don't get any error.
i think, there was something in the cache ?
any idea's why?

now it works perfect 

@punzeroni
error: look at reply 16!

3

Discussion & Troubleshooting / Re: query problems with MySQL 5.0.x

« on: December 07, 2005, 12:43:54 PM »

then you missed a line in the a file. cause in the error its clear that you didnt do the changes on that particular query that produces the error.

i changed the files with the help of "punzeroni"
now i get the error only on the starting site.
the other one are o.k.

there is no "new picture" showing on the same site too
could it be the same error?
howcan i fix it?

many thanks or helping me 

4

Discussion & Troubleshooting / Re: query problems with MySQL 5.0.x

« on: December 04, 2005, 11:41:57 PM »

I'm sorry, but i get always this
(tried 2 times with a new installation and an existing album)

Code: [Select]

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 0, 1
Unknown column 'i.user_id' in 'on 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.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 = 1 AND c.cat_id = i.cat_id ORDER BY image_name ASC LIMIT 0, 9
Unknown column 'i.user_id' in 'on clause'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in x\4images\includes\db_mysql.php on line 116

5

Discussion & Troubleshooting / Re: query problems with MySQL 5.0.x

« on: December 04, 2005, 07:58:54 PM »

please give us a chance to fix it