search photos feature

[taylorpiano]

I just created a search for photos with specific key words that I gave them starting Jan 1 2010. In the search I selected all in the past 1 month.
See link below.

I'm confused as to why this text was listed above my search

11 result(s) to your search. 2nd-Place - Wed, December 31, 1969

Search - BytePhoto Galleries

[Chuck S]

ALTER TABLE pp_searchids CHANGE searchdate searchdate VARCHAR(15) NULL;

Try running this query in phpmyadmin. Steve will know how to do that

The searchdate field has to be larger to save the entire unixtimestamp for your date.

[taylorpiano]

Actually, if Steve gave me had access to the database, I'd know how to do it lol
I used to work for a major pharmaceutical company as a data analyst and also all my best buds were database gurus so I actually know what a unixtimestamp is
Steve just doesn't realize yet that I understand more about queries than he thinks. I used to pull data from all different mainframe systems and relate them to one another to create my reports.
Now to only get Steve to trust me to have access

[Chuck S]

Got ya

[Steve_UK]

Chuck,

Just for info we just had to apply this fix on our PP 7.01.

The calendar results would show the 1970 date if anyone clicked on any of the May 2010 dates etc. Your fix worked fine so that is solved on our 7.01 site.

Sadly, if I go to the Advanced Search and ask to see all photos for the last 2 months it still shows the 1970 date at the top of the results.

Is there another field or two that needs that treatment/change you mentioned perhaps?

Hope the feedback is helpful.

Steve

[Chuck S]

yeah its fixed in the upcoming 7.02