[slogin_users' doesn't exist] error 1146

This forum is for general questions about extensions for Joomla! 3.x.

Moderators: pe7er, 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.
Post Reply
j-licious
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Mon Oct 11, 2021 11:24 pm

[slogin_users' doesn't exist] error 1146

Post by j-licious » Mon Oct 11, 2021 11:30 pm

Was working on new Joomla 3.10 site, everything was fine for weeks. Then when I logged in over the weekend, I get error 1146 [Table xxxxxxx#__slogin_users' doesn't exist"] and it won't let me log in. Just keeps throwing me back to the login screen. I checked the database integrity and it all reads fine. I didn't change any database structure. I have no idea why this would have happened, except maybe if there was a server maintenance that changed something Joomla depends on, but if it was that, WHAT?

Also, the site doesn't finish loading. So I'm thinking it can't log into the mysql database to get the content now, either. Probably related...

Any help getting me back in business would be appreciated.
Last edited by toivo on Tue Oct 12, 2021 8:18 am, edited 1 time in total.
Reason: mod note: moved from 3.x General Questions

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 23401
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: [slogin_users' doesn't exist] error 1146

Post by pe7er » Tue Oct 12, 2021 6:01 am

Welcome to Joomla forum!

Do you have a recent working backup that you could restore?

#__slogin_users is not a default Joomla database table.
What 3rd party extension do you use?

You could try one of these workarounds:
1. disable the system, user or authentication plugin that needs the #__slogin_users table

2. I searched on "joomla slogin_users" and found a git repocitory with the following SQL to create a database table: https://github.com/Joomline/slogin/blob ... l.utf8.sql
You could try to recreate that database table in phpMyAdmin using that SQL.
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
The best website: https://the-best-website.com

j-licious
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Mon Oct 11, 2021 11:24 pm

Re: [slogin_users' doesn't exist] error 1146

Post by j-licious » Tue Oct 12, 2021 6:27 am

I have a backup from when I first started getting this set up, but there's a LOT of information I've put in since then and am not looking forward to re-doing basically everything.

The theme I'm using has a number of plugins. I'll have to look them up.

How do I do #1 if I can't log in to the admin control panel? I literally get the error as soon as I put the login credentials in, and it then dumps me back to the login page again.

Is it possible that the server auto-updated the PHP version or some other key software that "broke" the plugin?

If all else fails, I'll try your option #2.

User avatar
brian
Joomla! Master
Joomla! Master
Posts: 12236
Joined: Fri Aug 12, 2005 7:19 am
Location: Leeds, UK
Contact:

Re: [slogin_users' doesn't exist] error 1146

Post by brian » Tue Oct 12, 2021 6:38 am

Hopefully your web host provides a tool to let you edit the database. Usually phpmyadmin.

With that locate the __extensions table and then look for a record for a user plugin with slogin in the name and change the record so that the value for the field enabled is 0

That should disable the sdocial login plugin and let you access the joomla admin
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/

j-licious
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Mon Oct 11, 2021 11:24 pm

Re: [slogin_users' doesn't exist] error 1146

Post by j-licious » Tue Oct 12, 2021 6:50 am

Yes, I have access to PHPMyAdmin (it's how I was able to scan the database and look for corruption, and found none).

Thanks for this. I'll give it a shot and see what I come up with.

j-licious
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Mon Oct 11, 2021 11:24 pm

Re: [slogin_users' doesn't exist] error 1146

Post by j-licious » Tue Oct 12, 2021 7:13 am

brian wrote:
Tue Oct 12, 2021 6:38 am
Hopefully your web host provides a tool to let you edit the database. Usually phpmyadmin.

With that locate the __extensions table and then look for a record for a user plugin with slogin in the name and change the record so that the value for the field enabled is 0

That should disable the sdocial login plugin and let you access the joomla admin
Okay, disabling the sdocial extension in phpmyadmin gets me into the joomla control panel.

On the system configuration list, it seems to be using the correct database (and I can see there are records in that database in PHPMyAdmin), but literally ALL the articles are not visible under the article menu and the site doesn't load.

Any idea why it would not show anything from the linked database? I can see the plugins and extensions in the extension manage menu, but nothing under content.

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 23401
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: [slogin_users' doesn't exist] error 1146

Post by pe7er » Tue Oct 12, 2021 7:25 am

j-licious wrote:
Tue Oct 12, 2021 6:27 am
How do I do #1 if I can't log in to the admin control panel? I literally get the error as soon as I put the login credentials in, and it then dumps me back to the login page again.
Oh, sorry I wasn't clear about that.
You can use the method via phpMyAdmin that Brian described.
Or use FTP and rename the /plugins/some-area/some-plugin/ to /plugins/some-area/some-plugin-old/ so that Joomla cannot find the plugin and won't run it.
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
The best website: https://the-best-website.com

j-licious
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Mon Oct 11, 2021 11:24 pm

Re: [slogin_users' doesn't exist] error 1146

Post by j-licious » Tue Oct 12, 2021 7:31 am

pe7er wrote:
Tue Oct 12, 2021 7:25 am
j-licious wrote:
Tue Oct 12, 2021 6:27 am
How do I do #1 if I can't log in to the admin control panel? I literally get the error as soon as I put the login credentials in, and it then dumps me back to the login page again.
Oh, sorry I wasn't clear about that.
You can use the method via phpMyAdmin that Brian described.
Or use FTP and rename the /plugins/some-area/some-plugin/ to /plugins/some-area/some-plugin-old/ so that Joomla cannot find the plugin and won't run it.
thanks for following up. I was able to disable the offending plugin with phpmyadmin. But now that I can get into the joomla control panel I can see why the site isn't loading anymore. None of the articles are listed under content/articles, despite the fact that I can see that the database has lots of rows of data in phpmyadmin.

Any idea what may have happened or how I can get the articles/categories/etc back?? The correct database is listed under system configuration, so it just isn't displaying what's there for some reason...

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 23401
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: [slogin_users' doesn't exist] error 1146

Post by pe7er » Tue Oct 12, 2021 9:47 am

j-licious wrote:
Tue Oct 12, 2021 7:31 am
But now that I can get into the joomla control panel I can see why the site isn't loading anymore. None of the articles are listed under content/articles, despite the fact that I can see that the database has lots of rows of data in phpmyadmin.
Are all articles published? Or are they trashed? (Trashed articles have published = -2 in the #__content table)
Are all categories published?

Do you use any 3rd party extension (system or content) that hides your articles in the back-end?

To give more info about your setup, please use Forum Post Assistant https://forumpostassistant.github.io/docs/
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
The best website: https://the-best-website.com

j-licious
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Mon Oct 11, 2021 11:24 pm

Re: [slogin_users' doesn't exist] error 1146

Post by j-licious » Tue Oct 12, 2021 9:53 am

There's just nothing on the articles list at all. Looks empty. I looked at the log to see if there was some user action by some hacker or something, but there's no actions at all in between when I last used it and when I logged in and this problem started.

The theme came with helix bundle (26 items) and joom gallery. I haven't added anything else.

I'll read up on that FPA and try to run it in the morning.

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 23401
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: [slogin_users' doesn't exist] error 1146

Post by pe7er » Tue Oct 12, 2021 10:00 am

j-licious wrote:
Tue Oct 12, 2021 9:53 am
There's just nothing on the articles list at all. Looks empty.
Could you check the published status in the database using phpMyAdmin?

Or in the back-end in Content > Articles use the "Search Tools" filter and set the "- Select Status -" to All.
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
The best website: https://the-best-website.com


Post Reply

Return to “Extensions for Joomla! 3.x”