OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
Error message when calling Media Library component (0 viewing) 
MediaLibary Component Support
Go to bottom Favoured: 1
TOPIC: Error message when calling Media Library component
#15
srm (Visitor)
Fresh Boarder
Posts: 1
graphgraph
User Offline
Error message when calling Media Library component 7 Years, 3 Months ago Karma: 0  
Problem Description:
Just after the install process received an error message (together with the message saying installation success. Calling the component, receive the error messages below:

DB function failed with error number 1267
Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '=' SQL=SELECT count(*) FROM srm_medialibrary AS library LEFT JOIN srm_categories AS cc ON cc.id = library.catid LEFT JOIN srm_medialibrary_lend AS l ON library.fk_lendid = l.id LEFT JOIN srm_users AS u ON u.id = library.checked_out LEFT JOIN (SELECT id, title, 'game' as type, comment, studio as ext1, binding as ext2, platform as ext3 FROM srm_medialibrary_game UNION all SELECT id, title, 'music' as type, comment,artist as ext1, label as ext2, tracklist as ext3 FROM srm_medialibrary_music UNION all SELECT id, title, 'book' as type,comment,authors as ext1, manufacturer as ext2, edition as ext3 FROM srm_medialibrary_book UNION all SELECT id, title, 'video' as type, comment,actors as ext1, producers as ext2, format as ext3 FROM srm_medialibrary_video) AS other_table ON other_table.id = library.media_id and other_table.type = library.media_typeDB function failed with error number 1267
Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '=' SQL=SELECT library.id, library.media_type, library.media_id,cc.title AS category, library.published, library.hits, library.checked_out, library.catid, library.informationFrom, l.id as lendid, l.lend_from as lend_from, l.lend_return as lend_return, l.lend_until as lend_until , u.name AS editor, other_table.id as media_type_id, other_table.title as title FROM srm_medialibrary AS library LEFT JOIN srm_categories AS cc ON cc.id = library.catid LEFT JOIN srm_medialibrary_lend AS l ON library.fk_lendid = l.id LEFT JOIN srm_users AS u ON u.id = library.checked_out LEFT JOIN (SELECT id, title, 'game' as type, comment, studio as ext1, binding as ext2, platform as ext3 FROM srm_medialibrary_game UNION all SELECT id, title, 'music' as type, comment,artist as ext1, label as ext2, tracklist as ext3 FROM srm_medialibrary_music UNION all SELECT id, title, 'book' as type,comment,authors as ext1, manufacturer as ext2, edition as ext3 FROM srm_medialibrary_book UNION all SELECT id, title, 'video' as type, comment,actors as ext1, producers as ext2, format as ext3 FROM srm_medialibrary_video) AS other_table ON other_table.id = library.media_id and other_table.type = library.media_type ORDER BY library.catid, library.ordering LIMIT 0,20;




Diagnostic Information
Joomla! Version: Joomla! 1.5.11 Production/Stable [ Vea ] 03-June-2009 03:30 GMT
configuration.php: Not Writable (Mode: 444 ) | RG_EMULATION: N/A
Architecture/Platform: Linux 2.6.18-92.1.10.el5 ( x86_64) | Web Server: Apache ( www.formulador.com ) | PHP Version: 5.2.5
PHP Requirements: register_globals: Disabled | magic_quotes_gpc: Enabled | safe_mode: Disabled | MySQL Support: Yes | XML Support: Yes | zlib Support: Yes
mbstring Support (1.5): Yes | iconv Support (1.5): Yes | save.session_path: Writable | Max.Execution Time: 60 seconds | File Uploads: Enabled
MySQL Version: 5.0.81-community-log ( Localhost via UNIX socket )

Extended Information:
SEF: Enabled (with ReWrite) | FTP Layer: Disabled | htaccess: Implemented
PHP/suExec: User and Web Server accounts are the same. (PHP/suExec probably installed)
PHP Environment: API: cgi | MySQLi: Yes | Max. Memory: 64M | Max. Upload Size: 50M | Max. Post Size: 50M | Max. Input Time: 60 | Zend Version: 2.2.0
Disabled Functions:
MySQL Client: 5.0.81 ( latin1 )
 
Logged Logged  
  The administrator has disabled public write access.
#18
admin (Admin)
Admin
Posts: 4856
graph
User Offline Click here to see the profile of this user
Re:Error message when calling Media Library compon 7 Years, 3 Months ago Karma: 61  
You have to go to phpmyadmin and change the collation of the tables that you are using.
 
Logged Logged  
  The administrator has disabled public write access.
#63
sekhmet (Visitor)
Fresh Boarder
Posts: 3
graphgraph
User Offline
Re:Error message when calling Media Library component 7 Years, 2 Months ago Karma: 0  
I get the same error message, but I am not sure how to fix the collation of the tables can you be more specific or can you give an example of the correct collation so I can import it. Thanks
 
Logged Logged  
  The administrator has disabled public write access.
#66
admin (Admin)
Admin
Posts: 4856
graph
User Offline Click here to see the profile of this user
Re:Error message when calling Media Library compon 7 Years, 2 Months ago Karma: 61  
Sorry I don't do that self. I don't take so errors. So can show only where and how you can change collation.

I think that will help
File Attachment:
File Name: img.zip
File Size: 153760
 
Logged Logged  
 
Last Edit: 2009/07/13 21:29 By admin.
  The administrator has disabled public write access.
#141
osinquin (Visitor)
Fresh Boarder
Posts: 1
graphgraph
User Offline
Re:Error message when calling Media Library compon 7 Years ago Karma: 0  
I get the exact same problem with the latest version of media library I just downloaded. It will take so long to change the collation from latin1_swedish to utf8_general. Can't you just provide an utf8_general version of the tables. thank you
 
Logged Logged  
  The administrator has disabled public write access.
#142
samantha22 (Visitor)
Fresh Boarder
Posts: 1
graphgraph
User Offline
Re:Error message when calling Media Library component 7 Years ago Karma: 0  
I have the same error message. Please help

DB function failed with error number 1267
Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '=' SQL=SELECT count(*) FROM jos_medialibrary AS library LEFT JOIN jos_categories AS cc ON cc.id = library.catid LEFT JOIN jos_medialibrary_lend AS l ON library.fk_lendid = l.id LEFT JOIN jos_users AS u ON u.id = library.checked_out LEFT JOIN (SELECT id, title, 'game' as type, comment, studio as ext1, binding as ext2, platform as ext3 FROM jos_medialibrary_game UNION all SELECT id, title, 'music' as type, comment,artist as ext1, label as ext2, tracklist as ext3 FROM jos_medialibrary_music UNION all SELECT id, title, 'book' as type,comment,authors as ext1, manufacturer as ext2, edition as ext3 FROM jos_medialibrary_book UNION all SELECT id, title, 'video' as type, comment,actors as ext1, producers as ext2, format as ext3 FROM jos_medialibrary_video) AS other_table ON other_table.id = library.media_id and other_table.type = library.media_typeDB function failed with error number 1267
Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '=' SQL=SELECT library.id, library.media_type, library.media_id,cc.title AS category, library.published, library.hits, library.checked_out, library.catid, library.informationFrom, l.id as lendid, l.lend_from as lend_from, l.lend_return as lend_return, l.lend_until as lend_until , u.name AS editor, other_table.id as media_type_id, other_table.title as title FROM jos_medialibrary AS library LEFT JOIN jos_categories AS cc ON cc.id = library.catid LEFT JOIN jos_medialibrary_lend AS l ON library.fk_lendid = l.id LEFT JOIN jos_users AS u ON u.id = library.checked_out LEFT JOIN (SELECT id, title, 'game' as type, comment, studio as ext1, binding as ext2, platform as ext3 FROM jos_medialibrary_game UNION all SELECT id, title, 'music' as type, comment,artist as ext1, label as ext2, tracklist as ext3 FROM jos_medialibrary_music UNION all SELECT id, title, 'book' as type,comment,authors as ext1, manufacturer as ext2, edition as ext3 FROM jos_medialibrary_book UNION all SELECT id, title, 'video' as type, comment,actors as ext1, producers as ext2, format as ext3 FROM jos_medialibrary_video) AS other_table ON other_table.id = library.media_id and other_table.type = library.media_type ORDER BY library.catid, library.ordering LIMIT 0,20;
 
Logged Logged  
 
Last Edit: 2009/09/05 09:00 By .
  The administrator has disabled public write access.
Go to top
What are you looking for?
Anti-spam question: How many eyes has a typical person?