Sails-mongo many to many association not working

Question

I am using sails 0.10.5 , and i have two models as below for many to many relation. but i am getting error while lifting app.

model 1) Category.js

attributes: {
        name: {
            type: 'string',
            required: true
        },
        features: {
            type: 'array'
        },
        desc: {
            type: 'string'
        },
        sub_cats: {
            collection: 'SubCategory',
            via: 'cats',
            dominant: true
        }
    }

model 2) SubCategory.js

attributes: {

        cats: {
            collection: 'Category',
            via: 'sub_cats'
        },
        name: {
            type: 'string',
            required: true
        },
        features: {
            type: 'array'
        },
        desc: {
            type: 'string'
        }
    }

Now while lifting sails app, this error always trigger

"C:\Program Files (x86)\JetBrains\PhpStorm 8.0.2\bin\runnerw.exe" "C:\Program Files\nodejs\node.exe" app.js

c:\wamp\www\holymantra\hm\node_modules\sails\node_modules\waterline\node_modules\waterline-schema\lib\waterline-schema\utils.js:47
  return hop.call(obj, prop);
             ^
TypeError: Cannot convert null to object
    at hasOwnProperty (native)
    at exports.object.hasOwnProperty (c:\wamp\www\holymantra\hm\node_modules\sails\node_modules\waterline\node_modules\waterline-schema\lib\waterline-schema\utils.js:47:14)
    at JoinTables.parseAttribute (c:\wamp\www\holymantra\hm\node_modules\sails\node_modules\waterline\node_modules\waterline-schema\lib\waterline-schema\joinTables.js:148:26)
    at c:\wamp\www\holymantra\hm\node_modules\sails\node_modules\waterline\node_modules\waterline-schema\lib\waterline-schema\joinTables.js:83:22
    at Array.forEach (native)

So i am confused (my code is wrong or there is some problem in sails-mongo many-many relation)

--ND

score 1 · Answer 1 · answered Feb 06 '15 at 12:50

1

It is just a typo in SubCategory.js: It should be attributes instead of attribute.

answered Feb 06 '15 at 12:50

roign

452
5
10

Could you try to start the app with `sails lift` or `node app.js` from a console? – roign Feb 11 '15 at 20:29
@NishchitDhanani and do you have any other models? – roign Feb 12 '15 at 07:14
Ya i have tried all the possibilities. And i have other models but these models are in relation at this point. – Nishchit Feb 12 '15 at 12:52

score 1 · Answer 2 · answered Apr 28 '15 at 17:48

Hopefully you've solved your problem by now! For others like me who ran into this error, balderdashy/waterline-schema just released a more helpful error message at https://github.com/balderdashy/waterline-schema/issues/17 which should help you figure out your particular problem. Because as of today (2015-04-28) npm install does not get you this most recent version, you can manually fix it by doing the following:

Navigate to node_modules/sails/node_modules/waterline/node_modules/waterline-schema/lib/waterline-schema (note: this may be in your global sails directory)
Replace joinTables.js with https://github.com/balderdashy/waterline-schema/blob/8f5a44d076ca36edea409bf41ac2cdbf760c2c59/lib/waterline-schema/joinTables.js

I know this doesn't exactly answer your question as to what went wrong, but hopefully it will give others with that error the tools to solve it more quickly.

Sails-mongo many to many association not working

2 Answers2