Link to home
Start Free TrialLog in
Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

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
SOLUTION
Avatar of johanntagle
johanntagle
Flag of Philippines image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RUA Volunteer2?

ASKER

I did save the newly added fields "usertype and gid"  and insert the records with "Super Administrator"......I did not know what to put in the gid record so I left it empty and with the settings you describe above and seen in the following line.......below

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.