[Solar-talk] Auto Creating databases in Solar

[Raymond Kolbe]

For a list of reserved words, look at Solar_Sql_Reserved. Comment is one of
them.

On Jan 15, 2008 1:49 PM, Raymond Kolbe <rkolbe at gmail.com> wrote:

> ( 'comment' => array ( 0 => 'ERR_IDENTIFIER_RESERVED', 1 =>
> array ( 'type' => 'column', 'name' => 'comment', ), ),
>
> Looks like 'comment' is a reserved word. Try changing that to something
> else and auto create should work.
>
>
> On Jan 15, 2008 1:22 PM, Walker, Jason T. <Jason.Walker at gd-ais.com> wrote:
>
> > Trying to create a new table called customer using Solar framework and
> > ran into this error:
> >
> > Fatal error: Uncaught exception
> > 'Solar_Controller_Page_Exception_DuringFetch' class::code
> > 'CAMIS_App_test::ERR_DURING_FETCH' with message 'Exception encountered
> > in the fetch() method.' information array ( 'exception' =>
> > Solar_Sql_Adapter_Exception_TableNotCreated::__set_state(array( '_info'
> > => array ( 'comment' => array ( 0 => 'ERR_IDENTIFIER_RESERVED', 1 =>
> > array ( 'type' => 'column', 'name' => 'comment', ), ), '__table' =>
> > 'shipping', ), '_class' => 'Solar_Sql_Adapter_Mysql', 'message' =>
> > 'ERR_TABLE_NOT_CREATED', 'string' => '', 'code' =>
> > 'ERR_TABLE_NOT_CREATED', 'file' => 'C:\\Solar\\Solar-0.28.0\\Solar.php',
> > 'line' => 363, 'trace' => array ( 0 => array ( 'file' =>
> > 'C:\\Solar\\Solar-0.28.0\\Solar.php', 'line' => 558, 'function' =>
> > 'factory', 'class' => 'Solar', 'type' => '::', 'args' => array ( 0 =>
> > 'Sol in C:\Solar\Solar-0.28.0\Solar.php on line 363
> >
> > My question is what change needs to be made in my model, so that it auto
> > creates the table?  See code below.  Thanks
> >
> >
> >
> > <?php
> >
> > class CAMIS_Models_Customer extends Solar_Sql_Model {
> >        /** class name should be same as file name
> >         * Model Setup for Inventory Table setup for CAMIS
> >         *
> >         */
> >
> >        protected function _setup() {
> >                /*The Shipping Asset Table */
> >                $this->_table_name = 'customer';
> >
> >                 /* The columns in our posts table */
> >        $this->_table_cols = array(
> >
> >            'customer_id' => array(
> >                'type'    => 'int',
> >                'require' => true,
> >                'primary' => true,
> >                'autoinc' => true,
> >            ),
> >            'name' => array(
> >                'type'  =>'varchar',
> >                'size'  => 150,
> >                'require' => true,
> >            ),
> >
> >
> >        );
> >
> >
> >        // This row contains all shipping asset which have a container
> > id
> >        //equal to the rows primary key
> >        $this->_hasMany('receivers', array(
> >            'foreign_class' => 'CAMIS_Models_Shipping',
> >            'foreign_key'   => 'receiver_id',
> >        ));
> >
> >        $this->_hasMany('shippers', array(
> >            'foreign_class' => 'CAMIS_Models_Shipping',
> >            'foreign_key'   => 'shipper_id',
> >        ));
> >
> >        $this->_hasMany('pos', array(
> >            'foreign_class' => 'CAMIS_Models_ProcessingOrder',
> >            'foreign_key'   => 'customer_id',
> >        ));
> >
> >        }
> >
> > }
> > ?>
> >
> >
> > Jason
> >
> > _______________________________________________
> > Solar-talk mailing list
> > Solar-talk at lists.solarphp.com
> > http://mailman-mail3.webfaction.com/listinfo/solar-talk
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman-mail3.webfaction.com/pipermail/solar-talk/attachments/20080115/e03b6c23/attachment.html