Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#13 2008-10-06 18:15:23
- rsilletti
- Moderator
- From: Spokane WA
- Registered: 2004-04-28
- Posts: 707
Re: Can't delete user or reset user password
Both queries return an empty set for any present user.
select name from txp_users where name IN ('web')or
select name from txp_users where name = 'web'I’ve swapped in a variety of user names and they all behave the same.
Offline
Re: Can't delete user or reset user password
Weird…
If you could mail me a login for that Textpattern install and allow me to install the rss_db_manager plugin so I can run a set of SQL queries to try and find why they’re not returning results, that might speed up things a little.
Offline
#15 2008-10-06 23:26:04
- rsilletti
- Moderator
- From: Spokane WA
- Registered: 2004-04-28
- Posts: 707
Re: Can't delete user or reset user password
I’ve already set up the plugin and I’ll email a sign on to your forum email. This is installed on one of two textdrive accounts that use the same mysql setup, queries work on one and not on the other?
Offline
Re: Can't delete user or reset user password
Thanks Rick!
Should be fixed in SVN changeset 2984
Problem was caused by a change in NOT operator precedence in MySQL 5.0.2.
I’m testing with a 5.x version of MySQL, so that’s why I couldn’t reproduce it. The new NOT operator precedence does make more sense than the older one, but since the difference between the old and new precedence order is so big, you can’t really rely on it anymore, unless you’re writing SQL for a MySQL installation where the precedence order is a known constant, so in TXP we have to avoid using it.
Offline
#17 2008-10-08 03:01:33
- rsilletti
- Moderator
- From: Spokane WA
- Registered: 2004-04-28
- Posts: 707
Re: Can't delete user or reset user password
My pleasure, I appreciate the timely solution.
Offline