MyBB Community Forums

Sorry if this is in the wrong place. Im just testing some sfuff here but I'm getting this error. What I've done is added a new field in the mybb_user table (input1). All i have is one textbox and one button in a form and im simply just inserting the value of the textbox into the new field, but im getting the error below.

This works perfectly if i create a new table and add my own fields, but it just wont work when i add a field to an existing table.

Error
[attachment=25245]

New field in mybb_users
[attachment=25246]

I'm guessing you actually want this:

UPDATE mybb_users SET input1='input here' WHERE uid='uid'

Whats thats gonna do? I just want to insert the extra value into an extra user field "input1" in mybb_users from a html form. All users can access this form.

Your current statement attempts to insert a new user.

Mine updates the value of a current user.