|
Tiggywiggler
|
Posted Fri 2 Sep 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
Thank you for the update. Glad to hear that you found a solution. Well done Paul for recognising the cause.
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|
|
|
|
shulemj
|
Posted Tue 30 Aug 2016
|
|
Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115,
Visits: 565
|
Update:
All the issues were caused by a bad database setup (see below for details). Once we rebuilt the database, both issues resolved. Thank you both for all your help.
Bad Database Setup
I will detail what went wrong so others can learn what not to do...
We ran the "kartrisSQL_MainData.sql" for initial setup, but then we also tried to run each update script in "\Uploads\Resources\" which totally messed up the database.
Please note that kartrisSQL_MainData.sql has the up-to-date database structure. Thank you Paul for clarifying this.
|
|
|
|
|
shulemj
|
Posted Tue 16 Aug 2016
|
|
Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115,
Visits: 565
|
Wow, so I don't know what to do at this point, and I really don't want to loose my data.
Would it make sense to start anew, with a new database, and then use the datatool to import all my product data?
|
|
|
|
|
Tiggywiggler
|
Posted Tue 16 Aug 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
When you download the latest source code, you get a creation script with it that creates a copy of the latest type of database.
This 'latest type' of database does not have the triggers you have pointed to, so it does not make any sense that you have used the latest database, and you have these triggers. Something else is going on and I don't know what it is.
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|
|
|
|
|
shulemj
|
Posted Tue 16 Aug 2016
|
|
Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115,
Visits: 565
|
That's right. I used the DB included with the download.I think we did the initial DB setup with the DataTool, and then tried to upgrade with the enclosed scripts.
|
|
|
|
|
Tiggywiggler
|
Posted Tue 16 Aug 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
So you did an original download of the source code and setup a new database from scratch? You didn't copy the database from somewhere else?
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|
|
|
|
|
Tiggywiggler
|
Posted Tue 16 Aug 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
So you did an original download of the source code and setup a new database from scratch? You didn't copy the database from somewhere else?
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|
|
|
|
|
shulemj
|
Posted Mon 15 Aug 2016
|
|
Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115,
Visits: 565
|
This is not an upgrade, but an original download from Kartris' website. Does kartris2_9005b1_WPI tell you which version? I think it's v2.9005.
I do remember that during the setup I was instructed to run several SQL scripts from \Uploads\Resources (via the DataTool) and may have received an error on two upgrades.
Does this answer anything?
|
|
|
|
|
Tiggywiggler
|
Posted Mon 15 Aug 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
What version is the DB?
what version of application did you upgrade from? That would be a good thing to know.
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|
|
|
|
|
shulemj
|
Posted Mon 15 Aug 2016
|
|
Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115,
Visits: 565
|
So it appears that our database needs some updating. What is the recommended method to do that while preserving the existing data?
|
|
|
|