UBB.Developers Forums Community Development Programming MySQL and Server Configuration Problem whith importing database

I made a backup from my running database and imported it using PHPmyAdmin into my testforum. My testforum is using IIP5.3.1, my running site is not.

I get the following error now in my testforum:

[]SQL ERROR: Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site15/fst/var/www/html/test/forum/mysql.inc.php on line 131
SQL ERROR: Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site15/fst/var/www/html/test/forum/mysql.inc.php on line 131[/].

I know the database needs to be altered for using IIP, but because I cannot loggin now, I don't know which SQL command to use. And hopefully this is the only change I should make.

My running database is 6.2.2 and the testdatabase 6.3, so I did run altertable-6.2-6.3.php.

Please help me

Pasquale

Hmmm... check the MySQL error logs for clues. That error is hiding the real error and doesn't give anything to go on.

Ooo! I see this all the time @ phpBB!

Most likely you are running MySQL 3 and you selecte MySQL 4 when installing.

MySQL 3 is forward compatible to MySQL 4.

Pasqualist, open mysql.inc.php and edit line 209 from

if ($u_status == 'Administrator'

to

if ($u_status != 'Administrator'

That will let the error become visible to you. You're making the error visible to anyone but an admin because at this point you can't log in as an admin to see them.

Useful tip that Navaho - had a similar problem myself the other day, when uploading to my test forum.

Pasqualist - what version of IIP are you running on your running site?

This thread is like 10 days old.