View Full Version : search photos feature
February 8th, 2010, 03:52 PM
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 :confused:
11 result(s) to your search. 2nd-Place - Wed, December 31, 1969
Search - BytePhoto Galleries (http://www.bytephoto.com/photopost/search.php?searchid=1778)
February 8th, 2010, 05:14 PM
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.
February 8th, 2010, 05:23 PM
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 :p
February 8th, 2010, 05:58 PM
;) Got ya
May 11th, 2010, 09:35 AM
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.
May 11th, 2010, 01:13 PM
yeah its fixed in the upcoming 7.02
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.