Login Form

#49 – Error on Items report

Posted in ‘BF Auction’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Monday, 09 December 2013 09:59 AEDT
socialprofilesus
Joomla! version: (2.5) - When clicking our the Items REport tab in the cp, we are getting the following error. Please advise.

500 - An error has occurred.

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT a.id, a.endDate, a.currentBid, a.tax, a.commission, a.saleType,a.productId, a.title, a.highBidder, e.name, a.itemLocation, a.shipping,a.costPrice, a.checked_out, a.checked_out_time,a.state, a.access, a.ordering,a.language, a.publish_up, a.publish_down,a.winEmailSent, a.reservePrice,a.uid, a.endDate,d.username, a.catid,ag.title AS access_level,c.title AS category_name,d.username,e.name FROM `jos_bfauction_plus` AS a LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN AS d ON d.id = a.uid LEFT JOIN AS e ON e.username = a.highBidder WHERE (a.state IN (0, 1, 2)) ORDER BY a.parent,c.title asc, a.ordering asc Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT a.id, a.endDate, a.currentBid, a.tax, a.commission, a.saleType,a.productId, a.title, a.highBidder, e.name, a.itemLocation, a.shipping,a.costPrice, a.checked_out, a.checked_out_time,a.state, a.access, a.ordering,a.language, a.publish_up, a.publish_down,a.winEmailSent, a.reservePrice,a.uid, a.endDate,d.username, a.catid,ag.title AS access_level,c.title AS category_name,d.username,e.name FROM `jos_bfauction_plus` AS a LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN AS d ON d.id = a.uid LEFT JOIN AS e ON e.username = a.highBidder WHERE (a.state IN (0, 1, 2)) ORDER BY a.parent,c.title asc, a.ordering asc LIMIT 0, 20 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT a.id, a.endDate, a.currentBid, a.tax, a.commission, a.saleType,a.productId, a.title, a.highBidder, e.name, a.itemLocation, a.shipping,a.costPrice, a.checked_out, a.checked_out_time,a.state, a.access, a.ordering,a.language, a.publish_up, a.publish_down,a.winEmailSent, a.reservePrice,a.uid, a.endDate,d.username, a.catid,ag.title AS access_level,c.title AS category_name,d.username,e.name FROM `jos_bfauction_plus` AS a LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN AS d ON d.id = a.uid LEFT JOIN AS e ON e.username = a.highBidder WHERE (a.state IN (0, 1, 2)) ORDER BY a.parent,c.title asc, a.ordering asc
Michael Zittel
SocialProfiles.us
Monday, 09 December 2013 10:42 AEDT 15'
Tim
BF Quiz Plus 3 Years, BF Survey 12 Months
Hi Michael,
This error indicates that the collation setting on some of your database tables are different, some are using utf8_unicode_ci, whereas others are using IMPLICIT collation. Basically your MySQL doesn't like this, and wants them all to be the same. The tables you'll need to look at are:

jos_bfauction_plus
jos_categories
jos_viewlevels

This can be fixed using phpMyAdmin, which is a tool usually provided by your web host in the CPanel.

Open phpMyAdmin
select your database
select jos_bfauction_plus table
click on the structure tab
Look at the collation column, and see what it is currently set to.
Compare this to jos_categories table, which will probably be different.

You should then be able to change your jos_bfauction_plus to the same collation as your other tables.

For example, if you wanted to change from utf8 to utf8_general_ci collation, you could use an SQL command such as:

ALTER TABLE jos_bfauction_plus CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Let me know if you still have a problem.

regards

Tim
Follow us on twitter http://twitter.com/tamlynsoftware
Monday, 09 December 2013 11:29 AEDT
socialprofilesus
That fixed it. Thanks Tim!

Next question. By default, if a public user visits an auction item, there is warning they need to login to bid. It's a bit ugly. I would like that warning to be shown only if a public user tries to bid...thoughts?
Michael Zittel
SocialProfiles.us
Monday, 09 December 2013 12:06 AEDT 5'
Tim
BF Quiz Plus 3 Years, BF Survey 12 Months
Hi Michael,
To remove that message, just comment out or delete line 143 of /components/com_bfauction_plus/views/bid/tmpl/default.php

echo "<br><a href='".JRoute::_($finalUrl)."'>".JText::_( 'COM_BFAUCTIONPLUS_AUCTION_LOG_IN')."</a><br>";

The bid button is actually hidden to public users, so they physically can't bid.
if($user->id != 0){

regards

Tim
Follow us on twitter http://twitter.com/tamlynsoftware
Monday, 09 December 2013 12:40 AEDT
socialprofilesus
Thank you. You may close this ticket.
Michael Zittel
SocialProfiles.us
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.
Go to top