Skip to Content Skip to Menu

*SOLVED* ERROR nr. 1064 - AEC Subscription Manager

  • siddan
  • siddan
  • OFFLINE
  • Posts: 10
  • Thanks: 0
  • Karma: 0
17 years 11 months ago #24173 by siddan
Hey

There have been a few weeks now since the last post, as what I have seen, about the "Account Expiration Control - Subscription Manager".
And now I would like to try it out...

I have installed it and it was successfully. But...
When I am clicking on "register" I get a type of error, like this:

DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND active=1 AND entry<1 ORDER BY ordering' at line 2 SQL=SELECT * FROM jos_acctexp_plans WHERE mingid= AND active=1 AND entry<1 ORDER BY ordering


Obviously I need to do something about my database?
I can however login with an already existing user created from Community Builder login module.

I dunno what else information to give but here is a brief from my webhotel I am using:

Operating system Linux
Kernel version 2.6.9-42.0.3.ELsmp
Machine Type x86_64
Apache version 1.3.37 (Unix)
PERL version 5.8.7
PHP version 4.4.4
MySQL version 4.1.21-standard

oh, and I have the complete Joomla site installed in a subdirectory... if this matters

This is another thread which was started in here about it being a BETA
www.joomlapolis.com/component/option,com_joomlaboard/Itemid,/func,view/catid,13/id,19861/#19861


Ok... I spent alot of hours searching different forums and finally found the answer

Post edited by: siddan, at: 2006/11/08 14:20

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

  • skOre
  • skOre
  • OFFLINE
  • Posts: 15
  • Thanks: 0
  • Karma: 3
17 years 11 months ago #24223 by skOre
For those who wonder what the solution is:

Just set a value for the second GID field on each payment plan. There was a problem when this was not automatically done when upgrading the AEC to RC1.

The upcoming public RC2 will remove this error.

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

Moderators: beatnantkrileon
Powered by Kunena Forum