We have been using phpbt for a long time, we really like it, but it is time to upgrade. I am assuming we're using 0.91, we installed in 2003.
I change the new config file like the upgrade instructions advise, then when I go to upgrade.php the browser appears to do nothing.
I checked the web servers error log and it says...
[Fri Jul 8 11:36:06 2005] [error] PHP Notice: Undefined variable: db_type in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 32
[Fri Jul 8 11:36:06 2005] [error] PHP Notice: Undefined variable: db_pass in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 53
[Fri Jul 8 11:36:06 2005] [error] PHP Notice: Undefined variable: admin_login in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 81
[Fri Jul 8 11:37:59 2005] [error] PHP Notice: Undefined variable: db_type in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 32
[Fri Jul 8 11:37:59 2005] [error] PHP Notice: Undefined variable: db_pass in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 53
[Fri Jul 8 11:37:59 2005] [error] PHP Notice: Undefined variable: admin_login in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 81
[Fri Jul 8 11:39:11 2005] [error] PHP Notice: Constant PEAR_PATH already defined in /Library/WebServer/Documents/admin/phpbt-1.0rc6/install.php on line 166
[Fri Jul 8 11:39:11 2005] [error] PHP Warning: test_database({PEAR_PATH}DB.php): failed to open stream: No such file or directory in /Library/WebServer/Documents/admin/phpbt-1.0rc6/install.php on line 167
[Fri Jul 8 11:39:11 2005] [error] PHP Fatal error: test_database(): Failed opening required '{PEAR_PATH}DB.php' (include_path='.:/usr/local/php/lib/php') in /Library/WebServer/Documents/admin/phpbt-1.0rc6/install.php on line 167
[Fri Jul 8 11:39:11 2005] [error] PHP Warning: main({PEAR_PATH}DB.php): failed to open stream: No such file or directory in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
[Fri Jul 8 11:39:11 2005] [error] PHP Fatal error: main(): Failed opening required '{PEAR_PATH}DB.php' (include_path='.:/usr/local/php/lib/php') in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
[Fri Jul 8 11:39:20 2005] [error] PHP Warning: main({PEAR_PATH}DB.php): failed to open stream: No such file or directory in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
[Fri Jul 8 11:39:20 2005] [error] PHP Fatal error: main(): Failed opening required '{PEAR_PATH}DB.php' (include_path='.:/usr/local/php/lib/php') in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
[Fri Jul 8 11:40:28 2005] [error] PHP Warning: main({PEAR_PATH}DB.php): failed to open stream: No such file or directory in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
[Fri Jul 8 11:40:28 2005] [error] PHP Fatal error: main(): Failed opening required '{PEAR_PATH}DB.php' (include_path='.:/usr/local/php/lib/php') in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
Upgrade attempt stopped, maybe you can help?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As a general advice I would say that it is probably better to first try install phpBT in a fresh new database instead of upgrading. Do the upgrade after that you have verified that the new version runs well on your system.
My *guess* about your problem is that something went wrong when you followed the upgrading instructions. Please compare your old config.php with your new config.php (which should be a copy of the new config-dist.php edited to match your old config.php for the DB_TYPE, DB_HOST, DB_DATABASE, DB_USER, DB_PASSWORD, TBL_PREFIX, and PEAR_PATH constants).
You say that you use upgrade.php but all warnings are from install.php. This *could* be due to problems with your config.php. phpBT suppresses the real error messages too often..
I think the constant PEAR_PATH is already defined when you reach install.php because upgrade.php includes config.php. But in that case this would also be an issue for people who reach install.php from index.php..
Since PEAR_PATH is defined as '{PEAR_PATH}' you must have forgotten to edit that one in config.php. phpBT no longer contains the pear files. You need to install them separately (or copy them from your 0.9.1 version).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
No, Sorry. I think you will have to go through the upgrade process. But installing first lets you see whether there is a general problem with RC6 or just the upgrade.php script. There have been so many changes since 0.9.1 that it is hard to tell where the problem lies..
If rc6 works after an install you can compare the rc6 config.php with config-dist.php and the old 0.9.1 config.php.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The instructions in the UPGRADING file are incomplete, not only must you change the DB_* and TBL_PREFIX constants, you also need to set the pear path near the bottom of the config file. I didn't know I needed to do that.
Now to start learning 1.0. Thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am also facing an issue with download spreadsheet link. Once i click the link i got the following error.
Warning: main(OLE/PPS/Root.php): failed to open stream: No such file or directory in /web/php-server/lib/php/Spreadsheet/Excel/Writer/Workbook.php on line 39
Fatal error: main(): Failed opening required 'OLE/PPS/Root.php' (include_path='.:/web/php-server/lib/php') in /web/php-server/lib/php/Spreadsheet/Excel/Writer/Workbook.php on line 39
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We have been using phpbt for a long time, we really like it, but it is time to upgrade. I am assuming we're using 0.91, we installed in 2003.
I change the new config file like the upgrade instructions advise, then when I go to upgrade.php the browser appears to do nothing.
I checked the web servers error log and it says...
[Fri Jul 8 11:36:06 2005] [error] PHP Notice: Undefined variable: db_type in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 32
[Fri Jul 8 11:36:06 2005] [error] PHP Notice: Undefined variable: db_pass in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 53
[Fri Jul 8 11:36:06 2005] [error] PHP Notice: Undefined variable: admin_login in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 81
[Fri Jul 8 11:37:59 2005] [error] PHP Notice: Undefined variable: db_type in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 32
[Fri Jul 8 11:37:59 2005] [error] PHP Notice: Undefined variable: db_pass in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 53
[Fri Jul 8 11:37:59 2005] [error] PHP Notice: Undefined variable: admin_login in /Library/WebServer/Documents/admin/phpbt-1.0rc6/templates/default/install.html on line 81
[Fri Jul 8 11:39:11 2005] [error] PHP Notice: Constant PEAR_PATH already defined in /Library/WebServer/Documents/admin/phpbt-1.0rc6/install.php on line 166
[Fri Jul 8 11:39:11 2005] [error] PHP Warning: test_database({PEAR_PATH}DB.php): failed to open stream: No such file or directory in /Library/WebServer/Documents/admin/phpbt-1.0rc6/install.php on line 167
[Fri Jul 8 11:39:11 2005] [error] PHP Fatal error: test_database(): Failed opening required '{PEAR_PATH}DB.php' (include_path='.:/usr/local/php/lib/php') in /Library/WebServer/Documents/admin/phpbt-1.0rc6/install.php on line 167
[Fri Jul 8 11:39:11 2005] [error] PHP Warning: main({PEAR_PATH}DB.php): failed to open stream: No such file or directory in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
[Fri Jul 8 11:39:11 2005] [error] PHP Fatal error: main(): Failed opening required '{PEAR_PATH}DB.php' (include_path='.:/usr/local/php/lib/php') in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
[Fri Jul 8 11:39:20 2005] [error] PHP Warning: main({PEAR_PATH}DB.php): failed to open stream: No such file or directory in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
[Fri Jul 8 11:39:20 2005] [error] PHP Fatal error: main(): Failed opening required '{PEAR_PATH}DB.php' (include_path='.:/usr/local/php/lib/php') in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
[Fri Jul 8 11:40:28 2005] [error] PHP Warning: main({PEAR_PATH}DB.php): failed to open stream: No such file or directory in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
[Fri Jul 8 11:40:28 2005] [error] PHP Fatal error: main(): Failed opening required '{PEAR_PATH}DB.php' (include_path='.:/usr/local/php/lib/php') in /Library/WebServer/Documents/admin/phpbt-1.0rc6/include.php on line 43
Upgrade attempt stopped, maybe you can help?
Hi Wes,
As a general advice I would say that it is probably better to first try install phpBT in a fresh new database instead of upgrading. Do the upgrade after that you have verified that the new version runs well on your system.
My *guess* about your problem is that something went wrong when you followed the upgrading instructions. Please compare your old config.php with your new config.php (which should be a copy of the new config-dist.php edited to match your old config.php for the DB_TYPE, DB_HOST, DB_DATABASE, DB_USER, DB_PASSWORD, TBL_PREFIX, and PEAR_PATH constants).
You say that you use upgrade.php but all warnings are from install.php. This *could* be due to problems with your config.php. phpBT suppresses the real error messages too often..
The warnings about undefined variables db_type, db_pass, and admin_login was fixed just a few weeks ago:
http://cvs.sourceforge.net/viewcvs.py/phpbt/phpbt/templates/default/install.html?r1=1.10&r2=1.11
I think the constant PEAR_PATH is already defined when you reach install.php because upgrade.php includes config.php. But in that case this would also be an issue for people who reach install.php from index.php..
Since PEAR_PATH is defined as '{PEAR_PATH}' you must have forgotten to edit that one in config.php. phpBT no longer contains the pear files. You need to install them separately (or copy them from your 0.9.1 version).
Thank you, I will take your advice and first try to get 1.0r6 going and then upgrade.
Now that I have 1.0r6 working (with an empty DB), can you outline the procedure to get my 0.91 database into 1.0r6?
Thanks again for the reply.
No, Sorry. I think you will have to go through the upgrade process. But installing first lets you see whether there is a general problem with RC6 or just the upgrade.php script. There have been so many changes since 0.9.1 that it is hard to tell where the problem lies..
If rc6 works after an install you can compare the rc6 config.php with config-dist.php and the old 0.9.1 config.php.
I re-did the upgrade and this time it worked.
The instructions in the UPGRADING file are incomplete, not only must you change the DB_* and TBL_PREFIX constants, you also need to set the pear path near the bottom of the config file. I didn't know I needed to do that.
Now to start learning 1.0. Thanks.
Yes, since rc6 you must set PEAR_PATH (earlier you could, but didn't have to). I will take a look at the UPGRADING text.
Thanks for you report.
I am also facing an issue with download spreadsheet link. Once i click the link i got the following error.
Warning: main(OLE/PPS/Root.php): failed to open stream: No such file or directory in /web/php-server/lib/php/Spreadsheet/Excel/Writer/Workbook.php on line 39
Fatal error: main(): Failed opening required 'OLE/PPS/Root.php' (include_path='.:/web/php-server/lib/php') in /web/php-server/lib/php/Spreadsheet/Excel/Writer/Workbook.php on line 39
Do you have http://pear.php.net/package/OLE installed?