Problem resolved by creating a whole new project directory and
starting over.
I was able to copy all generator.yml files, partials, etc without
making any changes
and everything runs fine.
The only thing that I can think of that created the misbehavior in the
previous project
was the fact that I named a column sort_order and then specified it in
the generator
as the field to sort on. Subsequently, I removed it from the schema
and thought I
regenerated the entire app folder, the framework's generator did not
pick up that
one change. Doesn't make sense, but any other explanation just gets
weirder.
- Michael
On Feb 5, 7:08 pm, michael hodges <mhodg...@gmail.com> wrote:
> # In which file did you find the "sort_order"
> database_interface.lib.php
>
> # Did you clear the cache
> First I cleared the cache, but that didn't work
> Second I renamed the app directory and recreated it from scratch using
> just my schema and fixture
> Even with the classes and generator files back to their pristine
> states the error would not go away for the one class
> I then cleared the cache and hunted for any file with 'sort_order',
> and found no occurrences unaccounted for.
> Not sure what to do next, execpt to start over since there are no
> stones left that I know to look under.
>
> What's especially odd for that class is I can change the generator
> entry for limit and see in the logs that the change is
> processed. But there is nothing I can do in the generator.yml file
> to change the sort. Whatever I specify is ignored.
>
> Thanks for your response. Nice to see that this is an active list.
> - Michael
>
> On Feb 5, 12:40 am, Tom Ptacnik <to...@tomor.cz> wrote:
>
> > Did you cleared the cache folder?
>
> > In which file ddid you find the "sort_order" (as you said you have
> > found it in internal symfony files...)
>
> > On 4 ún, 09:29, michael hodges <mhodg...@gmail.com> wrote:
>
> > > Hello all,
>
> > > I'm new to Symfony. While I've been able to figure things out as I go
> > > along, this one is very strange. I had a column named 'sort_order'
> > > and used if in the generator.yml to request a sort in the list.
> > > Subsequently I removed it from the schema and regenerated everything,
> > > including the backend. No matter what I do, I can't get executeView
> > > not to include ORDER BY sort_order in the sql statement that creates
> > > the list. I can influence the LIMIT statement by updating the
> > > generator.yml file, but I cannot influence ORDER BY with the sort
> > > statement.
>
> > > I even used Spotlight to hunt for sort_by in the files and come up
> > > empty, except where it is used internally to symfony.
>
> > > Any clue as to what might be happening would be appreciated. My next
> > > step would be to do a clean install of everything and begin fresh,
> > > which would probably be good practice in any case.
>
> > > Thanks
> > > - Michael
>
> > > # at Doctrine_Connection->rethrowException(object('PDOException'),
> > > object('Doctrine_Connection_Mysql'), 'SELECT s.code AS s__code,
> > > s.description AS s__description, s.class_of_year AS s__class_of_year,
> > > s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM
> > > StudentClassStanding s ORDER BY sort_order asc LIMIT 300')
> > > in SF_ROOT_DIR/symfony-1.4.1/lib/plugins/sfDoctrinePlugin/lib/vendor/
> > > doctrine/Doctrine/Connection.php line 1025 ...
>
> > > 1022. } catch (Doctrine_Adapter_Exception $e) {
> > > 1023. } catch (PDOException $e) { }
> > > 1024.
> > > 1025. $this->rethrowException($e, $this, $query);
> > > 1026. }
> > > 1027.
> > > 1028. /**
>
> > > # at sfExecutionFilter->executeView('student_class_standing', 'index',
> > > 'Success', array('configuration' =>
> > > object('student_class_standingGeneratorConfiguration'), 'helper' =>
> > > object('student_class_standingGeneratorHelper'), 'filters' =>
> > > object('StudentClassStandingFormFilter'), 'pager' =>
> > > object('sfDoctrinePager'), 'sort' => array('sort_order', 'asc')))
> > > in SF_ROOT_DIR/symfony-1.4.1/lib/filter/sfExecutionFilter.class.php
> > > line 116 ...
> > > 113. return;
> > > 114. }
> > > 115.
> > > 116. $this->executeView($actionInstance->getModuleName(),
> > > $actionInstance->getActionName(), $viewName,
> > > $actionInstance->getVarHolder()->getAll());
>
> > > 117. }
> > > 118.
> > > 119. /**
>
> > > generator:
> > > class: sfDoctrineGenerator
> > > param:
> > > model_class: StudentClassStanding
> > > theme: admin
> > > non_verbose_templates: true
> > > with_show: false
> > > singular: ~
> > > plural: ~
> > > route_prefix: student_class_standing
> > > with_doctrine_route: true
> > > actions_base_class: sfActions
>
> > > config:
> > > actions: ~
> > > fields: ~
> > > list:
> > > max_per_page: 300
> > > sort: class_of_year
> > > filter: ~
> > > form: ~
> > > edit: ~
> > > new: ~
--
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-us...@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.
