update sqlservertables

Author	« Topic »
wrtoll Ecommerce Template Expert USA 764 Posts Pre-sales questions only (More Details...)	Posted - 10/28/2021 : 11:03:07 Hi I am trying to install the Premium Generic version and I have database on Sql server which was version 7.1 The Premium Generic is on 7.3 I run updatestore and it fails with error :processing table :abandoncartemail"(this is using the sqlservertanles add on I paid for) I can log into to the website but orders show ,but no catefories or prooducts Any ideas Thanks Warren
Vince Administrator 42789 Posts	Posted - 10/28/2021 : 13:06:14 Hi Warren Can you use the v7.1 version of the SQL Server Creation script to upsize your Access database and then use the regular updater from here to take it up to v7.3... https://www.ecommercetemplates.com/updaters.asp Or, if you don't have any products, categories, etc defined yet in your database then just use the v7.3 version directly and don't upsize and then a default database will be created with just the sample products. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
wrtoll Ecommerce Template Expert USA 764 Posts Pre-sales questions only (More Details...)	Posted - 10/28/2021 : 13:49:20 Hi I dont have a access database I only have a microsoft sql database And I am trying to use the sql database tools that I purchases from you to update it to the new structure I restore my sql database and connect to the database and then run the update store sql tables tool that I got from and it gives this error after I click on Install Ecommerce plus version 7.1 I get this error processing table:abandonedcartemail An error orrcured on the server while processing this url
Vince Administrator 42789 Posts	Posted - 10/28/2021 : 14:01:28 Hi Warren Just get the v7.3 updater from here... https://www.ecommercetemplates.com/updaters.asp ...and just run the updatestore.asp file from that, and that will put your SQL Server database on the same version as the template files. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
wrtoll Ecommerce Template Expert USA 764 Posts Pre-sales questions only (More Details...)	Posted - 10/28/2021 : 14:03:52 We are trying that and it gives us the url error
wrtoll Ecommerce Template Expert USA 764 Posts Pre-sales questions only (More Details...)	Posted - 10/28/2021 : 14:09:20 Click the Upgrade to Version xxx button and you will see the database being updated. On completion you should see a "Success" message and the page will refresh. We only see 3 buttons Install to V7.1 all we see Is there meant to be an upgrade button.We only see an 1)install Ecommerce plusto v7.1 2)Install v7.1 and wipe 3)Do not create basis structure Is there meant to be an upgrade option? I dont see it
wrtoll Ecommerce Template Expert USA 764 Posts Pre-sales questions only (More Details...)	Posted - 10/28/2021 : 14:10:39 My programmer says he can see the code ,but its not showing up No upgrade option
Vince Administrator 42789 Posts	Posted - 10/28/2021 : 14:11:54 Hi Warren Forget the SQL Server Tables, just get the updater from here... https://www.ecommercetemplates.com/updaters.asp Then unzip that and use the updatestore.asp in that to update your database. Don't use the SQL Server Tables updatestore.asp script at all. If you see the 3 options you detailed above you have the wrong updatestore.asp script. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
wrtoll Ecommerce Template Expert USA 764 Posts Pre-sales questions only (More Details...)	Posted - 10/28/2021 : 14:15:53 My database is 7.1.1 What version do I download? Can I try the 7.44
wrtoll Ecommerce Template Expert USA 764 Posts Pre-sales questions only (More Details...)	Posted - 10/28/2021 : 14:22:26 I am only show 3 files
wrtoll Ecommerce Template Expert USA 764 Posts Pre-sales questions only (More Details...)	Posted - 10/28/2021 : 14:30:56 Weird it works now If we go to www.test.com it shows only 3 options If we go to localhost it shows the newer 7.4.4 option Thank you Warren
	« Topic »