OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
MediaLibary Component Support
Go to bottom Favoured: 0
TOPIC: Create New Media
#226
raniafekry (Visitor)
Fresh Boarder
Posts: 1
graphgraph
User Offline
Create New Media 7 Years, 1 Month ago Karma: 0  
I like to get Media library to work . but every time I click on New " add" new media

I got this error , let me know please, how to fix it , same error with version 1 or 1.5.3.3 or 1.5.3.2

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  
  The administrator has disabled public write access.
#230
admin (Admin)
Admin
Posts: 4882
graph
User Offline Click here to see the profile of this user
Re:Create New Media 7 Years, 1 Month ago Karma: 61  
Please check these post:

ordasoft.com/MediaLibary-Component-Suppo...ry-component.html#15

I believe that will help you.

Andrew
 
Logged Logged  
  The administrator has disabled public write access.
#281
Eck (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Re:Create New Media 7 Years, 1 Month ago Karma: 0  
i have this problem when i try to create a new media!
i try it with amazon.de i hope someone can help me!




hope u can read it but i can't copy&paste the error message cause the messagebox

Thx
 
Logged Logged  
 
Last Edit: 2009/11/03 10:00 By Eck.
  The administrator has disabled public write access.
#283
admin (Admin)
Admin
Posts: 4882
graph
User Offline Click here to see the profile of this user
Re:Create New Media 7 Years, 1 Month ago Karma: 61  
Hi,

Sorry, what problems you have ?
Very small images, can you give full workflow - how I can reproduce it.

Thanks

Andrew
 
Logged Logged  
  The administrator has disabled public write access.
#284
Eck (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Re:Create New Media 7 Years, 1 Month ago Karma: 0  
ok

the problem is that i can't add a new video.

http://ms-eck.de/images/sonstige/bild1.JPG

when i click on save this error message comes!
http://ms-eck.de/images/sonstige/Unbenannt.JPG


i hope you now know what's my problem is and can help me!

if i write the Title and so by my own, it works perfect, but its a lot of work and it would be fine if use it with amazon!
 
Logged Logged  
 
Last Edit: 2009/11/03 10:44 By Eck.
  The administrator has disabled public write access.
#285
admin (Admin)
Admin
Posts: 4882
graph
User Offline Click here to see the profile of this user
Re:Create New Media 7 Years, 1 Month ago Karma: 61  
Hi,
Please write to yours host provider first warning records from
ms-eck.de/images/sonstige/Unbenannt.JPG - "Warning: simplexml_load_file - URL file access is disabled ..."
And ask from him - open for you access.
 
Logged Logged  
  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?