Bakotopia

Search:
Error: Query failed. MySQL Says: "Column 'user_id' in where clause is ambiguous"\n
Error: This query is invalid:
SELECT COUNT( DISTINCT( data.data_id ) ) AS count FROM data
                    JOIN dataclassified ON dataclassified.data_id = data.data_id
                    JOIN datamap ON data.data_id = datamap.data_id
                    JOIN categoryswitchboard ON datamap.categorypool_id = categoryswitchboard.categorypool_id
                    LEFT JOIN user ON user.user_id = data.user_id
                    WHERE data.start_time <= '2008-09-07 03:50:48' AND data.end_time > '2008-09-07 03:50:48' AND data.is_active = 'true'  AND user_id = '223811'  AND otheradlinks = 'true'   
                        AND categoryswitchboard.lineage LIKE '|%'
                        AND data.brand_id = '1'

Call Stack Table:
filelinefunction
/var/www/html/bakotopia.com/2.9/webroot/core/Database.php294debug_table
/var/www/html/bakotopia.com/2.9/webroot/core/Database.php589query
/var/www/html/bakotopia.com/2.9/platform/component/core/database/GenericData.php1314query
/var/www/html/bakotopia.com/2.9/platform/component/classified/widgets/wdg_UserClassifiedAds/UserClassifiedAds.php29getDataCount
/var/www/html/bakotopia.com/2.9/webroot/home744post


All ads from this user

Bakotopia helps people in Bakersfield, California find cool events, meet up, buy and sell stuff, find jobs and more. Learn more about us.

Forgot password?

NO ACCOUNT YET? REGISTER NOW!