Forum OpenACS Development: Re: Categories pkg - Add new tree

Collapse
3: Re: Categories pkg - Add new tree (response to 1)
Posted by Gustaf Neumann on 01/27/17 09:34 AM
Iuri,

i tried to recreate to problem on a fresh and old, but upgraded site, but it worked in both cases without problems.

Which versions of the database and categories do you use exactly? My suspicion is that you do not have executed the following update scripts:

https://github.com/openacs/categories/blob/oacs-5-9/sql/postgresql/upgrade/upgrade-1.1.3d6-1.1.3d7.sql

Please submit a proper bug-report to the bugtracker
http://www.openacs.org/bugtracker/openacs/

Collapse
4: Re: Categories pkg - Add new tree (response to 3)
Posted by Iuri Sampaio on 01/29/17 07:29 PM
Hi Gustaf,

psql (9.1.23) and categories 1.1.3d5

I saw the script changes the datatype directly to char. Good. I thought about solution. But, as at the time I solved it, casting the variable, I haven't had the certainty neither visibility of the impact that such a datatype change would have along the source code

Then I decided to CAST the variable on every broken piece of code that appear while I was browsing the package and creating the stuff.

Bug is created. #3298
https://openacs.org/bugtracker/openacs/bug?bug_number=

Best wishes

Collapse
5: Re: Categories pkg - Add new tree (response to 4)
Posted by Gustaf Neumann on 01/30/17 12:24 AM
The problem existed in the categories package version 1.1.3d5 or 1.1.3d6 and was fixed by antonio on Nov 15, 2016. The current version of the categories package in the oacs-5-9 branch (1.1.3d7) works properly and does not need the cast operator.