I have been trying to get phpbt working for 2 days and have pretty much run out of +ve thoughts but perhaps someone out there can help.
I am trying to install v1.0.4 on CentOS 4.4, MySQL 5, Apache 2, PHP 5.
All of the above was already installed so I downloaded phpbt and gave it a go. Various problems but I seemed to get around them but ended up with an installation where the administrator had no permissions to do anything :-) After lots of attempts to resolve I went back to basics and rebuilt PHP 5 ensuring support for mysql (which was already there) and mysqli.
I wrote some test php scripts and can access mysql without PEAR and with PEAR using the mysqli driver.
So I deleted config.php and reinstalled phpbt: test db connection works fine and a new config.php is created which I copied to the phpbt directory. I reload the index page and get the phpbt login page and
DB Error: syntax error
concat(, resolution_id, , resolution_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 'concat(, resolution_id, , resolution_name, '"' )' at line 1]
I haven't even been able to find a php file that contains this code!
Something is working because the database tables have been created and a session is created. I guess that some variable is not set so the sql is invalid but not being able to find the source file makes it hard to track down.
If I don't get past this in the next few hours I'll have to give up. More than two days to install software that is "easier to install than Bugzilla" just ain't worth it. Sendmail was easier :-)
Any help gratefully received. I really want to phpbt a go!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
(Part of) the problem is that when SHOW_PROJECT_SUMMARIES is true, index.php tries to construct a query from the mysqli.php $QUERY array using indices of 'index-projsummary-3' and 'index-projsummary-4' and these array elements return empty strings.
So the next question is "is the array really empty and if so why?"
If anyone has a clue what's going on please feel free to cut short my misery.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Amidst all my problems, I had changed the path to the mysqli.php file in include.php.
I changed it to /usr/local/lib/php/DB. It was inc/db. Changing it back did the trick.
The key point is that although the files at those locations are both called mysqli.php they are totally different in purpose and as a newbie this subtle fact passed me by and never even said "hello".
Ok - let's see if it was worth all the trouble :-)
Happy bug tracking everyone.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have been trying to get phpbt working for 2 days and have pretty much run out of +ve thoughts but perhaps someone out there can help.
I am trying to install v1.0.4 on CentOS 4.4, MySQL 5, Apache 2, PHP 5.
All of the above was already installed so I downloaded phpbt and gave it a go. Various problems but I seemed to get around them but ended up with an installation where the administrator had no permissions to do anything :-) After lots of attempts to resolve I went back to basics and rebuilt PHP 5 ensuring support for mysql (which was already there) and mysqli.
I wrote some test php scripts and can access mysql without PEAR and with PEAR using the mysqli driver.
So I deleted config.php and reinstalled phpbt: test db connection works fine and a new config.php is created which I copied to the phpbt directory. I reload the index page and get the phpbt login page and
DB Error: syntax error
concat(, resolution_id, , resolution_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 'concat(, resolution_id, , resolution_name, '"' )' at line 1]
I haven't even been able to find a php file that contains this code!
Something is working because the database tables have been created and a session is created. I guess that some variable is not set so the sql is invalid but not being able to find the source file makes it hard to track down.
If I don't get past this in the next few hours I'll have to give up. More than two days to install software that is "easier to install than Bugzilla" just ain't worth it. Sendmail was easier :-)
Any help gratefully received. I really want to phpbt a go!
A bit more info:
(Part of) the problem is that when SHOW_PROJECT_SUMMARIES is true, index.php tries to construct a query from the mysqli.php $QUERY array using indices of 'index-projsummary-3' and 'index-projsummary-4' and these array elements return empty strings.
So the next question is "is the array really empty and if so why?"
If anyone has a clue what's going on please feel free to cut short my misery.
And the final resolution!
Amidst all my problems, I had changed the path to the mysqli.php file in include.php.
I changed it to /usr/local/lib/php/DB. It was inc/db. Changing it back did the trick.
The key point is that although the files at those locations are both called mysqli.php they are totally different in purpose and as a newbie this subtle fact passed me by and never even said "hello".
Ok - let's see if it was worth all the trouble :-)
Happy bug tracking everyone.