Date is set to 1970??

Marcus · Post by **Marcus** » Fri Mar 08, 2002 7:31 am

Hi

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

Thx
Marcus

yr · Post by yr » Fri Mar 08, 2002 7:45 am

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 · Post by **rhBoi** » Sun Apr 07, 2002 12:30 am

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 · Post by **Bear** » Sun Apr 07, 2002 9:40 am

Check the config table - you should have 59 entries.

rhBoi · Post by **rhBoi** » Sun Apr 07, 2002 10:35 am

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 · Post by **Bear** » Sun Apr 07, 2002 11:04 am

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.

rhBoi · Post by **rhBoi** » Sun Apr 07, 2002 11:36 am

Ok thanks bear thats a bit better though it is a bit bitter

Perhaps I will date-fake one topic a day....
But I have 1678 posts...

Bear · Post by **Bear** » Sun Apr 07, 2002 11:40 am

Looks like to confusing two posts here. Were your posts with the wrong date or just the board start date?

rhBoi · Post by **rhBoi** » Sun Apr 07, 2002 3:32 pm

All the posts were from 1970.
Now they are all from the start-day of my forum

Der Robe · Post by **Der Robe** » Fri Jul 05, 2002 1:13 am

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

advertisements