Oracle Problem on adding new module

[muharihar]

Tips Installing Elxis with Oracle as your Database:
1. Install Oracle
2. If your Database Server not in one server with your Web Server (you need install oracle instant client on you web server)
3. Make sure Oracle Path as Your First Path Queue (on Windows)
   set oracle path on you windows Environment Variables.
4. Install Apache + PHP (You can use xampp for windows ->http://www.apachefriends.org/en/xampp-windows.html)
5. Check you php.ini (on xampp you can found this file on : xampp/apache/bin ) configuration for supporting oracle:

; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.

...
;extension=php_ntuser.dll
extension=php_oracle.dll
extension=php_oci8.dll
;extension=php_oggvorbis.dll
...

6. Before installing elxis, make sure you oracle TNS Listener Service and Oracle service is running (check via windows service)

happy try....

Sorry for my bad english....

[batorgil]

I have 2 problem.

I have installed apache2.2, php5, oracle 10g.
then I get some error in the installation step.

1. "URI: index.php
Message: ORA-00911: invalid character
INSERT INTO aaaa_banner VALUES (1, 1, 'banner', 'Multi lingual Interface', 0, 0, 0, 'elxismultilingual.jpg', 'https://www.elxis.org', TO_DATE('1979-12-19 00:00:00','RRRR-MM-DD HH24:MI:SS'), 1, 0, TO_DATE('1979-12-19 00:00:00','RRRR-MM-DD HH24:MI:SS'), NULL, NULL, 1)"

2. then I ignore error 1. then My web site menu is unsuccessful.
this picture 'http://rapidshare.com/files/166252840/untitled.JPG.html' I have upload.

can you help me?

how Can I successful?

sorry my english is bad.

[muharihar]

yah... it's also happen  to me...

and i'm try to fixed it by replacing character "\n" with chr(10) (in every field values contain "\n").

try this query/script to fixed it:

UPDATE web2_categories
   SET params = REPLACE (params, '\n', CHR (10));
UPDATE web2_components
   SET params = REPLACE (params, '\n', CHR (10));
UPDATE web2_contact_details
   SET params = REPLACE (params, '\n', CHR (10));
UPDATE web2_content
   SET attribs = REPLACE (attribs, '\n', CHR (10));
UPDATE web2_mambots
   SET params = REPLACE (params, '\n', CHR (10));
UPDATE web2_menu
   SET params = REPLACE (params, '\n', CHR (10));
UPDATE web2_modules
   SET params = REPLACE (params, '\n', CHR (10));
UPDATE web2_sections
   SET params = REPLACE (params, '\n', CHR (10));
UPDATE web2_users
   SET params = REPLACE (params, '\n', CHR (10));
UPDATE web2_weblinks
   SET params = REPLACE (params, '\n', CHR (10));

replace web2_ with your elxis prefix table....

note:
it's work for me on windows....

happy try.....

 

[batorgil]

hello dear all.
thank you muharihar .

I have problem again. I create new link in the main menu. then I get error msg "mosmenu::store failed <br />ORA-00001: unique constraint (A4M.SYS_C00156566) violated"

How can I do it?

[batorgil]

this CONSTRAINT  is "
ALTER TABLE A4M.NEW_MENU
  DROP CONSTRAINT SYS_C00156566;

ALTER TABLE A4M.NEW_MENU ADD (
  PRIMARY KEY
 (ID));
"

[muharihar]

it's happen because last value of sequence (from dependent table) is not updated to the last id from table (primary key)

try this query/script to fix it:

DECLARE
   --seq_web2_menu (sequence name)
   --web2_menu (table name)
   --Replace web2_ with your Elxis Table Prefix
   max_seq   NUMBER (12);
   id_web2   NUMBER (12);
BEGIN
-- SEQ_web2_menu = web2_menu
-- a.ID = primary key

   SELECT NVL (MAX (a.ID), 1)
     INTO id_web2
     FROM web2_menu a;

   SELECT seq_web2_menu.NEXTVAL
     INTO max_seq
     FROM DUAL;

   DBMS_OUTPUT.put_line ('Tabel web2_menu, id = ' || id_web2 || ', seq = ' || max_seq);

   IF id_web2 > max_seq
   THEN
      DBMS_OUTPUT.put_line ('Looping...');

      WHILE max_seq < id_web2
      LOOP
         DBMS_OUTPUT.put_line (' - increment id = ' || id_web2 || ', seq = ' || max_seq);

         IF max_seq > id_web2
         THEN
            EXIT;
         END IF;

         SELECT seq_web2_menu.NEXTVAL
           INTO max_seq
           FROM DUAL;
      END LOOP;
   END IF;
END;



replace "web2_" with your elxis prefix table....

you can do this solution for any sequence problem (by replace related sequence and related table)...

happy try......

thanks.....