Solved

PHPMyAdmin database fields disappear after a Joomla 3.1 install

Posted on 2013-06-14
6
751 Views
Last Modified: 2013-07-02
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
0
Comment
Question by:ruavol2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 24

Assisted Solution

by:johanntagle
johanntagle earned 500 total points
ID: 39249413
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
 

Author Comment

by:ruavol2
ID: 39249581
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
 
LVL 24

Assisted Solution

by:johanntagle
johanntagle earned 500 total points
ID: 39250135
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
Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

 

Author Comment

by:ruavol2
ID: 39250601
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
 
LVL 24

Accepted Solution

by:
johanntagle earned 500 total points
ID: 39250626
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
 

Author Closing Comment

by:ruavol2
ID: 39294695
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

Featured Post

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
This article discusses how to implement server side field validation and display customized error messages to the client.
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question