|
| Technical information |
| Error type | 256 |
| Error description | Source: Microsoft JET Database Engine
Description: Data type mismatch in criteria expression. |
| URL | thelincolnregistry.com/registry/Lincolns_list.php?f=(VINplant~equals~1) |
| Error file | E:\hostingspaces\rotella\thelincolnregistry.com\wwwroot\registry\connections\Connection.php |
| Error line | 668 |
| SQL query | SELECT [ModelYear] AS [adrxywqopv],COUNT( [ModelYear] ) AS [ModelYearTOTAL] FROM ( SELECT
[ID], [VIN], [ModelYear], [SeriesName], [BodyStyle], [Codes], [VINyear], [VINplant], [VINseries], [VINengine], [VINsix], [CodesBody], [CodesColor], [CodesTrim], [CodesDSO], [CodesAxle], [CodesTrans], [Status], [Location], [Significant], [Source], [OwnerName], [OwnerDetails], [OwnerEmail], [SpotterName], [Comments], [HiddentComments], [UnusedExtra], [Image1], [Active], [PVE], [Alert], [Features], [Entered], [LastUpdate], [TrimLevel], [CodesDate], [Username]
FROM [Lincolns] WHERE ( ( ( ( ( ( VINplant = '1' OR VINplant LIKE '%,1' OR VINplant LIKE '1,%' OR VINplant LIKE '%,1,%' ) ) ) ) ) ) ) a WHERE ( NOT ( [ModelYear] is null or [ModelYear] = '' ) ) GROUP BY [ModelYear] |
| #0 |
connections\Connection.php:668 |
Connection->triggerError |
0. Source: Microsoft JET Database Engine
Description: Data type mismatch in criteria expression. |
| #1 |
connections\ADOConnection.php:96 |
ADOConnection->query |
0. SELECT [ModelYear] AS [adrxywqopv],COUNT( [ModelYear] ) AS [ModelYearTOTAL] FROM ( SELECT
[ID], [VIN], [ModelYear], [SeriesName], [BodyStyle], [Codes], [VINyear], [VINplant], [VINseries], [VINengine], [VINsix], [CodesBody], [CodesColor], [CodesTrim], [CodesDSO], [CodesAxle], [CodesTrans], [Status], [Location], [Significant], [Source], [OwnerName], [OwnerDetails], [OwnerEmail], [SpotterName], [Comments], [HiddentComments], [UnusedExtra], [Image1], [Active], [PVE], [Alert], [Features], [Entered], [LastUpdate], [TrimLevel], [CodesDate], [Username]
FROM [Lincolns] WHERE ( ( ( ( ( ( VINplant = '1' OR VINplant LIKE '%,1' OR VINplant LIKE '1,%' OR VINplant LIKE '%,1,%' ) ) ) ) ) ) ) a WHERE ( NOT ( [ModelYear] is null or [ModelYear] = '' ) ) GROUP BY [ModelYear] |
| #2 |
connections\dbfunctions\ODBCFunctions.php:117 |
ODBCFunctions->limitedQuery |
0. ADOConnection
1. SELECT [ModelYear] AS [adrxywqopv],COUNT( [ModelYear] ) AS [ModelYearTOTAL] FROM ( SELECT
[ID], [VIN], [ModelYear], [SeriesName], [BodyStyle], [Codes], [VINyear], [VINplant], [VINseries], [VINengine], [VINsix], [CodesBody], [CodesColor], [CodesTrim], [CodesDSO], [CodesAxle], [CodesTrans], [Status], [Location], [Significant], [Source], [OwnerName], [OwnerDetails], [OwnerEmail], [SpotterName], [Comments], [HiddentComments], [UnusedExtra], [Image1], [Active], [PVE], [Alert], [Features], [Entered], [LastUpdate], [TrimLevel], [CodesDate], [Username]
FROM [Lincolns] WHERE ( ( ( ( ( ( VINplant = '1' OR VINplant LIKE '%,1' OR VINplant LIKE '1,%' OR VINplant LIKE '%,1,%' ) ) ) ) ) ) ) a WHERE ( NOT ( [ModelYear] is null or [ModelYear] = '' ) ) GROUP BY [ModelYear]
2. 0
3. -1
4. 1 |
| #3 |
connections\Connection.php:608 |
Connection->limitedQuery |
0. SELECT [ModelYear] AS [adrxywqopv],COUNT( [ModelYear] ) AS [ModelYearTOTAL] FROM ( SELECT
[ID], [VIN], [ModelYear], [SeriesName], [BodyStyle], [Codes], [VINyear], [VINplant], [VINseries], [VINengine], [VINsix], [CodesBody], [CodesColor], [CodesTrim], [CodesDSO], [CodesAxle], [CodesTrans], [Status], [Location], [Significant], [Source], [OwnerName], [OwnerDetails], [OwnerEmail], [SpotterName], [Comments], [HiddentComments], [UnusedExtra], [Image1], [Active], [PVE], [Alert], [Features], [Entered], [LastUpdate], [TrimLevel], [CodesDate], [Username]
FROM [Lincolns] WHERE ( ( ( ( ( ( VINplant = '1' OR VINplant LIKE '%,1' OR VINplant LIKE '1,%' OR VINplant LIKE '%,1,%' ) ) ) ) ) ) ) a WHERE ( NOT ( [ModelYear] is null or [ModelYear] = '' ) ) GROUP BY [ModelYear]
1. 0
2. -1
3. 1 |
| #4 |
classes\datasource\table.php:829 |
DataSourceTable->getTotals |
0. DsCommand |
| #5 |
classes\controls\FilterValuesList.php:253 |
FilterValuesList->addFilterBlocksFromDB |
0. Array
(
)
|
| #6 |
classes\controls\FilterControl.php:216 |
FilterControl->buildFilterCtrlBlockArray |
0. ListPage_Simple |
| #7 |
classes\controls\FilterValuesList.php:602 |
FilterValuesList->buildFilterCtrlBlockArray |
0. ListPage_Simple |
| #8 |
classes\filterpanel.php:70 |
FilterPanel->buildFilterPanel |
N/A |
| #9 |
classes\runnerpage.php:5487 |
RunnerPage->buildFilterPanel |
N/A |
| #10 |
classes\runnerpage.php:1649 |
RunnerPage->init |
N/A |
| #11 |
classes\listpage.php:2494 |
ListPage::createListPage |
0. Lincolns
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] =>
)
|
| #12 |
Lincolns_list.php:135 |
Global scope |
N/A |