WordPress database error: [Table 'wp_options' is marked as crashed and should be repaired]
SELECT option_value FROM wp_options WHERE option_name = 'cron' LIMIT 1

WordPress database error: [Incorrect key file for table './ninelegends/wp_options.MYI'; try to repair it]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1568829038;a:1:{s:32:\"recovery_mode_clean_expired_keys\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [Incorrect key file for table './ninelegends/wp_options.MYI'; try to repair it]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1568829039;a:1:{s:34:\"wp_privacy_delete_old_export_files\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [Incorrect key file for table './ninelegends/wp_options.MYI'; try to repair it]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1568829039;a:1:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [Incorrect key file for table './ninelegends/wp_options.MYI'; try to repair it]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1568829039;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [Incorrect key file for table './ninelegends/wp_options.MYI'; try to repair it]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1568829039;a:1:{s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

Fixing old NS demos « ninelegends
 

Fixing old NS demos

This guide is woefully outdated. I’ve left it up in case someone finds it useful. Let me know if there is any interest in an updated version — I might feel compelled to fix it.

 

Lately I’ve gotten a few questions about the new Steam patch making old demos not work. Obviously this has been a problem for me as well, as I’m in the process of making an unannounced NS fragmovie (uh-oh!), so I decided to do some investigating on teh intarwebz. Fortunately I was able to find a reasonable solution quickly, although it isn’t perfect. For one it only works on first person demos, although eventually it will also fix HLTV demos. It also requires a tiny amount of effort on the part of the user. Anyway, for those of you interested in watching old firstperson demos — and hopefully HLTV demos in the near future — here’s the solution:

 

IMPORTANT: MAKE BACKUPS OF YOUR DEMOS BEFORE ATTEMPTING TO USE ANY OF THESE FIXES

 

1. Download the latest version of Half-Life Advanced Effects.

 

2. Install it (extract the archive durr).

 

3. Launch HLAE.

 

4. Follow the illustrated examples:

 

Click Tools-Demo Tools

 

Tick Convert to new demo version-Next

 

Select the demo you want to fix, Select a location and name for your fixed demo file-Finish

 

That’s all there is to it. Hopefully it won’t take too long until this, or something else, can fix HLTV demos too.

 

Update: The manual method described in this post should work for ALL demos, but it takes a slight bit of effort.

 

Update2: The complexity demo player supposedly also fixes all demos. I haven’t tried this yet however.