Profile Page URL

Has anyone been able to have the profile page urls like it is here on UNA:

https://site.com/u/name

  • 227
  • More
Replies (14)
    • INSERT INTO `sys_seo_uri_rewrites` (`id``uri_orig``uri_rewrite`VALUES (NULL'view-persons-profile''u')
      
      • Sorry, where do I add this code? Into a raw block on a view profile page?

        • No it's for mysql database) via phpmyadmin for example.

          • @Rocco You are really great in helping the UNA community's complaints. Your help is truly extraordinary. Hopefully you will always be healthy and everything will be easy for you. I also have 1 help from you. How to add some of these tables written by @Alex T⚜️

            https://una.io/cmts-view/1l129mt?sys=bx_forum&cmt_id=43455

            • Hey @Karina

              Alex T provided the solution to that question here:

              https://una.io/d/why-do-my-post-links-look-different

              • Hey @Karina

                Alex T provided the solution to that question here:

                https://una.io/d/why-do-my-post-links-look-different

                • Hey @Karina

                  Alex T provided the solution to that question here:

                  https://una.io/d/why-do-my-post-links-look-different

                  • Hi @OneEagle ! Thank you but, I don't know where to access this table to add those values in?

                    • And where would I find this table: sys_seo_uri_rewrites?

                      • Hi @Sensasi.Net. Okay here is the step by step:

                        1. Go into Studio -> Settings -> Permalinks and confirm all are Enabled, especially Enable SEO links**
                        2. Go into your phpMyAdmin in your Cpanel and select your database. (To find your database see this file: /inc/header.inc.php)
                        3. Click on SQL (tab) to run SQL query. Here is the code ->

                        image_transcoder.php?o=sys_images_editor&h=1728&dpx=2&t=1703866271Lastly, click GO, and it should work.

                        • @Karina To achieve that is quite easy. Here is a short guide.

                          In your database, e.g. MySQL, MariaDB, or whatever database you are using, you have to insert the following data in the 'id'. 'uri_orig' and 'uri_rewrite' fields of your 'sys_seo_uri_rewrites' table as suggested by @Alex T⚜️ :

                          RECORDS TO INSERT:

                          Rewrite Rule #1:

                          id: 1

                          uri_orig: view-group-profile

                          uri_rewrite: g

                          Rewrite Rule #2:

                          id: 2

                          uri_orig: view-persons-profile

                          uri_rewrite: u

                          Rewrite Rule #3:

                          id: 3

                          uri_orig: view-organization-profile

                          uri_rewrite: o

                          Rewrite Rule #4:

                          id: 4

                          uri_orig: item

                          uri_rewrite: i

                          Rewrite Rule #5:

                          id: 5

                          uri_orig: view-post

                          uri_rewrite: p 

                          Rewrite Rule #6:

                          id: 6

                          uri_orig: view-discussion

                          uri_rewrite: d

                          Rewrite Rule #7:

                          id: 7

                          uri_orig: view-event-profile

                          uri_rewrite: e

                          HOW TO DO THAT?

                          Please backup your 'sys_seo_uri_rewrites' table: or database first.

                          Assuming that you are using phpMyAdmin as your database administration / management tool:

                          OPTION 1: USING THE INSERT TAB

                          Please open the 'sys_seo_uri_rewrites' table and click on the 'Insert' tab. 

                          Enter the data in the corresponding fields and click on 'Go' to store them.

                          Records you just inserted can be seen by checking the 'Browse' tab.

                          Note: You don't need to enter the 'id' value. The 'id' field is an auto-increment field, meaning the id will be generated automatically when a new record is inserted into the table. Just enter records (data) in sequence as shown above. But it's ok if you would like to enter it (the 'id' value) manually. There is no problem at all.

                          OPTION 2: RUNNING A DATABASE QUERY

                          A. SINGLE ROW INSERT (One by One):

                          Just run the following database query:

                          INSERT INTO `sys_seo_uri_rewrites` (`id`, `uri_orig`, `uri_rewrite`) VALUES (NULL, 'view-group-profile', 'g');
                          

                          Please repeat this query for all the remaining Rewrite Rules listed above one by one (view-persons-profile, view-organization-profile etc) 

                          Same here, you don't need to enter the 'id' value as explained above.

                          Would you like to enter the id manually? Then, in the query, replace NULL with the 'id' value like this:

                          INSERT INTO `sys_seo_uri_rewrites` (`id`, `uri_orig`, `uri_rewrite`) VALUES ('1', 'view-group-profile', 'g');
                          

                          B. MULTIPLE ROW INSERT (BEST OPTION):

                          To make your life easier and instead of inserting rows one by one, you can just insert them all in a single database query like this (my favorite option so far):

                          INSERT INTO `sys_seo_uri_rewrites` (`id`, `uri_orig`, `uri_rewrite`) VALUES
                          (1, 'view-group-profile', 'g'),
                          (2, 'view-persons-profile', 'u'),
                          (3, 'view-organization-profile', 'o'),
                          (4, 'item', 'i'),
                          (5, 'view-post', 'p'),
                          (6, 'view-discussion', 'd'),
                          (7, 'view-event-profile', 'e');
                          

                          No matter which option you choose, If everything is done correctly, your 'sys_seo_uri_rewrites' table should look like the screenshot attached to this post.

                          All credit goes to @Alex T⚜️ and UNA Team:

                          https://unacms.com/cmts-view/1l129mt?sys=bx_forum&cmt_id=43455

                          image_transcoder.php?o=sys_images_editor&h=1729&dpx=2&t=1703874696

                          • wow - thank you @OneEagle ! I didn't realize there were quite a few ways of doing this.

                            • I've got it from @Alex T⚜️ . The following is the code used by UNA.

                              INSERT INTO `sys_seo_uri_rewrites` (`id`, `uri_orig`, `uri_rewrite`) VALUES
                              (1, 'view-group-profile', 'g'),
                              (2, 'view-persons-profile', 'u'),
                              (3, 'view-organization-profile', 'o'),
                              (4, 'item', 'i'),
                              (5, 'view-post', 'p'),
                              (6, 'view-discussion', 'd'),
                              (7, 'view-event-profile', 'e'),
                              (9, 'view-project-profile', 'project');
                              
                              • You are welcome @Karina. Yes are right :)

                                Login or Join to comment.