Rakeshvishnoi029 / NodeJs-ExpressJs-mysql-Admin-panel

This repository provide a node js Mysql based admin panel which provide various modules and features. This repository cover
30 stars 21 forks source link

Database error show #2

Open ravirathoreds opened 4 years ago

ravirathoreds commented 4 years ago

where i can find the database file . i have created the database in the localhost but getting this error. image Please help me solve this issue. Thank you.

gauravintellivision commented 4 years ago

kindly change like this subscription_id : { type: type.INTEGER }, in MembershipTransactions.js it will resolve coz forign key data type is different from primary key

gauravintellivision commented 4 years ago

but i have an issue after db installation i m not able to open over web i get only one thing after many changes Cannot GET /api/admin

rananaresh86 commented 4 years ago

Can you let let me know how to starts this app? After create a database 'construction_app_admin' Do we need to create database tables?

I am getting following error after running "node app.js" : localhost/tempprojects/NodeJs-Admin-Panel ⍉ ▶ node app.js module.js:681 return process.dlopen(module, path._makeLong(filename)); ^

Error: dlopen(/private/var/www/localhost/tempprojects/NodeJs-Admin-Panel/node_modules/bcrypt/lib/binding/bcrypt_lib.node, 1): no suitable image found. Did find: /private/var/www/localhost/tempprojects/NodeJs-Admin-Panel/node_modules/bcrypt/lib/binding/bcrypt_lib.node: unknown file type, first eight bytes: 0x4D 0x5A 0x90 0x00 0x03 0x00 0x00 0x00 /private/var/www/localhost/tempprojects/NodeJs-Admin-Panel/node_modules/bcrypt/lib/binding/bcrypt_lib.node: unknown file type, first eight bytes: 0x4D 0x5A 0x90 0x00 0x03 0x00 0x00 0x00 at Object.Module._extensions..node (module.js:681:18) at Module.load (module.js:565:32) at tryModuleLoad (module.js:505:12) at Function.Module._load (module.js:497:3) at Module.require (module.js:596:17) at require (internal/module.js:11:18) at Object. (/private/var/www/localhost/tempprojects/NodeJs-Admin-Panel/node_modules/bcrypt/bcrypt.js:6:16) at Module._compile (module.js:652:30) at Object.Module._extensions..js (module.js:663:10) at Module.load (module.js:565:32) at tryModuleLoad (module.js:505:12) at Function.Module._load (module.js:497:3) at Module.require (module.js:596:17) at require (internal/module.js:11:18) at Object. (/private/var/www/localhost/tempprojects/NodeJs-Admin-Panel/controllers/admin/UsersController.js:6:16) at Module._compile (module.js:652:30) at Object.Module._extensions..js (module.js:663:10) at Module.load (module.js:565:32) at tryModuleLoad (module.js:505:12) at Function.Module._load (module.js:497:3) at Module.require (module.js:596:17) at require (internal/module.js:11:18)

rananaresh86 commented 4 years ago

Hi @gauravintellivision ,

Did you get this working on your local machine? I am getting this 'Cannot GET /' when browsing at: http://localhost:8082/

Thanks

cookiesikeri commented 4 years ago

Can you let let me know how to starts this app? After create a database 'construction_app_admin' Do we need to create database tables?

I am getting following error after running "node app.js" : localhost/tempprojects/NodeJs-Admin-Panel ⍉ ▶ node app.js module.js:681 return process.dlopen(module, path._makeLong(filename)); ^

Error: dlopen(/private/var/www/localhost/tempprojects/NodeJs-Admin-Panel/node_modules/bcrypt/lib/binding/bcrypt_lib.node, 1): no suitable image found. Did find: /private/var/www/localhost/tempprojects/NodeJs-Admin-Panel/node_modules/bcrypt/lib/binding/bcrypt_lib.node: unknown file type, first eight bytes: 0x4D 0x5A 0x90 0x00 0x03 0x00 0x00 0x00 /private/var/www/localhost/tempprojects/NodeJs-Admin-Panel/node_modules/bcrypt/lib/binding/bcrypt_lib.node: unknown file type, first eight bytes: 0x4D 0x5A 0x90 0x00 0x03 0x00 0x00 0x00 at Object.Module._extensions..node (module.js:681:18) at Module.load (module.js:565:32) at tryModuleLoad (module.js:505:12) at Function.Module._load (module.js:497:3) at Module.require (module.js:596:17) at require (internal/module.js:11:18) at Object. (/private/var/www/localhost/tempprojects/NodeJs-Admin-Panel/node_modules/bcrypt/bcrypt.js:6:16) at Module._compile (module.js:652:30) at Object.Module._extensions..js (module.js:663:10) at Module.load (module.js:565:32) at tryModuleLoad (module.js:505:12) at Function.Module._load (module.js:497:3) at Module.require (module.js:596:17) at require (internal/module.js:11:18) at Object. (/private/var/www/localhost/tempprojects/NodeJs-Admin-Panel/controllers/admin/UsersController.js:6:16) at Module._compile (module.js:652:30) at Object.Module._extensions..js (module.js:663:10) at Module.load (module.js:565:32) at tryModuleLoad (module.js:505:12) at Function.Module._load (module.js:497:3) at Module.require (module.js:596:17) at require (internal/module.js:11:18)

ypou are to create a databse name "construction_app_admin" and run "sequelize db:migrate"

cookiesikeri commented 4 years ago

create a database construction_app_admin and run sequelize db:migrate to run a full migration

pragneshpj commented 3 years ago

any solution?