XF 2.3 All user_id values must be unique" when registering or creating a user (XF 2.3.13)

[vangelis]

Hello,

On XenForo 2.3.13 I get this error whenever I register a new user on the
front end or create one manually in the admin panel:

"Oops! We ran into some problems. All user_id values must be unique."
(phrase: all_x_values_must_be_unique)

Nothing is written to the server error log.

What I have already checked:

• Happens with all add-ons disabled ($config['enableAddOns'] = false)
• No active code event listeners or class extensions from non-XF add-ons
• File health check: core files OK (only a disabled third-party add-on is flagged)
• xf_user: one user (user_id 1), CREATE TABLE structure looks normal

(PRIMARY KEY user_id, AUTO_INCREMENT)
- No orphaned rows in xf_user_profile, xf_user_option, xf_user_privacy,
xf_user_authenticate, xf_user_group_relation, xf_user_group_change,
xf_admin_permission_entry

• AUTO_INCREMENT of xf_user raised to 1000: same error
• No database triggers (SHOW TRIGGERS is empty)
• CHECK TABLE on the user tables: all OK
• No WordPress/SSO integration, no recent import or restore

Could you tell me which code path produces this error, or what else I
should check?

Thank you.

 

[vangelis]

I’ve now reinstalled the forum. Everything’s working now. Thanks