Show Posts
16
Discussion & Troubleshooting / Re: query problems with MySQL 5.0.x
« on: September 03, 2008, 09:54:21 PM »
Greetings!
Admin, Mods & Fellow members,
Here's my site problem for reference:
http://freeadsph.com/faq.php
http://freeadsph.com/contact.php
Using:
4images Version: 1.7.6
PHP Version: 4.4.6
MySQL Version: 5
http://www.freeadsph.com/
I don't know if this is the right thread for me to ask question after exploring for possible answer i found this 7 pages thread and my problem looks similar but i don't know where to start really since my site properly running until my host upgraded yesterday from MSql 4/Php4 to MSql 5/Php 5 .
My problem to wit:
Admin Problem:
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 c.cat_id = i.cat_id AND i.cat_id IN (0, 13, 11, 10, 9, 2, 6, 7, etc...) AND i.image_date >=1219531456 ORDER BY RANT () LIMIT 3 Unknown column "i.user_id"in'on clause.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/freeads/public_html/includes/db_mysql.php on line 116
User Problem: An unexpected error occured. Please try again later
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/freeads/public_html/includes/db_mysql.php on line 116
Not only that as i observe when i minimize its size the contents/layout will also minimize. So, what's wrong? Can anyone help me? Or do i have to re-install again it.
Give me an idea please or can someone help me to solve this problem.
Thanks a lot...
Regards,
axlrose
from Philippines
Admin, Mods & Fellow members,
Here's my site problem for reference:
http://freeadsph.com/faq.php
http://freeadsph.com/contact.php
Using:
4images Version: 1.7.6
PHP Version: 4.4.6
MySQL Version: 5
http://www.freeadsph.com/
I don't know if this is the right thread for me to ask question after exploring for possible answer i found this 7 pages thread and my problem looks similar but i don't know where to start really since my site properly running until my host upgraded yesterday from MSql 4/Php4 to MSql 5/Php 5 .
My problem to wit:
Admin Problem:
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 c.cat_id = i.cat_id AND i.cat_id IN (0, 13, 11, 10, 9, 2, 6, 7, etc...) AND i.image_date >=1219531456 ORDER BY RANT () LIMIT 3 Unknown column "i.user_id"in'on clause.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/freeads/public_html/includes/db_mysql.php on line 116
User Problem: An unexpected error occured. Please try again later
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/freeads/public_html/includes/db_mysql.php on line 116
Not only that as i observe when i minimize its size the contents/layout will also minimize. So, what's wrong? Can anyone help me? Or do i have to re-install again it.
Give me an idea please or can someone help me to solve this problem.
Thanks a lot...
Regards,
axlrose
from Philippines