• Home
  • Get help
  • Ask a question
Last post 7 hours 58 min ago
Posts last week 94
Average response time last week 34 min
All time posts 67914
All time tickets 10497
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.

#953 – NO ACCESS to -URL MANAGER- error (126 Incorrect key file)

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, 04 September 2015 18:24 UTC
adsoma
HI, I am tried to access "url manager" but I have an error:


 126 Incorrect key file for table '/tmp/#sql_1373_3.MYI'; try to repair it SQL=select u.*, pg.pageid as pageid, pg.id as pageidid, pg.type as pageidtype, pg.hits as pageidhits, count(a.alias) as aliases from ( select distinct u1.*, count(d.`id`)-1 as duplicates, count(m.`id`) as metas from j25_sh404sef_urls as d, j25_sh404sef_urls as u1 left join `j25_sh404sef_metas` as m on m.newurl=u1.newurl WHERE u1.newurl <> "" AND d.oldurl=u1.oldurl AND u1.rank = 0 group by u1.`id`) as u left join `j25_sh404sef_aliases` as a on a.newurl = u.newurl left join `j25_sh404sef_pageids` as pg on pg.newurl = u.newurl group by u.newurl order by `oldurl` ASC


I went to extension>>extension manager>> database and the FIX,

but still I have the problem.

Any clue??
Friday, 04 September 2015 18:26 UTC
wb_weeblr
Hi

That's not a problem you can fix in Joomla or sh404SEF. It's your mysql database server that has a broken file and need maintenance.

If you don't know how to do it yourself (with phpmyadmin or similar), I'd suggest you contact your hosting company.

Rgds
 
Friday, 04 September 2015 18:46 UTC
adsoma
Fixed thanks
Friday, 04 September 2015 18:48 UTC
wb_weeblr
Glad to hear that :)

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.

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