hi,
i installed the package at my isp and ran the install.php. everything worked fine.
now i what to start the index.php and i get the following:
Database error: Invalid SQL: SELECT sum(CASE WHEN status_name in ('Unconfirmed','New','Assigned','Reopened') THEN 1 ELSE 0 END ) ,sum(CASE WHEN status_name not in ('Unconfirmed','New','Assigned','Reopened') THEN 1 ELSE 0 END )from bt_bug b left join bt_status s using(status_id) where assigned_to = 1
MySQL Error: 1064 (You have an error in your SQL syntax near 'WHEN status_name in ('Unconfirmed','New','Assigned','Reopened') THEN 1 ELSE 0 EN' at line 1)
Session halted.
any idear???
thanks in advance,
mr
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hi,
i installed the package at my isp and ran the install.php. everything worked fine.
now i what to start the index.php and i get the following:
Database error: Invalid SQL: SELECT sum(CASE WHEN status_name in ('Unconfirmed','New','Assigned','Reopened') THEN 1 ELSE 0 END ) ,sum(CASE WHEN status_name not in ('Unconfirmed','New','Assigned','Reopened') THEN 1 ELSE 0 END )from bt_bug b left join bt_status s using(status_id) where assigned_to = 1
MySQL Error: 1064 (You have an error in your SQL syntax near 'WHEN status_name in ('Unconfirmed','New','Assigned','Reopened') THEN 1 ELSE 0 EN' at line 1)
Session halted.
any idear???
thanks in advance,
mr
Your ISP is using an older version of mysql that does not support that syntax. They need to upgrade mysql if you want to use this package there.