RUA Volunteer2?
asked on
PHPMyAdmin database fields disappear after a Joomla 3.1 install
had a Joomla 3.1 install everything seemed fine for three weeks then last week somehow the fields in the user table that identify the SuperAdmins were gone. I noticed it when I logged in last week and I could no longer do anything with my Joomla site. I could not create or delete users. I could not add anything upload anything etc.
The two fields that are suddenly missing are GID and UserType fields from the Jos_Users table. See image attached.
Does anyone know what causes this.
Can it be fixed by adding the columns/fields back to the table and filling the records in manually.....?
How do I do that.
DatabaseTableJoomla.jpg
The two fields that are suddenly missing are GID and UserType fields from the Jos_Users table. See image attached.
Does anyone know what causes this.
Can it be fixed by adding the columns/fields back to the table and filling the records in manually.....?
How do I do that.
DatabaseTableJoomla.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I did exactly that.......it does not work sir. No changes. What would I put in the GID....record..? Is that even needed.
If I open the database table again and the record is there I assume he value..."Super Administrator" has been saved and the record is stored......? Still when I go in to the I cannot
1. add a new user .
2. Cannot change a configuration setting say Under Global Configuration All the way at the bottom Display Joomla Version.
3. Cannot go to Media Manager and upload the file I attached for my website. MailForge
4. I cannot upload a new template either.
If I open the database table again and the record is there I assume he value..."Super Administrator" has been saved and the record is stored......? Still when I go in to the I cannot
1. add a new user .
2. Cannot change a configuration setting say Under Global Configuration All the way at the bottom Display Joomla Version.
3. Cannot go to Media Manager and upload the file I attached for my website. MailForge
4. I cannot upload a new template either.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I discovered through Parallels Panel and PLESK that the problem lied withing the settings of PLESK. I do not think it had anything to do with the direction I was heading although it looked very suspect. I am awarding the points for the effor and not going to post it as a solution in the knowledge base.
ASKER
alter table jos_users add usertype varchar25, add gid tinyint(3) unsigned;
So .........How do I...or what do you mean by this.....
"then update the fields either via an update statement or via phpmyadmin interface"
I appreciate you hanging in with me.