Forum OpenACS Q&A: Photo-Album error on Create a New Album

Collapse
1: Photo-Album error on Create a New Album
Posted by Jay Dubanik on 06/06/02 08:31 AM
System: OpenACS 4.5b, Oracle 8.1.7, RedHat 7.2
After installing Photo-Album package, on first run Im getting this
error message when trying to Create a New Album.
---
ora8.c:3568:ora_tcl_command: error in `OCIStmtExecute ()': ORA-29540:
class
com/arsdigita/content/Util does not exist
ORA-06512: at "COMPUTORINO.STRING_TO_BLOB", line 0
ORA-06512: at "COMPUTORINO.CONTENT_REVISION", line 91
ORA-06512: at "COMPUTORINO.PA_ALBUM", line 40
ORA-06512: at line 4

SQL:

        begin
        :1 := pa_album.new (

--
I should add here, that when insalling photo-album package I did not
notice any errors.
any ideas?

Ciao,
Janus

Collapse
2: Response to Photo-Album error on Create a New Album (response to 1)
Posted by Jay Dubanik on 07/08/02 05:41 PM
This was happening due to dependency on other procs in Oracle which happened to be invalid.
Fixed by new cliean install of datamodel of oacs.

janus

Collapse
3: Response to Photo-Album error on Create a New Album (response to 1)
Posted by Andrew Piskorski on 07/11/02 02:13 AM
Janus, if your problem was indeed due simply to invalid Oracle pl/sql procedures, then reinstalled the OpenACS data model from scratch was overkill. Instead, you probably could have just recompiled all the invalid procedures using Trezzo's recompile_all_objects pl/sql procedure.
Collapse
4: Response to Photo-Album error on Create a New Album (response to 1)
Posted by Jay Dubanik on 07/11/02 06:48 AM
Andrew, Thanks for the tip, I will defenetly need this proc in the future.<br>
I had other problems with my first install due to java on RedHat 7.3 issue and no data, so I did not mind to reinstall. And besides Im so new to it that the more on hands experience the better (I hope:).