Multiple Admin SQL Server errors

Author	« Topic »
Marshall Ecommerce Template Guru USA 1984 Posts Pre-sales questions only (More Details...)	Posted - 11/03/2017 : 12:26:02 I updated a site to v6.8.1 running an SQL database. Getting two errors in the admin. First, when searching "stock assigned" in categories, the result is [code]Microsoft OLE DB Provider for SQL Server error '80040e57' Arithmetic overflow error converting expression to data type int. /vsadmin-v681-nomods/inc/inccats.asp, line 1058[/code] It may be relevant that Stock Management is being used an some levels are set at 999,999,999 and the are over 2,500 products. Second, when trying to create a Text Option under Product Options, the result is [code]Microsoft OLE DB Provider for SQL Server error '80040e14' Unclosed quotation mark after the character string ',0)'. /vsadmin-v681-nomods/inc/incfunctions.asp, line 2324[/code] While the site has several modified files, the admin folder being used for the tests contains all unmodified ECT files. Any help will be appreciated. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
Marshall Ecommerce Template Guru USA 1984 Posts Pre-sales questions only (More Details...)	Posted - 11/03/2017 : 13:56:18 Apparently, the no-mode copy was not uploaded. I just did that and am getting this error under sort actual order [code]Microsoft OLE DB Provider for SQL Server error '80040e57' Arithmetic overflow error converting expression to data type int. /vsadmin-v681-nomods/inc/inccats.asp, line 1135[/code] And this error when sort by stock assigned [code]Microsoft OLE DB Provider for SQL Server error '80040e57' Arithmetic overflow error converting expression to data type int. /vsadmin-v681-nomods/inc/inccats.asp, line 1056[/code] Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
Sinbad ECT Moderator USA 65942 Posts	Posted - 11/03/2017 : 14:40:18 Hi Marshall, can you let us know what version of php is running on the server. Winners never quit, quitters never win CSS and Responsive Designs User Manual for Ecommerce Templates
Marshall Ecommerce Template Guru USA 1984 Posts Pre-sales questions only (More Details...)	Posted - 11/03/2017 : 16:32:42 Will have to look into that. But in case there is confusion, it is an ASP site using and SQL database. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
Andy ECT Moderator 95440 Posts	Posted - 11/04/2017 : 00:38:13 I just tried the various sort orders in the categories admin page on my demo store and don't see any problems Line 1056 of inccats.asp is rsCats.CacheSize=admincatsperpage With 2500 products I don't suppose you've got a massive number of categories, do you? Andy Please feel free to review / rate our software
Marshall Ecommerce Template Guru USA 1984 Posts Pre-sales questions only (More Details...)	Posted - 11/04/2017 : 03:14:56 114 categories approximately. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
	« Topic »