If You are training Jobeet with v. 1.4 Doctrine  there is differences
in schema.yml shown in web  compared with  the file in repository
http://svn.jobeet.org/doctrine/tags/release_day_07/config/doctrine/schema.yml,
where there  is additional  actAS: Sluggable
which meaning is then explained on day 19 lessons.

When loading data with this schema, pager runs normally.



On 14 joulu, 11:07, Tapio <[email protected]> wrote:
> Hi,
>
> Working with Jobeet  tutorial SF v.1.4 +Doctrine.
>
> I have Jobeet_category-table as follows
> id      name
> 5       Design
> 6       Programming
>
> Selecting jobs with categories /programming ends up into ID 5 whichs
> is category id for  design as can be seen from log below.
>
> Selecting category design  ends up into design-category  too.
>
> Otherwise application runs as it should.
>
> routing.yml is
> category:
>   url:      /category/:slug
>   class:    sfDoctrineRoute
>   param:    { module: category, action: show }
>   options:  { model: JobeetCategory, type: object }
> job:
>   class:   sfDoctrineRouteCollection
>   options: { model: JobeetJob }
>
> job_show_user:
>   url:     /job/:company_slug/:location_slug/:id/:position_slug
>   class:   sfDoctrineRoute
>   options: { model: JobeetJob, type: object }
>   param:   { module: job, action: show }
>   requirements:
>     id: \d+
>     sf_method: [get]
>
> How to fix this?
> -----
> Dec 14 10:35:16 symfony [info] {sfPatternRouting} Match route
> "category" (/category/:slug) for /category/programming with parameters
> array (  'module' => 'category',  'action' => 'show',  'slug' =>
> 'programming',)
> Dec 14 10:35:16 symfony [info] {sfFilterChain} Executing filter
> "sfRenderingFilter"
> Dec 14 10:35:16 symfony [info] {sfFilterChain} Executing filter
> "sfExecutionFilter"
> Dec 14 10:35:16 symfony [info] {categoryActions} Call 
> "categoryActions->executeShow()"
>
> Dec 14 10:35:16 symfony [info] {Doctrine_Connection_Mysql} exec : SET
> NAMES 'UTF8' - ()
> Dec 14 10:35:16 symfony [info] {Doctrine_Connection_Mysql} query :
> SELECT j.id AS j__id, j.name AS j__name, j.created_at AS
> j__created_at, j.updated_at AS j__updated_at FROM jobeet_category j -
> ()
> Dec 14 10:35:16 symfony [info] {Doctrine_Connection_Statement}
> execute : SELECT COUNT(*) AS num_results FROM jobeet_job j WHERE
> j.category_id = ? AND j.expires_at > ? - (5, 2009-12-14 10:35:16)
> Dec 14 10:35:16 symfony [info] {sfPHPView} Render "/Applications/MAMP/
> htdocs/symo/jobeet/apps/frontend/modules/category/templates/
> showSuccess.php"

--

You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.


Reply via email to