[Cloud-Warrior]

Originally Posted by Oblivion Knight

It should exist, as you're adding the top line of that code as an earlier edit..

I realise that these edits aren't in the correct order, but I was documenting them as I edited the necessary code.


Thanks, that edit was removed from the RC2 private beta for this release as it wasn't necessary.

Nice one - my mistake - I was looking for order

I'm having problems with step seven of the script, due to the huge tables I have... I've had to change the first two SELECT queries to:

SELECT u.username, u.ipaddress, j.journal_id FROM user as u left join journals as j on u.userid=j.journalist_id WHERE j.journal_id<>"";

SELECT u.username, u.ipaddress, c.comment_id FROM user as u left join journal_comments AS c ON u.userid = c.commenter_id WHERE c.comment_id <> "";

Otherwise they run for way too long and the script times out.