Forum Problems

[Cholmondely]

Not sure how important this one is.

When I hit "Quick links" > "Your posts" at the top left of the page

I get this:


General Error
SQL ERROR [ mysqli ]

Table 'phpbb_posts' is marked as crashed and should be repaired [1194]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Please notify the board administrator or webmaster: [email protected]

[hiran]

Known already, yet unresolved:
viewtopic.php?p=294540#p294540

[timer]

Well...
mysqlrepair -A --auto-repair

console output

Code: Select all

oolite_phpbb3.phpbb_posts
info     : Key 1 - Found wrong stored record at 7867024
info     : Key 1 - Found wrong stored record at 11534176
info     : Key 1 - Found wrong stored record at 216299488
info     : Found link that points at 2684194980155360859 (outside data file) at 216318472
info     : Found link that points at 8670177938766336960 (outside data file) at 216318772
info     : Found block with too small length at 216319424; Skipped
info     : Found block with too small length at 216320360; Skipped
info     : Found block that points outside data file at 216320892
info     : Found block with too small length at 216321108; Skipped
info     : Found link that points at 1650363464591663196 (outside data file) at 216321124
info     : Found block that points outside data file at 216321292
info     : Found block with too small length at 216322160; Skipped
info     : Key 1 - Found wrong stored record at 220158900
info     : Found block with too small length at 220158968; Skipped
info     : Found link that points at -7937755026865918093 (outside data file) at 220160272
info     : Found block with too small length at 220161936; Skipped
info     : Found block with too small length at 220161992; Skipped
info     : Found block with too small length at 220162400; Skipped
info     : Found link that points at 7193250796888157757 (outside data file) at 220162660
info     : Found link that points at 2736905567608773628 (outside data file) at 220162744
info     : Found block with too small length at 220162872; Skipped
info     : Found block that points outside data file at 220162884
info     : Found block with too small length at 220162972; Skipped
info     : Found block with too small length at 220163436; Skipped
info     : Found block with too small length at 220163668; Skipped
warning  : Number of rows changed from 270852 to 270828
status   : OK

[Cody]

The Team's gone missing!

[Cholmondely]

The Team's gone missing!

Confess! What did you do to them?

[Cody]

I didn't do it, nobody saw me do it, you can't prove anything!

[Cholmondely]

I didn't do it, nobody saw me do it, you can't prove anything!

They're still missing.

Confess!

[hiran]

The Team's gone missing!

What makes you think that?

[Cholmondely]

What makes you think that?

Try clicking the "The Team" button on the bottom right of this page.

I don't know what Cody did to you, but if you don't even realise it then it must be pretty powerful.

[hiran]

What makes you think that?

Try clicking the "The Team" button on the bottom right of this page.

I don't know what Cody did to you, but if you don't even realise it then it must be pretty powerful.

Ah, no worries. I know what happened.

[timer]

Ah, no worries. I know what happened.

bug or feature?

[timer]

Hi Folks!

What was done during maintenance:
1) the type of table engine has been changed to InnoDB - this, in theory, should reduce the likelihood of problems with the integrity of the database and perhaps speed it up a little
2) all links to the old bb have been replaced
3) the bb has been updated to the latest version

PS I was able to complete it in 20 minutes, as planned - it’s a miracle.

PPS and now we’re testing everything and looking for where it broke off )

[Cholmondely]

Hi Folks!

What was done during maintenance:
1) the type of table engine has been changed to InnoDB - this, in theory, should reduce the likelihood of problems with the integrity of the database and perhaps speed it up a little
2) all links to the old bb have been replaced
3) the bb has been updated to the latest version

PS I was able to complete it in 20 minutes, as planned - it’s a miracle.

PPS and now we’re testing everything and looking for where it broke off )

Maybe put this as an "Announcement"? Or are you planning on doing yet more?

And what is a "table engine"? On Digebiti our tables have legs, not engines (even though we're an industrial economy)!

Non-Digebitian Table Engine
Table engine built by Lampitt of Banbury c1850 and used at the Hunt Edmunds brewery

[hiran]

Timer is referring to the storage engine used behind the forum.
https://mariadb.com/kb/en/storage-engines/

Since Giles installed phpbb technology has advanced and we make use of that.

Thank you @timer to migrate the data as planned.

[hiran]

Ah, no worries. I know what happened.

bug or feature?

It was a change on purpose. We can discuss about it.
I see advantage if admin accounts are not publicly known. At the same time I removed moderators, and now the team page is empty.

Should something come back? Why so?