Solved

PHPMyAdmin database fields disappear after a Joomla 3.1 install

Posted on 2013-06-14
6
740 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
  • 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
mysqli 3 23
RDBMS and No sql database 4 47
Bootstrap collapse causes odd behavior with php loop 7 26
sql_mode 1 20
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The viewer will learn how to dynamically set the form action using jQuery.
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.

863 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now