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
-
- · Romulus
- ·
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
-
- · Romulus
- ·
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.
-
-
·
LeonidS
-
·
In reply to Romulus
- ·
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.
-
·
LeonidS
-
- · Romulus
-
·
In reply to LeonidS
- ·
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.
-
- · Romulus
-
·
In reply to LeonidS
- ·
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.
-
- · Romulus
-
·
In reply to LeonidS
- ·
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.
-
- · Romulus
-
·
In reply to LeonidS
- ·
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
-
- · Romulus
-
·
In reply to LeonidS
- ·
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
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 t
SELECT * FROM `bx_persons_skills`
6 Architect 1
so the problem is in the code somewhere., the skill go in the table
-
-
·
Alex T⚜️
- ·
thank you for the report - https://github.com/unacms/una/issues/4727
-
·
Alex T⚜️
-
- · Romulus
-
·
In reply to Alex T⚜️
- ·
Thanks Alex T for open the ticket