Det oppstod en feil

• Q3Webshop\DAO\ServiceException: URL: /verksted-depo/verktoey/-lappesaker/g136.1005.1009 Server response not ok. Status code: 500 Response: {"Message":"An error has occurred.","ExceptionMessage":"42601: syntax error at or near \"UNION\"\r\n\r\nPOSITION: 903","ExceptionType":"Npgsql.PostgresException","StackTrace":" at Npgsql.Internal.NpgsqlConnector.<g__ReadMessageLong|215_0>d.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at Npgsql.NpgsqlDataReader.d__47.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Npgsql.NpgsqlDataReader.NextResult()\r\n at Npgsql.NpgsqlCommand.d__116.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at Npgsql.NpgsqlCommand.d__116.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)\r\n at Quick3CommunicationCommon.QNpgsqlCommand.ExecuteReader(CommandBehavior behavior, String callerName) in E:\\Dev\\Quick3\\Common\\Quick3CommunicationCommon\\NpgsqlConnectionUtils\\QNpgsqlCommand.cs:line 141\r\n at Quick3.DAL.Extensions.PGDBQuery.QueryInternal[T](QNpgsqlConnection connection, String sql, Object param, NpgsqlTransaction transaction, Nullable`1 commandTimeout) in E:\\Dev\\Quick3\\Server\\Quick3.DAL\\Extensions\\PGDBQuery.cs:line 62\r\n at Quick3.DAL.Implementations.PostgreSQL.Webshop.PGWebshopDao.<>c__DisplayClass50_0.b__1(QNpgsqlConnection dbConn) in E:\\Dev\\Quick3\\Server\\Quick3.DAL\\Implementations\\PostgreSQL\\Webshop\\PGWebshopDao.cs:line 1532\r\n at Quick3.DAL.ConnectionManager.<>c__DisplayClass15_0.b__0() in E:\\Dev\\Quick3\\Server\\Quick3.DAL\\ConnectionManager.cs:line 285\r\n at Quick3.DAL.ConnectionManager.<>c__DisplayClass5_0.b__0() in E:\\Dev\\Quick3\\Server\\Quick3.DAL\\ConnectionManager.cs:line 51\r\n at Quick3.DAL.ConnectionManager.TransactionWrapper[T](Func`1 func, Nullable`1 commandTimeout, Boolean useSuperUser) in E:\\Dev\\Quick3\\Server\\Quick3.DAL\\ConnectionManager.cs:line 171\r\n at Quick3.DAL.Implementations.PostgreSQL.Webshop.PGWebshopDao.GetWebshopFilterCollection(Int32[] itemUIDs, WebshopItemSearchArgs args) in E:\\Dev\\Quick3\\Server\\Quick3.DAL\\Implementations\\PostgreSQL\\Webshop\\PGWebshopDao.cs:line 1536\r\n at Quick3.Data.WebShop.Service.WebshopService.GetWebshopFilterCollection(Int32 clientUID, List`1 priceWithItemUIDs, WebshopItemSearchArgs args) in E:\\Dev\\Quick3\\Server\\Quick3.Data\\WebShop\\Service\\WebshopService.cs:line 533\r\n at Quick3WebCommon.WebshopItemFacade.GetWebshopFilterCollection(Int32 clientUID, List`1 priceWithItemUIDs, WebshopItemSearchArgs args) in E:\\Dev\\Quick3\\Web\\Quick3WebCommon\\WebshopItemFacade.cs:line 870\r\n at Quick3Web.Controllers.Apis.ItemController.d__4.MoveNext() in E:\\Dev\\Quick3\\Web\\Quick3Web\\Controllers\\Apis\\Items\\ItemController.cs:line 0\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Threading.Tasks.TaskHelpersExtensions.d__1`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.d__1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ActionFilterResult.d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.d__3.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.d__15.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.d__15.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.AspNet.WebApi.Extensions.Compression.Server.BaseServerCompressionHandler.d__15.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.HttpServer.d__24.MoveNext()"} Data: Array ( [type] => item [q] => [pageIndex] => 0 [pageSize] => 32 [sortBy] => [sortOrder] => [sublisttypeuid] => [sublistitemuid] => [itemgroupuid] => 1009 [itemcode] => Array ( ) [priceparameters] => [focusitemcode] => [includeMasterItems] => true [includeVariantItems] => false [modelSpecUID] => [modelSpecFilterValue] => [showItemFilter] => 1 [itemUIDs] => Array ( ) [customerUID] => ) in C:\inetpub\wwwroot\motorsyklisten\_Plugins\Q3Webshop\_Classes\DAO\class.ServiceAccess.php:152 Stack trace: #0 C:\inetpub\wwwroot\motorsyklisten\_Plugins\Q3Webshop\_Classes\DAO\class.ServiceAccess.php(249): Q3Webshop\DAO\ServiceAccess->throwOnBadStatus('6418ccb4d60e3', 500, '{"Message":"An ...', Array) #1 C:\inetpub\wwwroot\motorsyklisten\_Plugins\Q3Webshop\_Classes\DAO\class.ItemDAO.php(133): Q3Webshop\DAO\ServiceAccess->execute('item/getitemsea...', NULL, Array, Array) #2 C:\inetpub\wwwroot\motorsyklisten\_Plugins\Q3Webshop\_Classes\DAO\class.ItemDAO.php(101): Q3Webshop\DAO\ItemDAO->getFullItemSearchFilter(Object(Q3Webshop\DAO\ItemSearchParams)) #3 C:\inetpub\wwwroot\motorsyklisten\_Plugins\Q3Webshop\_Classes\WebshopData\Classes\class.WsItems.php(211): Q3Webshop\DAO\ItemDAO->search(Object(Q3Webshop\DAO\ItemSearchParams)) #4 C:\inetpub\wwwroot\motorsyklisten\_Plugins\Q3Webshop\_Classes\WebshopData\Classes\class.WsItems.php(86): Q3Webshop\WebshopData\Classes\WsItems::search('itemgroupuid=10...', NULL, NULL, false, false, true) #5 C:\inetpub\wwwroot\motorsyklisten\_Plugins\Q3Webshop\_Classes\class.Q3WebshopData.php(319): Q3Webshop\WebshopData\Classes\WsItems::searchItemsMultiple(Array, true, NULL, NULL, false, false, true) #6 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\templates_c\Q3Webshop\%%E7\E7C\E7C796A8%%itemgrid.tpl.php(93): Q3Webshop\Q3WebshopData->searchItemsMultiple(Array, true, NULL, NULL, false, false, true) #7 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\libs\Smarty.class.php(1888): include('C:\\inetpub\\wwwr...') #8 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\templates_c\Q3Webshop\%%69\69E\69EECD84%%wrapper.tpl.php(14): Smarty->_smarty_include(Array) #9 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\libs\Smarty.class.php(1888): include('C:\\inetpub\\wwwr...') #10 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\templates_c\Q3Webshop\%%69\69E\69EECD84%%wrapper.tpl.php(10): Smarty->_smarty_include(Array) #11 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\libs\Smarty.class.php(1888): include('C:\\inetpub\\wwwr...') #12 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\templates_c\Q3Webshop\%%69\69E\69EECD84%%wrapper.tpl.php(10): Smarty->_smarty_include(Array) #13 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\libs\Smarty.class.php(1888): include('C:\\inetpub\\wwwr...') #14 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\templates_c\Q3Webshop\%%B5\B5B\B5BFC23F%%general.tpl.php(4): Smarty->_smarty_include(Array) #15 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\libs\Smarty.class.php(1888): include('C:\\inetpub\\wwwr...') #16 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\templates_c\Q3Webshop\%%45\45E\45E480CD%%index.tpl.php(132): Smarty->_smarty_include(Array) #17 C:\inetpub\wwwroot\motorsyklisten\_Externals\Smarty2\libs\Smarty.class.php(1262): include('C:\\inetpub\\wwwr...') #18 C:\inetpub\wwwroot\motorsyklisten\index\class.IndexSmarty.php(254): Smarty->fetch('index.tpl', '_Plugins/Q3Webs...') #19 C:\inetpub\wwwroot\motorsyklisten\index\class.IndexSmarty.php(186): IndexSmarty->prepareToDisplayDefault(Object(Smarty), Object(HandlerReply)) #20 C:\inetpub\wwwroot\motorsyklisten\index.php(162): IndexSmarty->prepareContent(Object(Smarty), Object(HandlerReply)) #21 {main}