Recently many netizens asked me that Z-BlogPHP appeared“ mysqli_query(): (HY000/1194): Table ‘zbp_post’ is marked as crashed and should be repaired ”What is the meaning of error and how to solve it? The error interface is shown in the figure below. If you don't know what the meaning is, you can translate it. It probably means that the "zbp_post" table of the MySQL database is marked as broken and should be repaired. We can use the pagoda's own database management tool or the "Navicat" tool to optimize and repair. If the blogger uses the pagoda panel, it can be repaired directly, so it is very simple, Just fix the blog post data table.
Pagoda control panel:
Open the pagoda control panel, the menu on the left, find the database - find the corresponding database on the right, click "Tools", find“ zbp_post ”Data table, select right“ repair ”, wait until the repair is completed, as shown in the figure:
Navicat
open Navicat For MySQL tool to repair the table, right click the table to be repaired“ zbp_post ”Data table, right-click to select Maintenance, select Repair Table , Select fast The repair can be completed, as shown in the figure:
phpMyAdmin
use phpMyAdmin Link to the database, find the corresponding database, and check“ zbp_post ”Data table, select the repair table from the drop-down box at the bottom, as shown:
After the above three forms of repair are basically solved, you can ask why it is basic? I don't know, at least the above methods have been solved, but the program code, there are always some unexpected effects, maybe who follows course It's not easy to operate, right? If you really encounter the situation that the above tutorial is invalid, remember @ me. After all, this is a good learning experience. Well, if there is a problem, leave a message and feedback, and continue to move bricks. After all, you know that I am a true CV engineer~~~
