Registration problem

[Saftek]

New users cannot register. We get "an error occurred" message.

We experienced a problem adding your account. Please contact the System Administrator!

When I try to register and use the same email address the program complains, so it appears to be looking at the database.
-------------------------------------
Registration Options
Require unique email addresses for user registration?
yes
Do you want to prompt for optional info during registration?
yes
Use COPPA for registration?
yes
Use CAPTCHA images when verifying registration?
Requires GD2 support! no
Full Path to Registration Rules, or leave blank for default

Require verification of email address upon registration?
no
Your mailing address to receive COPPA permission forms?

Full path to COPPA rules file, or leave blank for default?

Allow new user registrations?
yes
Require users to be registered to view images?
no

[Chuck S]

This goes along with your initial error you need to resolve that and then reinstall and you should be okay.

[Saftek]

Yes, deleting the strict trans tables statement from my.ini allows new users to properly register.

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

[Chuck S]

No problem enjoy your weekend.