MyBB Community Forums

why my forum say i join 01-01-1970, 01:33 AM

you can use SQL query like below to fix it

UPDATE `mybb_users` SET regdate = UNIX_TIMESTAMP('2017-04-16 00:00:00') WHERE `uid` = '1'

see also common sql queries guidance

i need help to do it

^ well, required help is available through this => common sql queries guidance

i need someome to do it

create a file with name regdate.php at your MyBB files server where you have global.php file & index.php file
add below content into regdate.php file & save it

<?php
define('IN_MYBB', 1);
require_once "global.php";

$db->write_query("UPDATE " . TABLE_PREFIX . "users SET `regdate` = UNIX_TIMESTAMP('2017-04-16 00:00:00') WHERE `uid` = '1'; ");
		echo ("Done.");

visit your forumURL/regdate.php address with your browser so that it executes
after you get Done message, check your registration date on your forum
finally delete that regdate.php file

i car't do it

^ would you like to PM me temporary access to files (FTP account)
you can provide your own login details & change them later

ok

thank

^ your registration date on your forum should be changed now.