UseBB Community

The official board for UseBB help and discussion

• UseBB Community » Help & Support » SQL_ERROR

SQL_ERROR

Moderators: Gaia.

Page: 1

Author Post
bastya_elvtars
#1 Wed Jun 28, 2006 7:28 am
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!
Dietrich
#2 Wed Jun 28, 2006 10:32 am
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
bastya_elvtars
#3 Wed Jun 28, 2006 6:08 pm
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!
bastya_elvtars
#4 Thu Jun 29, 2006 4:34 pm
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!
Dietrich
#5 Thu Jun 29, 2006 5:30 pm
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
bastya_elvtars
#6 Fri Jun 30, 2006 8:05 am
Member
Registered: Mar 2005
Posts: 196
Location: Hungary
Works on another server. Must be a lighttpd/php issue.
_______________
Long Live Rock n' Roll!
Dietrich
#7 Fri Jun 30, 2006 6:05 pm
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
bastya_elvtars
#8 Sat Jul 01, 2006 7:07 pm
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