• Home
  • Get help
  • Ask a question
Last post 1 hour 10 min ago
Posts last week 94
Average response time last week 34 min
All time posts 67856
All time tickets 10487
All time avg. posts per day 20

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.

#750 – sh404SEF corrupted - 404 errors on all sub-pages

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.
Tuesday, 28 July 2015 23:54 UTC
afumcadmin1
I don't know how but it seems like the sh404SEF plugin database or something is corrupted. We noticed our website has a problem displaying every page...except for the homepage. Any other page gets a 404 error.

I've currently set 'Enable URL optimization' to NO and the website works now. Also, when I go to the admin site the Control Panel displays fine but when I go to any of admin links it displays the page code instead of the appropriate admin page.

Also note that originally we were behind one update when this started happening. I went ahead and updated to the latest version but it made no difference.

In case you need to login as an Admin:
http://xxxx.org/administrator/
xxxx
xxxx
Wednesday, 29 July 2015 06:37 UTC
wb_weeblr
Hi

I looked at the sh404SEF pages inside the backend and indeed you have a database server problem:
<title>Error: 145 Table './ankenyfi_joom/gqohr_sh404sef_urls' is marked as crashed and should be repaired SQL=select distinct u1.*, m.newurl as nonsefurl, m.id as metaid, m.metatitle as metatitle, m.metadesc as metadesc, m.metakey as metakey, m.metalang as metalang, m.metarobots as metarobots, m.canonical as canonical from `gqohr_sh404sef_urls` as u1 left join `gqohr_sh404sef_metas` as m on m.newurl=u1.newurl WHERE u1.newurl <> "" AND u1.rank = 0 order by `oldurl` ASC</title>

<link rel="stylesheet" href="/administrator/templates/isis/css/template.css" type="text/css" />

The database table for sh404SEF has crashed, your mysql server needs maintenance for that. You can either do it yourself if you're familiar with servers maintenance, or ask your hosting company support .

Rgds
 
Wednesday, 29 July 2015 11:30 UTC
afumcadmin1
Thank you for investigating. I'll look into this. You can close this ticket.
Wednesday, 29 July 2015 11:53 UTC
wb_dimitris
Hi

Closing this one as requested. Please feel free to open another ticket in the future.

Regards
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.