|
| Teknisk information |
| Feltyp | 256 |
| Felbeskrivning | Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation '=' |
| URL | sovain.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å rad | 668 |
| SQL-fråga | SELECT 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 |
| #0 |
connections/Connection.php:668 |
Connection->triggerError |
0. Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation '=' |
| #1 |
connections/MySQLiConnection.php:173 |
MySQLiConnection->query |
0. SELECT 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 |
| #2 |
connections/dbfunctions/MySQLFunctions.php:130 |
MySQLFunctions->limitedQuery |
0. MySQLiConnection
1. SELECT 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
2. 0
3. -1
4. 1 |
| #3 |
connections/Connection.php:608 |
Connection->limitedQuery |
0. SELECT 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
1. 0
2. -1
3. 1 |
| #4 |
classes/datasource/table.php:829 |
DataSourceTable->getTotals |
0. DsCommand |
| #5 |
classes/controls/FilterIntervalList.php:97 |
FilterIntervalList->addFilterBlocksFromDB |
0. Array
(
)
|
| #6 |
classes/controls/FilterControl.php:216 |
FilterControl->buildFilterCtrlBlockArray |
0. ListPage_Simple |
| #7 |
classes/filterpanel.php:70 |
FilterPanel->buildFilterPanel |
N/A |
| #8 |
classes/runnerpage.php:5487 |
RunnerPage->buildFilterPanel |
N/A |
| #9 |
classes/runnerpage.php:1649 |
RunnerPage->init |
N/A |
| #10 |
classes/listpage.php:2499 |
ListPage::createListPage |
0. Krukor Alla
1. Array
(
[pageName] =>
[pageType] => list
[id] => 1
[flyId] => 0
[mode] => 0
[xt] => XTempl Object
[firstTime] =>
[sortBy] =>
[requestGoto] => 0
[masterPageType] =>
[masterPage] =>
[masterId] =>
[masterTable] =>
[dashElementName] =>
[dashTName] =>
[dashPage] =>
)
|
| #11 |
krukor_alla_list.php:135 |
Global scope |
N/A |