[Leica.Robbiani]

Hi thincom2000,

I have noticed another database error:

Invalid SQL:

SELECT revision.*, user.username, user.usergroupid, user.membergroupids,
MAX(previous.revisionid) AS prev_revisionid, MIN(next_rev.revisionid) AS next_revisionid,
roll_rev.ipaddress AS targetipaddress, rolluser.username AS targetusername,
previous.userid AS rolluserid, prev_user.username AS rollusername,
previous.ipaddress AS rollipaddress, previous.unzip AS prev_unzip

FROM vb382_vault_revision AS revision
LEFT JOIN vb382_vault_revision AS next_rev ON (next_rev.lastrevisionid = revision.revisionid AND next_rev.pending = 0)
LEFT JOIN vb382_vault_revision AS previous ON (revision.lastrevisionid = previous.revisionid)
LEFT JOIN vb382_user AS user ON (user.userid = revision.userid)
LEFT JOIN vb382_vault_revision AS roll_rev ON (roll_rev.revisionid = revision.rollback)
LEFT JOIN vb382_user AS rolluser ON (rolluser.userid = roll_rev.userid)
LEFT JOIN vb382_user AS prev_user ON (prev_user.userid = previous.userid)

WHERE revision.threadid = 316
GROUP BY revision.revisionid
ORDER BY dateline DESC
LIMIT 0,1;

MySQL-Fehler : Unknown column 'next_rev.pending' in 'on clause'
Fehler-Nr. : 1054
Fehler-Zeit : Saturday, 05.06.2010 @ 21:43:49
Datum : Saturday, 05.06.2010 @ 21:43:49
Skript : XXXXXXXXXXXXX/showwiki.php?title=Absage&do=history
Referrer : XXXXXXXXXXXXg/showwiki.php?title=Absage
IP-Adresse : XXXXXXXXXXXXX
Benutzername : XXXXXXXXXXXX
Klassenname : vB_Database_MySQLi

This error happens not to all usergroups.

Now, when I try to go into it or anyone else tries to read it, it just keeps loading and basically freezes. You have to click another part of the site in order to get out.

The same for me when using some char-combinations. One of the problems is, when the title has a slash or a hyphen with whitespaces.

Hopefully you can check these few things, thanks.

Best regards

L.R.