Paste memberlist.php line# 1474 please.
(2010-11-30, 05:51 AM)Yaldaram Wrote: [ -> ]Paste memberlist.php line# 1474 please.
What Do You Want me To Do Again?
Open memberlist.php file and find line#1474 and paste that here.
Please try running these queries via phpMyAdmin:
UPDATE `mybb_users` SET `birthday` = '' WHERE `birthday` = '-';
AND
UPDATE `mybb_users` SET `birthday` = '' WHERE `birthday` LIKE '--%';
I just did a search of the forums, and found this, which had fixed this exact issue 3 times. Next time, search before you post. You never know, someone may have had this issue before you!
i did it and i still get that error
Do you know how many rows it said it affected?? There's nothing else known to cause this error.
Warning [2] mktime() expects parameter 4 to be long, string given - Line: 1474 - File: member.php PHP 5.2.14 (Linux)
That's not what I asked, do you know how many rows the query affected??
Run this query:
SELECT `username` FROM `mybb_users` WHERE `birthday` LIKE '-%';
How many usernames does it list when you run that??