admin section lockout after importing sample data rocketlauncher
-
-
- MR MARC LAURENT EURL DSD
- Newbie
- Posts: 5
- Thanks: 0
-
Hello,
I have a problem on joomla 1.5 and terrantribune, it is impossible to enter in the admin side of the example_data web site of TerranTribune that I installed.
I did read the forum and to be sure did remplace the password with a new one by a sql command in phpMySQL
UPDATE example_users SET password=MD5('yourpassword') WHERE usertype = "Super Administrator";
But it is still the same message : You do not have access to the administrator section of this site.
When I enter a wrong password it says that the user and password are not matching so the password is correct......
I did try to add a admin user direcly with a sql command but the message is the same with the new user....
Here is what there is in my jos_users table :
Modifier Effacer 62 Administrator admin This email address is being protected from spambots. You need JavaScript enabled to view it. 6ef1eec772093f2b5a0fa1d5b5995cce:y9WYEf7QhWcAEqOKDxGMk14y8ZGV6CXF Super Administrator 0 1 25 2008-09-09 19:17:07 0000-00-00 00:00:00
Modifier Effacer 63 Administrator dsd This email address is being protected from spambots. You need JavaScript enabled to view it. 5c7d0c90cf9e0ce560956179e8e82e7d Administrator 0 1 26 2008-09-09 19:19:07 0000-00-00 00:00:00
I spent a lot of time to succeed in installing the sample_data Rocketlauncher because of problems with the sql file that had to be modified deleting # character and now that the website works fine, I have this access problem and can't modify the example website ...
I did try to change gid to 24 or 26 as I read in the forum but it doesn't help.... th esession folder of libraries is also chmod 777... doesn't help either.....
Please help, I really don't see what to do now... - Last Edit: 16 years 7 months ago by MR MARC LAURENT EURL DSD.
-
-
-
- MR MARC LAURENT EURL DSD
- Newbie
- Posts: 5
- Thanks: 0
-
I made it work but that is not professional.....
The I did change all the .sql file located in the installation folder.
Putting jos_ instead of #_ and changing ENGINE=MyISAM by TYPE=MyISAM
then I did run the rocketlauncher and put an admin password for mysql
I had again the XML error returned from the server when pressing the button Install sample data but I did press next to end the installation process
I then edit sample_data.sql en remove the part where the jos_users table is created so that to let in the existing database the table where admin access was created by the RocketLauncher...
I connected phpMysql
and did run the sql file sample_data.sql that i just modified
I finished to import data
then all works, I am able to connect the admin part and the wesite works........
Rather tricky isn't it ?
If anyone has a better solution, I would be interested in Knowing it
Good luck
-
-
-
- MR MARC LAURENT EURL DSD
- Newbie
- Posts: 5
- Thanks: 0
-
MR MARC LAURENT EURL DSD wrote:
I made it work but that is not professional.....
The I did change all the .sql file located in the installation folder.
Putting jos_ instead of #_ and changing ENGINE=MyISAM by TYPE=MyISAM
then I did run the rocketlauncher and put an admin password for mysql
I had again the XML error returned from the server when pressing the button Install sample data but I did press next to end the installation process
I then edit sample_data.sql en remove the part where the jos_users table is created so that to let in the existing database the table where admin access was created by the RocketLauncher...
I connected phpMysql
and did run the sql file sample_data.sql that i just modified
I finished to import data
then all works, I am able to connect the admin part and the website works........
Rather tricky isn't it ?
If anyone has a better solution, I would be interested in Knowing it
Good luck
-
Time to create page: 0.049 seconds