Add additional columns to the users table

Hi There! 

Firstly, thank you for putting together an easy to use platform for administering users and levels! 

I am in need of adding some additional columns to the users table for some extra info. I can do this directly via the DB and call it back via the get_user_info method, but when registering an new user I am given an error about column counts. 

Can you tell me which files / lines I need to edit to increase the column count to match for the registration process? 

Many thanks,

Ben

Please tell me the error detail and if more details what are you trying to do then i can guide you how you can fix the issues thanks.

Hi Samar,

I've updated the install with the new code, including the database.

To add a new column, I've done the following:

ALTER TABLE `users` ADD `asm_codes` VARCHAR(250) NOT NULL AFTER `user_type`;

Then when adding a new user via the script, I get this error AFTER the users table has been updated: Column count doesn't match value count at row 1

Thanks,

Ben

Also, just to add some more info to this, I do not need this field to be editable and it will be populated manually, after an account is created. I just need to avoid the error. 

If you ALTER Script's table which is used in table then every function which insert, and update that table needs another column. 

So it would be good if you create another table with name. asm_codes with fields >> code_id  --- user_id (Foreign key to user table) ---  asm_code

And then save everything in that new table. For reference Check Notes module hot its table is created how it saves into database, and how it relates with Users. 

We would not able to provide you complete guide, you have to hire a PHP developer if you are not very good to do this thanks.

Hi Samar,

Thanks for coming back to me. I'll make the adjustments as you describe above. 

Please consider this request closed.

Thanks,

Ben