Solved

PHPMyAdmin database fields disappear after a Joomla 3.1 install

Posted on 2013-06-14
6
737 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
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 …

708 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

16 Experts available now in Live!

Get 1:1 Help Now