mrs_sweetpeach: (Default)
mrs_sweetpeach ([personal profile] mrs_sweetpeach) wrote2007-04-14 02:42 pm
Entry tags:

Not a happy camper

I had [insanejournal.com profile] jebra update PhpGedView the other day. Afterwards, I got the following message on our family tree home page, but everything seemed to work properly.

ERROR:-1 DB Error: unknown error
SQL:SELECT * FROM pgv_media WHERE m_gedfile='3' ORDER BY RAND() LIMIT 5 OFFSET 0 [nativecode=ERROR: function rand() does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts.]

Fatal error: Call to undefined function: numrows() in /var/www/localhost/htdocs/phpGedView-4.0.2-all/includes/functions_mediadb.php on line 551


Now I'm getting ready to go to the library to see if I can borrow one of their computers and log in to their genealogy database, and I find that I've lost *every* photo loaded into the database. Hopefully this is lost as in "PhpGedView can't find them" not "the photos were accidentally removed from the hard drive." If I have to re-link the photos to the database record, it'll be a pain in the ass, but do-able. If they've been deleted, I should have backups for 99% of the photos around here somewhere, but locating each individual photo and retyping the captions and providence of each photo will be a major undertaking. *sigh*