problem with Using plan for Self Sign-up

[Ros]

I am evaluating your trial version.

I have problem to set up any plan on Authentification Server page.
All settings all default, using ODBC.

Self signup works fine while Self signUp Plan="No plan is selected"

But when I change this option to any plan, even Plan A or Plan B, which is included in clean installation, then fill in Account SignUp form and submit.
Then I could see:

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC dBase Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in C:\Program Files\FirstSpot\authserv\common_functions.php on line 362

Account creation succeeded.
Please click here to proceed


So far I cannot find any solution. The user account are created, but the plan settings are not used to set up user settings.

[alan]

Are you using v5.0.0 final release or beta?

Also, make sure you don't change anything within the datasource directory.
_________________
~ Patronsoft Limited ~

[Ros]

I've downloaded on Nov 14.

I did not change anything in datasource directory.

[alan]

What is the Windows version and SP are you currently using?
_________________
~ Patronsoft Limited ~

[Ros]

Clean W2k svr EN SP4
running only FirstSpot

[dominic]

Your machine performs a stricter type checking and rejects the execution of SQL update from FirstSpot.

Please download the following files:
http://patronsoft.com/firstspot/download/patch/501/common_functions.zip
http://patronsoft.com/firstspot/download/patch/501/local.zip

Then, extract common_functions.php to FirstSpot\authserv folder and extract both ppal_ipn.php and transaction.php to FirstSpot\local folder. After the file update, please test if the same error is thrown again.

[Ros]

Thanks Dominic,
now works fine.

Robert