[TYPO3-core] RFC: Bug #4951: SQL error when editing BE User

[Michael Stucki]

This is a SVN patch request.

Problem:

Quoting from Bugtracker entry:
| Editing a BE User throws a SQL Error on top of the page..
| Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result
| resource in
| /srv/www/vhosts/<domain-removed>/httpdocs/typo3_src-4.1RC1/t3lib/class.t3lib_db.php
| on line 796
| 
| The BE User edit page is shown and its possible to change and save the
| settings for this user.

Solution:
The reason seems that "-1" is appended to every pid in select queries, though 
only versioned tables are signed and therefore allow such values.

Comments:
Seems to happen only with some MySQL versions, other versions simply ignore 
the problem.

Branches: Trunk only

Bugtracker reference:
http://bugs.typo3.org/view.php?id=4951

- michael
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bug_4951.diff
Type: text/x-diff
Size: 987 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20070216/958de782/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20070216/958de782/attachment.pgp