FIND YOUR PERFECT AFFORDABLE HOME.
THE RIGHT LOCATION, THE RIGHT PRICE.

Opps! Error 500

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 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 '' at line 1

NEARBY CITIES
NEARBY HOUSING AUTHORITIES

EAST REGION | MIDWEST REGION | SOUTH REGION | SOUTHWEST REGION | WEST REGION
Application Log
Timestamp Level Category Message
14:05:42.590833 error system.db.CDbCommand
CDbCommand::() failed: SQLSTATE[42000]: Syntax error or access violation:
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
'' at line 1. The SQL statement executed was: update property set
page_views = (page_views+1) where id_property=.
14:05:42.591590 error exception.CDbException
exception 'CDbException' with message 'CDbCommand failed to execute the SQL
statement: SQLSTATE[42000]: Syntax error or access violation: 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 '' at line 1' in
/home/cavepear/rentalhousingdeals.com/framework/db/CDbCommand.php:541
Stack trace:
#0 /home/cavepear/rentalhousingdeals.com/framework/db/CDbCommand.php(376):
CDbCommand->queryInternal('', 0, Array)
#1
/home/cavepear/rentalhousingdeals.com/protected/models/Property.php(494):
CDbCommand->query()
#2
/home/cavepear/rentalhousingdeals.com/protected/controllers/PropertysearchController.php(384):
Property->setPageViews(NULL)
#3
/home/cavepear/rentalhousingdeals.com/framework/web/actions/CInlineAction.php(49):
PropertysearchController->actionDetail()
#4
/home/cavepear/rentalhousingdeals.com/framework/web/CController.php(308):
CInlineAction->runWithParams(Array)
#5
/home/cavepear/rentalhousingdeals.com/framework/web/CController.php(286):
CController->runAction(Object(CInlineAction))
#6
/home/cavepear/rentalhousingdeals.com/framework/web/CController.php(265):
CController->runActionWithFilters(Object(CInlineAction), Array)
#7
/home/cavepear/rentalhousingdeals.com/framework/web/CWebApplication.php(282):
CController->run('detail')
#8
/home/cavepear/rentalhousingdeals.com/framework/web/CWebApplication.php(141):
CWebApplication->runController('propertysearch/...')
#9
/home/cavepear/rentalhousingdeals.com/framework/base/CApplication.php(169):
CWebApplication->processRequest()
#10 /home/cavepear/rentalhousingdeals.com/index.php(12):
CApplication->run()
#11 {main}
REQUEST_URI=/OR/Island-City/UCSL/Emily-Drive
---