Last post 44 min ago

Posts last week 141

Average response time last week 4 hours 42 min

All time posts 67799

All time tickets 10476

All time avg. posts per day 21

Helpdesk is open from Monday through Friday CET

Please create an (free) account to post any question in the support area.

Please check the development versions area. Look at the changelog, maybe your specific problem has been resolved already!

All tickets are private and they cannot be viewed by anyone. We have made public only a few tickets that we found helpful, after removing private information from them.

#5614 – Getting 1146 errors when I enable SEF URLs

Posted in ‘sh404SEF’

This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Friday, 22 February 2019 03:30 UTC

gilesb13

I'm getting several 1146 errors when I enable SEF URLs (1146 Table XXX#_redirect_links doesn't exist).

For example, when I try to load this page:
https://www.xxxx.net/esl-idioms-worksheets.html?id=202
With SEF off, it loads fine. With SEF on, I get an 1146 error.

I'm having this problem with several pages all over my site. I can't figure out why. Any help is much appreciated.

sh404sef version: 4.15.2.3878
Joomla version: 3.9.2

Thanks

Friday, 22 February 2019 08:40 UTC

wb_weeblr

For example, when I try to load this page:

https://www.xxxx.net/esl-idioms-worksheets.html?id=202

I do not get any error loading this page, yet SEF URLs seems to be enabled.

With SEF off, it loads fine. With SEF on, I get an 1146 error.

Do you mean when enabling Joomla SEF or sh404SEF "Enable URL optimization"?

(1146 Table XXX#_redirect_links doesn't exist)

That table is not from sh404SEF, it's one of Joomla standard database tables and it should be there. Maybe you have not updated the Joomla database after doing a Joomla update?

Best regards

Friday, 22 February 2019 14:33 UTC

gilesb13

Ya, I meant URL optimization.
I was able to go in and create the MySQL table, and I think the problem is fixed.
So nevermind. But thanks!

Friday, 22 February 2019 17:08 UTC

wb_weeblr

Hi

Glad it's sorted out. Any idea why this table was missing?

I would recommend going to Extensions - Manage - Database and use the Fix button. You might be missing other critical Joomla database elements.

Best regards

Saturday, 23 February 2019 01:10 UTC

gilesb13

No idea why this table went missing. I assumed it was sh404sef, but perhaps not.

When I tried to "Fix" the Database previously, I got several errors related to the table.
After adding the table, all the errors are gone and it updated with no problems.

So I think I'm good. Thanks again.

Monday, 25 February 2019 14:04 UTC

wb_weeblr

I assumed it was sh404sef, but perhaps not.

Nope, that table is 100% joomla and sh404SEF has nothing to do with it.

When I tried to "Fix" the Database previously, I got several errors related to the table.

That would be expected, Joomla totally expects this table to be present. I would assume the table was somehow deleted either manually, or during a backup/restore operation or similar.

Glad it's sorted out, closing this ticket now, feel free to open a new one as needed. If you do so, please mention this ticket number in the new one.

If you created any superadmin account for us, be sure to delete or block it now to avoid unnecessary risk in the future.

Be sure to also check out wbAMP, our new Accelerated Mobiles pages plugin for Joomla - the next big thing is SEO, direct from Google themselves!

This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.