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 ...
user avatar
  • 19.5k
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 ...
user avatar
  • 26.5k
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 ...
user avatar
4 votes
Accepted

Looking for "start publishing" field in database

In the #__content database table, the column you're looking for is publish_up. This contains the timestamp value for the publish date. See screenshot below:
user avatar
  • 26.5k
4 votes

Change Super User account password

There's also a tool available for Joomla 2.5 (haven't tested with Joomla 3): http://myext.eu/en/j25-login It's simply a PHP file that you upload to your /administrator/ folder and visit in your ...
user avatar
  • 13.3k
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 ...
user avatar
  • 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. ...
user avatar
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; ...
user avatar
  • 3,072
3 votes
Accepted

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

UPDATE kms_content SET fulltext = REPLACE (fulltext, 'text to find', 'text to replace') WHERE catid IN (16, 17, 18, 19, 20, 21, 22);
user avatar
  • 2,275
3 votes
Accepted

Migrating Joomla site to local machine

Take a look at your database settings in the file configuration.php in your Joomla root directory, this is the file that connects Joomla with your MySQL database. When using XAMPP on your computer, ...
user avatar
  • 13.3k
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.
user avatar
  • 1,196
2 votes

I can load data from Joomla database and external database?

Query object is created from a database connection. It cannot manage two connected databases in a single query. To solve the requirement, it is better if you enable the acces at MySQL level. If the ...
user avatar
  • 7,415
2 votes

Migrating Joomla site to local machine

This error means what it means. You have defined some incorrect value for the database connection parameters. Check your configuration.php file and ensure you have filled in the following variables ...
user avatar
  • 26.5k
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 ...
user avatar
  • 26.5k
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. ...
user avatar
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 = ...
user avatar
  • 4,448
1 vote

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.
user avatar
  • 26.5k
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 ...
user avatar
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(...
user avatar
  • 1,781
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 ...
user avatar
  • 1,396
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 ...
user avatar
  • 3,693
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 ...
user avatar
  • 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 ...
user avatar
  • 7,415

Only top scored, non community-wiki answers of a minimum length are eligible