1 Topic by narf

  • narf
  • Junior Member
  • Offline
  • Registered: 2006-08-01
  • Posts: 4

Topic: Error after .sql import

hey,

i deleted all punBB tables in the Database for mistake.
so i took one of my MySql-Dumps from one Night before, and added the tablesstructure & contents as .sql Query with phpMyAdmin in the database.

Now all the punBB_ tables are in the database with their contents, but the installation keeps complaining with:
Error: Unable to fetch newest registered user.

any ideas? thanx a lot smile

cheers
Narf

  • From: U.S.A.
  • Registered: 2005-08-26
  • Posts: 1,607

Re: Error after .sql import

Enable debug mode, please.

Looking for a certain modification for your forum? Please take a look here before posting.

3 Reply by narf (edited by narf 2006-08-01 20:15)

  • narf
  • Junior Member
  • Offline
  • Registered: 2006-08-01
  • Posts: 4

Re: Error after .sql import

An error was encountered
File: /home/www/web9/web/xxx/xxx/xxx/forum/upload/index.php
Line: 155

PunBB reported: Unable to fetch newest registered user 

Database reported: Got error 124 from table handler (Errno: 1030)

thats it... is there an option to import content/config into a fresh install/database of punBB?

edit:
i commented line 155 to 160 in upload/index.php, and now i can see the forum again. but the layout is kind of broken.

thank you for feedback smile

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Error after .sql import

Try 

repair table prefixusers

Replace prefix with your db_prefix

5 Reply by narf

  • narf
  • Junior Member
  • Offline
  • Registered: 2006-08-01
  • Posts: 4

Re: Error after .sql import

i did repair table cmd.

uncommented the error output/check (that // Collect some statistics from the database) from index.php.

but error still occurs (now its cant fetch total user count)

cheers
n

6 Reply by Smartys (edited by Smartys 2006-08-01 22:41)

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Error after .sql import

Run a check then run a repair again
Paste the output of the check here

What version of MySQL are you running?

7 Reply by narf

  • narf
  • Junior Member
  • Offline
  • Registered: 2006-08-01
  • Posts: 4

Re: Error after .sql import

Hi, i did that check with REPAIR, and it pretends to work, but some of the Content (HyperLinks in Postings) seem to be broken.
we wil do a clean/Fresh install, becausr we dont need the old content anymore.

thx for the help, i appreciate that!
narf