Register/Edit Users, error on params column missing

[RobInk]

When you try to register a new user, or edit an existing one, in some cases you can get a MySQL error message stating that there is an unknown column params. In short, somehow the params column has been deleted form the jos_users tabel.

One of the causes is related to uninstalling the phpBB forum and bridge, see this topic.

To restore the column, check the above mentioned topic first. If you are sure it is not related to phpBB, then make a backup of your database.

Once you have done that, go to any database tool such as phpMyAdmin, select your database and after that the jos_users table and run the following script:

Code: Select all

ALTER TABLE jos_users ADD params TEXT NOT NULL;

This will add the params column again and the problem should be solved.

keywords: unknown column params mysql error