UseBB Community

The official board for UseBB help and discussion

UseBB Community » Help & Support » SQL_ERROR

SQL_ERROR

Moderators: Gaia.

Page: 1

Author Post
Member
Registered: Mar 2005
Posts: 196
Location: Hungary
An error was encountered. We apologize for any inconvenience.

In file db_mysqli.php on line 114:

SQL_ERROR - Column 'id' cannot be null

Enable debug mode level 2 to see the error and erroneous SQL query.


What may be causing this? Occurs when one tries to register.
_______________
Long Live Rock n' Roll!
Developer
Registered: Apr 2004
Posts: 2224
Location: Belgium
Please enable debug mode level 2 to see the error and erroneous SQL query.
_______________
--Dietrich (developer)
UseBB roadmap, dev mailing list & weblog
Member
Registered: Mar 2005
Posts: 196
Location: Hungary
INSERT INTO usebb_members ( id, name, email, passwd, regdate, level, active, active_key, template, language, date_format, timezone, enable_quickreply, return_to_topic_after_posting, target_blank, hide_avatars, hide_userinfo, hide_signatures, displayed_name, banned_reason, signature ) VALUES ( NULL, 'tester', 'szakal.gergo@gmail.com', 'f890537226a89501775c0a6aee29633b', 1151514751, 1, 0, '926f3642d850792548910b2bc376e204', 'default', 'English', 'D M d, Y g:i a', 1, 1, 1, 1, 0, 0, 0, 'tester', '', '' )
_______________
Long Live Rock n' Roll!
Member
Registered: Mar 2005
Posts: 196
Location: Hungary
If that helps, it does the pretty same when posting a topic.
Oh, here you can see my phpinfo.
_______________
Long Live Rock n' Roll!
Developer
Registered: Apr 2004
Posts: 2224
Location: Belgium
Could you check with phpMyAdmin whether the id fields (in for example usebb_posts) have auto_increment set?
_______________
--Dietrich (developer)
UseBB roadmap, dev mailing list & weblog
Member
Registered: Mar 2005
Posts: 196
Location: Hungary
Works on another server. Must be a lighttpd/php issue.
_______________
Long Live Rock n' Roll!
Developer
Registered: Apr 2004
Posts: 2224
Location: Belgium
What is the MySQL version of that other server? Since the one you use is 4.1.
_______________
--Dietrich (developer)
UseBB roadmap, dev mailing list & weblog
Member
Registered: Mar 2005
Posts: 196
Location: Hungary
Also 4.1.
_______________
Long Live Rock n' Roll!

Page: 1

UseBB Community » Help & Support » SQL_ERROR

UseBB Community is powered by UseBB 1 Forum Software