MyBB Community Forums

Full Version: [F] [PostgreSQL] Registration Error [C-Chris]
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Wen trying to register an account on a forum that is using PostgreSQL, an error is returned.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    55000 - ERROR: currval of sequence "trunk_userfields_ufid_seq" is not yet defined in this session 
Query:
    SELECT currval('trunk_userfields_ufid_seq') AS last_value 

Reproduction Steps:
1. Go to the registration form and fill out the required information.
2 Click "Submit Registration!".
3. The error mentioned above is returned. Also, it seems that the member does actually get registered ok, despite the error. (but the 'Please welcome our newest member' section on the board index doesn't get updated with the new user).

MyBB: Latest internal version
PostgreSQL 8.3.4
PHP: 5.2.6-2ubuntu4
Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.

With regards,
MyBB Group