Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 8 Years, 9 Months, 2 Weeks ago Change admin "Joined" date.
#1
Solved: 8 Years, 9 Months, 2 Weeks ago Smile 
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.

Angel
#2
Solved: 8 Years, 9 Months, 2 Weeks ago
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 )
[Image: information.gif] MyBB Support Technician
Please do not PM me for support.


MyBBatically - A quick and easy way to update your board!
#3
Solved: 8 Years, 9 Months, 2 Weeks ago
Thank you Vernier.

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

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! Toungue
#4
Solved: 8 Years, 9 Months, 2 Weeks ago
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
[Image: modmybb-banner-0.png]
If you think I've helped you; a + rep would be appreciated.
#5
Solved: 8 Years, 9 Months, 2 Weeks ago
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.

Big Grin
#6
Solved: 8 Years, 9 Months, 2 Weeks ago
No problem, I'm glad it works Wink.
[Image: modmybb-banner-0.png]
If you think I've helped you; a + rep would be appreciated.


Forum Jump:


Users browsing this thread: 1 Guest(s)