#1016 - Can't open file: 'wp_bad_behavior_log.MYI' (errno: 145)
# myisamchk wp_bad_behavior_log.MYI
Checking MyISAM file: wp_bad_behavior_log.MYI
Data records: 109 Deleted blocks: 270
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 4 clients are using or haven't closed the table properly
- check file-size
- check record delete-chain
myisamchk: error: Record at pos: 203284 is not remove-marked
myisamchk: error: record delete-link-chain corrupted
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: warning: Auto-increment value: 19908 is smaller than max used value: 19909
- check record links
myisamchk: error: Record-count is not ok; is 113 Should be: 109
myisamchk: warning: Found 235456 deleted space. Should be 236988
myisamchk: warning: Found 419 parts Should be: 414 parts
MyISAM-table 'wp_bad_behavior_log.MYI' is corrupted
Fix it using switch "-r" or "-o"
# myisamchk -r wp_bad_behavior_log.MYI
- recovering (with sort) MyISAM-table 'wp_bad_behavior_log.MYI'
Data records: 109
- Fixing index 1
Data records: 113
I’ve never had to deal with a “multiple” select html entity before with PHP… somehow.
If you have the html tag “select” with the attribute “multiple” set, as in: <select name='favorites' multiple>
Unless end the name of the tag with [], you aren’t able to utilize the values.
e.g. <select name='favorites' multiple>
<option selected value='0'>0</option>
<option selected value='1'>1</option>
</select>
as seen here
When the data is submitted, PHP will only have one data value, even though two are selected:
Array
(
[favorites] => 1
)
If you add brackets to the name
e.g. <select name='favorites[]' multiple>
<option selected value='0'>0</option>
<option selected value='1'>1</option>
</select>
as seen here (it looks the same)
PHP will then have an array of the selected values: