#60 ✓resolved
Schirkan

Creating Models from existing tables doesn't work

Reported by Schirkan | 2009-01-30 18:00:39 UTC | in 0.12

That's the error message I get:

Undefined index: fields

Location: Line 209 of /srv/www/web204/html/recess/recess/lib/recess/apps/tools/controllers/RecessToolsAppsController.class.php

* 205:            $dataSource = $values['dataSource'];
* 206:            $createTable = $values['createTable'] == 'Yes' ? true : false;
* 207:            $tableName = $values['tableName'];
* 208:        }
* 209:        $propertyNames = $values['fields'];
* 210:        $primaryKey = $values['primaryKey'];
* 211:        $types = $values['types'];
* 212:        
* 213:        Library::import('recess.database.orm.Model', true); 
* 214:        // Forcing b/c ModelDescriptor is in Model

Comments and changes to this ticket

  • Kris Jordan

    Kris Jordan 2009-02-04 17:41:18 UTC

    • State changed from “new” to “open”

    Interesting and unable to reproduce. Which internet browser are you using? This is likely an issue with the Javascript client side improperly submitting the form.

  • Schirkan

    Schirkan 2009-02-05 16:14:16 UTC

    Hello,

    I'm using the latest version of Firefox, but I don't think, that's the problem.

    I think I found the problem in the HTML-code:

    
    <h3><input name="tableExists" value="__yes__" type="radio"> Table does not exist.</h3>
    
    [...]
    
    <h3><input name="tableExists" value="__no__" type="radio"> Table already exists.</h3>
    

    I think the values have to be interchanged.

    This was the corresponding Request & Response

    
    POST /recess/recess/apps/app/SnippetsApplication/model/gen HTTP/1.1
    Host: schirkan.de
    User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.0.6) Gecko/2009011913 Firefox/3.0.6 (.NET CLR 3.5.30729) FirePHP/0.2.1
    Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    Accept-Language: de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
    Accept-Encoding: gzip,deflate
    Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
    Keep-Alive: 300
    Connection: keep-alive
    Referer: http://schirkan.de/recess/recess/apps/app/SnippetsApplication/model/gen
    Cookie: PHPSESSID=0dc1b4d4729ea232389568a9f83b0d2d
    Content-Type: application/x-www-form-urlencoded
    Content-Length: 91
    modelName=Category&tableExists=no&existingDataSource=Default&existingTableName=sn_categorys
    
    HTTP/1.x 500 Internal Server Error
    Date: Thu, 05 Feb 2009 21:00:40 GMT
    Server: Apache/2.2.3 (Debian) mod_ssl/2.2.3 OpenSSL/0.9.8c
    X-Powered-By: PHP/5.2.6-0.dotdeb.1
    Connection: close
    Transfer-Encoding: chunked
    Content-Type: text/html
    
  • Luiz Alberto Zaiats

    Luiz Alberto Zaiats 2009-02-05 18:27:19 UTC

    Just wondering why:

    modelName=Category&tableExists=no&existingDataSource=Default&existingTableName=sn_categorys

    Doesn't make sense to me... How could it have a tableExists=no and a existingTableName=sn_categorys ?

    LZ

  • Kris Jordan

    Kris Jordan 2009-03-30 21:52:52 UTC

    • Milestone changed from “0.11.1” to “0.12”

    Moving this ticket to the next maintenance release due out shortly: 0.11.2

  • Kris Jordan

    Kris Jordan 2009-03-31 14:48:37 UTC

    • State changed from “open” to “resolved”

    Fixed the pointed out logic error in commit 8611f453

    Still don't believe this is at the root of your problem as the post content does not have a fields[] array. This leads me to suspect something in the jQuery went wrong but I've tested in the latest Firefox release without fail.

  • simon.rycroft

    simon.rycroft 2010-01-19 16:09:43 UTC

    This problem still exists for me in version 0.20. Replicated in in Firefox and IE.

    If I try to create a model based on an existing database I get:

    Undefined index: fields

    Location: Line 208 of D:\xampp\htdocs\recess\recess\recess\apps\tools\controllers\RecessToolsAppsController.class.php

    Any ideas please?

  • simon.rycroft

    simon.rycroft 2010-01-19 16:19:23 UTC

    Well I think I just found a bug :-(

    If you select an existing datasource and click 'Generate Model' it errors out with 'undefined index'.

    However if you go back the the 'ew Model Helper' page, select 'Table does not exist' and then change it to 'Table already exists' the model will be generated correctly.

    I'm surprised more people haven't reported this.

  • ehpc

    ehpc 2010-07-06 13:53:44 UTC

    • Milestone order changed from “0” to “0”

    Have the same issue in 0.20. Firefox 3.6.6. And unlike simon.rycroft, I cannot get it to work...

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

The Recess PHP Framework is an open source, full stack, RESTful PHP framework.

http://www.recessframework.org/

People watching this ticket

Pages