evcordeiro / express-admin Goto Github PK

stack trace of POST model/add:

[object Object]
at Object.exports.replace (/home/ecord/myb-admin/express-admin/lib/utils/query.js:93:15)
at updateRecord (/home/ecord/myb-admin/express-admin/lib/core/database.js:55:25)
at loopRecords (/home/ecord/myb-admin/express-admin/lib/core/database.js:37:17)
at loopTables (/home/ecord/myb-admin/express-admin/lib/core/database.js:41:14)
at loopTypes (/home/ecord/myb-admin/express-admin/lib/core/database.js:42:10)
at Object.exports.update (/home/ecord/myb-admin/express-admin/lib/core/database.js:43:6)
at /home/ecord/myb-admin/express-admin/routes/editview.js:56:18
at loop (/home/ecord/myb-admin/express-admin/lib/core/editview.js:195:39)
at /home/ecord/myb-admin/express-admin/lib/core/editview.js:210:13
at loop (/home/ecord/myb-admin/express-admin/lib/core/editview.js:219:42)
POST /image/add 302 10ms - 68b

this is a mysql-validator thing. see /lib/utils/template.js:79. mysql-validator/validate.js:check(value, type) assumes type exists if not will trigger exception.

table alias for join are not unique, need some sort of composite or increment. how do the view deal with this? composite could be be easier to disambiguate probably. Workaround is to not include in listview

query: 'SELECT post.post_id AS __pk,post.post_date,post.created_dat e,post.edited_date,post.event_date,CONCAT_WS(' ',CAST(user.usernam e AS CHAR)) AS author,post.post_text,post.title,CONCAT_WS(' ',CAST( image.folder AS CHAR),CAST(image.name AS CHAR),CAST(image.date AS CH AR)) AS header_image,CONCAT_WS(' ',CAST(image.folder AS CHAR),CAST(imag e.name AS CHAR),CAST(image.date AS CHAR)) AS thumbnail_image,CONCAT_WS( ' ',CAST(image.folder AS CHAR),CAST(image.name AS CHAR),CAST(image.date AS CHAR)) AS footer_image FROM post JOIN user ON post.author = user.user_id JOIN image ON post.header_image = image.image_id JO IN image ON post.thumbnail_image = image.image_id JOIN image ON po st.footer_image = image.image_id ORDER BY post.post_id asc LIMIT 0,25 ;'