Skip to Content Skip to Menu

[SOLVED] Probable conflit with queries plugins?

  • vipzeus
  • vipzeus
  • OFFLINE
  • Posts: 54
  • Thanks: 3
  • Karma: 0
13 years 8 months ago - 13 years 8 months ago #156201 by vipzeus
[SOLVED] Probable conflit with queries plugins? was created by vipzeus
Hello all community

I have more sites which dipend by first site community-builder registration.
At my first site i have CB_Subs where at the default plan activation used sql_actions i can send the registration on external databases of other sites (Virtuemart fields) and this work perfectly. At the same time for the local database i use CB_Virtuemart plugin with triggers frond end back After user registration and work perfectly too.

Now i created with CB_Queries the update query with triggers frond end back After profile update. The problem is i have not actions on the CB_Queries. Looks like dead.

Any idea what can be the problem? I use j1.5.22 and CB 1.4
Last edit: 13 years 8 months ago by krileon.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48536
  • Thanks: 8290
  • Karma: 1445
13 years 8 months ago #156226 by krileon
Replied by krileon on topic Re: Probable conflit with queries plugins?

The problem is i have not actions on the CB_Queries. Looks like dead.

Don't understand what you mean by this. You added no database query? Is the query not firing? Please better explain your issue with further details. Please also test with debug mode and maximum error reporting enabled.

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.

  • vipzeus
  • vipzeus
  • OFFLINE
  • Posts: 54
  • Thanks: 3
  • Karma: 0
13 years 8 months ago #156236 by vipzeus
Replied by vipzeus on topic Re: Probable conflit with queries plugins?

Is the query not firing?

What does mean?

Here is what i used
Code:
UPDATE #__users SET `name`='[firstname] [lastname]', `username`='[username]', `email`='[email]', `password`=MD5('[password]') WHERE `id`='[user_id]'; UPDATE #__vm_user_info SET `company`='[cb_ragionesociale]', `last_name`='[lastname]', `first_name`='[firstname]', `phone_1`='[cb_telefono]', `phone_2`='[cb_celulare]', `fax`='[cb_fax]', `address_1`='[cb_indirizzofatturazione]', `city`='[cb_citta]', `state`='[cb_state]', `country`='[cb_country]', `zip`='[cb_cap]', `user_email`='[email]', `extra_field_1`='[cb_partitaiva]', `extra_field_2`='[cb_codicefiscale]' WHERE `user_id`='[user_id]';

As Triggers i used onAfterUserUpdate,onAfterUpdateUser

As Access all

Nothing happen

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48536
  • Thanks: 8290
  • Karma: 1445
13 years 8 months ago #156259 by krileon
Replied by krileon on topic Re: Probable conflit with queries plugins?
You can not have 2 queries in a single trigger for CB Queries, copy your trigger and have a single query for each one. It currently does not support multiple queries as does CBSubs SQL Actions.

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.

  • vipzeus
  • vipzeus
  • OFFLINE
  • Posts: 54
  • Thanks: 3
  • Karma: 0
13 years 8 months ago #156293 by vipzeus
Replied by vipzeus on topic Re: Probable conflit with queries plugins?
Im confirm now works properly with single query for trigger.

Thanks for support

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

Moderators: beat, nant, krileon
Powered by Kunena Forum