Hi,
I am having problems much like others here. I got an error that read:
Code: Select all
SQL PROCESSING HALTED
An error was encountered while processing the SQL commands. Further SQL processing has been halted. You may choose to complete the MOD installation anyway and perform the SQL commands manually yourself. However, at this point EM cannot guarantee the MOD will work correctly so you are best off seeking support from the Author before continuing further.
The failed line was:
UPDATE phpbb_users AS u,phpbb_posts AS p1 LEFT OUTER JOIN phpbb_posts AS p2 ON p1.poster_id = p2.poster_id AND p2.post_time < p1.post_time INNER JOIN phpbb_posts AS p3 ON p3.post_time = p1.post_time SET u.user_firstpost=p3.post_time WHERE p2.post_time IS NULL AND p1.poster_id = u.user_id;;
SQL ERROR: 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; p1.post_time INNER JOIN phpbb_posts AS p3 ON p3.post_time = p
So, I went into the functions_post and deleted what was recommended in earlier posts.
The MySQL version I'm running is 5.0.37.
I know nothing about SQL, and am having problems figuring out what I'm missing, as it doesn't seem to be working. Also, since installing Admin Userlist, I got an SQL error with that as well. Since I installed that one right before this one, I have no idea if that error is part of Admin Userlist, or because of SQL problems when installing this one. The error I got there was a:
Code: Select all
Could not delete auto-login keys for this user
DEBUG MODE
SQL Error : 1146 Table 'forum.SESSIONS_KEYS_TABLE' doesn't exist
DELETE FROM SESSIONS_KEYS_TABLE WHERE user_id = 264
Line : 355
File : admin_userlist.php
I've been trying to figure this out for hours now with no luck. Please let me know if there is any other information I can provide. I want to get this working, because as of right now I can't even delete the users through the userlist, so I'd like to at least get them hidden.
It might be that I just need help making the SQL changes manually. I know how to get into phpmyadmin, but what to do once there...well...I'm pretty lost. However, I was able to do the first one, (the add user_firstpost thingy). It's just everything after that that seems like a foreign language.