Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#589 Preferences in MySQL not updated

Database
open
Reini Urban
5
2012-10-11
2008-02-02
Paul Stevens
No

phpwiki 1.3.14.

pearDb.php

preferences being kept in mySQL database.

If a user's current preferences == ""

<CODE>
if($prefs_blob != "" ){
...
}
{
insert new row
};
</CODE>

Then pearDb attempts to add another row to the database. It should get a 'Unique' failure but unfortunately it gets the userid and the preferences reversed so it inserts a row with the username set to the preferences and vise-versa.

I can probably fix this myself if necessary but it would be ugly as I have never written php before!

Discussion