Can't delete user or reset user password

rsilletti · 2008-10-05 03:37:43

I’m trying to delete a user from a site running in development files from this commit: Textpattern version: 4.0.6 (r2957)
Last Update: 2008-08-13 02:37:16/2008-08-13 02:27:40

These files have been altered somewhat in general, but nothing that should affect users directly. Is anyone else having this problem?

Adding new users isn’t a problem, only the options accomplished with the multiedit.

Last edited by rsilletti (2008-10-05 03:38:08)

ruud · 2008-10-05 11:37:45

Works for me. Do you have any plugins installed that could affect the admin tab?

rsilletti · 2008-10-05 13:59:46

It still won’t delete a user with all plugins installed turned off. I’m using a taghandlers file with some additions that may be suspect, I’ll see if moving those back into a plugin and reloading a clean install will solve the problem – thanks.

rsilletti · 2008-10-05 17:00:18

Still won’t delete a user. The only thing left that I can see is a DNS problem that doesn’t make sense to me, given that the site is findable and clean urls are working fine.

Textpattern version: 4.0.6 (r2981)
Last Update: 2008-10-05 16:28:54/2008-10-05 15:05:34
Document root: /users/home/parkling/domains/parkling.net/web/public
$path_to_site: /users/home/parkling/domains/parkling.net/web/public
Textpattern path: /users/home/parkling/domains/parkling.net/web/public/textpattern
Permanent link mode: section_id_title
upload_tmp_dir: /usr/local/www/php/tmp
Temporary directory path: /var/tmp
Site URL: parkling.net
PHP version: 5.1.4
GD Image Library: bundled (2.0.28 compatible); supported formats: GIF, JPG, PNG.
Server Local Time: 2008-10-05 16:53:42
MySQL: 4.1.22-log
Locale: en_GB.UTF-8
Server: Apache
Apache version: Apache
PHP Server API: apache2handler
RFC 2616 headers:
Server OS: FreeBSD 6.2-STABLE
Active plugins: wet_slimpattern-0.1, mod_authors_list-4.0.7.devm, mdp_calendar-1.1, ras_plugin_credits-4.0.6.1, zem_contact_lang-4.0.3.6, zem_contact_reborn-4.0.3.20, ras_page_of-0.03m, rvm_css-0.3

Pre-flight check:
————————————
Web Domain DNS lookup fails: parkling.net
Some Textpattern files have been modified: /include/txp_preview.php
You are running in-development files on a live server: /include/txp_category.php, …

Clean URL test failed.
————————————

.htaccess file contents:
————————————
#DirectoryIndex index.php index.html

#Options +FollowSymLinks
#Options -Indexes

<IfModule mod_rewrite.c> RewriteEngine On #RewriteBase /relative/web/path/

RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]

RewriteRule ^(.*) index.php

RewriteCond %{HTTP:Authorization} !^$ RewriteRule .* – [E=REMOTE_USER:%{HTTP:Authorization}]
</IfModule>

#php_value register_globals 0

————————————

ruud · 2008-10-05 17:50:58

Is it just deleting a user that fails or any action that uses the multi-edit functionality?
What is the (login) name of the user you’re trying to delete?

If you set DEBUG to 1 in constants.php and then try to delete a user, which SQL queries are shown?

rsilletti · 2008-10-05 18:22:15

