• Registered: 2005-06-29
  • Posts: 16

Topic: Unable to fetch newest registered user - revisited

Hello guys,

I've been using punBB on a few sites for quite some time now and just recently moved from one server to another.
Naturally, this included dumping the DBs and reuploading them - all no problem, or so I thought.

I use one punBB Installation to save quotes and other stuff I want to remember and when I accessed it today, I only got the following:

Unable to fetch newest registered user

There was a thread here somewhere with the same problem, but the user got help from the admin and no solution was posted.

Here's more debug information:

File: /home/httpd/vhosts/example.com/httpdocs/index.php
Line: 152

PunBB reported: Unable to fetch newest registered user
Database reported: Got error 124 from table handler (Errno: 1030)

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Unable to fetch newest registered user - revisited

try repairing the table (using something like phpmyadmin)

FluxBB.
Connorhd.co.uk.

Connorhd's Website

3 Reply by liquidblaze (edited by liquidblaze 2005-06-29 16:51)

  • Registered: 2005-06-29
  • Posts: 16

Re: Unable to fetch newest registered user - revisited

nope - that didnt help.

[EDIT]

i'm not sure if this is related or not, but when I repaid the tables, it works for all except this one:

database.punbbonline      repair      error      The handler for the table doesn't support repair

all others repair / optimize fine.

what I also noticed - the punbbonline is 1.6 megs in size, which is kinda big considering the only person its reporting online is me.

  • From: UK
  • Registered: 2004-07-24
  • Posts: 97

Re: Unable to fetch newest registered user - revisited

liquidblaze wrote:

PunBB reported: Unable to fetch newest registered user
Database reported: Got error 124 from table handler (Errno: 1030)

MySQL error code 124: Wrong index given to function

Maybe dropping and recreating the indexes on the user table could help.

Nibbler(cpg)'s Website

5 Reply by liquidblaze (edited by liquidblaze 2005-06-29 18:49)

  • Registered: 2005-06-29
  • Posts: 16

Re: Unable to fetch newest registered user - revisited

sounds good to me.

and just how would I achieve this? :-$

phpmyAdmin suggests:

---

Indexes:

Warning No index defined!

Create an index on X columns

---

should I do just that ?

how much should X be? standard value currently is 1

  • Registered: 2005-06-29
  • Posts: 16

Re: Unable to fetch newest registered user - revisited

anyone got any thoughts on this?

I'd really love to get my knowledge base up and running again smile

  • Registered: 2005-04-01
  • Posts: 345

Re: Unable to fetch newest registered user - revisited

Any mods?

scottywz's Website

  • Registered: 2005-06-29
  • Posts: 16

Re: Unable to fetch newest registered user - revisited

Nothin at all. Just a plain punBB

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Unable to fetch newest registered user - revisited

i guess the problem is when you backed up the databases you didn't backup the indexes, you could look in index.php at the indexes and add them all manually i guess

FluxBB.
Connorhd.co.uk.

Connorhd's Website

  • Registered: 2005-06-29
  • Posts: 16

Re: Unable to fetch newest registered user - revisited

ouch.

I'll have a go. but wouldnt phpmyadmin's function to create indexes work as well?

does anyone have another solution? something ... a bit simpler smile

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Unable to fetch newest registered user - revisited

yes you can do it through phpmyadmin, but you need to tell it which indexes to create...

FluxBB.
Connorhd.co.uk.

Connorhd's Website

  • Registered: 2005-06-29
  • Posts: 16

Re: Unable to fetch newest registered user - revisited

when you say

"you could look in index.php at the indexes", where exactly would you have me look at ?

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Unable to fetch newest registered user - revisited

wow sorry i meant install.php theres a big set of queries that adds all the indexes i think, i'm not too sure about that

FluxBB.
Connorhd.co.uk.

Connorhd's Website

  • Registered: 2005-06-29
  • Posts: 16

Re: Unable to fetch newest registered user - revisited

ok thx ... I'll see how I can accomplish that, considering that the forum I used as a knowledge base was the 1.1.4 version smile

would it help if I'd install the newest version with the old config.php values?