Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

PHPMyAdmin database fields disappear after a Joomla 3.1 install

Posted on 2013-06-14
6
Medium Priority
?
761 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 2000 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 2000 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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 2000 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

715 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