1 Topic by apmuthu (edited by apmuthu 04/08/2015 11:12:43 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Topic: FA 2.3 DB Fixes

FA 2.3 database fixes and notes:

1. 0_comments table has no primary key. Correct it with:

ALTER TABLE `0_comments` ADD PRIMARY KEY (`type`, `id`), DROP INDEX `type_and_id`;

2. Table field 0_gl_trans.person_id is tinyblob Nullable. In some cases it is a blank string and in others it is 0 when not a valid integer.

3. Table field 0_gl_trans.person_type_id is 1, 2, or 3 and NULL.

apmuthu's Website