Don't Work - Database Error

[sweetfunny]

Hello,

I've been trying for hours to get this script to work with no joy.

I'm using:

phpBB 2.0.22 (Downloaded Today)
Multi Forums Beta 8 (Downloaded Today)
php 4.4.6
MySql 5.0.27-Standard
WHM/cPanel Linux box with phpMyAdmin

I upload all files, input the correct MySql credentials and /path/to/install in the renamed config file point the browser at the install URL and get:


Database Error
We're sorry, we seem to be experiencing problems with our database. Please try refreshing this page to see if this message goes away.
The database server might be restarting. If this message still appears, please try again later. You may also contact the site owner if you wish.


There's nothing wrong with MySql as i just installed vBulletin/vBseo and phpLD on it.

I've wiped the whole install off the server 4 times, re-installed from scratch and still same result. I've installed nearly every mod on phpBB, vBulletin.org and Invision since 2003 so i'm hardly new at this but i can't get it to run.

Do you have a .sql i can try and import and skip the install process, or another solution?

Thanks.

[Derek]

Can you right click the page and view the source and see if it says the MySQL error?

It should say the error in comments (starting with <!-- and ending with -->).

Derek

[sweetfunny]

Thanks for your reply Derek.

I get:


SQL Query: SELECT `varname`, `value` FROM nbs_settings
MySQL Error: Table 'wwwthel_alpha.nbs_settings' doesn't exist
MySQL Error Number: 1146
Date: Saturday, May 12, 2007 02:42:50
Username:
IP Address:


I didn't remove Username/IP for security either, there was just no values there.

When i run /nsb/install/install.php it goes straight to that Database Error page, checking phpMyAdmin shows no tables in the database at all.

[Derek]

Hmm... Is the INSTALLED constant in the config file set to 1? I'm guessing it's thinking its already installed and taking you to the upgrade page. If it's set to 1 change it to 0 and try running the installer again.

Derek

[sweetfunny]

Thanks again Derek, still no joy.

Yep i've got:

define('INSTALLED', 0);

I also tried using Persistent MySql connection. And also tried CHMOD all files and folders to 777 in case it was a read, write, execute problem with config or one of the others.

I know 777 is a security risk, and i wouldn't leave it like that in a live environment... But it ruled out permission problems.

[sweetfunny]

Any ideas?

I was hoping to get this working before the domain expired.

[Derek]

PM me FTP Info, MySQL info, and the admin info you would like and I will try and install it for you.

Derek

[salazarboy]

This also happened to me. Any ideas?

The script is installed at

s1.shadowhaze.net/nbs/ (http://s1.shadowhaze.net/nbs/)

[DFCROW]

Hey there,

any news on the above mentioned issue? I'm getting the same error.

I deleted the complete DB already, created a new db etc .. nothing seems to work... I slowly run out of ideas :notamused


I searched the board and found a good few user with the same issue it seems they all got it sorted somehow ( re-uploading backups etc ) but it seems the root cause is still unknown... any ideas what it could be ?

thanks a mill
-CROW

[copy112]

Did you changed nbs_config.php.new to nbs_config.php and the info in it?

[DFCROW]

yip ... its all changed .. all info in there ... I am working with PHP + MySql since quiet a while but it seems I cant find the cause myself .. so I was hoping somebody from NBS knows why that happens.

-CROW

[DR_GIGGULS]

http://xampp.org/
setup xampp on your computer and install nbs locally.
Then export the database, import it on your host, upload the files, change the paths and it should work.