6
« on: October 28, 2008, 05:44:46 am »
Hi today have encounterd this error while login
Error (DBQueryError)
Query failed with message '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 ') AND show_in_parents = 1) ORDER BY updated_on DESC LIMIT 0, 5' at line 1'
Error params:
File: C:\Program Files\Apache Group\Apache2\htdocs\opengoo\environment\library\database\adapters\AbstractDBAdapter.class.php
Line: 371
Sql: SELECT * FROM `og_project_charts` WHERE (project_id in () AND show_in_parents = 1) ORDER BY updated_on DESC LIMIT 0, 5
Error number: 1064
Error message: 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 ') AND show_in_parents = 1) ORDER BY updated_on DESC LIMIT 0, 5' at line 1
Backtrace:
#0 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\environment\library\database\adapters\AbstractDBAdapter.class.php(289): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\environment\library\database\DB.class.php(194): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\environment\classes\dataaccess\DataManager.class.php(182): DB::executeAll('SELECT * FROM `...')
#3 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\application\models\project_charts\base\BaseProjectCharts.class.php(109): DataManager->find(Array)
#4 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\environment\classes\dataaccess\DataManager.class.php(210): BaseProjectCharts->find(Array)
#5 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\application\models\project_charts\base\BaseProjectCharts.class.php(126): DataManager->findAll(Array)
#6 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\application\models\project_charts\base\BaseProjectCharts.class.php(128): BaseProjectCharts->findAll(Array)
#7 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\application\controllers\DashboardController.class.php(56): BaseProjectCharts->findAll(Array)
#8 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\environment\classes\controller\Controller.class.php(69): DashboardController->index()
#9 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\environment\classes\controller\PageController.class.php(62): Controller->execute('index')
#10 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\environment\classes\Env.class.php(152): PageController->execute('index')
#11 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\init.php(150): Env::executeAction('dashboard', 'index')
#12 C:\Program Files\Apache Group\Apache2\htdocs\opengoo\index.php(9): require('C:\Program File...')
#13 {main}
Autoglobal varibles:
$_GET: Array (
['c'] => (string) 'dashboard'
['a'] => (string) 'index'
)
$_POST:
$_COOKIE: Array (
['PHPSESSID'] => (string) 'gf37ckkbmlk9gq3701fo2jco20'
['id'] => (string) '1'
['token'] => (string) '8b9657a85fd75fa392cbffc805fdc87fa4d19b21'
)
$_SESSION: Array (
['cal_version'] => true
['cal_month'] => (string) '10'
['cal_year'] => (string) '2008'
['cal_day'] => (string) '28'
['cal_loginfailed'] => (int)0
['cal_user'] => (string) 'avadhutp'
['cal_userid'] => (int)10
)
Execution time:
Total execution time: 0.210541 seconds