Dev {Tricks}

You are here: Home / Archives for Joomla / Fix & Tricks

by

How to exclude a specific folder from rewrite rule in htaccess

  • .htaccess mod_rewrite – how to exclude directory from rewrite rule
  • Exclude Certain Folders from htaccess Rewrite Rules
  • How to Exclude Folder from Rewrite Rule in .htaccess

Add the following line above your rule to exclude a directory (for example, journal) from rewrite rule

RewriteRule ^(journal)($|/) - [L]

To exclude multiple folders, use the following condition above your rule

RewriteCond %{REQUEST_URI} !^/(folder1|folder2/.*)$

OR

RewriteRule ^(folder1|folder2)($|/) - [L]

To exclude all existent directories, you will need to use the following condition above your rule

RewriteCond %{REQUEST_FILENAME} !-d

 

 

 

by

How to create joomla Super Administrator account using phpMyAdmin

SQL code for use with Joomla Joomla 2.5 Joomla 3.x Joomla 4.x  

INSERT INTO 'jos_users'
('name', 'username', 'password', 'params', 'registerDate', 'lastvisitDate', 'lastResetTime')
VALUES ('Administrator2', 'admin2',
'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '', NOW(), NOW(), NOW());
INSERT INTO 'jos_user_usergroup_map' ('user_id','group_id')
VALUES (LAST_INSERT_ID(),'8');

Please check your table prefix jos_ . The above will create Super Administrator with username “admin2” and password “secret”. After logging in change your details.

If failed above, try below syntex

INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) VALUES (1000000, 'tempsuperuser1', 'tempsuperuser1', '[email protected]', MD5('temppassword'), '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', '0', '', '', '0');
INSERT INTO `jos_user_usergroup_map` (`user_id`, `group_id`) VALUES ('1000000', '8');

The above will create Super Administrator with username “tempsuperuser1” and password “temppassword”. After logging in change your details.

 

Password = You can choose other password
——————————————————
– admin = 433903e0a9d6a712e00251e44d29bf87:UJ0b9J5fufL3FKfCc0TLsYJBh2PFULvT
– secret = d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
– OU812 = 5e3128b27a2c1f8eb53689f511c4ca9e:J584KAEv9d8VKwRGhb8ve7GdKoG7isMm

by

Solved: Can’t save module, exceeds limits | Joomla

  • Save failed with the following error the content exceeds allowed limits
  • Can’t save module, exceeds limits

Solution

The error message is triggered by the size limit of the text that can be stored into the column ‘content’ in the modules table. The text limit is 65535 in the MySQL database.

  • Login to your hosting panel (For example cPanel, Plesk, DirectAdmin, CWP etc.)
  • Now open your database in phpMyAdmin
  • Check the definition of the column ‘content’ and it should be ‘text’ and we have to make it ‘mediumtext’.

That’s all!

If not solved, please change Default editor to TinyMCE.