-
☆ A M B ☆
- 309 Posts
Edited alias field using phpmyadmin but front end still using old alias:
- I changed several dozen pagetitles, longtitles and aliases using phpmyadmin
- Noticed that the front end was still using the old alias although the page titles and long titles had updated.
- In the manager I opened a few of the edited pages to check if the new aliases were showing, they were.
- Re-saved the pages through the manager hoping that would fix it. (Had to delete and re-type a character in order to activate the Save button.)
No luck.
- Throughout this process I repeatedly cleared the cache, flushed permissions, logged out and in of the manager, refreshed phpmyadmin, closed phpmyadmin, cleared the browser cache...
So now I have a database and manager pages that show new alias names, but a front end that is using the old alias names. If I manually type one of the new aliases in the browser it is not found. Not understanding how the information stored in the manager and database can be ignored; I have to assume the aliases are stored somewhere else. How do I access this and push the change?
- Revolution 2.2.2-pl (advanced)
- PHP Version 5.2.17
- MySQL Version: 5.1.66 community log
- Installed MODX Add-ons: CodeMirror, Gallery, GetResources, SimpleSearch, TinyMCE, WayFinder
- Error Log Contents: [2012-11-16 09:26:13] (ERROR @ /connectors/resource/locks.php) xPDO->removeObject - Error deleting modDbRegisterMessage instance using query DELETE FROM `modx_register_messages` WHERE ( `modx_register_messages`.`topic` = 1 AND `modx_register_messages`.`id` = 'c51ce410c124a10e0db5e4b97fc2af39' )
-
☆ A M B ☆
- 24,524 Posts
Try manually deleting all the folders in the core/cache/ folder.
-
☆ A M B ☆
- 309 Posts
Thanks Susan, I fully expected that to work. Strangely, it didn't. I tried twice.
So far the only thing I've found that works is to open each resource in the manager, type a different new alias, save it, then re-enter the new alias I had inputted through phpmyadmin, and save again. Simply saving the new alias that is already in the resource page doesn't work, I assume because it doesn't register as a change...?
I had hoped to avoid opening and saving each resource through the manager - the page reload drives me batty and with dozens of changes to make it's maddening.
-
☆ A M B ☆
- 309 Posts
Could it be another cache folder, other than those in core?
discuss.answer
-
☆ A M B ☆
- 1,056 Posts
Quote from: lucy at Nov 16, 2012, 02:36 PMCould it be another cache folder, other than those in core?
Lucy,
Since MODx Revolution, there is a new `uri` column on the `modx_site_content` table. Unfortunately, changing the alias directly in the database and clearing the cache does not seem to refresh the configured URI for your resources.
I can't find my original post, but basically I found one way to regenerate the URIs via the MODx Manager, and that by following these steps:
- Go to System > System Settings
- Search for friendly_urls setting.
- Change it to No, and wait for it to complete.
- Change it back to Yes.
You should see that the URI column has been regenerated with any new alias or parent hierarchy changes made via the database directly.
-
☆ A M B ☆
- 309 Posts
Thanks Mike, that did the trick!
Now that you mention it, I remember seeing the URI column while I was editing records in phpmyadmin and was mildly curious that it couldn't be edited from there. I figured it would take care of itself once MODX refreshed everything. I guess I shouldn't have been so optimistic!
Was your original post in these forums? Because I did a fair bit of searching here before posting my question and couldn't come up with anything related...
-
☆ A M B ☆
- 1,056 Posts
Quote from: lucy at Nov 16, 2012, 05:17 PMThanks Mike, that did the trick!
[...]
Was your original post in these forums? Because I did a fair bit of searching here before posting my question and couldn't come up with anything related...
You're quite welcome!
Yes, it was in these forums, and I have been looking everywhere for that post... it almost seems like it is lost.
Nevertheless, it was related to the
method that gets triggered when
friendly_urls is set
on, and I recall @opengeek even replied suggesting it be added as feature in the MODx Manager menu.
Glad it worked!
EDIT:
Feature request added!
http://tracker.modx.com/issues/9129
[ed. note: pixelchutes last edited this post 13 years, 10 months ago.]
