Version 7.4.7 crashing site

Author	« Topic »
Marshall Ecommerce Template Guru USA 1875 Posts	Posted - 03/09/2022 : 06:39:25 Tried updating site to v7.4.7 from v7.4.6. No files are modified and has only one add-on, DLSS CSV download. Server Microsoft-IIS/10.0, with VBScript 5.8 and using Access database with only 69 defined products. After updating, everything seemed to work fine but products.asp and proddetail.asp which returned 500 errors. Long story short, thinking a file may not have been over-written, deleted all ECT files from server and uploaded everything new (v7.4.7). This resulted in the entire site, including admin, returning either 404 or 500 errors: 404 ERRORS GET / - HTTP/1.1 500 ERRORS GET /industrial-matting.asp \|180\|80040e14\|Incorrect_syntax_near_'#'. HTTP/2.0 GET /vsadmin/admin.asp \|180\|80040e14\|Incorrect_syntax_near_'#'. HTTP/2.0 GET /commercial-kitchen-mats.asp \|542\|80040e14\|Incorrect_syntax_near_'.'. HTTP/1.0 GET /Switchboard_Matting prod=Switchboard_Matting\|2024\|80040e14\|Incorrect_syntax_near_'#'. HTTP/1.0 GET /Diamond_Switchboard_Matting prod=Diamond_Switchboard_Matting\|14\|ASP_0126\|Include_file_not_found HTTP/1.0 GET /vsadmin/ajaxservice.asp action=dashboard\|1264\|80040e14\|Incorrect_syntax_near_'#'. HTTP/2.0 GET /vsadmin/adminorders.asp id=837\|781\|80040e14\|Incorrect_syntax_near_'#'. HTTP/2.0 ServeLink believes it is an ECT script issue, but used same files to update another site without any problem. I restored v7.4.6 and everything is fine. I cannot seem to identify the problem. Any help appreciated. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
Vince Administrator 42488 Posts	Posted - 03/09/2022 : 07:09:17 Hi Marshall Most of those errors are the same... Incorrect_syntax_near_'#' MS Access would require a # for date values where SQL Server would require single quotes so could it possibly be that this site isn't really using MS Access? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
insight ECT Moderator USA 4476 Posts	Posted - 03/09/2022 : 07:55:55 quote: ServeLink believes it is an ECT script issue That isn't quite what we said yesterday . What we said was this is what you will get if you are running a MS SQL Server database (which you are, it's not Access) and don't have sqlserver=true set in your includes file. Currently you do have that set, but you also don't currently have any errors and obviously I can't see what the includes file looked like at the time that you did. Only if you have sqlserver=true set and still have errors is there a possibility that a date format bug got introduced between 7.4.6 and 7.4.7 (pretty unlikely). The other site you mentioned does run with an Access database, so that isn't going to see the same error, even using the same files. Hope that helps . Peter Professional ecommerce web hosting services Shared hosting Windows & Linux \| Dedicated servers \| Domains \| SSL Ecommerce Templates specialists since 2003 https://servelink.com
Marshall Ecommerce Template Guru USA 1875 Posts	Posted - 03/09/2022 : 08:37:55 Peter, the site I am referring to is industrialXXXX.xxx which does run access. The client's other site runs SQL. It is industrialXXXX.xxx that is having the problem updating to v7.4.7. I have not tried to update his other site which is still on v7.4.6. [edit] The db connection is sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\www\industrialXXXX.xxx\data\XXXXXXXXXXXX.mdb;" [/edit] Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com Edited by - Marshall on 03/09/2022 08:42:28
insight ECT Moderator USA 4476 Posts	Posted - 03/09/2022 : 10:13:51 Both of those customer sites use Microsoft SQL Server thus they need "sqlserver=true" or they will error out. We actually did the conversion for him on them in 2019 for better speed and resilience. Not sure where you are seeing an Access connection string, but the ones on the server are definitely MSOLEDBSQL, that's the first thing we checked, and there are no Access databases present. Peter Professional ecommerce web hosting services Shared hosting Windows & Linux \| Dedicated servers \| Domains \| SSL Ecommerce Templates specialists since 2003 https://servelink.com
Marshall Ecommerce Template Guru USA 1875 Posts	Posted - 03/10/2022 : 05:42:18 Got the database issue squared away, it is SQL. Still does not explain why v7.4.6 works and 7.4.7 is causing errors. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
Vince Administrator 42488 Posts	Posted - 03/10/2022 : 06:05:32 Hi Marshall Is it possible that when upload the changes for the updater your changed the includes.asp file removing the sqlserver=TRUE parameter? Could you double check that this parameter is there as that is just the sort of error I would expect if it were missing. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
Marshall Ecommerce Template Guru USA 1875 Posts	Posted - 03/10/2022 : 11:17:24 The parameter is there. I am going to do a fresh upload either tonight or tomorrow. Let you know how it goes. Marshall CENLYT Productions - ms designs Affordable Web Design Custom Ecommerce Designs Responsive Websites Cenlyt.com
	« Topic »