I upgraded ecommerce from version 3 to version 4 and got the following error.
Update #5401

* Failed: ALTER TABLE {ec_cart} ALTER COLUMN cookie_id TYPE VARCHAR(40)

CommentFileSizeAuthor
#2 counter_pgsql.patch1.61 KBiktaka

Comments

balagurumoorthy’s picture

balagurumoorthy commented

Quick Fix for the above, i ran the query manually as given below.

ALTER TABLE ec_cart modify COLUMN cookie_id VARCHAR(40);

iktaka’s picture

iktaka commented
Project: e-Commerce » Counter
Version: 5.x-4.1-alpha10 » 6.x-1.2
Component: cart » Code
Status: Active » Needs review
StatusFileSize
new counter_pgsql.patch1.61 KB

The 6.x-1.2 code doesn't work with postgresql.
some SQLs are MySQL based code.
I've fixed them in oreder to work with posegresql.
I've tested with postgresql 8.1.11 (CentOS 5.2 version).

drupalnesia’s picture

drupalnesia commented
Status: Needs review » Closed (fixed)

Counter 6.x-1.4 has used Drupal 6 new Database schema. Now, all database supported by Drupal automatically works, thanks to new D6 database schema!
Enjoy Counter 6.x-1.4