PathAuto indices and user
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 120If 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 120Additionally, 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!
Same here
Same problem here for 4.7.0.
Any luck so far, Nick?
Hmm... I think the first
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?
Hey Ramdak, excuse my ignorance, but what's the OG module?
organic groups module:-)
organic groups module:-)
Original Gangster
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?'