Skip to Content Skip to Menu

[SOLVED] upgrading to new CB auto action plugin SQL error.

9 years 5 months ago - 9 years 5 months ago #264941 by tlwebdesign
[SOLVED] upgrading to new CB auto action plugin SQL error. was created by tlwebdesign
Hi guys,

was upgrading the CB to the new version and now getting this error on installing the latest ersion of CB Auto actions:
Code:
Unknown column 'translate' in 'field list' SQL=UPDATE `xxx_comprofiler_plugin_autoactions` SET `title` = '', `description` = '', `type` = 'query', `trigger` = 'onAfterUserRegistration', `object` = '0', `variable` = '1', `access` = '-1', `conditions` = '[{\"field\":\"[cb_personeelsnummer]\",\"operator\":\"7\",\"value\":\"\",\"translate\":null}]', `field` = NULL, `operator` = NULL, `value` = NULL, `exclude` = '', `published` = '1', `ordering` = '2', `params` = '{\"query\":[{\"sql\":\"UPDATE `personeelsnummers` SET `status`= \'Geregistreerd\' WHERE `personeelsnummer` = \'[cb_personeelsnummer]\'\",\"mode\":\"0\",\"host\":\"\",\"username\":\"\",\"password\":\"\",\"database\":\"\",\"charset\":\"\",\"prefix\":\"\"}]}', `translate` = NULL WHERE `id` = '1'

how do i fix this?

Kind regards,

Tom
Last edit: 9 years 5 months ago by krileon.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 5 months ago #264950 by krileon
Replied by krileon on topic upgrading to new CB auto action plugin SQL error.
Upgrading from what to what? You maybe upgrading from a too old release of CB Auto Actions to a too new release and the migration doesn't take that into account.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

9 years 5 months ago #264986 by tlwebdesign
Replied by tlwebdesign on topic upgrading to new CB auto action plugin SQL error.
Hi krileon,

i'm updating from 3.1.3. How do i go about fixing what happened? install an older update now first and built up to the newest. Or wouldn't that work anymore?

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 5 months ago #265007 by krileon
Replied by krileon on topic upgrading to new CB auto action plugin SQL error.
No idea, that's 3 major releases behind. If the install upgrade completed just install it over it self a second time to ensure the install completed, but it probably messed up the migration so you'll need to double check your actions to ensure parameters weren't lost. If you've a backup you may want to rollback to it then install 4.x or 5.x then upgrade to 6.x. I can't recall when that column was added exactly though as the migration only accounts and is tested for the last major version before it so 5.x.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

9 years 5 months ago #265010 by tlwebdesign
Replied by tlwebdesign on topic upgrading to new CB auto action plugin SQL error.
Yeah i just uninstalled the plugin. Deleted the table manually through phpmyadmin and installed again. Then manually added the actions again. a bit more hassle than i was hoping for but i'm sure everything is right now. Thanks.

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

Moderators: beat, nant, krileon
Powered by Kunena Forum