Upgrading from Beta 2

luceos so far you've been the most helpful ? thank you so much

HavocK that has the command to install the latest version not older versions...its just you that doesn't read before sharing a link

comicsmuppet well in other communities there's nothing wrong with making new posts for new issues...it's just that this community has a different way of how things work and i do take responsibility for not reading the community guidelines and as I said previously, stop talking about this as this discussion is over.

[deleted] Don't worry, we're not competing.

[deleted] can you please stop firing your lasers on this community ?. You might not see it, but these kind people are actually doing their best to assist you in every way they can.

Something about the choice between a fish and a rod...

luceos i do realize that what im doing is wrong and as I previously said its my fault i didn't first check how things go here and i do apologize for that but please can we stop talking about this and move on? I learnt my lesson.

jordanjay29 thanks for being so patient ? im sorry

[deleted] If you read composer documentation then flarum installation you should have noticed that you could change the version number in the command.

Interesting thing to read : https://getcomposer.org/doc/01-basic-usage.md

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?

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?

@luceos @jordanjay29 nevermind I managed to successfully do the upgrade from beta 2 to beta 5.....I would like to highly thank you for all your time giving me support....

Please lock this thread ?