Codegen Problems

thread: 4 messages  |  last: about 3 years ago  |  started: monday, november 24, 2008, 4:55 am pst


#1  |  Coetzer (Durban) South Africa
Monday, November 24, 2008, 4:55 AM PST

Hi All

I have the Qcodo Version: 0.3.32 (Qcodo Beta 3) installed on windows with Postgres DB.
My 'devtools' subdirectory is pointing to'/qcodo/wwroot/_devtools' (config...inc.php)

I presuume this link is correct becuase there is a function running but comes up with an error: PostgreSql Error: Unsupported Field Type: oid

Two questions:
1- Am I pointing to to right codegen tool?

2- PostgreSql Error: Unsupported Field Type: oid. My Postgres tables are set to have oid's, I require this for another application reading from this database. Anyone has suggestions arround this.



Entire error:

PostgreSql Error: Unsupported Field Type: oid
Exception Type:   QPostgreSqlDatabaseException

Source File:   C:\ms4w\Apache\htdocs\qcodo\wwwroot\includes\qcodo\_core\database\QPostgreSqlDatabase.class.php     Line:   252

Line 247:                $objResult = $this->Query($strQuery);
Line 248:    
Line 249:                $objFields = array();
Line 250:              
Line 251:                while ($objRow = $objResult->GetNextRow()) {
Line 252:                    array_push($objFields, new QPostgreSqlDatabaseField($objRow, $this));
Line 253:                }
Line 254:    
Line 255:                return $objFields;
Line 256:            }
Line 257:    




hope someonecan help me please..
Sarel

#2  |  disaster (Bassano, Italy) Italy
Monday, November 24, 2008, 5:45 AM PST

near row 633 in file includes/qcodo/_core/database/QPostgreSqlDatabase.class.php

add
case 'oid':
below
case 'real':

#3  |  Coetzer (Durban) South Africa
Monday, November 24, 2008, 6:07 AM PST

Thanks for the fast reply..it solved one problem but created another..


PostgreSql Error: Unsupported Field Type: ARRAY
Exception Type:   QPostgreSqlDatabaseException

Source File:   C:\ms4w\Apache\htdocs\qcodo\wwwroot\includes\qcodo\_core\database\QPostgreSqlDatabase.class.php     Line:   252

Line 247:                $objResult = $this->Query($strQuery);
Line 248:    
Line 249:                $objFields = array();
Line 250:    
Line 251:                while ($objRow = $objResult->GetNextRow()) {
Line 252:                    array_push($objFields, new  QPostgreSqlDatabaseField($objRow, $this));
Line 253:                }
Line 254:    
Line 255:                return $objFields;
Line 256:            }
Line 257:    

--------------------------------------------------------------------
array_push is and accepted postgres/php command :-[
“slowly but surely getting there, thanks for the help this far”
Sarel

#4  |  disaster (Bassano, Italy) Italy
Monday, November 24, 2008, 7:24 AM PST

I don't think that qcodo supports database arrays :-(
Maybe you can open a requesto on qcubed trac

anyway, for a wuick workaround you may add the array type to the string types so it won't stop with an error



Copyright © 2005 - 2012, Quasidea Development, LLC
This open-source framework for PHP is released under the terms of The MIT License.