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
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
 
johanntagleCommented:
Okay I need to make a disclaimer that I'm an experienced MySQL DBA but definitely not a Joomla expert.  So I can only answer about the database side (I saw your post in the MySQL zone and since your original question was not Joomla specific I thought I could help).

Don't know why updating via phpmyadmin interface won't work for you but you can also try running the following SQL command:

update jos_users set usertype='whatever value', gid=25 where id=62;

Change "whatever value", 25 and 62 to whatever is appropriate.  The "where id=" clause of course will tell MySQL which row you are updating.
0
 
johanntagleCommented:
Does anyone know what causes this.
Somebody/something did an "alter table jos_users drop usertype", etc

Can it be fixed by adding the columns/fields back to the table and filling the records in manually.....?
Yes

How do I do that.
execute the following sql commands:

alter table jos_users add usertype varchar25, add gid tinyint(3) unsigned;

then update the fields either via an update statement or via phpmyadmin interface
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
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.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
johanntagleCommented:
The screenshot you attached shows exactly the page where you can update the value of the field for a specific record.  Fill in the value, go to the bottom of the page, choose "save" then click "go".  The other options whether to move to the next record, etc, are up to you.
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
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.
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.