PHPBB forum gives 01-01-1970 as startdate, and certain values are counted from that date too

Hi all

As the question indicates i have troubles with the startdate, i have already gone to the mysql database and pasted in the unix code for 3 september 2004, but it still wont display it, and the values of posts per day are for instance now 0,001 while i have 1867 posts in 12 days already, anyone know a workaround? I have been to the phpbb forum, that is where i got the solution to paste in the unix formatter code but that did also not help. This is my last resort, if no one can help me out here i will have to get used to that, my registration date is also unchangeable and displays 01-01-1970 too :(

Fdehell
LVL 1
fdehellAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
_GeG_Connect With a Mentor Commented:
I don't know phpbb, but 01-01-70 is the beginning of timestamp. So your startdate is probably of type timestamp and is set to 0. Try to set it to 20040903 in the mysql database.
0
 
AlanJDMCommented:
Is any data at all showing? It sounds like all of the php vars aren't recieving any values from the database.


Alan
0
 
fdehellAuthor Commented:
Yes like i said i have tried to set it and change it but it does not matter, and yes valiues are shown but derived from that date as well

Fdehell
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
_GeG_Commented:
how did you try to change it?
0
 
AlanJDMConnect With a Mentor Commented:
If you are sure that the database connection is bing made, then I would reinstall PHPBB. Definitely sounds like something got corrupt. 01-01-1970 is exactly what any PHP date/time function would return if it was passed a NULL or "blank" parameter, which is why I questioned weather or not you where seeing any data at all being returned.

I use PHPBB on several of our sites and I have never seen nor heard of anything like this so I think You should do a fresh install to be sure none of the files are corrupt.


Alan
0
 
fdehellAuthor Commented:
Geg, i went to the database with phpmyadmin and pasted the code in which was the date formatted in unix style, should i have done that different or?


Fdehell
0
 
_GeG_Commented:
phpmyadmin is good ;)

if you know in which field you want to enter the data, just edit the row, and paste 20040903 in it. Probably phpmyadmin gives you a choice on the left side, something like now. Don't choose that. Now just press go. When you browse the table, the value should have changed.

If it doesn't work, tell me exactely what you pasted where.
0
 
fdehellAuthor Commented:
Hi geg thx for still hanging on!

Isnt it strange that the config value which is record_online_date is a varchar, shouldnt that be something like the function unix_timestamp or from_unixtime, do you know this?

config_name varchar(255)     record_online_date      
config_value varchar(255)       1094677432 ---> this alue was pasted in by me it is the date of 3 september converted to unix style

This are the current values, and i thought maybe the config_value should be a function ?

Fdehell
0
 
_GeG_Commented:
shouldn't you change the date in the Admin section? What happens if you set it there?
0
 
fdehellAuthor Commented:
It does not give me the option to do so in the admin section, though after executing the previously described, the board starts date changed into 20 august this year, then it jumped back to the 01 01 1970 again. Maybe i should give it up no?

Fdehell
0
 
_GeG_Commented:
:( this seems to be a phpbb specific problem, so better post at their support forum.
Sorry that I couldn't help, maabe it just something simple, like that you have a switch to "go live" and the board counts from that moment, or whatever....
0
 
AlanJDMCommented:
I have seen people save dates as strings like that before. If you know that the format of the displayed date will always be stored the same way it is going to be used upon querying it later, then it is more efficient to not have to do the timestamp converting later on. I personally don't agree with the practice, but I have seen it done.

I am going to say again, you need to reinstall PHPBB. Even if you are able to make whatever changes you need to make to get it working, there is obviously something else wrong. PHPBB is a very stable, widely used product. There certainly should be no need to edit any code and/or database structures to get it to work.


Alan
0
 
fdehellAuthor Commented:
Ok well thank you both for your help, efforts will be rewarded regardless of the fact that i didnt get the date set the right way, i will divide the points , i have been at the phpbb forum by the way but they could not help me either so this was my last resort nevertheless a big thx for trying Geg and  Alan, you surely belong to the die hards which i think is great and which i have deepest respect for!

Cheers to the both of you

Fdehell
0
 
fdehellAuthor Commented:
I have given the excellent value, because i find it excellent that you two did not give up where a whole forum had already given up [phpBB]

Fdehell
0
 
AlanJDMCommented:
Sorry we couldn't have come to a proper resolution for you. I do hope you will have a go at re-installing PHPBB as I do think it will help. Anyway, let us know if you come across any new info that could help resolve this.


Alan
0
 
_GeG_Commented:
[quote]a big thx for trying Geg and  Alan, you surely belong to the die hards which i think is great and which i have deepest respect for![/quote]
English is not my native language, so I cannot formulate a fitting answer to this, but let's try:
You must be one of the last persons on earth who thanks people for not solving a problem. Thank you to fdehell for keeping up old values ;)
0
 
AlanJDMCommented:
"Thank you to fdehell for keeping up old values"

Yes, I second that! People like fdehell are who I come to these forums and hope to help in some way. We could use a few more like him around here.



Alan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.