Arrow Home
larger font smaller font default font Fixed screen resolution Auto adjust screen size

How to Recover from Joomla!1.0.13 CB hazard to 1.0.12
(Friday, 03 August 2007) Written by SiXX

For who just accidentally update to 1.0.13 (or fool enough, like me!) You should read the warning on the first page. But if it's the case you won't be reading this article right now.
The new 1.0.13 patch really cause the problem with cblogin module. Once login user can not login again from the front end.


You must know that this process quite a burden in case that you already got lot of users on your site, and even harder if they're quite active. Anyway it's my live saver.

So here's how i do it.

  1. Take your site OFFLINE, so no one may login and causes you more problem.
  2. Apply this REVERT PATCH I made.
  3. Now, take a deep breath, you must alter the MySQL database with phpMyAdmin or any other similar program. Log in to MySQL and open the database that joomla is installed.
  4. Browse table 'jos_users', you should see that password field of some user are longer than others. These fields are already altered by 1.0.13
    Another way to make sure of it is by spotting the color sign ":" in the password field.
  5. So what you can do about it? You can change it to something that you know. Let's try to change it to the word "PASSWORD" (Notes that it all capital letter).
    The encoded password for the word PASSWORD is "319f4d26e3c536b5dd871bb2c52e3178" without quotes. copy and paste it to EVERY password field that has been altered.
  6. You should also list all username that you edited. Then inform every users that their password has to be change via email or some other way,
    so they can use new password to login and change it to what they want.
  7. When you sure that everyone is informed, you can take your site ONLINE again.

That's it.

Comments
Not reverting
Written by ptornquist on 2007-11-12 12:36:32
Hi I have used the revert patch but still says 1.0.13 any body have the same problem 
 
Peter
Use SQL...
Written by ircmaxell on 2007-09-11 21:11:52
Instead of editing each user manually, try this 
Code:
UPDATE jos_users SET password = '319f4d26e3c536b5dd871bb2c52e3178' WHERE password LIKE '%:%';
 
 
And then to get a list of users that have been effected just use 
Code:
SELECT name,email FROM jos_users WHERE password LIKE '319f4d26e3c536b5dd871bb2c52e3178';
:>
Written by Gregoriuspl on 2007-08-08 17:25:11
Is there is the same problem when i instaling joomla 1.0.13 from the begining? and then add CB?
Thanks
Written by kanela on 2007-08-03 23:16:11
Many many thanks, Wam, you are my hero! 
Kind regards

Only registered users can write comments.
Please login or register.

Powered by AkoComment 2.0!

[ Back ]

CB 1.2.3 Documentation

Thank you bonus:

ProfileBook (+Blog) 1.2RC
ProfileGallery 1.2RC2
CB Privacy 1.0RC

What? Why? Where?

Click here for a yearly subscription: subscribe now

CB 1.2.3 Download

Community Builder 1.2.3
Stable and native for:
Joomla 1.5 & 1.0 & Mambo
(incl. CB 1.2.3 Installation pdf)
You need to be a registered member to download.

Full 180 pages updated
CB 1.2.3 documentation:
You need to be a CB doc subscriber to download.

CB Login