Location: PHPKode > projects > ProNuke. Postnuke To Oracle > postnuke/html/portoci8log.txt
PostNuke Modification logs




/PNTABLES.PHP

UID sql column name replaced by UID_
LEVEL sql column name replaced by LEVEL_
DATE sql column name replaced by DATE_
COMMENT sql column name replaced by COMMENT_
TO DO : VIEW,TYPE


because they are reserved words for Oracle (and many other DB).


/MAINFILE2.PHP

Comment the ALTER SESSION SQL COMMAND about the date format
because ADOdb does that automatically.

/INCLUDES/ADVBLOCKS.PHP

Add "IS NULL" clause for every request containing a "where <column> =''".
Oracle doest not associate '' with NULL (except for insert).
'' is not equivalent to NULL for MySQL. It's more like "empty".

/INCLUDES/SECURITY

USE PNTABLES definition for where clause (UID,GID was Hard coded).
Changement des boucles de lecture sql : ajout test EOF


/MODULE/NEWS/INDEX.PHP

Changement des boucles de lecture sql : ajout test EOF

/MODULE/NEWS/FUNCS.PHP

Add "IS NULL" clause for every request containing a "where <column> =''".
Modified test for Oracle to support oci8 + oci8po, oracle_odbc, oracle

Optimize tests for ($where and so on...) building request avoiding copy of the same code.
Changement des boucles de lecture sql : ajout test EOF


/INCLUDES/BLOCKS/CATEGORY.PHP
Add "IS NULL" clause for every request containing a "where <column> =''".

/INCLUDES/BLOCKS/EPHEM.PHP
Add "IS NULL" clause for every request containing a "where <column> =''".

/INCLUDES/BLOCKS/MENU.PHP
Add "IS NULL" clause for every request containing a "where <column> =''".

/INCLUDES/BLOCKS/POLL.PHP
Add "IS NULL" clause for every request containing a "where <column> =''".

/REFERER.PHP
Add _SEQ suffix to the sequence name to avoid objects name conflicts in Oracle.

idem for /includes/blocks/button.php
idem for /install/.php

TODO Rechercher GenID pour la suite













Return current item: ProNuke. Postnuke To Oracle