Register/Edit Users, error on params column missing
Posted: Tue Jan 23, 2007 10:36 am
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:
This will add the params column again and the problem should be solved.
keywords: unknown column params mysql error
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