Q3Webshop\DAO\ServiceException:
URL: /utstyr/fritidstoey/-sekk/g3520.924.3729
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] => 3729
[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('6418d67c72356', 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=37...', 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}