Ceon URI Mapping v4.x

[kitten091182]

If still have an error with that, temporarily create a new field that is autonumber/unique so that phpmyadmin can play with it, then I suggest deleting that column. This is something I have done to make a "quick/bulk" change. (Lazily)

To be honest with you, all of that just went way over my head! I'm not too good when it comes to SQL. It doesn't really matter if somebody has bookmarked the page, it wasn't up for long so I'm not sure that anybody would have done anyway. I just need to change get-boosted to ways_to_pay. I'll backup my database and have a play.
Thanks

[mc12345678]

To be honest with you, all of that just went way over my head! I'm not too good when it comes to SQL. It doesn't really matter if somebody has bookmarked the page, it wasn't up for long so I'm not sure that anybody would have done anyway. I just need to change get-boosted to ways_to_pay. I'll backup my database and have a play.
Thanks

Well, so much for trying to teach to fish.
In the ZC admin SQL patch tools option, copy and paste the following:

This assumes that your store is at your root directory and only does an update of your existing uri, less than ideal as described, but if this is what is desired, then here it is: otherwise could change the uri= statement to current_uri=0 and then insert a new entry with your desired information for the uri.

Update ceon_uri_mappings set uri=/ways_to_pay where main_page=page_2;

[kitten091182]

Hi, thanks for the help