Last post 15 hours 58 min ago

Posts last week 81

Average response time last week 4 hours 29 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.

#2806 – 1054 Error

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, 06 October 2016 02:30 UTC

lcmweb

I am getting the following error on some of the pages on my site: ERROR: 1054

Unknown column 'last_hit' in 'field list' SQL=UPDATE `#__sh404sef_urls` SET `cpt`=2088, `last_hit`='2016-10-06 02:28:50' WHERE `id`='5' AND `rank`=0;

If I disable sh404sef then the error disappears. Suggestions to fix this?

Thursday, 06 October 2016 06:58 UTC

wb_weeblr

Hi

Some of sh404SEF updates were not done correctly (this field should have been added when updating sh404SEF in some previous version).

In your other ticket, you explained that you built the site with sh404SEF version 4.4.9. With this version indeed this column did not exist. So what's the history here, how is it that you use database table from your old version? Did you copy the database tables directly or something?

Rgds

Thursday, 06 October 2016 13:03 UTC

lcmweb

This is a newer site build and this error wasn't there when the software was first installed. The error has only happened in the last few weeks. The software was installed through the Joomla install component and then updated as needed (typical install and updates)

Thursday, 06 October 2016 13:11 UTC

wb_weeblr

This is a newer site build and this error wasn't there when the software was first installed.

This field, last_hit, was added in 4.8.0, ie the last release actually. I don't really have any idea how this technically can happen, especially considering it's never been reported.

1 - Can you confirm (using phpmyadmin or similar), that the xxx_sh404sef_urls database table indeed does not have any 'last_hit' column?
2 - Was there any restore done on the site recently, either through Joomla or at the hosting level (that would be the most likely reason, a restore from a date prior to updating to 4.8.0)?
3 - I would suggest installing againg a freshly downloaded copy of 4.8.0 and installing again over the existing one. That should add back the last_hit field if it's missing.

Rgds

Thursday, 06 October 2016 15:36 UTC

lcmweb

I installed a fresh copy of sh404sef and that has fixed the problem. I suspect the host did something as the site hasn't had any changes made except to keep the site up to date. The site was tested after the updates were made.

Thursday, 06 October 2016 16:11 UTC

wb_weeblr

I suspect the host did something a

Unfortunately, this would not be the first time I hear about something like this. They sometimes restored a failed disk with something that may not be up to date.

The site was tested after the updates were made.

This would confirm that.

Glad it's solved anyway, 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.