duplicate tables and login problem

Need help with the Administration of your Joomla! 3.x site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
pabirds
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Fri Jun 23, 2017 6:04 pm

duplicate tables and login problem

Post by pabirds » Sun Dec 10, 2017 3:58 pm

Somehow I have duplicate tables in my Joomla database. One set is preceded with jos_ and the other with pso_.

When I installed Joomla (months ago) I set the precursor to pso_.

I recently moved the site to a new host (the new host did the migration). I have been logging in okay since the migration.

But, today I can't login to the backend. All I get is a white screen. I don't even get the login screen. Yesterday I set all of the permissions to default using the AdminTools plugin. But I was able to login after that.

The front end works fine.

After looking up the login problem, I checked the configuration file, but its settings were fine (cookies, etc.).

So...

Is it safe to delete the jos_ tables?

Any troubleshooting tips for the login problem?

User avatar
wwhite
Joomla! Explorer
Joomla! Explorer
Posts: 469
Joined: Wed Jul 30, 2008 4:40 am
Location: SC USA

Re: duplicate tables and login problem

Post by wwhite » Sun Dec 10, 2017 4:41 pm

Look under global config - server - database settings to be sure which tables your site is pointed to
back up back up first, then delete what you dont want
I assume you are logging into the back end again
Joomla - K2
Funeral Director - Every Day Above Ground is a Good Day!
Saying - This old world keeps spinning round, it a wonder tall trees aint laying down https://www.[youtube].com/watch?v=c_W9aaQ1Apo

pabirds
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Fri Jun 23, 2017 6:04 pm

Re: duplicate tables and login problem

Post by pabirds » Mon Dec 11, 2017 12:47 pm

I can't login, so I can''t get to the global settings. Is there a file with these settings that I can manually edit?

User avatar
wwhite
Joomla! Explorer
Joomla! Explorer
Posts: 469
Joined: Wed Jul 30, 2008 4:40 am
Location: SC USA

Re: duplicate tables and login problem

Post by wwhite » Mon Dec 11, 2017 12:50 pm

should be in configuration.php
public $dbprefix
Joomla - K2
Funeral Director - Every Day Above Ground is a Good Day!
Saying - This old world keeps spinning round, it a wonder tall trees aint laying down https://www.[youtube].com/watch?v=c_W9aaQ1Apo


Locked

Return to “Administration Joomla! 3.x”