Questions tagged [phpmyadmin]
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.
25 questions
1 vote
1 answer
120 views
How can I add an additional column to a database view in phpMyAdmin?
I have created a new view in my MariaDB database using phpMyAdmin combining the #_content and #content_frontpage tables called #__content_with_featured. I am now attempting to add a new column to this ...
- 421
1 vote
1 answer
210 views
After joining two tables in phpMyAdmin how do I save the results as a dynamic table?
In order to query the exact featured status of an article in a blog override (i.e. currently featured, not pending or expired or not featured at all) I have created a query to join two tables and ...
- 421
1 vote
1 answer
111 views
Mysqli query with regex to Joomla php syntax
// CODE1 (Mysql (MariaDB 10.8.3) query): SELECT s.`p_p`, COUNT(REGEXP_SUBSTR(r.`xml`, '[0-9]+')) FROM `#__s` AS s, `#__p` AS x, `#__v` AS r WHERE REGEXP_SUBSTR(r.`xml`, '[0-9]+') = [user_id] AND s.`...
- 49
1 vote
1 answer
463 views
Joomla 4 - 503 service unavailable
I've set public $error_reporting = 'maximum'; public $debug = '1'; If I go into cPanel and turn off mysqlnd nd_mysqli and nd_pdo_mysql and then turn on mysqli I get an error MySQL server has gone ...
- 2,091
0 votes
0 answers
247 views
An exception occurred while executing 'INSERT INTO
I am trying to sign up in a portal but I am getting the following error; "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'password' cannot be null How do I solve this problem?
0 votes
1 answer
164 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 ...
- 2,091
1 vote
1 answer
162 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 ...
- 156
0 votes
1 answer
164 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 ...
- 63
2 votes
1 answer
970 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,351
1 vote
0 answers
63 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 ...
- 11
3 votes
1 answer
149 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 ...
- 755
1 vote
2 answers
412 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 ...
- 88
3 votes
2 answers
2k views
Adding Multiple Users in Joomla
How can to add multiple users in Joomla 3 without using an extension? Thank you! :)
- 31
1 vote
2 answers
320 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 ...
- 165
0 votes
1 answer
136 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'...
- 69