• Home
  • Get help
  • Ask a question
Last post 2 hours 28 min ago
Posts last week 110
Average response time last week 29 min
All time posts 67418
All time tickets 10424
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.

#2894 – error with sh404sef

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.
Thursday, 27 October 2016 23:08 UTC
empea
Hi

I'm experiencing an error with the sh404sef component on the site xxxx.au. I've currently turned the component off as with it on, other than the homepage no other pages are accessible. 

I've tried reinstalling sh404sef to see if it helps the error but have seeing the following:

Message
shLib: skipping install of shLib version : Same or more recent version of shlib already installed.
Error while creating the database : Table './binnabur_joom3/#__sh404sef_urls' is marked as crashed and should be repaired SQL=CREATE TABLE IF NOT EXISTS `#__sh404sef_urls` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `cpt` INT(11) NOT NULL DEFAULT '0', `rank` INT(11) NOT NULL DEFAULT '0', `oldurl` VARCHAR(255) NOT NULL DEFAULT '', `newurl` VARCHAR(255) NOT NULL DEFAULT '', `option` VARCHAR(255) NOT NULL DEFAULT '', `referrer_type` TINYINT(3) NOT NULL DEFAULT '0' COMMENT 'Used for 404, 0 = not set, 1 = external, 2 = internal', `dateadd` DATE NOT NULL DEFAULT '0000-00-00', `last_hit` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `newurl` (`newurl`), KEY `rank` (`rank`), KEY `oldurl` (`oldurl`), KEY `last_hit` (`last_hit`) ) DEFAULT CHARSET=utf8;. Sh404SEF will probably not operate properly. Please uninstall it, then try again after checking your database server setup. Contact us in case this happens again.
Warning
Table './binnabur_joom3/#__sh404sef_urls' is marked as crashed and should be repaired SQL=SHOW FULL COLUMNS FROM `#__sh404sef_urls`

Any suggestions on how I can repair the database table. I have access to phpmyadmin and can follow instructions if you are able to provide them.

Cheers
Emily
Thursday, 27 October 2016 23:16 UTC
empea
All is fixed :) I worked out how to repair table and everything is working - hooray!!
Friday, 28 October 2016 06:51 UTC
wb_weeblr
Hi

Glad you work it out :) I would have told you to repair the database table with PHPMyAdmin or similar anyway, this is not an issue with Joomla or sh404SEF, but rather at the mysql server.

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!

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.