31
Discussion & Troubleshooting / Re: New images on different page
« on: July 04, 2007, 12:40:39 AM »
And how can i include this in a phpbb forum for example? what is the php code for include the pic_news.php ?
Check the new Tutorial subforum with helpfull guides and tutorials for modifications and tweaks.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Notice: Use of undefined constant SEARCH_STATS_TABLE - assumed 'SEARCH_STATS_TABLE' in C:\AppServ\www\search.php on line 93
Notice: Use of undefined constant SEARCH_STATS_TABLE - assumed 'SEARCH_STATS_TABLE' in C:\AppServ\www\search.php on line 98
I have a problem installing this mod in 1.7.4, when I enable cat_master appear this at the header: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_parent_id, c.cat_name, u.user_name FROM fondosimages i, fondoscategories c LEFT JOIN fondosusers u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_parent_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 C:\AppServ\www\includes\db_mysql.php on line 116
What im doing wrong?
Had the same problem, but solved it just replacing:Code: [Select]FROM ".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c
With this:Code: [Select]FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
Hope this helps!
Regards.
http://www.4homepages.de/forum/index.php?topic=3236.0
http://www.4homepages.de/forum/index.php?topic=10163.0
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_parent_id, c.cat_name, u.user_name FROM fondosimages i, fondoscategories c LEFT JOIN fondosusers u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_parent_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 C:\AppServ\www\includes\db_mysql.php on line 116