V. 8.1.8
Description: when creating node or nodets project with quasar vue (did not test with other frameworks)
Table1 : users (id, name, password ,…department_id)
Table2 departments (id, name)
in list page of users => Field deoartment_id properties creating a master detail relation users.department_id=departments.id , detailpage view, displaytext departments.name
[nodemon] starting
node app.js
Server is up and running on port: 8060
Executing (default): SELECT
users
.id
, users
.username
, “departments”.“name” AS “departments_name”, users
.department_id
, users
.email
, users
.phone
, users
.image
FROM users
AS users
INNER JOIN departments
AS departments
ON users
.department_id
= departments
.id
ORDER BY id desc LIMIT 0, 10;Executing (default): SELECT count(
users
.id
) AS count
FROM users
AS users
INNER JOIN departments
AS departments
ON users
.department_id
= departments
.id
;Server Request Error DatabaseError [SequelizeDatabaseError]: SQLITE_ERROR: ambiguous column name: id
at Query.formatError (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:403:16)
at Query._handleQueryResponse (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:72:18)
at afterExecute (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:238:27)
at Statement.errBack (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sqlite3\lib\sqlite3.js:14:21) {
parent: [Error: SQLITE_ERROR: ambiguous column name: id] {
errno: 1,
code: ‘SQLITE_ERROR’,
sql: ‘SELECT
users
.id
, users
.username
, “departments”.“name” AS “departments_name”, users
.department_id
, users
.email
, users
.phone
, users
.image
FROM users
AS users
INNER JOIN departments
AS departments
ON users
.department_id
= departments
.id
ORDER BY id desc LIMIT 0, 10;’},
original: [Error: SQLITE_ERROR: ambiguous column name: id] {
errno: 1,
code: ‘SQLITE_ERROR’,
sql: ‘SELECT
users
.id
, users
.username
, “departments”.“name” AS “departments_name”, users
.department_id
, users
.email
, users
.phone
, users
.image
FROM users
AS users
INNER JOIN departments
AS departments
ON users
.department_id
= departments
.id
ORDER BY id desc LIMIT 0, 10;’},
sql: ‘SELECT
users
.id
, users
.username
, “departments”.“name” AS “departments_name”, users
.department_id
, users
.email
, users
.phone
, users
.image
FROM users
AS users
INNER JOIN departments
AS departments
ON users
.department_id
= departments
.id
ORDER BY id desc LIMIT 0, 10;’,parameters: undefined
}
Executing (default): SELECT count(
users
.id
) AS count
FROM users
AS users
INNER JOIN departments
AS departments
ON users
.department_id
= departments
.id
;Executing (default): SELECT
users
.id
, users
.username
, “departments”.“name” AS “departments_name”, users
.department_id
, users
.email
, users
.phone
, users
.image
FROM users
AS users
INNER JOIN departments
AS departments
ON users
.department_id
= departments
.id
ORDER BY id desc LIMIT 0, 10;Server Request Error DatabaseError [SequelizeDatabaseError]: SQLITE_ERROR: ambiguous column name: id
at Query.formatError (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:403:16)
at Query._handleQueryResponse (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:72:18)
at afterExecute (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:238:27)
at Statement.errBack (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sqlite3\lib\sqlite3.js:14:21) {
parent: [Error: SQLITE_ERROR: ambiguous column name: id] {
errno: 1,
code: ‘SQLITE_ERROR’,
sql: ‘SELECT
users
.id
, users
.username
, “departments”.“name” AS “departments_name”, users
.department_id
, users
.email
, users
.phone
, users
.image
FROM users
AS users
INNER JOIN departments
AS departments
ON users
.department_id
= departments
.id
ORDER BY id desc LIMIT 0, 10;’},
original: [Error: SQLITE_ERROR: ambiguous column name: id] {
errno: 1,
code: ‘SQLITE_ERROR’,
sql: ‘SELECT
users
.id
, users
.username
, “departments”.“name” AS “departments_name”, users
.department_id
, users
.email
, users
.phone
, users
.image
FROM users
AS users
INNER JOIN departments
AS departments
ON users
.department_id
= departments
.id
ORDER BY id desc LIMIT 0, 10;’},
sql: ‘SELECT
users
.id
, users
.username
, “departments”.“name” AS “departments_name”, users
.department_id
, users
.email
, users
.phone
, users
.image
FROM users
AS users
INNER JOIN departments
AS departments
ON users
.department_id
= departments
.id
ORDER BY id desc LIMIT 0, 10;’,parameters: undefined
}