Welcome,
Guest
.
Please
login
or
register
.
Did you miss your
activation email
?
News:
Elxis documentation
for users and developers.
Home
Help
Login
Register
Elxis CMS Forum
»
Support
»
Database
»
Oracle Problem on adding new module
« previous
next »
Print
Pages:
1
[
2
]
Author
Topic: Oracle Problem on adding new module (Read 54790 times)
muharihar
Jr. Member
Posts: 77
muharihar
Re: Oracle Problem on adding new module
«
Reply #15 on:
November 22, 2008, 00:46:32 »
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....
Logged
how technology and nature stand together!
---------------------------------------------------
www.OmahIjo.net
batorgil
Newbie
Posts: 10
Re: Oracle Problem on adding new module
«
Reply #16 on:
November 22, 2008, 14:26:37 »
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.
Logged
muharihar
Jr. Member
Posts: 77
muharihar
Re: Oracle Problem on adding new module
«
Reply #17 on:
November 22, 2008, 16:18:22 »
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.....
Logged
how technology and nature stand together!
---------------------------------------------------
www.OmahIjo.net
batorgil
Newbie
Posts: 10
Re: Oracle Problem on adding new module
«
Reply #18 on:
November 24, 2008, 04:26:56 »
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?
Logged
batorgil
Newbie
Posts: 10
Re: Oracle Problem on adding new module
«
Reply #19 on:
November 24, 2008, 04:29:08 »
this CONSTRAINT is "
ALTER TABLE A4M.NEW_MENU
DROP CONSTRAINT SYS_C00156566;
ALTER TABLE A4M.NEW_MENU ADD (
PRIMARY KEY
(ID));
"
Logged
muharihar
Jr. Member
Posts: 77
muharihar
Re: Oracle Problem on adding new module
«
Reply #20 on:
November 24, 2008, 12:21:03 »
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.....
Logged
how technology and nature stand together!
---------------------------------------------------
www.OmahIjo.net
Print
Pages:
1
[
2
]
« previous
next »
Elxis CMS Forum
»
Support
»
Database
»
Oracle Problem on adding new module