Joomla! Discussion Forums



It is currently Tue Nov 24, 2009 11:16 pm (All times are UTC )

 


Forum rules

Please submit all new Tips and Tricks to: http://docs.joomla.org/Category:Tips_and_tricks

This forum section will be closed and removed eventually.



Post new topic Reply to topic  [ 1 post ] 
Author Message
Posted: Tue Jan 23, 2007 10:36 am 
User avatar
Joomla! Master
Joomla! Master
Offline

Joined: Thu Aug 18, 2005 10:41 am
Posts: 15089
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:
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

_________________
Regards Robin


Top
   
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

Quick reply

 



Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group