Slugs not generating automatically for anything

[gerard]

Hey everyone,

This post is related to http://groups.google.com/group/diem-users/browse_thread/thread/4214b29a211e57e2#

I decided to create a new post because that one ended up all over the
place with no resolution on my part.

When I follow the Diem blog engine tutorial or attempt to create any
diem module, everything appears to work fine except the Automatic SEO
responsible for generating the page slugs.

I thought maybe it was my environment, doctrine schema, database
structure, ect, but none of those seem to be the case.

In this latest attempt, I simply installed the IrNews plugin (http://
diem-project.org/plugins/lrnewsplugin).

Everything works except the slugs. In the page tree, new articles
appear with blank titles under "Articles". In the admin, the "show"
link is always index.php.

The dm_auto_seo and dm_auto_seo_translation both have the correct
records. The Automatic SEO tab for this in the admin also has the
correct information and even uses the example record I created to show
a fully formed slug. When I try to go to the url using that slug, it
just does a smart 404 redirect.

My Environment:
CentOS6
Diem 5.1.3
symfony 1.4.7-DEV
PHP 5.3.2
APC 3.1.9

The site in production: http://www.leadfusion.com

Thanks

[gerard]

Oh, and here is a test page with the article list

http://www.leadfusion.com/dev.php/test

On Jan 28, 3:38 pm, gerard <gerard.finne...@leadfusion.com> wrote:
> Hey everyone,
>

> This post is related tohttp://groups.google.com/group/diem-users/browse_thread/thread/4214b2...

[gerard]

I am able to loremize articles without error unless I create an
article of my own first.

Once that first article is created, pdo exceptions get thrown just as
when dm:sync or dm:sync-pages is run.

I cannot successfully set ATTR_MYSQL_ATTR_USE_BUFFERED_QUERY in
databases.yml.

The first article (record) I create on my own tends to work,
generating a page and allowing me to contextually place the article
within it.
Once there are two or more records, the pdo error is consistently
thrown. This can be found in both the front and admin.


On a side note, is the diem mirc chat dead?

[gerard]

I managed to "fix" this, but I could use some perspective.

The first article is successfully added to lr_article,
lr_article_translation and dm_page_translation.

All subsequent articles are only added to lr_article and
lr_article_translation, but not dm_page_translation.

In diem-5.1.3/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/
Doctrine/Connection.php on line 911, I added:
$this->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);

This doesn't seem like a good solution to me, but it fixes it.

If there is a way to set this in databases.yml, it would make more
sense, but I get an error when attempting this.
According to http://www.symfony-project.org/reference/1_4/en/07-Databases,
MYSQL_ATTR_USE_BUFFERED_QUERY is not an attribute that can be set.

What I don't understand is, I've read in multiple places that
MYSQL_ATTR_USE_BUFFERED_QUERY is set to true by default as of 5.2.1,
but I'm using 5.3.2 and still had to set this manually.

[Jacek Jędrzejewski]

You can always configure your connection in ProjectConfiguration class and set this constant there, without hacking doctrine

[Stéphane]

ProjectConfiguration->configureDoctrine(Doctrine_Manager $manager)
{
//here
}

2012/1/30 Jacek Jędrzejewski <jacek.jed...@gmail.com>