php ett fel uppstod

Teknisk information
Feltyp256
FelbeskrivningIllegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation '='
URLsovain.se/produkter/krukor_alla_list.php?f=(Form~equals~Rektangul%EF%BF%BD%EF%BF%BDr)
Fel i fil/var/www/sovain.se/public_html/produkter/connections/Connection.php
Fel på rad668
SQL-frågaSELECT COUNT( ( CASE WHEN ( NOT ( `Ljus Maximum` < 'Direkt sol' ) ) and ( NOT ( `Ljus Maximum` > 'Direkt sol' ) ) THEN 1 ELSE NULL END ) ) AS `Ljus Maximum1_count`,COUNT( ( CASE WHEN ( NOT ( `Ljus Maximum` < 'Sol' ) ) and ( NOT ( `Ljus Maximum` > 'Sol' ) ) THEN 1 ELSE NULL END ) ) AS `Ljus Maximum2_count`,COUNT( ( CASE WHEN ( NOT ( `Ljus Maximum` < 'Ljusl' ) ) and ( NOT ( `Ljus Maximum` > 'Ljus' ) ) THEN 1 ELSE NULL END ) ) AS `Ljus Maximum3_count`,COUNT( ( CASE WHEN ( NOT ( `Ljus Maximum` < 'Halvskugga' ) ) and ( NOT ( `Ljus Maximum` > 'Halvskugga' ) ) THEN 1 ELSE NULL END ) ) AS `Ljus Maximum4_count`,COUNT( ( CASE WHEN ( NOT ( `Ljus Maximum` < 'Skugga' ) ) and ( NOT ( `Ljus Maximum` > 'Skugga' ) ) THEN 1 ELSE NULL END ) ) AS `Ljus Maximum5_count` FROM ( SELECT `Sovain`.`Art. Nr.`, `Sovain`.`Beskrivning`, `Sovain`.`Visma`, `Sovain`.`Storlek`, `Sovain`.`Svenskt namn`, `Sovain`.`Ursprung`, `Sovain`.`Ø`, `Sovain`.`L`, `Sovain`.`B`, `Sovain`.`H`, `Sovain`.`Vikt`, `Sovain`.`Antal/kartong`, `Sovain`.`Enhet`, `Sovain`.`Produktgrupp`, `Sovain`.`Serie`, `Sovain`.`Färg`, `Sovain`.`Placering`, `Sovain`.`Form`, `Sovain`.`Material`, `Sovain`.`Struktur`, `Sovain`.`Finish`, `Sovain`.`Ny`, `Sovain`.`Ny Datum`, `Sovain`.`Visa`, `Sovain`.`UV Beständig`, `Sovain`.`Vattentät`, `Sovain`.`Frostsäker`, `Sovain`.`Återvunnen`, `Sovain`.`Vatten`, `Sovain`.`Ljus`, `Sovain`.`Ljus Minimum`, `Sovain`.`Ljus Maximum`, `Sovain`.`Bild`, `Sovain`.`Lagersaldo Leverantör`, `Sovain`.`Lagersaldo Ny`, `Sovain`.`Lagersaldo Begagnad`, `Sovain_Tekst`.`Tekst`, `Sovain4`.`Visma` as `inklusive`, `Sovain`.`Färggrupp`, `Sovain1`.`Art. Nr.` as `Art. Nr.1`, `Sovain1`.`Visma` as `Visma1`, `Sovain1`.`Bild` as `Bild1`, `Sovain2`.`Art. Nr.` as `Art. Nr.2`, `Sovain2`.`Visma` as `Visma2`, `Sovain2`.`Bild` as `Bild2`, `Sovain3`.`Art. Nr.` as `Art. Nr.3`, `Sovain3`.`Visma` as `Visma3`, `Sovain3`.`Bild` as `Bild3` FROM `Sovain` LEFT OUTER JOIN `Sovain_Tekst` ON Sovain_Tekst.ID = Sovain.`Text ID` LEFT OUTER JOIN `Sovain` `Sovain1` ON Sovain1.`Art. Nr.` = Sovain.`Tillbehör1` LEFT OUTER JOIN `Sovain` `Sovain2` ON Sovain2.`Art. Nr.` = Sovain.`Tillbehör2` LEFT OUTER JOIN `Sovain` `Sovain3` ON Sovain3.`Art. Nr.` = Sovain.`Tillbehör3` LEFT OUTER JOIN `Sovain` `Sovain4` ON Sovain4.`Art. Nr.` = Sovain.Bevattningssystem WHERE ( ( ( ( ( Sovain.Form='Rektangul��r' ) ) ) ) ) and ( (Sovain.Produktgrupp Like"Krukor%") AND (Sovain.Visa ="Ja") ) ) a

More info