Error
SQL query:
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 & lt;
MySQL said: Documentation
#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 '' at line 1
UPDATE phpbb_users SET (user_firstpost) = SELECT MIN(post_time) FROM phpbb_posts WHERE phpbb_posts.poster_id = phpbb_users.user_id
+++ Error: 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 '(user_firstpost) = SELECT MIN(post_time) FROM phpbb_posts WHERE
Could not query users
DEBUG MODE
SQL Error : 1054 Unknown column 'user_firstpost' in 'field list'
SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_firstpost, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar FROM phpbb_users WHERE user_id <> -1 ORDER BY user_regdate ASC LIMIT 0, 50
Line : 151
File : memberlist.php
Code: Select all
Unable to update user_firstpost
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 'AS u, phpbb_posts AS p1 INNER JOIN phpbb_posts AS p2 ON p2.post_id = 1' at line 1
UPDATE phpbb_users AS u, phpbb_posts AS p1 INNER JOIN phpbb_posts AS p2 ON p2.post_id = 113306 SET u.user_firstpost = 0 WHERE u.user_id = p2.poster_id AND u.user_firstpost = p2.post_time;
Line : 508
File : functions_post.php
Code: Select all
message_die(GENERAL_ERROR, 'Unable to update user_firstpost', '', __LINE__, __FILE__, $sql);
cutaia wrote: Hey...it's me again from the first half of this thread.
I reinstalled a forum recently and used this mod again, but this time it did something crazy weird.
http://forum.cutaia.net/memberlist.php
This is my memberlist. Those first three people actually used to be at the very end of the list. But suddenly when I re-added this mod. They've jumped before even me!
And they apparently joined in 1969. 8O
So...the question is...how did the mod do this, and how can I fix it?
(I've tested and new signups work like they should...going to the end of the list. So, maybe it's as simple as editing the database information for just those 3 people. But I don't know how. )
Any help would be great.
Code: Select all
#
#-----[ OPEN ]------------------------------------------
#
memberlist.php
#
#-----[ FIND ]------------------------------------------
#
case 'joined':
$order_by = "user_regdate $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
#
#-----[ REPLACE WITH ]----------------------------------
#
case 'joined':
$order_by = ($board_config['zero_list'] ? "user_firstpost" : "user_regdate") . " $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
#
#-----[ FIND ]------------------------------------------
#
default:
$order_by = "user_regdate $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
#
#-----[ REPLACE WITH ]----------------------------------
#
default:
$order_by = ($board_config['zero_list'] ? "user_firstpost" : "user_regdate") . " $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
#
#-----[ FIND ]------------------------------------------
#
$joined = create_date($lang['DATE_FORMAT'], $row['user_regdate'], $board_config['board_timezone']);
#
#-----[ IN-LINE FIND ]---------------------------------
#
$lang['DATE_FORMAT'],
#
#-----[ IN-LINE AFTER, ADD ]---------------------------
#
$board_config['zero_list'] ? $row['user_firstpost'] :