Well, when I run this:
SELECT * FROM users,users_comments,users_hits,users_index,users_info,users_prefs WHERE (users.uid='2' AND users_comments.uid='2' AND users_index.uid='2' AND users_info.uid='2' AND users_prefs.uid='2' AND users_hits.uid='2')
I get nothing. Hmmm.........
Jamie McCarthy wrote:
>OK, what I would do is this. Turn on MySQL logging if it isn't
>already. This will hurt performance on a production website
>but we're just debugging here. Add this to your my.cnf file:
>
> log = /var/log/mysql/mysql.log
>
>and restart mysqld. Then re-run the Slash::Test command above and
>check mysql.log to make sure it has lines that look vaguely like
>this:
>
> 196966 Query SELECT * FROM users,users_comments,users_hits,users_index,users_info,users_prefs WHERE (users.uid='2' AND users_comments.uid='2' AND users_index.uid='2' AND users_info.uid='2' AND users_prefs.uid='2' AND users_hits.uid='2')
> 196966 Query SELECT name, value FROM users_param WHERE uid = '2'
> 196966 Query SELECT acl FROM users_acl WHERE uid = '2'
>
>If that looks right, you have to start trying to find where that
>data comes from that breaks thaw(). Open up MySQL.pm and start
>editing _getUser_do_selects(). Right before the "if
>($answer->{people})" line, insert a
>
> print Dumper($answer);
>
>so you can see the raw data... then re-run the Slash::Test and
>see what that outputs.
>
>
|