X-Cart forums

[Jon]

Originally Posted by RobertMallett

While waiting for an official upgrade path I've been checking DB changes from 4.4.4 (our current version) to 4.5.0. I'd be glad to have others' eyes on these in case I've missed something important.

NB - Our DB tables all start 'xcart'. Yours may start with (for example) your directory name (for instance, 'shop')or something else you chose at installation.

-- BEGINS --

REQUIRED DATABASE CHANGES

A. Database COLLATION changed from 'latin1_swedish_ci'... to 'utf8_general_ci'


B. Changes to TABLE: 'xcart_products'

1. Four COLUMNS removed and placed instead in new TABLE: 'xcart_products_lng_en' [with index 'productid' at COLUMN 1, duplicated from 'xcart_products']

COL NAME
--- ----
3. 'product'
8. 'desc'
9. 'fulldesc'
29. 'keywords'
[reducing COLUMN count to 31]

2. Addition to 'xcart_products': new COLUMN

COL NAME
--- ----
32. 'taxcloud_tic'


C. Changes to TABLE: 'xcart_products_lng'

a. TABLE renamed to: 'xcart_products_lng_en'
b. COLUMN 'code' removed at position 1


D. New empty TABLES created, modelled on schema of 'xcart_products_lng_en'

a. 'xcart_products_lng_de'
b. 'xcart_products_lng_fr'
c. 'xcart_products_lng_sv'

E. Changes to TABLE: customers

Removal of six COLUMNS relating to retained credit card information:

COL NAME
--- ----
13. 'card_name'
14. 'card_type'
15. 'card_number'
16. 'card_expire'
17. 'card_cvv2'
18. 'card_valid_from'
19. 'card_issue_no'

-- ENDS --

Some other changes too including:

All the tables and columns will need charset changed.

"sessionid" is renamed to "sessid" throughout database with a varchar of 32.

data_type column in xcart_import_cache has been changed.

product, descr, keywords and fulldescr removed from xcart_products, taxcloud_tic added

xcart_taxcloud_cache table added

Many language variables have been added and/or removed.

Many cc processors have been removed.

Of course the version config value is different.

Many config values removed/added/changed.

xcart_language_codes all changed to UTF-8

New taxcloud module in xcart_modules

Many xcart_payment_methods add/changed/removed.

Many xcart_shipping values added/removed/changed.

USPS values in xcart_shipping_options changed.

[ADDISON]

With so many changes in DB structure is it a good idea to update from 4.x.x to 4.5.0?

[cflsystems]

4.4.5 to 4.5.x db changes are not that many actually and very simple and easy to apply. Any other version prior to 4.4.x will need more work but then you already have all the tools to convert it to 4.4.5 so not so bad idea. The issue right now (if you can call it an issue) is that 4.5.0 is not ready to be live yet in my opinion but 4.5.1 will be if QT don't try to introduce anything new in it but just fixes 4.5.0 bugs. Other than that I actually think a move to 4.5.x will be smart thing to do taking into account the payment restrictions implemented there. And 4.5.x is not that different form 4.4.5 so... But we need to stop there and get to XC5 ....

[cflsystems]

Admin -> Settings -> General settings

Since all CC manual and onsite processing is taken out of 4.5.x section "Payment options" should not be there at all and any php code related to it should be stripped out BUT it is not

[cflsystems]

Admin -> Maintenance

Section "Remove credit card information" should not be there at all and all coding related to it removed from the cart - XC does not store CC info anymore so this section is useless

[cflsystems]

This bug - http://forum.x-cart.com/showpost.php?p=312994&postcount=202 - still exists on 4.5.0

[ADDISON]

I don't understand why is this happening. Something reported as bug and fixed should not be again a problem in future versions. It is possible QT to have their own list of fixes, separated from Bugtracker. This is the only way I accept it seeing such situations. And it is not the only one, there are many of them.

Originally Posted by cflsystems

This bug - http://forum.x-cart.com/showpost.php?p=312994&postcount=202 - still exists on 4.5.0

[rocky]

Originally Posted by cflsystems

Admin -> Settings -> General settings

Since all CC manual and onsite processing is taken out of 4.5.x section "Payment options" should not be there at all and any php code related to it should be stripped out BUT it is not

Originally Posted by cflsystems

Admin -> Maintenance

Section "Remove credit card information" should not be there at all and all coding related to it removed from the cart - XC does not store CC info anymore so this section is useless

Thank you for your reports. I've forwarded them to our maintenance team.

Originally Posted by cflsystems

This bug - http://forum.x-cart.com/showpost.php...&postcount=202 - still exists on 4.5.0

This issue is under consideration of our maintenance engineers.

[james elliott]

I find it totally insane that a business releases a product that they assure people is totally ready for live production...

Then use this forum to feed them your free info on the bugs that it may or may not have. Yet if you ask them a simple question pertaining to this half done version they want me to pay them $99.00 .. How can you justify asking me for $99 for something that is so flawed that you have to come here to even find out what flaws you missed..


I give them credit for taking advantage of suckers like us...

[totaltec]

Originally Posted by james elliott

I find it totally insane that a business releases a product that they assure people is totally ready for live production...

Whoa, no need to react that strongly. Here we have a team that releases updates for free.

There are other platforms out there that charge annually for updates, and their releases are hardly "bug-free". You show me a team that provides free lifetime upgrades, and completely bug free releases. That simply doesn't exist, with open-source or paid software. At least in my experience.

QT does an excellent job, even releasing patches and fixes for older versions of their cart. Thanks guys, keep it coming.