?

Log in

No account? Create an account
Not a happy camper - Drinking from the Fire Hose — LiveJournal
and trying not to drown

Mrs_Sweetpeach
Date: 2007-04-14 14:42
Subject: Not a happy camper
Security: Public
Location:Home and on my corner of the couch
Mood:annoyedannoyed
Music:Suburban Secrets (on tv)
Tags:genealogy
I had 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*
Post A Comment | 5 Comments | | Link






jebra
User: jebra
Date: 2007-04-14 19:11 (UTC)
Subject: (no subject)
Any better yet?
Reply | Thread | Link



Mrs_Sweetpeach
User: mrs_sweetpeach
Date: 2007-04-14 23:24 (UTC)
Subject: (no subject)
Not entirely. The error message no longer appears, but when I went to the MultiMedia Object List, none of the images reappeared. Entries for them still exist, but each also has a notation similar to "File not found. media/bertmary.jpg" (with each having the actual file name that can't be found).

And I pretty much crapped out at the library too. I got there around 3:30 and stayed until they closed at 6:00, easily spending two hours poking about the library edition of ancestors.com and another database I've already forgotten the name of. Found my own data, three census records I knew about but may not have actually seen before, and the curious fact that the only known repository for Jackson County [West Virginia] Historical Society Newsletter is the Allen County Public Library in Fort Wayne, Indiana.
Reply | Parent | Thread | Link



jebra
User: jebra
Date: 2007-04-15 05:38 (UTC)
Subject: (no subject)
It looks as if the media directory is under phpGenView, not of in another directory (like some of the other "secure" files). I copied the media hierarchy from the phpGedView-4.0.1 directory to the phpGedView-4.0.2 directory and all seems well now.

Yay!

Reply | Parent | Thread | Link



silver_chipmunk
User: silver_chipmunk
Date: 2007-04-14 20:15 (UTC)
Subject: (no subject)
Lost pictures SUCK! Good luck!
Reply | Thread | Link



Mrs_Sweetpeach
User: mrs_sweetpeach
Date: 2007-04-14 23:25 (UTC)
Subject: (no subject)
Thank you!
Reply | Parent | Thread | Link



browse
my journal
August 2019