None of the multiedit was working. In any case, I pulled the domain down and I’m going to start over, given I trashed some stuff without backups :( Thanks anyway.

Last edited by rsilletti (2008-10-05 18:22:49)

rsilletti · 2008-10-05 19:04:18

Ok – new domain and a fresh install with nothing added as yet and the problem persists. The parkling.net domain has been insane for some time and is probably happier now. (The user name I’m using is “web”, but I have tried several)

Textpattern version: 4.0.6 (r2981)
Last Update: 2008-10-05 18:50:49/2008-10-05 18:44:19
Document root: /users/home/parkling/web/public
$path_to_site: /users/home/parkling/web/public
Textpattern path: /users/home/parkling/web/public/textpattern
Permanent link mode: section_id_title
upload_tmp_dir: /usr/local/www/php/tmp
Temporary directory path: /users/home/parkling/web/public/textpattern/tmp
Site URL: parkling.us
PHP version: 5.1.4
GD Image Library: bundled (2.0.28 compatible); supported formats: GIF, JPG, PNG.
Server Local Time: 2008-10-05 18:59:20
MySQL: 4.1.22-log
Locale: en_GB.UTF-8
Server: Apache
PHP Server API: cgi-fcgi
RFC 2616 headers:
Server OS: FreeBSD 6.2-STABLE

Pre-flight check:
————————————
Some Textpattern files have been modified: /include/txp_preview.php
You are running in-development files on a live server: /include/txp_category.php, …
————————————

.htaccess file contents:
————————————
#DirectoryIndex index.php index.html

#Options +FollowSymLinks
#Options -Indexes

<IfModule mod_rewrite.c> RewriteEngine On #RewriteBase /relative/web/path/

RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]

RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteRule ^(.*) index.php

RewriteCond %{HTTP:Authorization} !^$ RewriteRule .* – [E=REMOTE_USER:%{HTTP:Authorization}]
</IfModule>

#php_value register_globals 0

————————————

I’ll see what DEBUG tells me.

Displayed queries look like this for all three multiedit options.

describe `textpattern`

select val from txp_prefs where name = ‘version’

select name, val from txp_prefs where prefs_id=1

select name, data from txp_lang where lang=‘en-gb’

select nonce from txp_users where name=‘Rick’ AND last_access > DATE_SUB(NOW, INTERVAL 30 DAY)

select name, code, version from txp_plugin where status = 1 AND type IN (1,3) order by load_order

select privs from txp_users where name=‘Rick’

select name from txp_users where name IN (‘web’) AND NOT name = ‘Rick’

select privs from txp_users where name = ‘Rick’

select email from txp_users where `name` = ‘Rick’ limit 1

select count(*) from txp_users where 1=1

select *, unix_timestamp(last_access) as last_login from txp_users where 1 = 1 order by name asc limit 0, 25

Last edited by rsilletti (2008-10-05 20:21:56)

ruud · 2008-10-05 20:48:25

When you try to delete a user, there should be at least one more SQL query visible. Perhaps further down below.

rsilletti · 2008-10-05 21:31:31

No delete query, and it clears the check mark and the selected option on each attempt.

I’ll send a signon if that would help.

Last edited by rsilletti (2008-10-05 21:59:33)

ruud · 2008-10-05 22:12:08

If you execute this SQL query (in PHPmyAdmin for example), what result does it give?

select name from txp_users where name IN ('web') AND NOT name = 'Rick'

rsilletti · 2008-10-05 22:27:08

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)

That’s odd, both ‘web’ and ‘Rick’ are properly in the database as users.

select name from txp_users where 1 returns both names from the name column.

Last edited by rsilletti (2008-10-05 22:57:15)

ruud · 2008-10-06 14:12:27

It should only return ‘web’. The fact that it returns an empty result set is what causes this problem.

Does it return ‘web’ as a result if you do:

select name from txp_users where name IN ('web')

or

select name from txp_users where name = 'web'

Textpattern CMS

Textpattern CMS support forum

#1 2008-10-05 03:37:43

Can't delete user or reset user password

#2 2008-10-05 11:37:45

Re: Can't delete user or reset user password

#3 2008-10-05 13:59:46

Re: Can't delete user or reset user password

#4 2008-10-05 17:00:18

Re: Can't delete user or reset user password

#5 2008-10-05 17:50:58

Re: Can't delete user or reset user password

#6 2008-10-05 18:22:15

Re: Can't delete user or reset user password

#7 2008-10-05 19:04:18

Re: Can't delete user or reset user password

#8 2008-10-05 20:48:25

Re: Can't delete user or reset user password

#9 2008-10-05 21:31:31

Re: Can't delete user or reset user password

#10 2008-10-05 22:12:08

Re: Can't delete user or reset user password

#11 2008-10-05 22:27:08

Re: Can't delete user or reset user password

#12 2008-10-06 14:12:27

Re: Can't delete user or reset user password

Board footer