| Out of Sync Data in DICT [message #5909] |
Thu, 29 September 2016 12:54  |
kong
Messages: 90
Registered: December 2011
|
Member |
|
|
Notice that in dict/sql/mysql/dict_data.sql there are references to a column_id 'language_code' related to the mnu_user table. However, in the mnu_user schema there is no such a column. I suspect that some time in history 'language_code' was renamed to 'language_id' and remnants of this evolution still hiding in the DICT module. In v1.97 for example, the file dict-data.sql dates back to 2014.
When you try to re-import the columns in mnu_user via the DICT module (for example to solve http:// radicore.org/fud/index.php?t=msg&th=2293&start=0& ;amp ;amp ;amp ;amp ;), you will detect a hidden error with a debugger during the process: [language_code] 0: Cannot delete - record still linked to DICT_RELATED_COLUMN table
Now, when you try to create a new user: Fatal Error: MySQL: Unknown column 'language_code' in 'field list' (# 1054)
Interestingly, when you try to log out, you will have found an unrelated bug (http:// radicore.org/fud/index.php?t=msg&th=2294&start=0& ;amp ;amp ;amp ;amp ;) : Fatal Error: MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), (SELECT role_desc FROM mnu_user_role LEFT JOIN mnu_role ON (mnu_role.role_id=' at line 1 (# 1064)
SQL query: SELECT SQL_CALC_FOUND_ROWS mnu_user.*, mnu_account.account_name, (SELECT GROUP_CONCAT(role_desc ORDER BY is_primary DESC, mnu_user_role.role_id ASC SEPARATOR ', ') FROM mnu_user_role LEFT JOIN mnu_role ON (mnu_role.role_id=mnu_user_role.role_id) WHERE user_id=mnu_user.user_id) AS role_list), (SELECT role_desc FROM mnu_user_role LEFT JOIN mnu_role ON (mnu_role.role_id=mnu_user_role.role_id) WHERE user_id=mnu_user.user_id AND is_primary='Y' LIMIT 1) AS role_id FROM mnu_user LEFT JOIN mnu_account ON (mnu_account.rdcaccount_id=mnu_user.rdcaccount_id) WHERE mnu_user.user_id='EKL' ORDER BY mnu_user.user_name asc
So, what I did to re-import the columns of mnu_user:
(1) Make sure you first delete the parent relationship with mnu_language.
(2) Re-import the columns of mnu_user.
(3) Re-create the parent relationship with the mnu_language table.
(4) Export to PHP
For future releases, might want to think about:
(1) Fix code to show above mentioned hidden error on the screen.
(2) Update dict_data.sql file for new installs.
(3) Migration file to update data in DICT database to reflect schema changes in AUDIT, MENU and WORKFLOW.
[Updated on: Thu, 29 September 2016 13:27] Report message to a moderator |
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
