PathAuto indices and user

Posted by Nick Urban on July 6, 2006 at 2:52am

I feel like I must be misunderstanding this problem, because I haven't found ANY posts on this and I've been searching for a while (including the mailing list). Basically, my PathAuto indices don't work at all. This is Drupal 4.7.2.

Under the user account page pattern I have: users/[user]. blogs: users/[user]/blog. Blog entries: users/[user]/blog/[title].

I have "Create Index Aliases" checked, and all of the bulk update boxes checked. PathAuto says it has created node, user, and blog aliases, but 0 index aliases.

If I visit /users/nick_urban, it worked as expected, but if I visit /users, instead of a list of the user pages (which is what is supposed to happen, right?), it gives me an SQL error:

Warning: preg_replace(): Unknown modifier '\' in [DELETED]/includes/database.inc on line 283

Warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN node_access na ON na.nid = users/.nid WHERE (na.gra query: INNER JOIN node_access na ON na.nid = users/.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'og_all') OR (na.gid = 4 AND na.realm = 'og_subscriber') OR (na.gid = 8 AND na.realm = 'og_subscriber'))) in [DELETED]/includes/database.mysql.inc on line 120

Warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN node_access na ON na.nid = users/.nid WHERE (na.gra query: INNER JOIN node_access na ON na.nid = users/.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'og_all') OR (na.gid = 4 AND na.realm = 'og_subscriber') OR (na.gid = 8 AND na.realm = 'og_subscriber'))) LIMIT 0, 10 in [DELETED]/includes/database.mysql.inc on line 120

If I visit /pathauto/node, I get this error:

Warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(.nid) FROM url_alias a INNER JOIN node n ON a.src = CONCAT('no query: SELECT nDISTINCT(.nid) FROM url_alias a INNER JOIN node n ON a.src = CONCAT('node/', n.nid) WHERE n.status = 1 AND a.dst LIKE '%' ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in [DELETED]/includes/database.mysql.inc on line 120

Additionally, I deleted all the path entries and tried this again, and now pathauto is creating the alias /users/nick_urban_0 instead of /users/nick_urban. This is not true for the nested links, i.e. /users/nick_urban/blog/testing_pathauto works fine (/users/nick_urban/blog gets "page not found" but no SQL error). /users/nick_urban/blog_0 works fine.

Any ideas why my indexes don't work and I'm getting mysterious _0's appended to my paths?

Thanks!

Comments

Same here

Posted by appel on July 26, 2006 at 8:51am

Same problem here for 4.7.0.
Any luck so far, Nick?

'What's a Texas?'

Hmm... I think the first

Posted by venkat-rk on July 26, 2006 at 9:55am

Hmm... I think the first error is actually not pathauto but the OG module. Pathauto support was recently added to OG, so that might be problem.

What's the OG module?

Posted by appel on July 26, 2006 at 3:11pm

Hey Ramdak, excuse my ignorance, but what's the OG module?

'What's a Texas?'

organic groups module:-)

Posted by venkat-rk on July 26, 2006 at 3:37pm

organic groups module:-)

Original Gangster

Posted by appel on July 27, 2006 at 7:28am

Right, right.. and I thought it meant 'Original Gangster', figured it was similar to the pirate module :)
OG's not a part of the core module set, is it? I don't have it installed, so it cannot be blamed I guess. I took drastic measures already: uninstalled the pathauto plugin, which fixed the problem. Had no real need for it anyway and it seems to boost performance.

Thanks.

'What's a Texas?'