Log in Register
× Here you can get community support related to Tag Meta.

Error 500

  • janfk@storgaard.nu
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 11 months ago - 8 years 11 months ago #4576 by janfk@storgaard.nu
Error 500 was created by janfk@storgaard.nu
Unknown column 'a.custom_header' in 'field list' SQL=SELECT a.id, a.url, a.case_sensitive, a.request_only, a.decode_url, a.last_rule, a.placeholders, a.title, a.description, a.author, a.keywords, a.rights, a.xreference, a.canonical, a.custom_header, a.rindex, a.rfollow, a.rsnippet, a.rarchive, a.rodp, a.rydir, a.rimageindex, a.comment, a.synonyms, a.synonmax, a.synonweight, a.preserve_title, a.hits, a.last_visit, a.ordering, a.published, a.checked_out, a.checked_out_time,uc.name AS editor FROM wq4on_tagmeta_rules AS a LEFT JOIN wq4on_users AS uc ON uc.id = a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc LIMIT 0, 100

Could anyone supply a possible solution or a hint on what to look for?
Best regards

INFO:
5.5.46-0ubuntu0.12.04.2-log
Database Collation utf8_general_ci
PHP Version 5.5.9-1ubuntu4.14
Web Server Apache
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.4.6 Stable [ Ember ] 15-December-2015 11:11 GMT
Last edit: 8 years 11 months ago by janfk@storgaard.nu.

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago #4578 by admin
Replied by admin on topic Error 500
It seems the table is not updated to the latest schema (some missing fields). If you have no rule yet, just uninstall Tag Meta, check for existing tables (and delete them), and install the package again.

If you already have rules, you can execute the alter table manually as sql script:
ALTER TABLE `wq4on_tagmeta_rules` ADD `custom_header` varchar(255) DEFAULT NULL AFTER `canonical`;
ALTER TABLE `wq4on_tagmeta_rules` ADD `rydir` tinyint(1) NOT NULL DEFAULT '2' COMMENT '0=No,1=Yes,2=Skip' AFTER `rodp`;
ALTER TABLE `wq4on_tagmeta_rules` ADD COLUMN `skip` varchar(255) NOT NULL DEFAULT '' AFTER `url`;

Kind regards

Please Log in or Create an account to join the conversation.

  • janfk@storgaard.nu
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 11 months ago #4579 by janfk@storgaard.nu
Replied by janfk@storgaard.nu on topic Error 500 [SOLVED]
Thx. alot for the swift reply.
I uninstalled the extension, deleted database files, re-installed and voila - working!

Thumbs up

Best regards

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago #4582 by admin
Replied by admin on topic Error 500 [SOLVED]
Great news, I am glad to hear this.

Sincerely

Please Log in or Create an account to join the conversation.

Time to create page: 0.177 seconds