Bug in Skills field in 14.0.0-B1

If users add new skills in the profile get profile info persons-profile-info/test-user-name to look like this(the language ned to be restored in studio/module.php?name=bx_developer&page=polyglot):

About Test User Name
__icon__ __image__ Gender:
Man
__icon__ __image__ Age:
88
__icon__ __image__ Name:
Test User Name
__icon__ __image__ Email:
test@exemple.com
__icon__ __image__ Status:
Active
__icon__ __image__ Last account activity:
a few seconds ago

  • 170
  • More
Replies (10)
    • Also there is an error in db:

      Jun 04 22:40:01 [4] /edit-persons-profile/test-user-name Database query error
        Error: Unknown column 'skill_name[]' in 'where clause'Query: SELECT 1 FROM `bx_persons_skills` WHERE 1 AND `skill_name[]`=? LIMIT 1Account ID: 1
      
      • It seems that when installing a module, many column are missing from the table, it is common in many modules, not just this one, however, I checked in the database and it exists.
        
        • Hello @Romulus !

          In this part it looks like the new field has been created only in the sys_form_inputs table. Try to delete it and create again. BTW - under what name did you try to add it? I mean next time it's better to use the name without [] symbols.

          • Any name, It was my name "Name Surname", there is only an example, I did not use symbols, there was only a space between the name and surname. I just edited here "Test User Name", but the error is repeated in any profile. After reload the skill disappears.

            • It would be beneficial to have the ability to add skills, skill categories, and subcategories in the backend as a taxonomy. Users should be able to search only within the existing skills with autocomplete, with the option to propose new skills if they do not exist. If these proposed skills are approved by the admin, they will become available to other users as well.

              For all site fields and categories, implementing a taxonomy module would be advantageous. This module would manage all categories, allowing any other module to link desired fields to a taxonomy field. This would simplify both population and administration.

              With this system, new fields can be added by selecting a taxonomy field type, making it usable by any module. Additionally, a taxonomy field can be utilized by multiple modules simultaneously, simply by linking to it.

              In the taxonomy, it would be possible to create lists at a single level or across multiple levels, depending on preferences. These lists can include any data from any module, stored at either a single level or multiple levels, and can be edited if necessary. Certain user levels, such as those with more points as determined by the admin, could have the privilege to add new fields. This modular approach would enhance ease of administration and overall usability.

              • I deleted the new Skill "Architect" from skills field and added it several times, it doesn't work, the error is always the same. Also i tray to inactivate persons module and reactivate again. The skill field cannot be populated from the profile with more skills, users cannot add their skills. It is a module programming error. Otherwise it seems to work well. I will do other tests with other functionalities.

                • After disable and enable the module persons again, Skill architect compiles correctly and not more errors in the db, but the other fields are no longer visible correctly. I have to delete the architect field from the profile and recompile the language so that the html info block can be visualized correctly. If you have any idea what I could do about this I would be grateful. I will deactivate and reactivate the account module, maybe it has something to do with it. it seems that some modules after being installed have to be activated and reactivated again to work correctly.

                  this is how its look like the profile info after a user add a new skill : Info
                  
                  __icon__ __image__ Skills:
                  
                  
                  
                  
                  Name:
                  
                  Architect
                  
                  0
                  
                  __icon__ __image__ Upload a profile picture:
                  
                  a:1:{i:0;s:23:"bx_persons_picture_crop";}
                  
                  __icon__ __image__ Gender:
                  
                  Man
                  
                  __icon__ __image__ Age:
                  
                  49
                  
                  __icon__ __image__ Name:
                  
                  Romulus
                  
                  __icon__ __image__ Status:
                  
                  Active
                  
                  __icon__ __image__ IP:
                  
                  127.0.0.1
                  
                  __icon__ __image__ Last account activity:
                  
                  a few seconds ago
                  
                  __icon__ __image__ Added:
                  
                  20 May 2024
                  
                  __icon__ __image__ Updated:
                  
                  6 Jun 2024
                  
                  __icon__ __image__ Friends count:
                  
                  5
                  
                  __icon__ __image__ Followers count:
                  
                  5
                  
                  • going to

                    www.exemple.com/studio/module.php?name=bx_developer&page=forms&form_page=fields 
                    

                    i select filter persons, edit person view If I want to click on the edit field "skills" button in developer, it does not open, I cannot see what is in it. I can modify the other fields or view them, but I think this one has a problem somewhere in the database or in the code. Also from filter Full viev person the field skills edit buton dont open any window. in the db dot.gif

                    SELECT * FROM `bx_persons_skills`

                     MySQL returned an empty result set (i.e. zero rows). (Query took 0.0001 seconds.)

                    skill_id skill_name content_id

                    This is how the tables with the three columns look.

                    i i add from the profile edit skill Arhitect i wil have this valuie in the table tSELECT * FROM `bx_persons_skills`

                    6 Architect 1

                    so the problem is in the code somewhere., the skill go in the table

                      • Thanks Alex T for open the ticket

                        Login or Join to comment.