| ¢éÍÁÙÅ´éҹ෤¹Ô¤ |
»ÃÐàÀ·¢éͼԴ¾ÅÒ´ | 256 |
ÃÒÂÅÐàÍÕ´¢éͼԴ¾ÅÒ´ | 207 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'cat_desc'. 207 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'group_desc'. 207 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'warehouse_desc'.
|
URL | service.xovic.com/partxovic/part_search_v_list.php? |
ä¿Åì¼Ô´¾ÅÒ´ | C:\AppServ\www\partxovic\connections\Connection.php |
ºÃ÷Ѵ¼Ô´¾ÅÒ´ | 626 |
¤é¹ËÒ SQL | SELECT [partgrp] AS [a8gxnwuo5f] FROM ( SELECT
[partno], [warehouse_no], [partgrp], [part_type], [partname_t], [brand], [model], [balance], [price], [supplier], [groupid], [category], [cat_desc], [group_desc], [warehouse_desc], [staff]
FROM [dbo].[part_search_v] ) a WHERE ( NOT ( [partgrp] is null or [partgrp] = '' ) ) GROUP BY [partgrp] |
#0. |
connections\Connection.php:626 |
trigger_error |
1. 207 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'cat_desc'. 207 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'group_desc'. 207 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'warehouse_desc'. ; 2. 256; |
#1. |
connections\Connection.php:626 |
Connection->triggerError |
1. 207 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'cat_desc'. 207 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'group_desc'. 207 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'warehouse_desc'. ; |
#2. |
connections\MSSQLSrvConnection.php:52 |
MSSQLSrvConnection->triggerErrorMSSQL |
N/A |
#3. |
connections\MSSQLSrvConnection.php:91 |
MSSQLSrvConnection->query |
1. SELECT [partgrp] AS [a8gxnwuo5f] FROM ( SELECT
[partno], [warehouse_no], [partgrp], [part_type], [partname_t], [brand], [model], [balance], [price], [supplier], [groupid], [category], [cat_desc], [group_desc], [warehouse_desc], [staff]
FROM [dbo].[part_search_v] ) a WHERE ( NOT ( [partgrp] is null or [partgrp] = '' ) ) GROUP BY [partgrp]; |
#4. |
connections\dbfunctions\MSSQLFunctions.php:115 |
MSSQLFunctions->limitedQuery |
1. MSSQLSrvConnection; 2. SELECT [partgrp] AS [a8gxnwuo5f] FROM ( SELECT
[partno], [warehouse_no], [partgrp], [part_type], [partname_t], [brand], [model], [balance], [price], [supplier], [groupid], [category], [cat_desc], [group_desc], [warehouse_desc], [staff]
FROM [dbo].[part_search_v] ) a WHERE ( NOT ( [partgrp] is null or [partgrp] = '' ) ) GROUP BY [partgrp]; 3. 0; 4. -1; 5. 1; |
#5. |
connections\Connection.php:566 |
Connection->limitedQuery |
1. SELECT [partgrp] AS [a8gxnwuo5f] FROM ( SELECT
[partno], [warehouse_no], [partgrp], [part_type], [partname_t], [brand], [model], [balance], [price], [supplier], [groupid], [category], [cat_desc], [group_desc], [warehouse_desc], [staff]
FROM [dbo].[part_search_v] ) a WHERE ( NOT ( [partgrp] is null or [partgrp] = '' ) ) GROUP BY [partgrp]; 2. 0; 3. -1; 4. 1; |
#6. |
classes\datasource\table.php:758 |
DataSourceTable->getTotals |
1. DsCommand; |
#7. |
classes\controls\FilterValuesList.php:268 |
FilterValuesList->addFilterBlocksFromDB |
1. Array
(
)
; |
#8. |
classes\controls\FilterControl.php:304 |
FilterControl->buildFilterCtrlBlockArray |
1. ListPage_Simple; |
#9. |
classes\controls\FilterValuesList.php:617 |
FilterValuesList->buildFilterCtrlBlockArray |
1. ListPage_Simple; |
#10. |
classes\filterpanel.php:70 |
FilterPanel->buildFilterPanel |
N/A |
#11. |
classes\runnerpage.php:5525 |
RunnerPage->buildFilterPanel |
N/A |
#12. |
classes\runnerpage.php:1647 |
RunnerPage->init |
N/A |
#13. |
classes\listpage.php:2565 |
ListPage::createListPage |
1. dbo.part_search_v; 2. Array
(
[pageName] =>
[pageType] => list
[id] => 1
[flyId] => 0
[mode] => 0
[xt] => XTempl Object
[firstTime] =>
[sortBy] =>
[masterPageType] =>
[masterPage] =>
[masterId] =>
[masterTable] =>
[dashElementName] =>
[dashTName] =>
)
; |
#14. |
part_search_v_list.php:126 |
Global scope |
N/A |