OrdaSoft forum
Error message when calling Media Library component (0 viewing)
MediaLibary Component Support
Favoured: 1
|
Error message when calling Media Library component
Error message when calling Media Library component 15 Years, 6 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 )
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
The administrator has disabled public write access.
Re:Error message when calling Media Library compon 15 Years, 6 Months ago
Karma: 102
You have to go to phpmyadmin and change the collation of the tables that you are using.
Logged
The administrator has disabled public write access.
Re:Error message when calling Media Library component 15 Years, 5 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
The administrator has disabled public write access.
Re:Error message when calling Media Library compon 15 Years, 5 Months ago
Karma: 102
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
I think that will help
Logged
The administrator has disabled public write access.
Re:Error message when calling Media Library compon 15 Years, 3 Months 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
The administrator has disabled public write access.
Re:Error message when calling Media Library component 15 Years, 3 Months 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;
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
The administrator has disabled public write access.
 |
we support payment systems
