Forum .LRN Q&A: Re: Help with dotlrn-ecommerce

Collapse
Posted by Rob Mayhue on
The would be great if I can use dotlrn 2.3.0 because the zen theme would work much better for me but its based on OpenACS 5.3.1 and I've never been able to get the Ecommerce package to install under OpenACS 5.3.1.

The error I'm getting is:
Error: apm_package_install: Error installing E-Commerce version 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)

That was on a test server running dotlrn-2.3.0 with postgresql-8.1.8 installed. Since this is a database error I'm thinking that it must be the difference between postgresql-7.4.17 and postgresql-8.1.8.

If it is a database issue is there a fix for getting Ecommerce 5.0.5 installed on postgresql-8.x versions? According to the compatibility matrix OpenACS 5.3 core cannot use postgresql-7.4.x

Concerning the error you quoted - no I have not yet created a course or section. I'm guessing that error will go away when I do.

Thank you.