Radicore Forum: Bug Reports » v1.81.0 dict-schema.sql, dict-data.sql

Home » RADICORE development » Bug Reports » v1.81.0 dict-schema.sql, dict-data.sql (table dict_relationship insert into column count mismatch)

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

v1.81.0 dict-schema.sql, dict-data.sql [message #3986]

Sun, 01 December 2013 15:03

jbusciglio
Messages: 4
Registered: November 2013

Junior Member

I checked the schema and data for both mySql and sqlsrv,

it looks to me like the schema has the column for table dict_relationship:

mysql - `key_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'PRIMARY'

sqlsrv - key_name nvarchar(64) NOT NULL DEFAULT 'PRIMARY'

there are a total of 18 columns in the schema for this table. The data inserts only have 17 columns.

key_name is the 14th column. I am not sure if I should omit this column in the schema or insert the not null default value of 'PRIMARY' for each record. Both options don't seem feasible.

Since I am not sure what that field controls, I don't know what other values it might take besides 'PRIMARY'. I will try and leave the field to '' and see what happens.

Report message to a moderator