Collection Record Problem

General bug reports for the Archon software.

Moderators: paulnsorensen, kylefox2, prom, rishel

Collection Record Problem

Postby lhocking » Mon Mar 05, 2012 8:40 pm

Today while uploading digital content in a particular collection, our Web server crashed because of insufficient memory. The Web host resolved the problem and got everything up and running except the collection we were working on. The rest of the collection descriptions in our install of Archon appear to be as they were. This is the link for the collection:

http://www.litchfieldhistoricalsociety. ... lcard&id=5

Nothing loads when I click the collection title. I also tried going in through admin, and an almost blank page loads with two words "Digital Content" on the left of the screen.

The digital content library is another story. Nothing displays for any letter. This appears if I click on one:
SELECT DISTINCT tblDigitalLibrary_DigitalContent.ID,tblDigitalLibrary_DigitalContent.Title,tblDigitalLibrary_DigitalContent.ContentURL,tblDigitalLibrary_DigitalContent.Identifier FROM tblDigitalLibrary_DigitalContent INNER JOIN tblDigitalLibrary_Files ON (tblDigitalLibrary_Files.DigitalContentID = tblDigitalLibrary_DigitalContent.ID) INNER JOIN tblDigitalLibrary_FileTypes ON tblDigitalLibrary_FileTypes.ID = tblDigitalLibrary_Files.FileTypeID WHERE 1 = 1 AND tblDigitalLibrary_FileTypes.MediaTypeID = ? ORDER BY tblDigitalLibrary_DigitalContent.Title


If I search the digital content library for "Wolcott" (the name of the collection) I get this:
SELECT DISTINCT tblDigitalLibrary_DigitalContent.ID,tblDigitalLibrary_DigitalContent.Title,tblDigitalLibrary_DigitalContent.ContentURL,tblDigitalLibrary_DigitalContent.Identifier FROM tblDigitalLibrary_DigitalContent INNER JOIN tblDigitalLibrary_Files ON (tblDigitalLibrary_Files.DigitalContentID = tblDigitalLibrary_DigitalContent.ID) INNER JOIN tblDigitalLibrary_FileTypes ON tblDigitalLibrary_FileTypes.ID = tblDigitalLibrary_Files.FileTypeID WHERE (tblDigitalLibrary_DigitalContent.Title LIKE ? OR tblDigitalLibrary_DigitalContent.Scope LIKE ? OR tblDigitalLibrary_DigitalContent.PhysicalDescription LIKE ? OR tblDigitalLibrary_DigitalContent.Contributor LIKE ? OR tblDigitalLibrary_DigitalContent.Identifier LIKE ?) AND tblDigitalLibrary_FileTypes.MediaTypeID = ? ORDER BY tblDigitalLibrary_DigitalContent.Title

The Web host e-mailed me the following error which appeared when he tried to access the link to the collection description:
[Mon Mar 05 16:07:12 2012] [error] [client 213.186.119.131] PHP Warning:
include_once(analyticstracking.php) [<a
href='function.include-once'>function.include-once</a>]: failed to open
stream: No such file or directory in
/home/litch/production/php/calendar/calendar.php on line 41
[Mon Mar 05 16:07:12 2012] [error] [client 213.186.119.131] PHP Warning:
include_once() [<a href='function.include'>function.include</a>]:
Failed opening 'analyticstracking.php' for inclusion
(include_path='.:/usr/share/pear:/usr/share/php') in
/home/litch/production/php/calendar/calendar.php on line 41
[Mon Mar 05 16:08:37 2012] [error] [client 157.55.16.55] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/digitalcontent.inc.php
on line 263
[Mon Mar 05 16:08:58 2012] [error] [client 66.249.71.51] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/file.inc.php
on line 758
[Mon Mar 05 16:10:45 2012] [error] [client 66.249.71.51] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/file.inc.php
on line 758
[Mon Mar 05 16:12:31 2012] [error] [client 66.249.71.51] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/file.inc.php
on line 758
[Mon Mar 05 16:13:53 2012] [error] [client 71.235.196.179] PHP Warning:
include_once(analyticstracking.php) [<a
href='function.include-once'>function.include-once</a>]: failed to open
stream: No such file or directory in
/home/litch/production/php/library/guide.php on line 16, referer:
http://www.google.com/url?sa=t&rct=j&q= ... u-X1xPJj-Q
[Mon Mar 05 16:13:53 2012] [error] [client 71.235.196.179] PHP Warning:
include_once() [<a href='function.include'>function.include</a>]:
Failed opening 'analyticstracking.php' for inclusion
(include_path='.:/usr/share/pear:/usr/share/php') in
/home/litch/production/php/library/guide.php on line 16, referer:
http://www.google.com/url?sa=t&rct=j&q= ... u-X1xPJj-Q
[Mon Mar 05 16:14:17 2012] [error] [client 66.249.71.51] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/file.inc.php
on line 758
[Mon Mar 05 16:16:45 2012] [error] [client 72.14.199.57] PHP Warning:
include_once(analyticstracking.php) [<a
href='function.include-once'>function.include-once</a>]: failed to open
stream: No such file or directory in
/home/litch/production/php/museum/collection/costume/index.php on line 16
[Mon Mar 05 16:16:45 2012] [error] [client 72.14.199.57] PHP Warning:
include_once() [<a href='function.include'>function.include</a>]: Failed
opening 'analyticstracking.php' for inclusion
(include_path='.:/usr/share/pear:/usr/share/php') in
/home/litch/production/php/museum/collection/costume/index.php on line 16
[Mon Mar 05 16:17:50 2012] [error] [client 66.249.71.51] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/file.inc.php
on line 758
[Mon Mar 05 16:19:36 2012] [error] [client 66.249.71.51] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/file.inc.php
on line 758
[Mon Mar 05 16:21:23 2012] [error] [client 66.249.71.51] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/file.inc.php
on line 758
[Mon Mar 05 16:22:56 2012] [error] [client 207.46.13.115] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/digitalcontent.inc.php
on line 263
[Mon Mar 05 16:23:10 2012] [error] [client 66.249.71.51] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/file.inc.php
on line 758
[Mon Mar 05 16:24:55 2012] [error] [client 66.249.71.51] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/file.inc.php
on line 758
[Mon Mar 05 16:25:59 2012] [error] [client 209.145.68.74] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/digitalcontent.inc.php
on line 263
[Mon Mar 05 16:26:42 2012] [error] [client 66.249.71.51] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/file.inc.php
on line 758
[Mon Mar 05 16:28:17 2012] [error] [client 213.186.119.131] PHP Warning:
include_once(analyticstracking.php) [<a
href='function.include-once'>function.include-once</a>]: failed to open
stream: No such file or directory in
/home/litch/production/php/museum/collection/art/11.php on line 16
[Mon Mar 05 16:28:17 2012] [error] [client 213.186.119.131] PHP Warning:
include_once() [<a href='function.include'>function.include</a>]:
Failed opening 'analyticstracking.php' for inclusion
(include_path='.:/usr/share/pear:/usr/share/php') in
/home/litch/production/php/museum/collection/art/11.php on line 16
[Mon Mar 05 16:28:28 2012] [error] [client 66.249.71.51] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/file.inc.php
on line 758
[Mon Mar 05 16:28:33 2012] [error] [client 209.145.68.74] PHP Fatal
error: Call to undefined method MDB2_Error::execute() in
/home/litch/production/php/archon/packages/digitallibrary/lib/digitalcontent.inc.php
on line 263

