Oracle Problem on adding new module

[Ahmad Said]

hi all i have aproblem in adding new module -----> uniqe constrain , the problem is get new id from the seq of module
i solve the one for adding componnet by adding id as select max(nvl(id,0))+ 1 from #__component, but with module untill now i cant

[datahell]

Marked for fix.

[muharihar]

try this....

execute this sql script from your oracle sql query/script tool:
-------------------------------------------------------------

DECLARE
   --SEQ_ELX_MODULES   
   --Replace ELX_ with your Elxis Table Prefix
   max_seq_elx_modules   NUMBER (12);
   id_elx_modules        NUMBER (12);
BEGIN
-- SEQ_ELX_MODULES = elx_MODULES
   SELECT NVL (MAX (a.ID), 1)
     INTO id_elx_modules
     FROM elx_modules a;

   SELECT seq_elx_modules.NEXTVAL
     INTO max_seq_elx_modules
     FROM DUAL;

   /*
   DBMS_OUTPUT.put_line (   'Tabel elx_MODULES, id = '
                         || id_elx_modules
                         || ', seq = '
                         || max_seq_elx_modules
                        );
   */
   IF id_elx_modules > max_seq_elx_modules
   THEN
       /*
      DBMS_OUTPUT.put_line ('Looping...');
      */
      WHILE max_seq_elx_modules < id_elx_modules
      LOOP
           /*
         DBMS_OUTPUT.put_line (   ' - increment id = '
                                 || id_elx_modules
                                 || ', seq = '
                                 || max_seq_elx_modules
                                );
           */
         IF max_seq_elx_modules > id_elx_modules
         THEN
            EXIT;
         END IF;

         SELECT seq_elx_modules.NEXTVAL
           INTO max_seq_elx_modules
           FROM DUAL;
      END LOOP;
   END IF;
END;


------------------------------------------
if you want to use this query (srcipt) for another sequence problem, replace "ELX_" with your Elxis Table Prefix....

thank....
sorry for my english....

[Ahmad Said]

grat muharihar
am try it and its work 100%

[batorgil]

How can I install Elxis with oracle 10g, windows. Pls help me.

[datahell]

Elxis installation procedure is the same for any database type.

[batorgil]

Elxis installation procedure is the same for any database type.

can you help me? step by step installation. Then, where I write some configuration?
I stopped in the step3.

[datahell]

The Oracle default port is 1521 so you dont have to enter the port in the host.
If Oracle resides on the same machine as Elxis you can enter localhost instead of the ip address.

Host name: localhost (or 172.15.0.10)
Database type: oci8 (the database type is the adodb's driver used to connect to your database, use oci8 for oracle)
Database name: The database name (your oracle user name)
Database path: leave this empty
Database table prefix: elx_
Database username: your oracle user name
Database password: your oracle password
Database verify password: your oracle password (again)

[batorgil]

Database type: oci8 (the database type is the adodb's driver used to connect to your database, use oci8 for oracle)

but there has not oci8.
there has oracle 7, oracle 8.0.5 , oracle 8/9, oracle (odbc)

I have this error
"
Warning: ocilogon() [function.ocilogon]: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor in C:\AppServ\www\elxis\includes\adodb\drivers\adodb-oci8.inc.php on line 228

Warning: ocilogon() [function.ocilogon]: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor in C:\AppServ\www\elxis\includes\adodb\drivers\adodb-oci8.inc.php on line 228
"

My listener file is
"
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = batorgil)(PORT = 1521))
    )
  )
"

[batorgil]

I have some error
"At least one fatal error occured during the previous step. You cannot continue. Please go back and correct the database settings. The Elxis installer error messages follows:

  • Could not connect to the database."

my configuration :

database type : ADO(generic) and oracle 7 but I have not good result.  

Pls help me pls pls

[datahell]

Use oci8 or oci805 driver:
Oracle 8.0.5: this is oci805
Oracle 8/9: this is oci8

Both drivers work fine for Oracle 10/11g

Check also that in the Elxis installer's first page Oracle database is highlighted in green (supported). If not you must enable the corresponding dll file in php.ini (php_oci8.dll).

[batorgil]

Dear datahell.
I have one more problem. this is
"
Warning: ocilogon() [function.ocilogon]: Invalid character set name: utf8 in C:\AppServ\www\j&o\includes\adodb\drivers\adodb-oci8.inc.php on line 231
Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries in C:\AppServ\www\j&o\includes\adodb\drivers\adodb-oci8.inc.php on line 231
Warning: ocilogon() [function.ocilogon]: Invalid character set name: utf8 in C:\AppServ\www\j&o\includes\adodb\drivers\adodb-oci8.inc.php on line 231
Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries in C:\AppServ\www\j&o\includes\adodb\drivers\adodb-oci8.inc.php on line 231
"

What do I do?

[datahell]

I think this is because you might have not set up Oracle to support international characters. I am not an oracle expert and I can not see your database from here to help you more with this. Why dont you try with MySQL or ProstgreSQL as you face too many problems with Oracle?

[batorgil]

I think this is because you might have not set up Oracle to support international characters. I am not an oracle expert and I can not see your database from here to help you more with this. Why dont you try with MySQL or ProstgreSQL as you face too many problems with Oracle?

Thanks your for support.
Our database's character set is RU8PC866. theh, Can I change elxis's character set. how can I change elxis character set?

thank you your for support.

[datahell]

Elxis uses UTF-8 encoding in everything. You should set your database's charset to AL32UTF8.

Some related adodb settings/commands for Oracle.

Before connection:
$database->_resource->NLS_DATE_FORMAT = 'RRRR-MM-DD HH24:MI:SS';
$database->_resource->charSet = 'AL32UTF8';
After connection:
$database->_resource->Execute("ALTER SESSION SET NLS_DATE_FORMAT='RRRR-MM-DD HH24:MI:SS'");

You can also try these (not recommended):
$database->_resource->Execute("ALTER SESSION SET NLS_LANGUAGE=RUSSIAN");
$database->_resource->Execute("ALTER SESSION SET NLS_TERRITORY=RUSSIA");