Acajoom SQL Integration

9 years 7 months ago #121150 by nant
coachnet wrote:

Thanks for that.

I've just test the activation code and it didn't work for me. The code on this topic didn't work for me either.

I've just copied and pasted the code as is into the SQL Action tab for the appropriate plan and substituted <listid> with 2.

I notice there are some spaces before and after some of the (), symbols... can't this be a problem?


Sorry, should have tested better before I posted.

Think I fixed it - please use updated statements in first post.
9 years 7 months ago #121212 by ThePiston
that code looks different from the official Acajoom SQL code I posted here: www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,118827/catid,90/limit,6/limitstart,12/

Nant, can you decipher what the differences are?

CB 2.3, CBsubs 4.3, PHP 7.1, J! 3.9.X
9 years 7 months ago #121219 by nant
ThePiston wrote:

that code looks different from the official Acajoom SQL code I posted here: www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,118827/catid,90/limit,6/limitstart,12/

Nant, can you decipher what the differences are?


Sure, if you tell me what "official" means?
9 years 7 months ago #121220 by ThePiston
they have a page on their site that lists SQL actions for integration into 3rd party components:
www.ijoobi.com/help/acajoom/sql-queries.html#integrate

Post edited by: ThePiston, at: 2010/01/08 17:58

CB 2.3, CBsubs 4.3, PHP 7.1, J! 3.9.X
9 years 7 months ago #121222 by nant
ThePiston wrote:

they have a page on their site that lists SQL actions for integration into 3rd party components:
www.ijoobi.com/help/acajoom/sql-queries.html#integrate

Post edited by: ThePiston, at: 2010/01/08 17:58


hmmm, ok need to study this further.
9 years 7 months ago #121371 by coachnet
nant wrote:

Sorry, should have tested better before I posted.

Think I fixed it - please use updated statements in first post.


Unfortunately still not working. Could it be a problem that I have the plan set up to require approval? Does the SQL Action run before or after the approval?

I have checked both before and after I approve the subscription and the user is still not subscribed to the Acajoom list.

Renee Hasseldine
CoachNetwork Founder
Life Coaches | Business Coaches | Executive Coaches
Moderators: beatnantkrileon
Time to create page: 0.397 seconds