error : phpbb2 + phpraider 1.0.8

[mynomias]

Everything went fine till 1.0.7b, but with 1.0.8 i run in trouble where i didnt found a solution yet.

I upgraded as usual - renamed the old installation - copied the new one, copied the config and games - run the installscript with upgrade - deleted the install folder.

At the beginning i was able to browse around, check here and there for new functions but suddenly error screens happen. meanwhile i get those errors on every page even the index.


phpBB : critical error
Could not query config information

DEBUG MODE

SQL Error : 1046 No database selected

SELECT * FROM phpbb_config

Line : 215
File : common.php

once in a while everything is working as intended - minutes later it doesnt - sometimes its enough to refresh the page

cleared cache and cookies ... no change

anyone got an idea ?

[BoaConstrictor]

Weird, the auth module in 1.0.7b and 1.0.8 for phpbb2 is the same.
However, the database access has changed a bit, so you might try to remove line 11 in phpbb2.functions.php:

mysql_select_db($pConfig['db_name']);


It shouldn't be needed anymore.
However I don't understand why you get it, since phpbb2 forces the selection of it's own database when it's called.

Also check if you got some weird setting in your database after the update.
Check if the config file got overwritten.
Might have been that you've added "$pConfig['db_newlink']=true;" in your old config. I think that setting is removed when you upgrade. Not sure about that.

[BoaConstrictor]

Or to make it even more easy, try to swap out includes/database.php with the 1.0.7b one.

That one still selected the database. Might be that phpbb isn't very good at sharing connection. On the other hand, the connection sharing in php is not good at all.

[mynomias]

so you might try to remove line 11 in phpbb2.functions.php:
still errors
Also check if you got some weird setting in your database after the update.
Check if the config file got overwritten.
got overwritten.
Might have been that you've added "$pConfig['db_newlink']=true;" in your old config. I think that setting is removed when you upgrade. Not sure about that.
nope.

Or to make it even more easy, try to swap out includes/database.php with the 1.0.7b one.
Thats it, now everything works properly, thank you.

Am i affected with any bugs that where fixed with 1.0.8 related to the database.php ?

[cwittjes]

I'm having a similar error after update from phpRaider 1.0.7 (not 1.0.7b) - also in combination with phpbb2. I got the exact error message from parent post on every server hit.

I then tried to comment out line 11 from phpbb2.functions.php, which results in only getting the error randomly, maybe half the time.

I tried copying includes/database.php from 1.0.7, but that resulted in another error message.

Configuration file was updated at time of install process update. It contains entries for db_server, db_name, db_user, db_pass, db_prefix and db_pers.

I have copied the games/ folder from 1.0.7, it is still to be updated - can this be related to this issue?

Any ideas are welcome.

[mynomias]

Did you read the upgrade instructions about 1.0.7 ?
Due to a known bug in the old 1.0.7 installation/upgrade, it's recomended that you run an upgrade from 1.0.6 in this installation
Maybe you run in an error over there ?


I tried copying includes/database.php from 1.0.7, but that resulted in another error message.
did you tried to copy the database.php vom 1.0.7b (still downloadble on this site) ?
I can't compare those two versions right now because i dont have a plain 1.0.7 file anymore.

[BoaConstrictor]

I tried copying includes/database.php from 1.0.7, but that resulted in another error message.

The 1.0.7 and the 1.0.7b is different. The 1.0.7b has more functionality that's used in both 1.0.7b and 1.0.8. So you'll need at least the 1.0.7b one.

Configuration file was updated at time of install process update. It contains entries for db_server, db_name, db_user, db_pass, db_prefix and db_pers.

Would be nice if you could try to add the line:

$pConfig['db_newlink']=true;

to your configuration.php file to see if it changes.

I have copied the games/ folder from 1.0.7, it is still to be updated - can this be related to this issue?

Gamefiles aren't part of phpRaider. They're separate, so just download the updated gamefile in the download section.

[BoaConstrictor]

Oh, while I still remember, I've heard that sometimes during the upgrade, the DB settings are also stored in the DB so they're basically overwrite the ones in configuration.php.

Could you check if you have any variables containing starting with 'db_' in the table phpraider_config or the phpraider_config_auth table?

[cwittjes]

Inserted $pConfig['db_newlink']=true; in configuration.php.
It still fails with the same error.


Could you check if you have any variables containing starting with 'db_' in the table phpraider_config or the phpraider_config_auth table?

Only got the following entries in phpraider_config_auth:
phpbb_path, phpbb_url, register_url, use_login

Would it make sense to download 1.0.7b and install include/database.php?

I've been searching for the special instructions for updating from 1.0.7, but without finding them - can a link be provided? Or doesn't it matter anymore?

As a sidenote I reenabled the 1.0.7 files, and - atleast from a cursory scan - it seems to work (no schema changes from 1.0.7 to 1.0.8, etc). Is this dangerous?

[BoaConstrictor]

I've been searching for the special instructions for updating from 1.0.7, but without finding them - can a link be provided? Or doesn't it matter anymore?

The readme.html in the docs folder in the zip file that you download says:
Due to a known bug in the old 1.0.7 installation/upgrade, it's recomended that you run an upgrade from 1.0.6 in this installation.
and that's still valid since you're not running 1.0.7b.


As a sidenote I reenabled the 1.0.7 files, and - atleast from a cursory scan - it seems to work (no schema changes from 1.0.7 to 1.0.8, etc). Is this dangerous?

There are no schema changes from 1.0.7 to 1.0.8, no.

[BoaConstrictor]

Also, I think I've figured this error out now.
It only affects phpbb2 as far as I can see.

It seems Spiffy borrowed the DB code from phpBB2 when he started out.
So basically this is what's wrong:
phpRaider has a db class called sql_db and the same does phpbb2.
And in both phpRaider and phpBB2 there is a check if someone allready defined that class. So what happens is that phpbb2 is using phpRaider's database class internally and that will fail, since I've removed the need to have the databasename set in phpRaider.

So if you two that have this error could be so kind to download the patch attached to this message and see if it works for you?
Just overwrite the files with the ones from the zip.

[mynomias]

since i already upgraded to the latest svn version, where i also had to exchange the database.php to the 1.7b, i would like to know if i should still test the .zip with all files included or just a few ?

I just dont want to mix up the installation more than necessary.

[BoaConstrictor]

I updated the SVN at 0930 this morning, but I'm not sure if this is GMT or my localtime (GMT+1).
So if you do a new get from SVN, you'll get the changes.

But to answer your question, the database.php is the same as the SVN version. The other files in that zip isn't. Those are for the 1.0.x series.

[mynomias]

According to the SVN i got rev 501 with 3 new files (index,database,joomlaauth) now and everythings works (surfed around with 50 clicks). Thanks for the update.

[cwittjes]

So if you two that have this error could be so kind to download the patch attached to this message and see if it works for you?
Just overwrite the files with the ones from the zip.

I added the new patch, did a new install with upgrade from 1.0.6, and everything seems to work.

I removed $pConfig['db_newlink']=true; from configuration.php - it doesn't seem to make a difference, works both with and without.

Thanks alot for the assistance.

[mynomias]

Just a quick mini bug report :

In relation to the change in the index.php you should also change the line in the help.php

$db_raid = &new sql_db($pConfig['db_server'].........

should be


$db_raid = &new pr_sql_db($pConfig['db_server'].........

otherwise you get problems with the mouseovertooltip in the admin panel.

[BoaConstrictor]

Just checked in to SVN now.