8
votes
Adding Multiple Users in Joomla
I see in the tags of your question you are using mysql and phpmyadmin, so I assume you are after a a way to INSERT records of users directly into the Joomla database.
However please note that, the ...
- 19.6k
4
votes
Accepted
Set user as super user from db
I was very cautious about this question and nearly flagged it as a security hole, but re-read it.
You mentioned you have access to the database, so assuming the Super User group ID had not been ...
- 26.7k
4
votes
Accepted
Remove entire joomla installation
Before reinstalling, delete the files and folders that have been installed into the www or public_html or other folder where Joomla is installed.
There is an option during the standard Joomla ...
- 7,983
3
votes
Accepted
Quotes Displayed in Database Value
As far as I can tell from the profiles plugin code, the speech marks come from data being JSON encoded before being entered into the database.
$tuples = array();
$order = 1;
...
- 3,072
3
votes
Accepted
How to tell what WAS the local time of an article?
In database tables, dates are always in UTC.
Coordinated Universal Time (French: Temps universel coordonné), abbreviated as UTC, is the primary time standard by which the world regulates clocks ...
- 7,415
3
votes
Loading time is slow in Joomla PHP
The reason your page is slow is because you are trying to load all or a lot of the data at once, or because your query isn't optimised correctly due to missing indexes. Hard to say without more info.
...
- 154
2
votes
Remove entire joomla installation
Yes, just clear the installation folder and remove the database. If you intend to reinstall you only need to clear the files and tables, you can reuse the folder and database.
- 1,196
2
votes
Accepted
Change administrator site language through phpmyadmin
Based on the error you provided in the screenshot, you need to go to the following file:
public_html/hammer/administrator/language/fo-FO/fo-FO.lcalise.php
at the top of the file, you will see the ...
- 26.7k
2
votes
Change administrator site language through phpmyadmin
So you are not able to access the backend correct? You just see a white page when you try to do so? if that is the case you should enable error reporting in order to see what is causing the issue.
...
2
votes
Accepted
Joomla database tables have duplicates that start with bak_
You dont need to worry about these tables. They are generated from the Akeeba Backup extension when you perform a backup.
You can drop these table and no, your site won't be affected.
- 26.7k
2
votes
Correct ways to verify update query is successful under conditions
Here is a basic structure for isolating each outcome.
$id = 2286; // you can jinput this or whatever
$found = 0; // establish default value
$affrows = 0; // establish default value
$db = ...
- 4,646
2
votes
Accepted
After joining two tables in phpMyAdmin how do I save the results as a dynamic table?
Unless you are magically updating the new table with fresh data then you will only see the data from the initial select statement.
In this case you have a few options
populate the new table with ...
- 111
1
vote
How can I add an additional column to a database view in phpMyAdmin?
I solved it by using CREATE OR REPLACE VIEW rather than ALTER VIEW, like this:
#_content_with_featured_two AS
SELECT #_content.id AS f_id,
#_content.title,
#_content.featured,
#...
- 313
1
vote
Accepted
Mysqli query with regex to Joomla php syntax
quoteName() is something that you call when you are quote-wrapping identifiers. (REGEXP_SUBSTR(r.xml, \'[0-9]+\')) is not a table name or column name so it makes no sense to try to wrap it in quotes ...
- 4,646
1
vote
Accepted
Joomla 4 - 503 service unavailable
I managed to solve this by setting up the myqsl_nd_pdo module in PHP
- 1,869
1
vote
Quotes Displayed in Database Value
The profile_value field is a JSON encoded field, when it's empty it will be an empty quoted string as the default value.
You don't want to mess with the way the data is stored. (unless you want to ...
- 502
1
vote
Adding Multiple Users in Joomla
I have made an ajax call and then just passing the variables to this script.
define('_JEXEC', 1);
define('JPATH_BASE', __DIR__);
define('DS', DIRECTORY_SEPARATOR);
/* Required Files */
require_once(...
- 1,791
1
vote
Accepted
Fatal error: JApplicationCms::getUserState()
Maybe an active session (not closed properly) in the Joomla! sessions table is the error.
Try this:
Login to cPanel.
Access the database using PHPmyAdmin.
Delete all the user sessions from the ...
- 168
1
vote
I change a value 'id' in the modules table & cannot find a way for it to work
It is pretty advanced what you are doing. Thus, you have to deeply know how all tables are linked. Otherwise, you are at risk of generating inconsistencies.
I would not dare to change values at ...
- 7,415
1
vote
Loading time is slow in Joomla PHP
Selecting only the relevant rows is easy, provided the component has been properly integrated in the Joomla CMS. The first thing is to confirm you are requesting and storing the JPagination object ...
- 1,406
1
vote
How to merge joomla tag using SQL query from phpMyadmin?
Try this, but please backup your database before:
UPDATE
xxx_contentitem_tag_map
SET
tag_id = 2
WHERE
tag_id = 1 AND
core_content_id NOT IN (
SELECT
core_content_id
FROM
...
- 3,713
Only top scored, non community-wiki answers of a minimum length are eligible