The debug output follows, I have the same problem.
It apparently is trying to do something with billing, yet, I have no billing set up, so there is no ID, causing the error...
Adam
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 '' at line 1'
Error params:
File: /home/goo/public_html/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 386
Sql: SELECT * FROM `og_workspace_billings` WHERE project_id = '28' AND billing_id =
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 '' at line 1
Backtrace:
#0 /home/goo/public_html/environment/library/database/adapters/AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /home/goo/public_html/environment/library/database/DB.class.php(199): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /home/goo/public_html/environment/classes/dataaccess/DataManager.class.php(182): DB::executeAll('SELECT * FROM `...')
#3 /home/goo/public_html/application/models/workspace_billing/base/BaseWorkspaceBillings.class.php(112): DataManager->find(Array)
#4 /home/goo/public_html/environment/classes/dataaccess/DataManager.class.php(228): BaseWorkspaceBillings->find(Array)
#5 /home/goo/public_html/application/models/workspace_billing/base/BaseWorkspaceBillings.class.php(146): DataManager->findOne(Array)
#6 /home/goo/public_html/application/models/workspace_billing/base/BaseWorkspaceBillings.class.php(148): BaseWorkspaceBillings->findOne(Array)
#7 /home/goo/public_html/application/models/projects/Project.class.php(455): BaseWorkspaceBillings->findOne(Array)
#8 /home/goo/public_html/application/controllers/TimeslotController.class.php(108): Project->getBillingAmount(0)
#9 /home/goo/public_html/environment/classes/controller/Controller.class.php(75): TimeslotController->add_timespan()
#10 /home/goo/public_html/environment/classes/controller/PageController.class.php(62): Controller->execute('add_timespan')
#11 /home/goo/public_html/environment/classes/Env.class.php(133): PageController->execute('add_timespan')
#12 /home/goo/public_html/init.php(146): Env::executeAction('timeslot', 'add_timespan')
#13 /home/goo/public_html/index.php(9): require('/home/goo/publi...')
#14 {main}
Autoglobal varibles:
$_GET: Array (
['active_project'] => (string) '28'
['ajax'] => (string) 'true'
['c'] => (string) 'timeslot'
['a'] => (string) 'add_timespan'
['object_id'] => (string) '385'
['object_manager'] => (string) 'ProjectTasks'
['current'] => (string) 'tasks-panel'
)
$_POST: Array (
['timeslot'] => Array (
['description'] => (string) 'asdf'
['time'] => (string) '.5'
)
)
$_COOKIE: Array (
['PHPSESSID'] => (string) '2ac4b691573fd0551cb715f727a97856'
['id'] => (string) '1'
['token'] => (string) 'ba09f24cc485bfec2248fafeb9097df39db443c8'
)
$_SESSION: Array (
['cal_version'] => true
['month'] => (string) '3'
['year'] => (string) '2009'
['day'] => (string) '18'
['total_task_times_report_data'] => Array (
['date_type'] => (string) '4'
['timeslot_type'] => (string) '0'
['start_value'] => (string) '03/18/2009'
['end_value'] => (string) '03/18/2009'
['user'] => (string) '0'
['project_id'] => (string) '6'
['include_subworkspaces'] => (string) 'checked'
['group_by_1'] => (string) '0'
['group_by_2'] => (string) '0'
['group_by_3'] => (string) '0'
['alt_group_by_1'] => (string) '0'
['alt_group_by_2'] => (string) '0'
['alt_group_by_3'] => (string) '0'
)
)