Login-signup doesn't work anymore

Justoverclock

hi all, on my forum today (yesterday works fine and i didn't change anything) is impossible to login into admin cp, or proceed to login or signup.....can someone help me?

https://valorant-italia.it/forum/ here my forum

tankerkiller125

Justoverclock It appears like your trying to load Bootstrap into your forum. This is likely breaking Flarum as we use several class names that conflict with Bootstrap.

Wadera

Justoverclock didn't change anything

tankerkiller125 appears like your trying to load Bootstrap into your forum

Justoverclock yes is for the footer

I like it

Just remove this code which you added. If you changed some files - just revert changes. If you changed it trough admin panel - most likely you will need dig into database (phpmyadmin will be your friend). Remember to make backup before playing with anything 😉

Justoverclock

yes is for the footer, now how can i do to fix?

tankerkiller125

Wadera They can't login because the modal won't load because of the extra bootstrap. I'm working on getting them the database value/command they need to run in order to clear the issue.

Justoverclock

yes exactly i can't login anymore

tankerkiller125

Justoverclock Alright so you will need to login to the MySQL server either via phpmyadmin or SSH

Once logged into the database you'll want to run:

USE yourdatabasenamehere;

This tells MySQL which database we are going to run our commands against. The next command will clear your footer completely, I will also be including the command to clear the header since I don't know where you put that CSS/JS HTML code.

DELETE FROM settings WHERE `key` = 'custom_footer';
DELETE FROM settings WHERE `key` = 'custom_header';

Justoverclock

i'm in phpmyadmin but if i lauch the query the system say that:

#1146 - Table 'justover_flarum.settings' does not exist

tankerkiller125

Justoverclock During setup did you by chance setup a table prefix?

Justoverclock

mmmhh i dont remember but probably yes

tankerkiller125

Justoverclock Once you find out what that table prefix is you'll need to put it in front of settings. So for example if your prefix is forum then the commands would be:

DELETE FROM forum_settings WHERE `key` = 'custom_footer';
DELETE FROM forum_settings WHERE `key` = 'custom_header';

If you don't know/remember the prefix you can run:

SHOW TABLES;

in order to view all the table names, which should tell you what the prefix is.

Justoverclock

here the result:

Tables_in_justover_flarum
_flaraccess_tokens
_flarapi_keys
_flardiscussion_tag
_flardiscussion_user
_flardiscussions
_flaremail_tokens
_flarflags
_flargroup_permission
_flargroup_user
_flargroups
_flarlogin_providers
_flarmigrations
_flarnotifications
_flarpassword_tokens
_flarpost_likes
_flarpost_mentions_post
_flarpost_mentions_user
_flarpost_user
_flarposts
_flarregistration_tokens
_flarsettings
_flartag_user
_flartags
_flarusers

tankerkiller125

Alright, looks like the commands are going to be:

DELETE FROM _flarsettings WHERE `key` = 'custom_footer';
DELETE FROM _flarsettings WHERE `key` = 'custom_header';

Justoverclock

ok now it works....thx!!!!