Every time I need to reset the admin password in Open X it takes me ages to scan through all the tables, thinking “which bloody table would contain the admin password”, remembering from the last time it’s the one you least expect …

For future reference, it’s the preference table, record 0 and where the agency_id = 0.  Imagine, who ever would have thought of a password as a preference.  I suppose it’s getting better, in phpAdsNew it was in the config table!

This is where logical thinking can cause you to waste hours of time: an application has many users, each user has a password …