Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
 All Forums
 Technical
 Getting Started and Pre-Sales
 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

41803 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

41803 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

41803 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 »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.03 seconds. Snitz Forums 2000