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
Strange error. It looks like that the column "customer" has utf8_mb4. I just tested this select of the query on my system
`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"
I don't understand the problem :-\
Can't attach the database - says upload folder is full.
Edit by Milbo (link removed)
Any ideas?
VM store is not functioning...
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.
I am experiencing this same issue...but for the life of me, i cannot decipher what the fix is. I would appreciate any assistance.
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...
Please update also to vm3.2.2, I tried to make it more flexible.