Backend Orders table not displaying correctly

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 2.5.28
-- PHP version -- : 5.5.16
-- Browser(s) name and version -- : FF (34.0), CHromium (39)
-- Error-message(debug-mod must be tuned on) -- : JDatabaseMySQL::query: 1253 - COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM lzu_hikashop_order AS b LEFT JOIN lzu_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN lzu_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN lzu_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20

After just applying the update of version 2.3.4, I am unable to make the orders display on the backend. It simply shows the Order page with a page selector for 5 pages (Hikashop obviously know about them)...but the table containing the detail is not shown...the page looks normal, but with 0 orders.

This was the SQL error:
JDatabaseMySQL::query: 1253 - COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM lzu_hikashop_order AS b LEFT JOIN lzu_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN lzu_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN lzu_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20

Maybe a bit of context to help diagnose:

I backed up a version of the website and installed it on a temporary virtual server in order to apply the Hikashop update.
I backup using Virtualmin
I restored using VIrtualmin (on another identical server...there are other webapps using it).
I then applied Hikashop 2.3.4

The collation of the source db is utf8.
The collation of the target db is: utf8.
...according to phpmyadmin

I mention this in relation to the message: 'utf8_general_ci' is not valid for CHARACTER SET 'latin1'
...does the SQL of the Hikashop update explicitly use another collation?

Hello, the fix worked partially.

The backend orders page is displaying (ie: we see the orders table now) but not the Order Numbers column, it is blank.

Debug mode is on and I cannot see an error being generated anywhere..not even in the apache error/access log files.

Is there anything I can do to further debug this problem?

Thanks

Yes I am using Falang. I upgraded to the latest version (1.4.5) and the order numbers were being generated again. Thanks.

But there is still something funky going on.

Some of my products are not displaying anymore, precisely the last 30 or so we entered. If I remove the Canonical URL property they display but if I add a canonical url they simply do not show up inside a category listing page.

Also, my main language is french and the second language is english. And using the language tab in the products detail editing page, I simply CANNOT delete the english canonical url. If I delete the value and save there is no error message...but when I reload the product the last value is always there.

Last question: When I use the language tab to create a language-specific version of the product, the translations are not published inside Falang it seems. They are all listed but the "published" status is red...yet it works for all my previous products.

Thanks

I added four images of what I hope you requested.

1. I do not think the canonical url is invalid, I use a relative url, like: /en/productxxx. Also, the same approach works for 100+ existing products.

2. I am not trying to delete the translation, only the Canonical Url value from the translation. The interface prevents me from doing so.

3. Ok, I enabled those attributes and I will see how that affects existing entries.

Lastly, I cannot delete the "alias" value from the product details page...it seems to be generated automatically. If I go into existing products (which do not have an Alias assigned)...one is automatically generated despite my intentions.

Thanks for your help.

Any chance someone had an idea about this?

Edit: Nicolas, I can send you logon creds, it might be easier. Please let me know.

Hello,
Sorry for the late reply, can you test it with the last Hikashop version by downloading it through our website, and directly installing it.
2. You'll just have to unpublish it .

I believe the bug I was having was from either Falang or Hikashop...or the combination of both with mismatched versions.

I reverted back to a previous version of both and now have my environment stable again. My client's season will end early summer, so I will re-attempt at that point with any updates...

Thanks for the belated reply.

Can you confirm, however, that I stumbled upon a bug?

Hi,

Yes it seemed to be a bug.