Hi,

It's probably something I did .. :). Bulk deleted all aliases and then did a rebuild.

1. After the rebuild, it doubled all aliases, (path/name-0) so although it showed 0 aliases originally, it was still somewhere in the system.

2. Now when I create a node, it does not create an alias, but I have to bulk create to make them work.

Please, where can I delete all the aliases in sql, as now nodes are numbered at 11 000+ aliases, and definitely do not have that many. Have tried reinstalling the module, but still the same.

I also have global_redirect installed, maybe there is a conflict somewhere?

Anyhow, please, how do I delete all the aliases in the sql database, as even if the table url_aliases is empty, it still seems to be in the system.

Look forward to your reply, and thank you.
Lilian

Comments

liliplanet’s picture

liliplanet commented

Oops, gone from bad to worse. I've been trying to clean url_aliases and now have:

url_alias' doesn't exist query: SELECT COUNT(pid) FROM drupal_url_alias in /home/public_html/includes/database.mysqli.inc on line 128

Does someone perhaps have the table install for me please? Can't seem to find it in the module or install file ..

Or maybe a suggestion how to fix this?

Look forward to any help, and thank you.
Lilian

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Closed (won't fix)

It's provided by core's system.module. Your best bet is to restore from a database backup at this point.