adduser.php not working

[Brandin]

Hi there!

As per previous conversations I had informed you guys that I had moved the

Code:

adduser

portion of the

Code:

admin_users.php

page to its own page. Everything was fine and dandy, until I removed some of the table columns I felt weren't needed. This is what the structure of the users table is now:
http://hastebin.com/enigihigax.lisp

So now, when I try to add a user, it will no longer insert to the DB. It will perform the permission and profile DB queries, but inserts a row with no user_id because it doesn't exist. Ultimately I can change the structure back, I just really didn't wanna have to.

Any help would be greatly appreciated!

Thanks.

[mudmin]

I would say deleting from the user table is pretty dangerous because the system makes assumptions that those fields will be there. You can always add columns, bu taking away doesn't enhance security or performance in any measurable way.

If you want to try to leave them out, does your "try" block still contain company and stripe_cust_id because those two are in the admin_users.php one and not in your db so they would cause it to fail. If it were me, though, I would just restore the deleted columns.

[Brandin]

Hey,

It was definitely the DB. I had a backup so I dumped the structure into a new table, copied the data over and renamed the table, and everything works fine now. For future reference, don't ever mess with the tables haha.

Thanks!