DB check!

[mediman]

if you have problems with your database, first check if your settings are correct! you can do this with this little script:

Code Select Expand

<?php$DBName = "";$DBUser = "";$DBPass = "";$DBHost = "";$prefix = "";$testconnect = @mysql_connect ( $DBHost, $DBUser, $DBPass )or die ( "1.<font color=red> Can´t found any DB-Server on (<font color=blue>$DBHost</font> or DBPass/DBUser may be wrong!</font><br><br>" );print ( "1.<font color=green> DB-Server found and connected!</font><br><br>" );$testdb = @mysql_select_db ( $DBName )or die ( "2.<font color=red> Database not found! (is the DBName <font color=blue>$DBName</font> correct? (have you yet a database created with this name?</font><br><br>" );print ( "2.<font color=green> Database <font color=blue>$DBName</font> found and connected!</font><br><br>" );$testtabl = @mysql_query ("select * from {$prefix}members")or die ( "3.<font color=red> Prefix <font color=blue>$prefix</font> is wrong or no tables in DB created!</font><br><br>" );print ( "3.<font color=green> Prefix <font color=blue>$prefix</font> is correct and tables found!</font><br>" );mysql_close ( $testconnect );?>

[Shoeb Omar]

hehe - should help some of our users but yabb se already has thi sin the installr partially with the "couldn't connect to database, connection succeeded by the way" message thing
but nice script

[mediman]

jip, you´re right, but many users (at least in the spanish support board) have problems with this kind of errors or think that install.php will create the database). so only for newbies in mysql is this script, of course not for you !

i will change it a little bit, so the error messages are little bit more helpfull...

thx mediman

[mediman]

so i changed the script this way that now only my errors appear, and not the errors produced by php or mysql!

hope now the appearence is a little bit clearer!

mediman

[Xplorador]

If, very good work!

[Shoeb Omar]

see - now thats more useful

goodjob