Date is set to 1970??

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
Marcus
Registered User
Posts: 3
Joined: Tue Jan 29, 2002 10:49 am
Location: Germany, Hannover
Contact:

Date is set to 1970??

Post by Marcus »

Hi

How can I set the Date, when the Boad startet? Somehow it is set to 1970.


Thx
Marcus
User avatar
yr
Registered User
Posts: 18
Joined: Tue Feb 12, 2002 11:28 am

Re: Date is set to 1970??

Post by yr »

Marcus wrote: Hi
How can I set the Date, when the Boad startet? Somehow it is set to 1970.

You can set the date by modifying your board database, in table `config' and you can find the config_name: board_startdate then change its config_value.
rhBoi
Registered User
Posts: 66
Joined: Sun Apr 07, 2002 12:28 am
Location: Germany
Contact:

Post by rhBoi »

I have the same problem but the config_name you wrote doesn-t exist in my table!
Are you sure this entry must exist?
Can this be the source of my 1970 problem?
Bear
Registered User
Posts: 2586
Joined: Mon Dec 31, 2001 7:50 pm
Location: 127.0.0.1
Contact:

Post by Bear »

Check the config table - you should have 59 entries.
Bear
Got a thing for fashion? So do we at the Fashion Spot.
Let us give you the Royal Treatment at Les Tribunes Royales.
rhBoi
Registered User
Posts: 66
Joined: Sun Apr 07, 2002 12:28 am
Location: Germany
Contact:

Post by rhBoi »

Ok I have this entry!
Please give me a straight answer what can I do with the 1970 problem.
I have no back up of the database.
Is there any chance?
Bear
Registered User
Posts: 2586
Joined: Mon Dec 31, 2001 7:50 pm
Location: 127.0.0.1
Contact:

Post by Bear »

This has been discussed before.

The problem appears to be associated with running upgrade.php when it's not needed. Make sure upgrade.php, install.php, and update_to_FINAL.php are removed from your server.

If you do not have a backup, you have two choices - 1) do a clean install, or 2) manually edit the database.

For the database option:

Open phpMyAdmin and click on the database name in the left frame. Now in the right frame you should have a large box labeled Run SQL query/queries on database dbname. Insert the script there and press Go.

Code: Select all

UPDATE phpbb_posts SET post_time = 1018224000 WHERE post_time = 0
This works if phpbb_ is your prefix, otherwise change it. I inserted today's date (as an Unix timestamp). I would recommend changing it to some other day, perhaps the board startdate. Use this calculator to give you the timestamp. Just put the date in the right side and press the arrow button.

Let me if that works.
Bear
Got a thing for fashion? So do we at the Fashion Spot.
Let us give you the Royal Treatment at Les Tribunes Royales.
rhBoi
Registered User
Posts: 66
Joined: Sun Apr 07, 2002 12:28 am
Location: Germany
Contact:

Post by rhBoi »

Ok thanks bear thats a bit better though it is a bit bitter :cry:
Perhaps I will date-fake one topic a day....
But I have 1678 posts... :roll:
Bear
Registered User
Posts: 2586
Joined: Mon Dec 31, 2001 7:50 pm
Location: 127.0.0.1
Contact:

Post by Bear »

Looks like to confusing two posts here. Were your posts with the wrong date or just the board start date?
Bear
Got a thing for fashion? So do we at the Fashion Spot.
Let us give you the Royal Treatment at Les Tribunes Royales.
rhBoi
Registered User
Posts: 66
Joined: Sun Apr 07, 2002 12:28 am
Location: Germany
Contact:

Post by rhBoi »

All the posts were from 1970.
Now they are all from the start-day of my forum :)
Der Robe
Registered User
Posts: 54
Joined: Fri Apr 05, 2002 10:10 pm
Contact:

Post by Der Robe »

Sorry to bring this post back up but I followed verbatem what you saiud and my board open date did not change
WANTED:
Artists and debaters

The Pit
Locked

Return to “2.0.x Support Forum”