Rigorous and Reliable (RAR) - 论坛

mybb_sessions crashed and need repaired

Thu, 16 Jun 2016 09:33:15 +0800

error info is

Code:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:

    145 - Table './tests/mybb_sessions' is marked as crashed and should be repaired

Query:

    SELECT * FROM mybb_sessions WHERE sid='df61d039ab5d004dcafabfe0e136252b' AND ip='183.17.230.93' LIMIT 1

The error like below:

How to fix it:

1. log in on host of mybb forum

2. log in(e.g. user: test, password: test) mysql of mybb forum

Code:

mysql -u  test -p test

3. change to database(e.g. test) which it use.

Code:

use test;

4. repair it by command like below:

Code:

repair table `mybb_sessions`;

The results of this command like below:

Code:

mysql> repair table `mybb_sessions`;

+--------------------+--------+----------+--------------------------------------------+

| Table              | Op     | Msg_type | Msg_text                                   |

+--------------------+--------+----------+--------------------------------------------+

| test.mybb_sessions | repair | warning  | Number of rows changed from 10489 to 10486 |

| test.mybb_sessions | repair | status   | OK                                         |

+--------------------+--------+----------+--------------------------------------------+

2 rows in set (0.26 sec)

You can try to access website again to test it work or not.

note: root password is in /var/www/html/inc/config.php
---
20210804/zhihao: update root password location
20210804/zhihao: add error info

my_bb调整图片附件显示的大小

Tue, 12 Jan 2016 16:02:19 +0800

可编辑模板：
postbit_attachments_images_image
下的

修改width的值即可，可百分比也可固定大小。
默认情况下无width字段，请自己添加。

Invalid forum 解决

Thu, 24 Dec 2015 17:21:21 +0800

在移动帖子时出现移动‘Invalid forum‘提示，解决办法：

选择第二项

mybb软件图片附件直接显示方式

Wed, 02 Dec 2015 11:02:19 +0800

mybb软件默认图片附件是不会直接显示，如果想改为图片附件上传后直接显示，可通过进入mybb管理员后台，选择“configuration", 在右边的search框内输入'Thumbnail'后点击search，按下图设置:

修改完毕后点击"save setting"即生效。

设置中各个字段具体含义可参考相应选项的说明。