Warning (512): SQL 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 'ORDER BY `Tweet`.`id` DESC' at line 1 [/var/www/cake_1.2.1.8004/cake/libs/model/datasources/dbo_source.php, line 514]
$sql = "SELECT `Tweet`.`id`, `Tweet`.`twitter_user_id`, `Tweet`.`tweet`, `Tweet`.`created`, `TwitterUser`.`id`, `TwitterUser`.`name`, `TwitterUser`.`screen_name`, `TwitterUser`.`location`, `TwitterUser`.`description`, `TwitterUser`.`profile_image_url`, `TwitterUser`.`url` FROM `tweets` AS `Tweet` LEFT JOIN `twitter_users` AS `TwitterUser` ON (`Tweet`.`twitter_user_id` = `TwitterUser`.`id`) WHERE (Tweet LIKE '%beer%' OR Tweet LIKE '%dancing bologna%' OR Tweet LIKE '%geek hot%' OR Tweet LIKE '%blah%' OR Tweet LIKE '%digium%' OR Tweet LIKE '%asterisk%' OR Tweet LIKE '%tweetup%') AND twitter_user_id= ORDER BY `Tweet`.`id` DESC "
$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 'ORDER BY `Tweet`.`id` DESC' at line 1"
$out = null
DboSource::showQuery() - /var/www/cake_1.2.1.8004/cake/libs/model/datasources/dbo_source.php, line 514
DboSource::execute() - /var/www/cake_1.2.1.8004/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - /var/www/cake_1.2.1.8004/cake/libs/model/datasources/dbo_source.php, line 337
DboSource::read() - /var/www/cake_1.2.1.8004/cake/libs/model/datasources/dbo_source.php, line 636
Model::find() - /var/www/cake_1.2.1.8004/cake/libs/model/model.php, line 1956
Model::findAll() - /var/www/cake_1.2.1.8004/cake/libs/model/model.php, line 2821
TwitterUsersController::view() - APP/controllers/twitter_users_controller.php, line 18
Object::dispatchMethod() - /var/www/cake_1.2.1.8004/cake/libs/object.php, line 117
Dispatcher::_invoke() - /var/www/cake_1.2.1.8004/cake/dispatcher.php, line 245
Dispatcher::dispatch() - /var/www/cake_1.2.1.8004/cake/dispatcher.php, line 211
[main] - APP/webroot/index.php, line 84
Query: SELECT `Tweet`.`id`, `Tweet`.`twitter_user_id`, `Tweet`.`tweet`, `Tweet`.`created`, `TwitterUser`.`id`, `TwitterUser`.`name`, `TwitterUser`.`screen_name`, `TwitterUser`.`location`, `TwitterUser`.`description`, `TwitterUser`.`profile_image_url`, `TwitterUser`.`url` FROM `tweets` AS `Tweet` LEFT JOIN `twitter_users` AS `TwitterUser` ON (`Tweet`.`twitter_user_id` = `TwitterUser`.`id`) WHERE (Tweet LIKE '%beer%' OR Tweet LIKE '%dancing bologna%' OR Tweet LIKE '%geek hot%' OR Tweet LIKE '%blah%' OR Tweet LIKE '%digium%' OR Tweet LIKE '%asterisk%' OR Tweet LIKE '%tweetup%') AND twitter_user_id= ORDER BY `Tweet`.`id` DESC
To give a tweetout, follow aubiematt on twitter and tweet using any of these keywords: beer, dancing bologna, geek hot, blah, digium, asterisk, tweetup