MySQL

There appears to be an error with the database.

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2006

Posts: 10

Reputation: animatronico is an unknown quantity at this point

Solved Threads: 0

animatronico animatronico is offline

Offline

Newbie Poster

There appears to be an error with the database.

Jun 26th, 2006

I just got this Error Returned when i tryied Type the url of my site
mySQL query error: SELECT e.*,b.blog_name, b.blog_friendly_url FROM ibf_blog_entries e,ibf_blog_blogs b LEFT JOIN ibf_blog_categories bc ON ( e.blog_id=bc.blog_id and e.category_id=bc.category_id ) WHERE e.entry_status='published' AND (b.blog_private=0 or b.blog_id = 1) AND ((bc.blog_id IS NULL) or (b.blog_id = 1) or (bc.category_type = 'private' AND bc.blog_id=1) or (bc.category_type = 'public')) AND e.blog_id=b.blog_id ORDER BY e.entry_date DESC LIMIT 0,5
SQL error: Unknown column 'e.blog_id' in 'on clause'
SQL error code:
Date: Monday 26th of June 2006 07:51:58 AM

any one know what I should do? to fix that.

http://www.webtraffic-4u.com 180 FREE Hits per hour to your site. That's 4320 FREE Hits per day.

----------------------------------------------------------------
75000 MB. Web Space 1110 GB Transfer £5.25 per month add this coupon and get extra 5000 Mb extra space
http://www.servage.net/?coupon=cust19989