OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
DB function failed with error number 1267 (0 viewing) 
MediaLibary Component Support
Go to bottom Favoured: 0
TOPIC: DB function failed with error number 1267
#1216
fazel (Visitor)
Fresh Boarder
Posts: 4
graphgraph
User Offline
DB function failed with error number 1267 6 Years, 1 Month ago Karma: 0  
I have successfully installed Medialibrary basic. I get the following error when I click on Media or Lend request options:

DB function failed with error number 1267

This is followed by some codes in red. It seems the component cannot access the database.
Do I have to do something to set up the database?
Fazel
 
Logged Logged  
  The administrator has disabled public write access.
#1217
admin (Admin)
Admin
Posts: 4867
graph
User Online Now Click here to see the profile of this user
Re:DB function failed with error number 1267 6 Years, 1 Month ago Karma: 61  
Hi Fazel,

Can you give admin access to yours site ? With that we will can check where error.

Account details you can send to this form: http://ordasoft.com/Contact/category/?catid=0

Thanks,
Andrew
 
Logged Logged  
  The administrator has disabled public write access.
#1245
Phil (Visitor)
Fresh Boarder
Posts: 3
graphgraph
User Offline
Re:DB function failed with error number 1267 6 Years, 1 Month ago Karma: 0  
I am obviously being confronted with the same problem.

When trying to start the 'media'-area of this component in the admin-frontend of joomla! this error message appears.

I tried to execute the whole query directly in mysql. When removing the sub-query, the statement worked fine - also the sub-query alone worked well.

Could you please post the solution of the problem that Fazel was experiencing?

The complete error message is:
DB function failed with error number 1267
Unerlaubte Mischung von Sortierreihenfolgen (utf8_general_ci, COERCIBLE) und (latin1_swedish_ci, IMPLICIT) f�r 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, (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 where other_table.id = library.media_id and other_table.type = library.media_type ORDER BY library.catid, library.ordering LIMIT 0,20;

Thanks in advance,

Phil.
 
Logged Logged  
  The administrator has disabled public write access.
#1246
lalitovalera (Visitor)
Fresh Boarder
Posts: 1
graphgraph
User Offline
Re:DB function failed with error number 1267 6 Years, 1 Month ago Karma: 0  
Hi, I have the same problem. Even when I try to install the component it says that has an error with XML and then I have the same problem in the "media" area.
I really need this component because I´m creating a video club. So I hope it could be fixed.

Thank you so much

Eddie
 
Logged Logged  
  The administrator has disabled public write access.
#1247
admin (Admin)
Admin
Posts: 4867
graph
User Online Now Click here to see the profile of this user
Re:DB function failed with error number 1267 6 Years, 1 Month ago Karma: 61  
Hello,

Look like you have problem with database font codding.
Yours database have encoding "latin1_swedish_ci" but from site it take ""utf8_general_ci". Joomla work with UTF8

Please search "collation" from this site forum. I believe that reslve yours errors with Media Library.

Thanks,
OrdaSoft team
 
Logged Logged  
  The administrator has disabled public write access.
#1250
Phil (Visitor)
Fresh Boarder
Posts: 3
graphgraph
User Offline
Re:DB function failed with error number 1267 6 Years, 1 Month ago Karma: 0  
Hello,

all tables in my mysql-db are latin1_swedish_ci. Even all columns of the given sql-statement are encoded latin1-swedish_ci.

Which tables should be changed?

In the meantime I checked every table and every single column in my database - they are all either without collation, or with collation "latin1_swedish_c1".

Why is there a conversion to utf-8 in the database? Can you please help or give me a hint?

Thank you for your support.

Phil.
 
Logged Logged  
 
Last Edit: 2010/10/25 14:22 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?