Upgrading from Beta 2

HavocK i suck at commands

Ok now when i go to mydomain.com/admin and enter my db pass to upgrade, it says this error

Something went wrong: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'u901538740settings' already exists (SQL: rename table u901538740config to u901538740settings)

And from my understanding, it wants to rename the config table to settings but settings already exists.....but here's the problem, if i remove the settings table i wont be able to get to the update page cuz ill get an error saying :

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u901538740_flaru.u901538740settings' doesn't exist' in /home/u901538740/public_html/test2/vendor/illuminate/database/Connection.php:319 Stack trace: #0 /home/u901538740/public_html/test2/vendor/illuminate/database/Connection.php(319): PDO->prepare('select value,...') #1 /home/u901538740/public_html/test2/vendor/illuminate/database/Connection.php(655): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\MySqlConnection), 'select value,...', Array) #2 /home/u901538740/public_html/test2/vendor/illuminate/database/Connection.php(618): Illuminate\Database\Connection->runQueryCallback('select value,...', Array, Object(Closure)) #3 /home/u901538740/public_html/test2/vendor/illuminate/database/Connection.php(324): Illuminate\Database\Connection->run('select value,...', Array, Object(Closure)) #4 /home/u901538740/public_html/test2/vendor/illuminate/database/Query/Build in /home/u901538740/public_html/test2/vendor/illuminate/database/Connection.php on line 662

Which means that it cant load cuz the settings table doesn't exist.... So what's the fix to this? Isn't there a way i can make it skip the renaming from config to settings process and proceed to do all the rest?

[deleted] yes you can prevent that, delete the migration, if I'm not mistaken:

rm vendor/flarum/core/migrations/2015_10_07_130531_rename_config_to_settings.php

luceos I shall notify him. Thank you! ?

luceos thanks that worked...may i also ask on how i can delete a column from a table in my db?

the table is

u901538740disscussions

and i wanna delete the column
is_locked
from it

[deleted]

alter table `u901538740disscussions` drop column `is_locked`;

luceos thank you ?

[deleted] Is this solved, then?

jordanjay29 I haven't tried the fixes yet as I didn't get time to do so....please keep this topic open until i get you a response of whether I succeeded or failed.

@luceos so the upgrade process wasn't really successful so I decided to get a clean installation of the latest version of flarum and compare the tables of the new and old one and see whats missing and manually add it in myself....and it succeeded!!!! I was able to get all my data from the beta 2 version to the new beta 5 version....

but then came the catastrophe.....

once I logged out, all it showed was the forum title and that line under it.....nothing else....refreshing wont help

so may I know what went wrong there? Also can I give you the credentials to login to the host im using so that you can personally have a look at the db and the files to see if anything is wrong?

Digital all i did was install a fresh version of flarum (latest one) and compared the tables between the old one which has all the data and the new one and i made all the changes that i can see present in the new version which are not there in the old version....then I renamed config to settings and changed the version in that table to beta 5 to stop flarum from updating anything and giving me errors since I pretty much already updated it all....then I backed up my assets and config, deleted all the beta 2 files (not the db) and installed beta 5 and removed the assets folder and added the assets and config folder i backed up earlier

Then I went ahead to re-enable all plugins but it threw me an error since the tables these plugins create already existed but I simply fixed that by deleting everything in the migrations folder on each and every single plugin folder. And that made me able to re-enable the plugins without any errors and everything worked perfectly ever since ?

[deleted] You are awesome. This will surely help others in the future. Thank you!

Digital awwww thanks!!!!!!!

Digital he

Digital ibrahimk157 You are awesome. This will surely help others in the future. Thank you!

He had helped me too! Thank you!