Workaround: instead of "select customers_name, value, date_purchased,
orders_status from shop_orders LEFT JOIN ...", "select * LEFT
JOIN ..."
On 6 Dic, 18:39, Javier Garcia <tirengar...@gmail.com> wrote:
> Hi,
>
> i'm trying to use my own method to show a list in the backend:
>
> class ShopOrderPeer extends BaseShopOrderPeer {
>
> public static function getOrdini()
> {
> $con = Propel::getConnection();
> $sql = "select customers_name, value, date_purchased,
> orders_status from shop_orders LEFT JOIN shop_orders_total ON
> shop_orders.orders_id = shop_orders_total.orders_id";
> $stmt = $con->prepare($sql);
>
> $result = $stmt->execute();
> $ordini = self::populateObjects($stmt);
>
> return $ordini;
>
> }
>
> }
>
> And this is my generator.yml
>
> generator:
> class: sfPropelGenerator
> param:
> model_class: ShopOrder
> theme: admin
> non_verbose_templates: true
> with_show: false
> singular: ShopOrder
> plural: ShopOrders
> route_prefix: shop_order
> with_propel_route: 1
> actions_base_class: sfActions
>
> config:
> actions: ~
> fields: ~
> list:
> display: [customers_name, date_purchased, orders_status ]
> peer_method: getOrdini
> filter: ~
> form: ~
> edit: ~
> new: ~
>
> When i load the page of the list, the list is showed but I get this
> erro messages
>
> Notice: Undefined offset: 4 in /home/javier/Aptana_Studio_Workspace/
> dev_repo/lib/model/om/BaseShopOrder.php on line 1864
> Call Stack
> # Time Memory Function Location
> 1 0.0017 324556 {main}( ) ../backend_dev.php:0
> 2 0.0891 4457868 sfContext->dispatch( )
> ../backend_dev.php:13
> 3 0.0891 4457912 sfFrontWebController->dispatch( ) ../
> sfContext.class.php:170
> 4 0.0892 4464168 sfController->forward( ) ../
> sfFrontWebController.class.php:48
> 5 0.1181 5054656 sfFilterChain->execute( ) ../
> sfController.class.php:229
> 6 0.1188 5061248 sfRenderingFilter->execute( ) ../
> sfFilterChain.class.php:53
> 7 0.1188 5061248 sfFilterChain->execute( ) ../
> sfRenderingFilter.class.php:33
> 8 0.1191 5070452 sfBasicSecurityFilter->execute( ) ../
> sfFilterChain.class.php:53
> 9 0.1192 5070496 sfFilterChain->execute( ) ../
> sfBasicSecurityFilter.class.php:72
> 10 0.1196 5082256 sfExecutionFilter->execute( ) ../
> sfFilterChain.class.php:53
> 11 0.2778 11817440 sfExecutionFilter->handleView( ) ../
> sfExecutionFilter.class.php:47
> 12 0.2778 11817440 sfExecutionFilter->executeView( ) ../
> sfExecutionFilter.class.php:116
> 13 0.2815 11859256 sfPHPView->render( ) ../
> sfExecutionFilter.class.php:155
> 14 0.2815 11859632 sfPHPView->renderFile( )
> ../sfPHPView.class.php:
> 179
> 15 0.2855 11973804 require('/home/javier/Aptana_Studio_Workspace/
> dev_repo/cache/backend/dev/modules/autoOrdini/templates/
> indexSuccess.php') ../sfPHPView.class.php:75
> 16 3.0826 115065148 include_partial( ) ../indexSuccess.php:19
> 17 3.0826 115065148 get_partial( ) ../PartialHelper.php:180
> 18 3.0831 115068964 sfPartialView->render( )
> ../PartialHelper.php:
> 218
> 19 3.0832 115070248 sfPHPView->renderFile( ) ../
> sfPartialView.class.php:110
> 20 3.0866 115161828 require(
> '/home/javier/Aptana_Studio_Workspace/
> dev_repo_cashgold/cache/backend/dev/modules/autoOrdini/templates/
> _list.php' ) ../sfPHPView.class.php:75
> 21 3.6215 115636256 sfPropelPager->getResults( )
> ../_list.php:28
> 22 3.6215 115636668 call_user_func ( )
> ../sfPropelPager.class.php:
> 117
> 23 3.6216 115636696 ShopOrderPeer::getOrdini( ) ../
> sfPropelPager.class.php:0
> 24 3.6227 115676928 BaseShopOrderPeer::populateObjects( ) ../
> ShopOrderPeer.php:31
> 25 3.6229 115684084 BaseShopOrder->hydrate( )
>
> And then:
>
> Notice: Undefined offset: 5
> Notice: Undefined offset: 6
> ....
>
> This is the file BaseShopOrder.php
>
> try {
>
> $this->orders_id = ($row[$startcol + 0] !== null) ? (int)
> $row[$startcol + 0] : null;
> $this->sfgu_id = ($row[$startcol + 1] !== null) ? (int)
> $row[$startcol + 1] : null;
> $this->utenti_email = ($row[$startcol + 2] !== null) ?
> (string) $row[$startcol + 2] : null;
> $this->utenti_telefono = ($row[$startcol + 3] !== null) ?
> (string) $row[$startcol + 3] : null;
> $this->customers_name = ($row[$startcol + 4] !== null) ?
> (string) $row[$startcol + 4] : null; // line 1864
> $this->customers_company = ($row[$startcol + 5] !==
> null) ? (string) $row[$startcol + 5] : null;
> $this->customers_street_address = ($row[$startcol + 6] !==
> null) ? (string) $row[$startcol + 6] : null;
> $this->customers_suburb = ($row[$startcol + 7] !== null) ?
> (string) $row[$startcol + 7] : null;
> $this->customers_city = ($row[$startcol + 8] !== null) ?
> (string) $row[$startcol + 8] : null;
> $this->customers_postcode = ($row[$startcol + 9] !==
> null) ? (string) $row[$startcol + 9] : null;
> $this->customers_state = ($row[$startcol + 10] !== null) ?
> (string) $row[$startcol + 10] : null;
> $this->customers_country = ($row[$startcol + 11] !==
> null) ? (string) $row[$startcol + 11] : null;
>
> Any idea?
>
> Javi
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
