คืนนี้เพิ่งจะได้มีโอกาสนั่งรื้อปัญหาคาใจใน JoomlaPack Installer 4 ที่ไม่สามารถแก้ไขข้อมูล Super Admin ได้ ระหว่างการ restore ครับ ทั้ง password และ email จะไม่ยอมเปลี่ยน (ซึ่งทำให้มีปัญหากับ Joomseed เสียด้วยสิ) แต่ว่าตอนนี้หาเจอแล้วครับ ว่าผิดพลาดตรงไหน
Original Post: http://joomlapack.net/
Dear JoomlaPack Team,
First of all I would like to salute all you guys in JoomlaPack team that make such a great backup solution under GPL. JoomlaPack is really my most favorite Joomla extension ever.
Anyway after I upgraded to JoomlaPack Installer 4, it's really nice interface, but I cannot change Super Administrator Settings at all, including password and email.
Finally I found out that the problem was only one missing double quote ( " ) in the sql query before update the super admin data in the database.
The location is /installation/includes/logic/finish.php
Line 47-49
// Update database
$query = 'UPDATE `#__users` SET `password` = "'.$db->escape($cryptpass).
', `email` = "'.$db->escape($email).'" WHERE `id` = "'.$uid.'"';
The missing double quote is behind password before comma ( , ) and email. So the proper sql query should be
// Update database
$query = 'UPDATE `#__users` SET `password` = "'.$db->escape($cryptpass).
'", `email` = "'.$db->escape($email).'" WHERE `id` = "'.$uid.'"';
After I fixed this, all settings are working. Look forward to having a next version of JoomlaPack : )
Best regards,
Keerati S.
Subscribe to this comment's feed
| < Prev | Next > |
|---|
