News:

Support the VirtueMart project and become a member

Main Menu

1253 error

Started by garikello, November 02, 2016, 21:09:47 PM

Previous topic - Next topic

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

`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"
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

garikello

#2
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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/