Home
Get your talents noticed!  Have fun!  Find friends!
Fun4biz

Fun4Biz is much more than just communication.

We help you shine and prosper!

Suggestion
[ Ravi Bindra ]   Created: 9/13/10   Closing date: 10/11/10
Type of improvement: Error correction Area of improvement: Interface
Location: http://fun4biz.com

I wished to see my favorite postings (Favorites - Postings), but received the following error message:

SELECT COUNT(*) FROM favorites AS t1 LEFT JOIN favoritesCategoriesAssoc
                             ON favoritesCategoriesAssoc.id_object = t1.id
                             AND favoritesCategoriesAssoc.modelname = 'favorites' WHERE id_owner=41  AND (favoritesCategoriesAssoc.id_type NOT IN () OR favoritesCategoriesAssoc.id_type IS NULL ) GROUP BY t1.id
289 Execution error => 1064: 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 ') OR favoritesCategoriesAssoc.id_type IS NULL ) GROUP BY t1.id' at line 3

 

Expert rating 6.5
Public rating 6.5

Voting is completed

Correct the error

 
Tree of discussion
Expand all Hide comments Sort by serious/humorous Author Rating Date
Sponsors of this page: