Forums

Unfortunately no one can be told what FluxBB is - you have to see it for yourself.

You are not logged in.

#1 2012-05-30 02:26:05

yandexwm
New member
Registered: 2012-05-30
Posts: 3

"Error: Unable to fetch user information." Help me!

yandexwm.com

What is problem?

754bz.png
???

Last edited by yandexwm (2012-05-30 02:42:17)

Offline

#2 2012-05-30 04:51:40

Mark
Member
From: Southport, Uk
Registered: 2008-05-03
Posts: 547

Re: "Error: Unable to fetch user information." Help me!

enable debug mode and paste full message

https://fluxbb.org/forums/viewtopic.php?id=6078

Offline

#3 2012-05-30 13:35:17

yandexwm
New member
Registered: 2012-05-30
Posts: 3

Re: "Error: Unable to fetch user information." Help me!

Mark wrote:

enable debug mode and paste full message

File: /home/yandexwm/public_html/include/functions.php
Line: 53

FluxBB reported: Unable to fetch user information

Database reported: Table './yandexwm_4/yandex_online' is marked as crashed and should be repaired (Errno: 145)

Failed query: SELECT u.*, g.*, o.logged, o.idle FROM yandex_users AS u INNER JOIN yandex_groups AS g ON u.group_id=g.g_id LEFT JOIN yandex_online AS o ON o.user_id=u.id WHERE u.id=2


what is problem?

Offline

#4 2012-05-30 13:47:27

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,695
Website

Re: "Error: Unable to fetch user information." Help me!

In that case, please go to PHPMyAdmin, select the "yandex_online" table and click on "Repair".


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

Offline

#5 2012-05-30 13:52:29

yandexwm
New member
Registered: 2012-05-30
Posts: 3

Re: "Error: Unable to fetch user information." Help me!

It worked. Thanks Franz.

Offline

#6 2020-03-25 18:49:37

DarkZero
Member
From: France
Registered: 2015-03-11
Posts: 16

Re: "Error: Unable to fetch user information." Help me!

Hello, Franz,

I had the same problem, actually that fixes it. Can we get an explanation for the cause? How can we prevent it from happening again?

Thank you in advance.

Offline

#7 2020-03-27 09:48:02

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,695
Website

Re: "Error: Unable to fetch user information." Help me!

Hmm, guessing the root problem seems unlikely, given we don't know the exact circumstances. If you search the web for "Table is marked as crashed and should be repaired", you might find some possible explanation. I hope that helps. hmm


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

Offline

#8 2020-03-29 11:20:10

DarkZero
Member
From: France
Registered: 2015-03-11
Posts: 16

Re: "Error: Unable to fetch user information." Help me!

For me the cause is just table saturation. Is there a native FluxBB mechanism that empties this table?
Because every online user or guest will have an entry in this table (for life?). For a forum that has been in existence for 10 years, even if members are deleted due to their inactivity, there is always an entry in this table.

In our case, that was probably the cause.

myisamchk: MyISAM file /var/lib/mysql/xxxxxx/xxxxxx.MYI
myisamchk: warning: Table is marked as crashed and last repair failed
myisamchk: warning: Size of indexfile is: 49152         Should be: 8192
myisamchk: error: Found 262 keys of 265
Found row block followed by deleted block

myisamchk: warning: Size of indexfile is: 49152         Should be: 8192

For information, the forum runs on systems that are up to date and compatible with FluxBB.

Offline

Board footer

Powered by FluxBB