Database Population and Multiple Languages

10 views
Skip to first unread message

Luke O'Sullivan

unread,
May 15, 2012, 8:12:09 AM5/15/12
to xerxes...@googlegroups.com
Hi Folks,

After Adding Welsh as a language to Metalib, running the populate databases command eventually causes the following:

Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '000002889' for key 'PRIMARY'' in /usr/local/xerxes/lib/framework/DataMap.php:160
Stack trace:
#0 /usr/local/xerxes/lib/framework/DataMap.php(160): PDOStatement->execute()
#1 /usr/local/xerxes/lib/framework/DataMap.php(178): Xerxes_Framework_DataMap->update('INSERT INTO xer...', Array)
#2 /usr/local/xerxes/lib/Xerxes/DataMap.php(2118): Xerxes_Framework_DataMap->insert('INSERT INTO xer...', Array, false)
#3 /usr/local/xerxes/lib/Xerxes/DataMap.php(255): Xerxes_DataMap->doSimpleInsert('xerxes_subcateg...', Object(Xerxes_Data_Subcategory))
#4 /usr/local/xerxes/commands/databases/PopulateDatabases.php(134): Xerxes_DataMap->addCategory(Object(Xerxes_Data_Category))
#5 /usr/local/xerxes/lib/framework/Command.php(31): Xerxes_Command_PopulateDatabases->doExecute(Object(Xerxes_Framework_Request), Object(Xerxes_Framework_Registry))
#6 /usr/local/xerxes/lib/framework/FrontController.php(362): Xerxes_Fram in /usr/local/xerxes/lib/framework/DataMap.php on line 160

I think this may be because all our Systems Librarian has done is to copy the English settings into the Welsh.

We don't really need to translate the category and sub category names as all we are doing is using the language settings to provide a  multi-lingual site. Is there any native way to ensure the populate command only runs on the English settings or will it require a hack?

Thanks,

Luke

Walker, David

unread,
May 15, 2012, 7:14:32 PM5/15/12
to xerxes...@googlegroups.com

Did you click the ‘all subcategories’ link in Metalib’s Categories Admin after adding the languages, Luke?

 

--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/-/bWRunhh7N2kJ.
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

unread,
May 17, 2012, 9:47:40 AM5/17/12
to xerxes...@googlegroups.com
Hi Dave,

Yes - we've tried that and still get

PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '000002889' for key 'PRIMARY'' in /usr/local/xerxes/lib/framework/DataMap.php:160

Cheers,

Luke

To unsubscribe from this group, send email to xerxes-portal+unsubscribe@googlegroups.com.

Walker, David

unread,
May 17, 2012, 11:15:28 AM5/17/12
to xerxes...@googlegroups.com

Something is fundamentally wrong, Luke -- great insight, I know! ;-)

 

The fact that you haven’t actually changed the original English subjects in the new Welsh language in Metalib is not the problem.  I can create a new language in Metalib, not touch the text at all, re-run the KB pull in Xerxes, and everything is fine.

 

See my dummy Afrikaans language, which is just English all over again:

 

   http://cowewpaq01.calstate.edu/demo/afr/

 

I think the problem is that, on the Metalib side, the new Welsh language has not been fully created.

 

How did you make it?  When I go to add a new language in the Metalib management interface, it only allows me to create one from a pre-set pull-down menu, and Welsh is not in that list. 

 

Did your Systems Librarian maybe add this at a config or file level in Metalib?  Maybe you need to go back and “create” the language in the Management interface?

 

--Dave

 

-------------------------

David Walker

Interim Director, Systemwide Digital Library Services

California State University

562-355-4845

 

From: xerxes...@googlegroups.com [mailto:xerxes...@googlegroups.com] On Behalf Of Luke O'Sullivan
Sent: Thursday, May 17, 2012 6:48 AM
To: xerxes...@googlegroups.com
Subject: Re: [xerxes-portal] Database Population and Multiple Languages

 

Hi Dave,

Yes - we've tried that and still get

PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '000002889' for key 'PRIMARY'' in /usr/local/xerxes/lib/framework/DataMap.php:160

Cheers,

Luke

On Wednesday, 16 May 2012 00:14:32 UTC+1, David Walker wrote:

Did you click the ‘all subcategories’ link in Metalib’s Categories Admin after adding the languages, Luke?

 

--Dave

 

-------------------------

David Walker

Interim Director, Systemwide Digital Library Services

California State University

562-355-4845

 

From: xerxes...@googlegroups.com [mailto:xerxes...@googlegroups.com] On Behalf Of Luke O'Sullivan
Sent: Tuesday, May 15, 2012 5:12 AM
To: xerxes...@googlegroups.com
Subject: [xerxes-portal] Database Population and Multiple Languages

 

Hi Folks,

 

After Adding Welsh as a language to Metalib, running the populate databases command eventually causes the following:

 

Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '000002889' for key 'PRIMARY'' in /usr/local/xerxes/lib/framework/DataMap.php:160

Stack trace:

#0 /usr/local/xerxes/lib/framework/DataMap.php(160): PDOStatement->execute()

#1 /usr/local/xerxes/lib/framework/DataMap.php(178): Xerxes_Framework_DataMap->update('INSERT INTO xer...', Array)

#2 /usr/local/xerxes/lib/Xerxes/DataMap.php(2118): Xerxes_Framework_DataMap->insert('INSERT INTO xer...', Array, false)

#3 /usr/local/xerxes/lib/Xerxes/DataMap.php(255): Xerxes_DataMap->doSimpleInsert('xerxes_subcateg...', Object(Xerxes_Data_Subcategory))

#4 /usr/local/xerxes/commands/databases/PopulateDatabases.php(134): Xerxes_DataMap->addCategory(Object(Xerxes_Data_Category))

#5 /usr/local/xerxes/lib/framework/Command.php(31): Xerxes_Command_PopulateDatabases->doExecute(Object(Xerxes_Framework_Request), Object(Xerxes_Framework_Registry))

#6 /usr/local/xerxes/lib/framework/FrontController.php(362): Xerxes_Fram in /usr/local/xerxes/lib/framework/DataMap.php on line 160

 

I think this may be because all our Systems Librarian has done is to copy the English settings into the Welsh.

 

We don't really need to translate the category and sub category names as all we are doing is using the language settings to provide a  multi-lingual site. Is there any native way to ensure the populate command only runs on the English settings or will it require a hack?

 

Thanks,

 

Luke

--
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/-/bWRunhh7N2kJ.
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.

--

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/-/eMDxHlbnLzEJ.


To post to this group, send email to xerxes...@googlegroups.com.

To unsubscribe from this group, send email to xerxes-porta...@googlegroups.com.

Reply all
Reply to author
Forward
0 new messages