Questions tagged [phpmyadmin]

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.

0
votes
1answer
68 views

Can't login to Joomla! admin updating password in PHP MyAdmin doesn't work

I cannot log into the Joomla! admin. Updating the password in PHP My Admin does not work. It always says that my username and password do not match, the user does not exist or I have not been ...
1
vote
1answer
52 views

Joomla database tables have duplicates that start with bak_

I have a Joomla website, and somehow, the database shows duplicate entries for every table row. The duplicates all start with bak_. I assume it was caused by some sort of backup process, but this has ...
0
votes
1answer
31 views

Copy users from one Joomla db to a slightly newer one

Assuming I have an earlier copy of a Joomla database can I simply copy the jos_users, jos_userkeys, jos_usernotes, jos_userprofiles and jos_usergroup_map tables to a newer copy of the database - by ...
2
votes
1answer
350 views

Correct ways to verify update query is successful under conditions

I was trying to find out correct ways to verify db update query is successful but some problems i am fetching. Even if update query($db->execute()) is not done/row does not exists.... but it ...
1
vote
0answers
35 views

Found something weird in my _users table. Wondering if hacked or if part of the joomla code might the culprit. And most important how to resolve.

I noticed that I couldn't log into the back end or front end of a joomla 3.5.1 installation. After hours of trying to figure it out, I finally went to phpmyadmin and viewed the _users table to reset ...
3
votes
1answer
59 views

How to tell what WAS the local time of an article?

Sorry if this was explained somewhere, but up to now - nothing found. So, I have an article published today, Aug.14th, at 11:11 local time. This means +3 hours from UTC. At MySQL table content I can ...
1
vote
2answers
263 views

Quotes Displayed in Database Value

So any profile data filled in within a user profile for joomla is being saved with quotes around it in the database. Does anyone know how to remove the quotes? It seems to do it even as the default ...
3
votes
2answers
926 views

Adding Multiple Users in Joomla

How can to add multiple users in Joomla 3 without using an extension? Thank you! :)
1
vote
2answers
183 views

Change administrator site language through phpmyadmin

I was trying to setup a multilingual joomla site, and Faroese wasn't an option so I asked this question: "Add Custom language to content language" but this didn't give the user the opportunity to ...
0
votes
1answer
84 views

Fatal error: JApplicationCms::getUserState()

I was trying to update my Joomla 3 site to the 3.2 stable release via Extension manager on localhost, but after installing it, I got a white screen when I try to access the back and the front-end. I'...
0
votes
1answer
282 views

I change a value 'id' in the modules table & cannot find a way for it to work

I'm using Joomla & I go into phpMyAdmin, Straight to the modules table. For a lot of the tables in the database, I can change the 'id' field of numerous tables, (menu, content) ect .. & then ...
1
vote
2answers
155 views

Loading time is slow in Joomla PHP [closed]

I am creating an application with PHP ; Joomla 3 , Nooku and MySql Database , and I am interacting with the database to get datas from a table , i get over 64400 rows to 5 columns , but the problem is ...
0
votes
1answer
311 views

How to merge joomla tag using SQL query from phpMyadmin?

Since Joomla does not have a tag merging feature, I'm looking for a way to merge existing tags using SQL query in phpmyadmin. Old tag_id=1 New tag_id=2 This query works as long as all of the ...
1
vote
1answer
4k views

Set user as super user from db

Joomla 3.3.6 I have a user called 'Jo'. He is currently set as a Joomla 'Administrator' with front and back-end access. However I would like to now set him as a 'Super User'. How can I achieve this ...
4
votes
2answers
351 views

Remove entire joomla installation

After an malresearched update I have broken my joomla installation trying to push 3.2.7 to 3.3.6 as my server does not support the Php version required. Since I didn't keep backups as it is currently ...
1
vote
1answer
1k views

I can load data from Joomla database and external database?

It is possible to join 2 databases at the same time in a single query? For example: I want to see how many users I have on my server and how many users I have on an external server, all in a single ...
2
votes
1answer
252 views

phpmyadmin: how to save changes made on multiple rows using “edit”

Using an "find and replace" chrome's app, I made some changes in the fulltext field of 300 joomla articles. I could save each row one by one using the "go" button under each row (cf picture) but is ...
1
vote
1answer
143 views

Looking for “start publishing” field in database

I'm looking for the "start publishing" field into the xx_content of my database. I Don't see any column named like that. I can't find where its value are store. Any idea where I could find it? (...
1
vote
2answers
1k views

Migrating Joomla site to local machine

I borked a Joomla site while trying to upgrade to Joomla 3. One of the extensions was not supported and I had to restore my backup, including the backup of the database. Unfortunately, it did not work ...
15
votes
6answers
6k views

Change Super User account password

I have forgotten my super admin password. How can I reset the super admin account password? I have access to both FTP and phpMyadmin how can I change the Super User account password? My table ...