Oracle & RedHat Installation with some problems

[bernz76]

hi,

i did following installation:

Database Version: oci8 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining Scoring Engine and Real Application Testing options (Version: 10.2.0.4.0)
PHP Version: 5.1.6
Web Server: Apache/2.2.3 (Red Hat)
Web Server to PHP interface: apache2handler
Version Elxis 2009.0 Stable rev2437 [ Pandora ] 22-May-2009 10:31 GMT+2

i'm able to enter the administration page
BUT

i've 2 big problems ...

i cannot open the main page (not the admin but the regular/cms one) ... calling http://cms.company.com makes an redirect to an empty page: http:///  (http://cms.company.com/administration works fine)
don't know, maybe there is a problem with the template ho comes along with the installation ?? - i'm using the okto template of Ioannis Sannos version 2009.0

and second problem:
WYSIWYG doesn't work - on the page i get a javascript error every time i refresh a page. main page admin for example gives me :

Line 60
Character 118
Error: Constant String without termination
Code: 0

this problem doesn't show up if i deactivate the editor in the configuration file

... has anybody else same or similar troubles

[datahell]

Oracle support is highly experimental and should not be used on production sites. On Elxis 2008.x we had done a great effort and implemented Oracle but as people don't use Oracle we did n't checked for Oracle compatibility Elxis 2009.0. So, there will be surely issues under Oracle for Elxis 2009.0. In the future we plan to fix Oracle support even if we don't have enough requests for this.

[bernz76]

ok but oracle is working fine for me ! the problem is the javascript error of WYSIWYG - is this issue DB dipendend ?

the js error on the main page i've allready described
if i go in detail opening a page to edit i get following error:

Line: 2
Character: 88996
Error: Object needed
Code: 0

any help would be great because i'm forced to use ORACLE as DB

[datahell]

There is no issue regarding the WYSIWYG editor, it works fine. That's why I guess the error has to do with the database. Maybe a certain db query related to the editor is the problem. Unless the error derives from something else (gzip compression, cache, bad encoded language files, missing files, safe_mode, template, etc). Did you checked the apache's error log? A close look at the resulted html source code might help to find out the problem.

[bernz76]

ok - could you indicate me in which table i can find some configuration of the editor itself ? maybe this way i get closer to the solution of the problem

[datahell]

The editor initializes here: mambots/editors/tinymce.php
It does n't have to do with the database except from the configuration parameters (a row in table elx_mambots).

[bernz76]

checked the setting in elx_mambots:

params: theme=advanced\nentity_encoding=raw ...


a more detailed description of the error is provided by firefox:

Error: o is not a constructor
File: http://cms.company.com/mambots/editors/tinymce/jscripts/tiny_mce/tiny_mce.js
Line: 1

complains about a constructor in javascript file ...

[datahell]

You wont find the problem in javascript. The javascript error is just a result of the real error. The problem should be database related. A query generates error or does not gets the proper result and this causes the error. You should search and find this query.