MyBB Community Forums

Hi,

The admin joined date is,
"Joined: Thursday 01 January 1970",
but it should be Friday 20 July 2012.

Is there a simple way to correct the joined date?

For example, without having to edit the database, as that is too difficult for me.

Thanks.

You have to run a query.

Login to your cPanel
( http://i.imm.io/xKsU.png )

Click Phpmyadmin (unless you use a different database manager)
( http://i.imm.io/xKqR.png )

Click your database (on the right hand side)
( http://i.imm.io/xKrp.png )

Click the SQL tab
( http://i.imm.io/xKrJ.png )

Copy and paste the following into the box:

UPDATE `mybb_users` SET `regdate`='1342742400' WHERE `uid`='X'

Replace X with the admins UID that you want to change the regdate of.
( http://i.imm.io/xKsf.png )

Click Go
( http://i.imm.io/xKsn.png )

Thank you Vernier.

---

Hi ... I braved an attempt, but didn't fair too well.

Update:

I backed up myBB.

I identified my UID by looking at my user profile, hovering over my username and seeing the url, ending with the UID.

I then adjusted the time and my time zone using:
http://www.convert-unix-time.com
http://www.unixtimestamp.org

I followed the rest of the instructions.

UPDATE mybb_users SET regdate='1342767300' WHERE uid='1'

I got the following error message:

#1146 - Table 'TEXT_mbb4.mybb_users' doesn't exist

* TEXT replaces the actual word.

At this stage the wheels feel off my attempt!

That's right, you can find your UID like that.

You're using PHPMyAdmin right? If so, on the left you should have a list with all the existing database tables. Can you find "mybb_users" between the list?

If not: I presume you have maybe used another prefix. Do all the tables on the left begin with "mybb_"? If not, change the "mybb_" in your update query with what it actually starts.
Also make sure you clicked the correct database (mybb database).

If that's not it, maybe you can post a screenshot of the error happening (so we can see the tables and database name).

Hope this helps.

Kevin

A ha !!!!!!!!!!!!!!!!!!!!!

Fantastic help there KevinVR!

I found my username at the database as per:

1. cPanelX
2. phpMyAdmin
3. _mbb4 (yeah myBB is pretty popular on my domains - all non commercial, eg opensource content, community/advocacy sites)
4. scrolled down, to mbb_users
5. found my username and the "regdate" which had "2012"
6. clicked "Edit"
7. replaced the "regdate" "2012" with my one from the calculates in my above post "1342767300"
8. crossed my fingers it wouldn't blow up
9. clicked "Go" to save and checked my forum ... correct date and time down to the minute ... email confirmation of myBB install gave me a good time to use.
10. gave KevinVR first "Reputation" point.

No problem, I'm glad it works .