|
| Technical information |
| Error type | 256 |
| Error description | Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' |
| URL | explodedviews.permobil.com/catpages/drawings_list.php?q=(name~equals~C350%20Base)(Part~equals~Tilt%2045%EF%BF%BD%EF%BF%BD%27 |
| Error file | /home/explodedviewsper/public_html/catpages/connections/Connection.php |
| Error line | 661 |
| SQL query | select `name` from ( SELECT DISTINCT
`drawings`.`id`, `drawings`.`pid`, `drawings`.`sid`, `drawings`.`part_id`, `drawings`.`Part`, `drawings`.`Drawing`, `parts`.`PartNumber`, `parts`.`D365_Poduct_Number`, `parts`.`old_sales_number`, `parts`.`name`, `old_category`.`Category`, `old_category`.`generic`, `parts`.`description`
FROM `drawings`
INNER JOIN `parts` ON `drawings`.`part_id` = parts.part_id
INNER JOIN `old_category` ON `drawings`.`pid` = old_category.id WHERE ( ( ( (1=1) and (upper(parts.name)=upper('C350 Base')) and (upper(drawings.Part)=upper('Tilt 45��')) ) ) ) GROUP BY `drawings`.`sid`,`drawings`.`Drawing` ) a where `name` is not NULL and `name` <> '' GROUP BY `name` |
| #0. |
connections/Connection.php:661 |
trigger_error |
1. Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=';
2. 256; |
| #1. |
connections/Connection.php:661 |
Connection->triggerError |
1. Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='; |
| #2. |
connections/MySQLiConnection.php:142 |
MySQLiConnection->query |
1. select `name` from ( SELECT DISTINCT
`drawings`.`id`, `drawings`.`pid`, `drawings`.`sid`, `drawings`.`part_id`, `drawings`.`Part`, `drawings`.`Drawing`, `parts`.`PartNumber`, `parts`.`D365_Poduct_Num...; |
| #3. |
classes/controls/FilterValuesList.php:208 |
FilterValuesList->addFilterBlocksFromDB |
1. Array
(
)
; |
| #4. |
classes/controls/FilterControl.php:311 |
FilterControl->buildFilterCtrlBlockArray |
1. ListPage_Simple; |
| #5. |
classes/controls/FilterValuesList.php:535 |
FilterValuesList->buildFilterCtrlBlockArray |
1. ListPage_Simple; |
| #6. |
classes/filterpanel.php:65 |
FilterPanel->buildFilterPanel |
N/A |
| #7. |
classes/runnerpage.php:5533 |
RunnerPage->buildFilterPanel |
N/A |
| #8. |
classes/runnerpage.php:1517 |
RunnerPage->init |
N/A |
| #9. |
classes/listpage.php:2403 |
ListPage::createListPage |
1. drawings;
2. Array
(
[pageType] => list
[id] => 1
[flyId] => 0
[mode] => 0
[xt] => XTempl Object
[masterPageType] =>
[masterTable] =>
[masterId] =>
[firstTime] =>
[sortB...; |
| #10. |
drawings_list.php:289 |
Global scope |
N/A |