Error

This error is happening when, in demo, under "Opened today", I click on number "2".

ERROR: /home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php(62): Error 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 executing:

SELECT project_name, project_color_identifier, project_company AS item_company_id FROM projects where project_id=

Backtrace:
0 /home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php:62 dprint('/home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php',62,0,'Error 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 executing:

SELECT project_name, project_color_identifier, project_company AS item_company_id FROM projects where project_id=

')
1 /home/caseydk/public_html/demo/dotproject-man/includes/db_connect.php:134 db_exec('SELECT project_name, project_color_identifier, project_company AS item_company_id FROM projects where project_id=')
2 /home/caseydk/public_html/demo/dotproject-man/modules/helpdesk/view.php:27 db_loadlist('SELECT project_name, project_color_identifier, project_company AS item_company_id FROM projects where project_id=')
3 /home/caseydk/public_html/demo/dotproject-man/index.php:326 require('/home/caseydk/public_html/demo/dotproject-man/modules/helpdesk/view.php')

ERROR: /home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php(62): Error 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 executing:

SELECT company_name FROM companies where company_id=

Backtrace:
0 /home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php:62 dprint('/home/caseydk/public_html/demo/dotproject-man/includes/db_adodb.php',62,0,'Error 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 executing:

SELECT company_name FROM companies where company_id=

')
1 /home/caseydk/public_html/demo/dotproject-man/includes/db_connect.php:134 db_exec('SELECT company_name FROM companies where company_id=')
2 /home/caseydk/public_html/demo/dotproject-man/modules/helpdesk/view.php:33 db_loadlist('SELECT company_name FROM companies where company_id=')
3 /home/caseydk/public_html/demo/dotproject-man/index.php:326 require('/home/caseydk/public_html/demo/dotproject-man/modules/helpdesk/view.php')

Reply

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <br> <img> <p> <blockquote>
  • Lines and paragraphs break automatically.

More information about formatting options