Topic-icon Update with Postgresql

Active Subscriptions:

None
9 years 8 months ago #46428 by everburninglight
Just upgraded to the last version and got this error:

Database query failed (error # %s): %s SQL=UPDATE "joo_jfbconnect_config" SET value=MOD(CAST(value as BIGINT)+1,2), setting = 'automatic_registration' WHERE setting = 'create_new_users';

Anything I need to fix manually?
The topic has been locked.
Support Specialist
9 years 8 months ago #46437 by alzander
Replied by alzander on topic Update with Postgresql
Hmm.. we'll have to check why that's throwing the error. We specifically tested that query with Postgre (I remember, it was a pain).

Either way, no, you shouldn't have to 'fix' anything. Please check the "Enable Automatic Registration" setting in the JFBConnect -> Configuration area. That SQL query was meant to flip the setting value because of how we use it now. Just make sure Auto Registration is configured however you want it to work.

Thanks,
Alex
The topic has been locked.