2008-12-06, 10:32 PM
Wen trying to register an account on a forum that is using PostgreSQL, an error is returned.
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
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