We're currently using version 3.14. Many thanks for any advice or suggestions.

Linda Hocking
Litchfield Historical Society
lhocking
 
Posts: 33
Joined: Wed Apr 29, 2009 9:28 am

Re: Collection Record Problem

Postby beltramie » Tue Mar 06, 2012 2:10 pm

Hi Linda,

Were you using either a customized template or theme. And if so, did you make a lot of changes? It looks like there is a PHP error on your page, but Archon by default is set to not display what the error is. Customizations and a broken association with a theme or template could explain some of this behavior.

Can you change the default theme,default administrative theme and default template to "default" and see if these errors go away. If so, that would narrow down the causes.

Nat
beltramie
 
Posts: 157
Joined: Mon Feb 16, 2009 3:58 pm
Location: Carleton College, Northfield MN

Re: Collection Record Problem

Postby lhocking » Tue Mar 06, 2012 3:18 pm

Nat,

Thanks for the suggestion. I don't think anything is customized, but we'll try it anyway. I'll let you know if it helps. Thank you.

Linda
lhocking
 
Posts: 33
Joined: Wed Apr 29, 2009 9:28 am

Re: Collection Record Problem

Postby lhocking » Wed Mar 07, 2012 9:27 am

I've confirmed with our web person that we haven't done any customization to Archon. Is it possible that there is a maximum amount of data that can be stored in the digital library? We have a lot of digital content, and this did happen while we were adding more. Thanks.

Linda
lhocking
 
Posts: 33
Joined: Wed Apr 29, 2009 9:28 am

Re: Collection Record Problem

Postby beltramie » Wed Mar 07, 2012 1:00 pm

The only time I have had problems related to the digital library are when I added items that were too large, like 100mg audio files. They bogged down the database and made searching and browsing really slow. When I removed those large files the problem went away, but they didnt create the issues you have.

And your themes and templates are still set to default?

Would your IT person be able to set up a test instance of Archon with a fresh install of the software as well as a duplicate of the database you currently have? This would be a good testing site to have anyway, and it would help you figure out if the problem resides in the database or in Archon's php code.
beltramie
 
Posts: 157
Joined: Mon Feb 16, 2009 3:58 pm
Location: Carleton College, Northfield MN

Re: Collection Record Problem

Postby lhocking » Wed Mar 07, 2012 2:03 pm

We downsized the files, they were each about 400kb jpegs, so not huge. I have since realized that not only did the digital repository vanish, but all of the finding aids linked to it won't display either. We are all set to default templates and themes. Trouble is we don't really have IT people, which is why we're still using an older version of the software. Our Web host is working on restoring the last successful backup which unfortunately was a week old. Once that's done and before we enter any more digital files, I'm going to figure out a way to get us upgraded to see if that helps. Thanks.
Linda
lhocking
 
Posts: 33
Joined: Wed Apr 29, 2009 9:28 am

Re: Collection Record Problem

Postby beltramie » Thu Mar 08, 2012 6:05 pm

Y, 400 K should not be an issue for you files. A fresh install has worked for me in the past, but to me its a measure of last resort. Upgrading to the newest version is a good thing to do when you get a chance.

In the mean time try changing first your theme than your template to "illinois", checking after each change to see if any of those problems disappear. Illinois is one of the other themes that comes with the standard Archon package. If your problems go away after any of these changes, than you might be able to replace only the broken theme or template.

Nat
beltramie
 
Posts: 157
Joined: Mon Feb 16, 2009 3:58 pm
Location: Carleton College, Northfield MN


Return to Archon Bugs

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest

cron