Radicore Forum: Bug Reports » Value is missing for fieldspec['type']

Home » RADICORE development » Bug Reports » Value is missing for fieldspec['type']

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Value is missing for fieldspec['type'] [message #5177]

Fri, 27 November 2015 08:36

kong
Messages: 90
Registered: December 2011

Member

This error can be replicated as follows:
1. Configure Radicore v1.91 with 2 database servers: mysql and sqlsrv
2. On mysql server: Run the system databases 'audit', 'dict', 'menu' and 'workflow'
3. On sqlsrv server: Create a custom database 'testdb' with a table 'testtbl' with some arbitrary fields and a field 'testnum' of type 'numeric'
4. Create a new subsystem, import the custom database 'testdb', table 'testtbl' and its columns
5. In the Tables tab Select 'testtbl', click "Export to PHP" button will result in error message: "[testnum] Value is missing for fieldspec['type']"

Error trace:
This error can be traced back to function _createFieldSpecs in file dict_table_s02.class.inc
The function calls $this->_ddl_getColumnSpecs() which returns the ColumnSpecs for mysql rather than sqlsrv, which results in error because ColumnSpecs of mysql do not have 'numeric' type.

Proposed fix:
1. In file std.table.class.inc, change

Code: [Select all] [Show/ hide]

    function _ddl_getColumnSpecs ()
    // obtain column specifications.
    {
        $DDL =& $this->_getDBMSengine($this->dbname);

        $array = $DDL->ddl_getColumnSpecs();

        return $array;

    } // _ddl_getColumnSpecs

Code: [Select all] [Show/ hide]

    function _ddl_getColumnSpecs ($dbname=null)
    // obtain column specifications.
    {
    	if ($dbname === null) $dbname = $this->dbname;
    	$DDL =& $this->_getDBMSengine($dbname);
    	
        $array = $DDL->ddl_getColumnSpecs();

        return $array;

    } // _ddl_getColumnSpecs

2. In function _createFieldSpecs of file dict_table_s02.class.inc, change

Code: [Select all] [Show/ hide]

$this->_ddl_getColumnSpecs()

Code: [Select all] [Show/ hide]

$this->_ddl_getColumnSpecs($column_array[0]['database_id'])

Report message to a moderator

Re: Value is missing for fieldspec['type'] [message #5178 is a reply to message #5177]

Sat, 28 November 2015 04:56

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

Well spotted. That fix will be in the next release.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Error with bitwise operation
Next Topic:	preg_replace operation distorts multibyte unicode characters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jul 07 04:33:02 EDT 2025

Total time taken to generate the page: 0.00984 seconds