Help with ecommerce 5.05
Hi. I have tried to read most of the postings relating to ecommerce stability and installation but I'm still baffled with my being a newcomer to openacs framework.
But I must admit that openacs, even though it has a steep learning curve, appears
to be quite intelligent in many respects; one of them being the data model and
separation of programmer and presentation part.
There is one client interested in installing an ecommerce site and i was asked to
provide support. From the postings, I have seen that ecommerce module is in some
sort of transition; anyway I downloaded openacs-5.3.0b1, postgres 8.1.3 and aolserver 4.0 and I followed the installation procedures. Everything works great and I was
able to download from cvs.openacs.org some packages like Edit-This-Page and install it without problems. The only problem I faced was a server error when i tried to install
from repository(http://localhost:8000/acs-admin/install/) Seems like repository 5-3 does not exist. Before installing openacs-5.3.0b1, I installed and tested openacs-5.2.3
and i was able to install from repository without problems except that ecommerce module was not available
Now for the ecommerce part. I downloaded from cvs the ecommerce module (5.05) and tried to install
it but installation failed. I peaked at the log and this is what I saw:
part of log file:
-------
[13/Dec/2006:15:23:25][6587.1091087280][-conn:service0::3] Notice: CREATE FUNCTION
[13/Dec/2006:15:23:25][6587.1091087280][-conn:service0::3] Notice: CREATE FUNCTION
[13/Dec/2006:15:23:25][6587.1091087280][-conn:service0::3] Notice: CREATE FUNCTION
[13/Dec/2006:15:23:25][6587.1091087280][-conn:service0::3] Notice: CREATE TRIGGER
[13/Dec/2006:15:23:25][6587.1091087280][-conn:service0::3] Notice: CREATE TRIGGER
[13/Dec/2006:15:23:25][6587.1091087280][-conn:service0::3] Notice: CREATE TRIGGER
[13/Dec/2006:15:23:25][6587.1091087280][-conn:service0::3] Error: apm_package_install: Error installing E-Commerce versio
n 5.05: psql:ecommerce-create.sql:51: ERROR: syntax error at or near "(" at character 22
psql:ecommerce-create.sql:51: LINE 1: create function least(numeric,numeric)
psql:ecommerce-create.sql:51: ^
psql:ecommerce-create.sql:108: WARNING: changing return type of function ec_templates_audit_tr from "opaque" to "trigger
"
psql:ecommerce-create.sql:155: WARNING: changing return type of function ec_categories_audit_tr from "opaque" to "trigge
r"
psql:ecommerce-create.sql:205: WARNING: changing return type of function ec_subcategories_audit_tr from "opaque" to "tri
gger"
psql:ecommerce-create.sql:263: WARNING: changing return type of function ec_subsubcategories_audit_tr from "opaque" to "
trigger"
psql:ecommerce-create.sql:466: WARNING: changing return type of function ec_products_audit_tr from "opaque" to "trigger"
psql:ecommerce-create.sql:548: WARNING: changing return type of function ec_sale_prices_audit_tr from "opaque" to "trigg
er"
--------------------------------------------------
Can someone give me some guidelines? Is this the compatible version of ecommerce for 5.3.0b? I would really like to
use version openacs 5.x since it provides localization which is something that interests me highly. Do i have
to install ssl on aol for it to work? Right now, I am interested in getting it(ecommerce)installed correctly and
leaving other details for later time. Furthermore, I was wondering if there is something i can do to help. Most
likely other newcomers may be facing same problems. Perhaps I could write up some documentation once i get it to
work.
Thank you so much in advance. Finally, I got here(openacs.org) after reading phil's online book. Your work is really impressive. Yes, a newcomer may be lost in the beginning but it really pay off later. At least, that's
my humble opinion.
Cheers
