diff options
| author | copypaste <admin@8chan.co> | 2014-04-27 17:01:57 +0200 |
|---|---|---|
| committer | czaks <marcin@6irc.net> | 2014-04-27 17:01:57 +0200 |
| commit | c0e82e077f46564527f50dfc6202bdad32ad0b47 (patch) | |
| tree | be33a54010ad4d5c82a24331958f0bb682952a81 | |
| parent | a96f28afc04afc46bcfb96941af072a97c01fb30 (diff) | |
fix upgrade path
| -rw-r--r-- | install.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/install.php b/install.php index 7e889d09..d102c3d5 100644 --- a/install.php +++ b/install.php @@ -527,7 +527,7 @@ if (file_exists($config['has_installed'])) { query(sprintf('ALTER TABLE ``posts_%s`` ADD `num_files` int(11) DEFAULT 0 AFTER `files`;', $board['uri'])) or error(db_error()); query(sprintf('UPDATE ``posts_%s`` SET `files` = CONCAT(\'[{"file":"\',`file`,\'", "thumb":"\',`thumb`,\'", "filename":"\',`filename`,\'", "size":"\',`filesize`,\'", "width":"\',`filewidth`,\'","height":"\',`fileheight`,\'","thumbwidth":"\',`thumbwidth`,\'","thumbheight":"\',`thumbheight`,\'", "file_path":"%s\/src\/\',`filename`,\'","thumb_path":"%s\/thumb\/\',`filename`,\'"}]\') WHERE `file` IS NOT NULL', $board['uri'], $board['uri'], $board['uri'])) or error(db_error()); query(sprintf('ALTER TABLE ``posts_%s`` DROP COLUMN `thumb`, DROP COLUMN `thumbwidth`, DROP COLUMN `thumbheight`, DROP COLUMN `file`, DROP COLUMN `fileheight`, DROP COLUMN `filesize`, DROP COLUMN `filename`', $board['uri'])) or error(db_error()); - query(sprintf('ALTER TABLE ``posts_%s`` REBUILD', $board['uri'])); // or error(db_error()); apparently this didn't work for my mariadb installation, let's just don't quit if it doesn't succeed + query(sprintf('REPAIR TABLE ``posts_%s``', $board['uri'])); } case false: // TODO: enhance Tinyboard -> vichan upgrade path. |