Search Error

[Luke O'Sullivan]

Hi Folks,

A strange one this - a search for "dog" is resulting in an error:

Notice: unserialize(): Error at offset 89113 of 109586 bytes in /usr/local/xerxes/lib/Xerxes/Cache.php on line 39 Notice: Trying to get property of non-object in /usr/local/xerxes/lib/Xerxes/Cache.php on line 67 Fatal error: Uncaught exception 'Exception' with message 'text_error_search_expired' in /usr/local/xerxes/lib/Xerxes/Cache.php:69 Stack trace: #0 /usr/local/xerxes/commands/metasearch/Metasearch.php(484): Xerxes_Cache->getCache('search', 'DOMDocument') #1 /usr/local/xerxes/commands/metasearch/MetasearchResults.php(38): Xerxes_Command_Metasearch->getCache('2012-08-22-0001...', 'search', 'DOMDocument') #2 /usr/local/xerxes/lib/framework/Command.php(31): Xerxes_Command_MetasearchResults->doExecute(Object(Xerxes_Framework_Request), Object(Xerxes_Framework_Registry)) #3 /usr/local/xerxes/lib/framework/FrontController.php(362): Xerxes_Framework_Command->execute(Object(Xerxes_Framework_Request), Object(Xerxes_Framework_Registry)) #4 /usr/local/xerxes/demo/index.php(17): Xerxes_Framework_FrontController::execute() #5 {main} thrown in /usr/local/xerxes/lib/Xerxes/Cache.php on line 69

Is this a Metalib timeout error or is dodgy data to blame?

Thanks,

Luke

[John Wynstra]

Believe it or not, this may have to do with the encoding of your mysql database.  It should be utf8.

See the following thread for this same problem.

https://groups.google.com/forum/?fromgroups=#!searchin/xerxes-portal/Cache.php/xerxes-portal/QfU1ySl6M4E/PdMykjReQH0J 

--
You received this message because you are subscribed to the Google Groups "xerxes-portal" group.
To view this discussion on the web visit https://groups.google.com/d/msg/xerxes-portal/-/qIA_4yZm-0EJ.
To post to this group, send email to xerxes...@googlegroups.com.
To unsubscribe from this group, send email to xerxes-porta...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/xerxes-portal?hl=en.

[Luke O'Sullivan]

Hi John,

Thanks for the reply -  you were spot on! It looks like Fedora defaults to utf8 whilst Ubuntu defaults to Latin1.

Dave - It might be worth explicitly setting the encoding in the SQL scripts which come with Xerxes.

Cheers,

Luke

[Walker, David]

I thought we were already. Does this not do that?

CREATE DATABASE IF NOT EXISTS xerxes DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

http://code.google.com/p/xerxes-portal/source/browse/trunk/sql/mysql/create-kb.sql

--Dave

-------------------------
David Walker
Interim Director, Systemwide Digital Library Services
California State University
562-355-4845

--
You received this message because you are subscribed to the Google Groups "xerxes-portal" group.

To view this discussion on the web visit https://groups.google.com/d/msg/xerxes-portal/-/fe7Z0bc5xJoJ.

[Luke O'Sullivan]

Hi Dave,

Yes - sorry! I see that they do...

I think I must have created the database myself and then run the sql commands!

Thanks,

Luke