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

Collapse
2: Re: Help with dotlrn-ecommerce (response to 1)
Posted by Dave Bauer on 06/25/07 07:24 PM
You need dotlrn 2.3.0 for dotlrn-ecommerce. It might not be reflected in the dependencies.

This error which I see more than once:
Query did not return any rows. "db_1row get_course "select * from dotlrn_catalog, cr_items where item_id=:course_id and course_id=latest_revision"

It looks like your data in dotlrn-catalog is not setup correctly. Did you create a course or section?

Collapse
3: Re: Help with dotlrn-ecommerce (response to 2)
Posted by Rob Mayhue on 06/25/07 10:32 PM
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.