14

From the joomla docs How do you recover or reset your admin password? Method 1: Configuration.php Use an FTP program to access your site's ftp Locate and download the configuration.php Using a text editor open configuration.php and add the following line. Substitute myname to a name of an account with administrator access that you know the password. ...


8

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 exact approach should depend on from where you want to import these users and the actual user-data you already have and want to import. Also, if these users ...


6

Joomla uses the Xyz8_users table for storing user data. Reseting the passwort is simple just execute this query in phpmyadmin: update Xyz8_users set password=md5('newpassword') where username='yourusername'; After changing the password with SQL, log into Joomla and it will be converted to an update passwort hashing method.


5

Method 1 In phpMyAdmin, go to the Xyz8_users table (change the table prefix, Xyz8_ to your table prefix if it is different.) Select the record for the Super User account (the Super Admin account has an ID of 62 or 42 by default). Copy and paste a known MD5 hash (one of the longer character strings below) into the password field. admin = ...


5

you should look for table Xyz8_users. Click "Browse" 2 List with all users will appear. Find the user you want to edit and click the "Edit" link in front of the row Find the "password" row and click on the select box under the "Function" column. Select "MD5" and type the new password in "Value" textarea. Click the "Go" button at the bottom of the page and ...


4

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 changed in any way, you can open the #__user_usergroup_map table, find the user_id that corresponds to your user, and change the group_id to 8 which is the default ...


4

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 installation on the Database Configuration page to remove any existing tables so there's no need to drop (remove) the database tables using phpMyAdmin or similar. ...


4

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 browser. Log in as Super admin without account How to: Сopy the file in "administrator" and go to [your_site]/administrator/log.php WARNING: remove the file ...


4

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:


3

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. In case the query is optimised you need to ensure to paginate the loading of your data by LIMIT 'ing your query and resulting resultset. Out of the box Nooku ...


3

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; foreach ($data['profile'] as $k => $v) { $tuples[] = '(' . $userId . ', ' . $db->quote('profile.' . $k) . ', ' ...


3

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 and time. It is within about 1 second of mean solar time at 0° longitude;[1] it does not observe daylight saving time. It is one of several closely related ...


3

UPDATE kms_content SET fulltext = REPLACE (fulltext, 'text to find', 'text to replace') WHERE catid IN (16, 17, 18, 19, 20, 21, 22);


3

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, the root user (with empty password) usually has access to all your databases. Try setting the following variables in you configuration.php file: public $user = ...


2

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 correctly: public $user = 'DB_USER'; public $password = 'DB_PASSWORD'; public $db = 'DB_NAME'; public $dbprefix = 'jos32_'; Also ensure that you have assigned ...


2

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.


2

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 two databases are local, you can just a ssign permissions to access the second database to your database user. In this way, the multi-database query is solved ...


2

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 following snippet of code: class da_DKLocalise { which you need to replace with: class fo_FOLocalise {


2

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. https://www.ostraining.com/blog/joomla/white-screen-of-death/ try this guide on how to do it


2

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 = JFactory::getDBO(); try { $select_query = $db->getQuery(true) ->select("COUNT(*)") ->from("#__users") ...


1

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 write your own version of the profile plugin) What You will need to do is parse the JSON data in your code to get to the underlying values. This is common in ...


1

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(JPATH_BASE . DS . 'includes' . DS . 'defines.php'); require_once(JPATH_BASE . DS . 'includes' . DS . 'framework.php'); $app = JFactory::getApplication('site'); $...


1

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 from your view class: public function display($tpl = null) { $this->items = $this->get('Items'); $this->pagination = $this->get('...


1

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 xxx_contentitem_tag_map WHERE tag_id = 2 ) Basically you have to select all article IDs where the tag ID is already 2 and then exclude them ...


1

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 sessions table.


1

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 tables directly on a daily basis. I have created batch scripts for migration (after careful testing). For examples, module instances are also linked to menu items. ...


1

It is possible for recover the admin password. Two ways to recover the admin password. Step 1 Edit configuration.php file public $root_user='myname'; Step 2 Edit #__user table in database. http://docs.joomla.org/How_do_you_recover_or_reset_your_admin_password%3F 1.Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand ...


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