Radicore Forum: Bug Reports » MNU_USER Incorrect Columns Spec and Cannot Re-Import

Home » RADICORE development » Bug Reports » MNU_USER Incorrect Columns Spec and Cannot Re-Import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

MNU_USER Incorrect Columns Spec and Cannot Re-Import [message #5901]

Wed, 28 September 2016 17:51

kong
Messages: 90
Registered: December 2011

Member

Noticed that starting from v1.95, mnu_user.dict.inc file shows:

$fieldspec['user_name']                 = array('type' => 'string',
                                                    'size' => 30);
    
$fieldspec['user_password']             = array('type' => 'string',
                                                    'size' => 16,
                                                    'password' => 'y',
                                                    'nosearch' => 'y',
                                                    'noaudit' => 'y');

Up till version v1.94 these used to be required fields. The database schema too showed that these should be required fields.
So, the first bug: Application crash whenever new user added without populating these fields, because the 'required' validation rule did not kick in.

Then, when tried to re-import MNU_USER table's columns in DICT module of v1.97 in the hope of correcting menu_user.dict.inc file, the column import function did not make 'user_name' and 'user_password' fields 'required'. So, that is the second problem: Columns import does not work for table MNU_USER.

Not sure these are related or not.

[Updated on: Wed, 28 September 2016 22:25]

Report message to a moderator

Re: MNU_USER Incorrect Columns Spec and Cannot Re-Import [message #5905 is a reply to message #5901]

Thu, 29 September 2016 05:45

AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK

Senior Member

You haven't identified which database you are using, so I'll assume that it's MySQL.

I have checked on my system that these two fields are marked as NOT NULL in the database, re-imported the data, and regenerated the mnu_user.dict.inc file and everything works as it should do.

Attached is a copy of the correct file.