Join Date problem

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
Gibby540
Registered User
Posts: 5
Joined: Sat Feb 04, 2006 10:21 am

Join Date problem

Post by Gibby540 »

How do I change the "join date"? It says I joined on Jan 1, 1970. I wasn't even born yet. thanks.
Wo1f
Registered User
Posts: 2039
Joined: Fri Jan 28, 2005 3:20 am

Post by Wo1f »

Hi Gibby540,

The following article discusses this issue and offers a few solutions, located here:
  • How to change a user join date
[/url]

Hope this helps,
Wolf
Gibby540
Registered User
Posts: 5
Joined: Sat Feb 04, 2006 10:21 am

Post by Gibby540 »

I tried everything and went to every link provided with no luck. I would follow the suggested steps and then I would run into a roadblock when I couldn't find something that was described in a particular step. Some of the links had conflicting information on how to fix the problem. I guess I will have to stumble through it until I figure it out and hopefully not screw something up royally.

The information you gave me was great; I'm just not bright enough to figure it out yet I guess. I am quite the rookie so I am teaching myself how to navigate around the database.

Thanks.
Gibby
P.S. If you could draw me a picture, I might figure it out.
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10392
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Post by Noxwizard »

Go to: http://www.4webhelp.net/us/timestamp.php
Fill in your correct registration date in the second section.
Click "Convert to a TimeStamp"
A gray box appears above it.
Take the long number it generates, and copy it.
Go into your database. (phpMyAdmin)
Find the phpbb_users table.
Click the Browse tab.
Find your username.
Click Edit/Change
Find your registration field and paste in the new number.
Click Save.

It should be similar to that. I'm just doing that from memory.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
Gibby540
Registered User
Posts: 5
Joined: Sat Feb 04, 2006 10:21 am

Post by Gibby540 »

Thanks, that's the best information I have received so far. Now I can't get it to save. I click "save" after I change it and it goes back to the setting it was before I saved it. Ugh!
Gibby540
Registered User
Posts: 5
Joined: Sat Feb 04, 2006 10:21 am

Post by Gibby540 »

Here's something else I have noticed:

In the user regdate field on the database, the date shows today's date. I can't get it to change. Whenever I change it and save it, it goes back to the current date. This date (current date) does not reflect on my profile either; it still says Jan 1 of 1970. Man, this is frustrating.
Gibby540
Registered User
Posts: 5
Joined: Sat Feb 04, 2006 10:21 am

Got it!

Post by Gibby540 »

OK, I finally figured it out. I'm very slow but I learned that in the regdate row, I had to leave the "function" drop down window BLANK in order for the unix time stamp to save and reflect on my profile. Ok, now I'm ready for my next big roadblock. Thanks everyone for your help.
tdschild
Registered User
Posts: 1
Joined: Fri Feb 17, 2006 11:40 am
Contact:

Post by tdschild »

Thank you Noxwizard for a simple straightforward solution!

Tim.
Rat Fink
Registered User
Posts: 15
Joined: Tue Feb 28, 2006 12:06 am

Post by Rat Fink »

Thanks for this - I'm new to the admin side of phpbb, and I'm often reluctant to ask a seemingly "silly" question. Well done - it worked perfectly for me.
Locked

Return to “2.0.x Support Forum”