1253 error

[garikello]

Hi,

I have 1253 error, when I try to look at the product in front end.
I have it in all three site languages...

No idea what caused it. Most obviously it was after some update, but I lost a track of which one was that.

Screenshot below:
http://screencast.com/t/gp8frYl08
______________________________
Joomla! 3.6.4 Stable
VirtueMart 3.0.18

[Milbo]

Strange error. It looks like that the column "customer" has utf8_mb4. I just tested this select of the query on my system

Code Select Expand


`u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name` COLLATE utf8mb4_unicode_ci, `pr`.`customer` COLLATE utf8_unicode_ci) AS customer

The reason is that joomla converts the tables to utf8mb4, but in your case it looks like that the vm table has also utf8_mb4. Btw, a screenshot is hard to copy/paste :-). A copy of the sql would be good.
One solution is just to set the right collation for "customer"

[garikello]

I don't understand the problem 

Can't attach the database - says upload folder is full.
Edit by Milbo (link removed)

[garikello]

Any ideas?
VM store is not functioning...

[Milbo]

In general I think that your mysql default charset is set to utf8_mb4. I think you need to change the default charset (a mysql command) and delete all tables and start from scratch. Or you convert the tables. But that is quite hard.

[Supa]

I am experiencing this same issue...but for the life of me, i cannot decipher what the fix is. I would appreciate any assistance.

[garikello]

I haven't solved this.
I suspect that this is caused by server configuration.  It is windows server.

I will transfer website to Apache server to see if the different server will make any impact on page...

[Milbo]

Please update also to vm3.2.2, I tried to make it more flexible.