|
Could not query users
DEBUG MODE
SQL Error : 1525 Incorrect DATE value: '0000-00-00'
SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar,user_avatar2, user_avatar_type, user_allowavatar
,user_town_other,user_town_part_other
,town.name as town_name,town_part.name as town_part_name
,user_velobrand_other,user_velomodel_other
,velobrand.name as velobrand_name,velomodel.name as velomodel_name
,user_velomodel_color,user_velomodel_year, user_birthday, month(user_birthday) as birthady_month, dayofmonth(user_birthday) as birthday_day
,user_hide_my_photo,user_hide_my_profile
FROM phpbb_users
LEFT OUTER JOIN town on town.id=user_town
LEFT OUTER JOIN town_part on town_part.id=user_town_part
LEFT OUTER JOIN velobrand on velobrand.id=user_velobrand
LEFT OUTER JOIN velomodel on velomodel.id=user_velomodel
WHERE user_id <> -1 and user_birthday is not null and user_birthday<>'0000-00-00'
ORDER BY month(user_birthday),dayofmonth(user_birthday) LIMIT 0, 50 Line : 185 File : memberlist.php |
|
|