Installed version 1.0, using Postgres SQL 8.03, PHP 4.3.6 on
Scientific Linux 3.3
Installiation worked fine, Database connection check OK, Tables in DB were created. I checked the postgres database, and found several tables there.
After logging in , and using the administration tools for setting up users,m groups, projects etc. I always get the error "A database error occured" -
After reinstalling and trying to fix the problem - I give up !!
Any suggestions where the error is !!!
Thanxs for your help
ThN
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
On line 521 of inc/functions.php, change the RAWERROR definition from false to true, then try loading the page again. This should allow the full error to be displayed.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi I did activate the RAWERROR flag to true and get the message:
DB Error: unknown error
select bug_id, title, project_name from bug b, project p where b.project_id not in (0) and b.project_id = p.project_id order by b.created_date desc LIMIT 5, 0 [nativecode=ERROR: LIMIT #,# syntax is not supported ]
It seems that the select satement is not working with POSTGRES 8.03 ???
Any idea for a bugfix ??
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Are you using the latest PEAR, and have you defined the DB type as pgsql? The code uses the modifyLimitQuery function from the PEAR DB code, and that function uses the limit x offset x syntax for pgsql, not limit x,x.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Using php 5.0.4, mysql 4.1.10, on FC4 get the same error on index.php and report.php
raw db error i was receiving was:
select project_name as "Project", sum(case when resolution_id = 0 then 1 else 0 end) as "Open" 123456, count(bug_id) as "Total" from bt_bug b left join bt_project p using (project_id) where b.project_id not in (0) group by b.project_id, project_name order by project_name [nativecode=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 '123456, count(bug_id) as "Total" from bt_bug b left join bt_project p using (pro' at line 1]
for index.php i commented out line 112
//$querystring .= $countquery;
as that was adding the 123456 to the query. everything seems to work fine now
(line 41 on report.php)
any reason for that to have been there?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Installed version 1.0, using Postgres SQL 8.03, PHP 4.3.6 on
Scientific Linux 3.3
Installiation worked fine, Database connection check OK, Tables in DB were created. I checked the postgres database, and found several tables there.
After logging in , and using the administration tools for setting up users,m groups, projects etc. I always get the error "A database error occured" -
After reinstalling and trying to fix the problem - I give up !!
Any suggestions where the error is !!!
Thanxs for your help
ThN
On line 521 of inc/functions.php, change the RAWERROR definition from false to true, then try loading the page again. This should allow the full error to be displayed.
Hi I did activate the RAWERROR flag to true and get the message:
DB Error: unknown error
select bug_id, title, project_name from bug b, project p where b.project_id not in (0) and b.project_id = p.project_id order by b.created_date desc LIMIT 5, 0 [nativecode=ERROR: LIMIT #,# syntax is not supported ]
It seems that the select satement is not working with POSTGRES 8.03 ???
Any idea for a bugfix ??
I can't currently get to their site to check, but I'm looking into why this syntax wouldn't work.
Are you using the latest PEAR, and have you defined the DB type as pgsql? The code uses the modifyLimitQuery function from the PEAR DB code, and that function uses the limit x offset x syntax for pgsql, not limit x,x.
Using php 5.0.4, mysql 4.1.10, on FC4 get the same error on index.php and report.php
raw db error i was receiving was:
select project_name as "Project", sum(case when resolution_id = 0 then 1 else 0 end) as "Open" 123456, count(bug_id) as "Total" from bt_bug b left join bt_project p using (project_id) where b.project_id not in (0) group by b.project_id, project_name order by project_name [nativecode=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 '123456, count(bug_id) as "Total" from bt_bug b left join bt_project p using (pro' at line 1]
for index.php i commented out line 112
//$querystring .= $countquery;
as that was adding the 123456 to the query. everything seems to work fine now
(line 41 on report.php)
any reason for that to have been there?
Got the same problem, i posted in Debug section. Using php 5.0.4, mysql 4.1.13.
same issue with fc4. comment out line 113 in index.php and line 41 in reports.php. not sure what is the purpose of those lines.
Is this again with MySQL4.1 (mysqli)? Please try the patch for inc/functions.php mentioned in the corresponding bug-report:
http://sourceforge.net/tracker/index.php?func=detail&aid=1272753&group_id=14939&atid=114939
I need someone with this problem who can verify whether the fix works.
/Ulf