To the best of my knowledge, in vb5, the only way to modify the date/time of a post is direct database manipulation in the node table, either the created column or the publishdate column (I don't remember which). Date/Times are stored in Unix Timestamp format. It's not difficult, but I would do a DB backup before doing any queries.
To the best of my knowledge, in vb5, the only way to modify the date/time of a post is direct database manipulation in the node table, either the created column or the publishdate column (I don't remember which). Date/Times are stored in Unix Timestamp format. It's not difficult, but I would do a DB backup before doing any queries.
That's what I was afraid of, touching the DB always gives me lots of worry. Ill backup and give it try.
Thanks for the heads up
--------------- Added [DATE]1451607838[/DATE] at [TIME]1451607838[/TIME] ---------------
I found the spot with the date in Unix format. How safe is it to edit the table directly? I have a back-up but I don't want to go thru the trouble of a restore if I don't need to.
If I remember correctly, I adjusted both the created and publishdate columns (now that I'm thinking about it) in the node table and had zero issues. I can't say for certain that there may or may not be a different column that has to be adjusted ( I didn't make any) but I haven't had any issues with the posts I changed.
If I remember correctly, I adjusted both the created and publishdate columns (now that I'm thinking about it) in the node table and had zero issues. I can't say for certain that there may or may not be a different column that has to be adjusted ( I didn't make any) but I haven't had any issues with the posts I changed.
Thanks I appreicate the help, im going to try it...... maybe :erm:
12-31-2015, 07:49 PM
Linear Mode
