Last post 1 hour 36 min ago

Posts last week 81

Average response time last week 4 hours 29 min

All time posts 67915

All time tickets 10498

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.

#2722 – 1054 Unknown column

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.

Saturday, 17 September 2016 19:03 UTC

hotgomer

Hello!
when I try to save the meta I get an error:
1054 Unknown column 'twittercards_enable' in 'field list' SQL=INSERT INTO `#__sh404sef_metas` (`id`,`newurl`,`metadesc`,`metakey`,`metatitle`,`metalang`,`metarobots`,`canonical`,`og_enable`,`og_type`,`og_image`,`og_enable_description`,`og_enable_site_name`,`og_site_name`,`fb_admin_ids`,`og_enable_location`,`og_latitude`,`og_longitude`,`og_street_address`,`og_locality`,`og_postal_code`,`og_region`,`og_country_name`,`og_enable_contact`,`og_email`,`og_phone_number`,`og_fax_number`,`og_enable_fb_admin_ids`,`twittercards_enable`,`twittercards_site_account`,`twittercards_creator_account`,`google_authorship_enable`,`google_authorship_author_profile`,`google_authorship_author_name`,`google_publisher_enable`,`google_publisher_url`) VALUES ('0','index.php?option=com_zoo&Itemid=330&item_id=1192&lang=ru&task=item','','','Стоматология','','','','2','2','','2','2','','','2','','','','','','','','2','','','','2','2','','','2','','','2','')

how fix it?

Monday, 19 September 2016 07:19 UTC

wb_weeblr

Hi

This indicate that the database you are using has an old sh404SEF format, not the current one (well the current one is already from like a year or more ago), so your database format is pretty old.

1 - What are your exact and full (not "latest") Joomla and sh404SEF versions?
2 - What's the history? when did you install sh404SEF, was this an update from a previous version?
3 - When did this start to happen?

Rgds

Monday, 19 September 2016 20:31 UTC

hotgomer

Hello!
I had an older version sh404 and Joomla 3.0
I migrated the joomla 3 and I made a database migration sh404 so as not to lose data 3000 pages
1) Joomla 3.5.1 and sh404SEF 4.7.3.3292
2) I installed sh404SEF and migrate old database(for old sh404sef) on new
3) I do not know when it started

Tuesday, 20 September 2016 07:01 UTC

wb_weeblr

Hi

This explains that. You moved the database table, but it has an old format because:

2) I installed sh404SEF and migrate old database(for old sh404sef) on new

You installed first the new sh404SEF, and then you copied over the old, bad database table. You should have done the other way around: move the table(s) and then install the new version. Fixing up the db table is done during installation, so sh404SEF didn't have a chance to do that, because you copied again the table after install.

I would think simply installing again the current version over itself would run then database updating process again, and bring your db up to date.

Rgds

Wednesday, 05 October 2016 05:34 UTC

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

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.