igorkowalczyk / majo.exe Goto Github PK

I'm trying to host the bot on railway.app wich offer a free mysql database. But this error constatly pop-up

in config i set prefix as ; but it does not work, please help

add rank commands and security commands like anti-nuke and welcome-leave dm and wlcavatar , add info commands ...
you can inspiration Commands from this https://github.com/Tomato6966/Multipurpose-discord-bot

Hello i get this error when i try to start all with the replit npm start command:

PLS help
Note: 1 time i tryed it said i need to install node v16+ but node v16+ is installed
@IgorKowalczyk

    at Handshake.Sequence._packetToError (/home/container/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Handshake.ErrorPacket (/home/container/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18)
    at Protocol._parsePacket (/home/container/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/home/container/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/home/container/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/home/container/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/home/container/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/home/container/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (node:events:390:28)
    at addChunk (node:internal/streams/readable:315:12)
    --------------------
    at Protocol._enqueue (/home/container/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at Protocol.handshake (/home/container/node_modules/mysql/lib/protocol/Protocol.js:51:23)
    at PoolConnection.connect (/home/container/node_modules/mysql/lib/Connection.js:116:18)
    at Pool.getConnection (/home/container/node_modules/mysql/lib/Pool.js:48:16)
    at Pool.query (/home/container/node_modules/mysql/lib/Pool.js:202:8)
    at /home/container/utilities/giveaways/giveaways.js:8:21
    at new Promise (<anonymous>)
    at Giveaways.getAllGiveaways (/home/container/utilities/giveaways/giveaways.js:7:11)
    at Giveaways._init (/home/container/node_modules/discord-giveaways/src/Manager.js:665:39)
    at new GiveawaysManager (/home/container/node_modules/discord-giveaways/src/Manager.js:59:24) {
  code: 'ER_CON_COUNT_ERROR',
  errno: 1040,
  sqlMessage: 'Too many connections',
  sqlState: undefined,
  fatal: true
}
node:internal/process/promises:246
          triggerUncaughtException(err, true /* fromPromise */);
          ^
Error: ER_CON_COUNT_ERROR: Too many connections
    at Handshake.Sequence._packetToError (/home/container/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Handshake.ErrorPacket (/home/container/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18)
    at Protocol._parsePacket (/home/container/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/home/container/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/home/container/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/home/container/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/home/container/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/home/container/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (node:events:390:28)
    at addChunk (node:internal/streams/readable:315:12)
    --------------------
    at Protocol._enqueue (/home/container/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at Protocol.handshake (/home/container/node_modules/mysql/lib/protocol/Protocol.js:51:23)
    at PoolConnection.connect (/home/container/node_modules/mysql/lib/Connection.js:116:18)
    at Pool.getConnection (/home/container/node_modules/mysql/lib/Pool.js:48:16)
    at Pool.query (/home/container/node_modules/mysql/lib/Pool.js:202:8)
    at /home/container/utilities/giveaways/giveaways.js:8:21
    at new Promise (<anonymous>)
    at Giveaways.getAllGiveaways (/home/container/utilities/giveaways/giveaways.js:7:11)
    at Giveaways._init (/home/container/node_modules/discord-giveaways/src/Manager.js:665:39)
    at new GiveawaysManager (/home/container/node_modules/discord-giveaways/src/Manager.js:59:24) {
  code: 'ER_CON_COUNT_ERROR',
  errno: 1040,
  sqlMessage: 'Too many connections',
  sqlState: undefined,
  fatal: true
}

This is the issue I am facing, I think the bot is not supposed to do this or did I missed something in the installation? Please let me know, Thanks.

Im running my bot in repl.it as I don't have a domain and it provides a free one. I keep entering my webhook into the secrets (.env) but keep getting this error

`

[email protected] dashboard /home/runner/majobot
node dashboard/run.js

[MAJO] Web dashboard client logged
[MAJO] Getting dashboard config file...
/home/runner/majobot/utilities/dashboard.js:6
if (!process.env.CONTACT_WEBHOOK) throw new Error("[HOST] You need to provide Discord Contact Webhook ID in .env - CONTACT_WEBHOOK_ID=YOUR_WEBHOOK_ID");
^

Error: [HOST] You need to provide Discord Contact Webhook ID in .env - CONTACT_WEBHOOK_ID=YOUR_WEBHOOK_ID
at Object. (/home/runner/majobot/utilities/dashboard.js:6:41)
at Module._compile (node:internal/modules/cjs/loader:1101:14)
at Object.Module._extensions..js (node:internal/modules/cjs/loader:1153:10)
at Module.load (node:internal/modules/cjs/loader:981:32)
at Function.Module._load (node:internal/modules/cjs/loader:822:12)
at Module.require (node:internal/modules/cjs/loader:1005:19)
at require (node:internal/modules/cjs/helpers:102:18)
at Object. (/home/runner/majobot/dashboard/dashboard.js:22:1)
at Module._compile (node:internal/modules/cjs/loader:1101:14)
at Object.Module._extensions..js (node:internal/modules/cjs/loader:1153:10)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] dashboard: node dashboard/run.js
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] dashboard script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! /home/runner/.npm/_logs/2021-11-24T11_40_35_490Z-debug.log
exit status 1

`

how to setup database

I know this is MIT license and I don't have to inform you.
But I want to ask how can I give this credit to you and where should I give you credit.

Thanks

Hello, I tried to use your repository as an attempt to modify it just for fun, But, When I tried to run it, I ran into some errors.

TypeError: Cannot read properties of undefined (reading 'endsWith')
at Object.<anonymous> (/home/runner/majoexe/web/web.js:5:35)

and another error in the same process

/home/runner/majoexe/node_modules/mysql/lib/protocol/Parser.js:437
     throw err; // Rethrow non-MySQL errors`
             ^
Error: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JSON NULL, `leaves` JSON NULL, `last_updated` DATE NOT NULL, PRIMARY KEY (`guild' at line 1
    at Query.<anonymous> (/home/runner/majoexe/utilities/mysql/database.js:37:22)
   at Query.<anonymous> (/home/runner/majoexe/node_modules/mysql/lib/Connection.js:526:10)
    at Query._callback (/home/runner/majoexe/node_modules/mysql/lib/Connection.js:488:16)
   at Query.Sequence.end (/home/runner/majoexe/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)

Dashboard is not working and slash commands too

database-scripts.js Has a annoying error.
When trying to run the bot NodeJS v16 and all the other apis working i get this error with mySQL

/home/runner/majobot-4/node_modules/mysql/lib/protocol/Parser.js:437
      throw err; // Rethrow non-MySQL errors
      ^

Error: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JSON NOT NULL, PRIMARY KEY (`id`))' at line 1
    at Query.<anonymous> (/home/runner/majobot-4/utilities/database-scripts.js:13:17)
    at Query.<anonymous> (/home/runner/majobot-4/node_modules/mysql/lib/Connection.js:526:10)
    at Query._callback (/home/runner/majobot-4/node_modules/mysql/lib/Connection.js:488:16)
    at Query.Sequence.end (/home/runner/majobot-4/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
    at Query.ErrorPacket (/home/runner/majobot-4/node_modules/mysql/lib/protocol/sequences/Query.js:92:8)
    at Protocol._parsePacket (/home/runner/majobot-4/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/home/runner/majobot-4/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/home/runner/majobot-4/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/home/runner/majobot-4/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/home/runner/majobot-4/node_modules/mysql/lib/Connection.js:88:28)
exit status 1

I have switched mysql databases and i still get this error :/

hi is there anyway to make a mysql acc for free or switch the bot to mongodb ? cus i cant put a credit card while making a payment method and i wanna try to self host a bot for some time until i finish my to run my server and cus i found this bot amazing but sadly i cant make a mysql acc without a payment method\

i have this error on the bot: Database error: ER_NOT_SUPPORTED_AUTH_MODE

node:events:498
      throw er; // Unhandled 'error' event
      ^

Error: Connection lost: The server closed the connection.
    at Protocol.end (/home/runner/MAJOEXE-djs13/node_modules/mysql/lib/protocol/Protocol.js:112:13)
    at Socket.<anonymous> (/home/runner/MAJOEXE-djs13/node_modules/mysql/lib/Connection.js:94:28)
    at Socket.<anonymous> (/home/runner/MAJOEXE-djs13/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (node:events:532:35)
    at endReadableNT (node:internal/streams/readable:1346:12)
    at processTicksAndRejections (node:internal/process/task_queues:83:21)
Emitted 'error' event on Connection instance at:
    at Connection._handleProtocolError (/home/runner/MAJOEXE-djs13/node_modules/mysql/lib/Connection.js:423:8)
    at Protocol.emit (node:events:520:28)
    at Protocol._delegateError (/home/runner/MAJOEXE-djs13/node_modules/mysql/lib/protocol/Protocol.js:398:10)
    at Protocol.end (/home/runner/MAJOEXE-djs13/node_modules/mysql/lib/protocol/Protocol.js:116:8)
    at Socket.<anonymous> (/home/runner/MAJOEXE-djs13/node_modules/mysql/lib/Connection.js:94:28)
    [... lines matching original stack trace ...]
    at processTicksAndRejections (node:internal/process/task_queues:83:21) {
  fatal: true,
  code: 'PROTOCOL_CONNECTION_LOST'
}
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] majo:web: `node majo.js --api --dashboard`
npm ERR! Exit status 1
npm ERR! 
npm ERR! Failed at the [email protected] majo:web script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     /home/runner/.npm/_logs/2022-03-13T20_38_44_336Z-debug.log

MySQL error :< ive tried changing mysql hosts but it does that every 10 minutes

oh and i need help changing the logo/favicon of the dashboard 💀

and theres a error with the anti crash and it crashes the bot :/

Environment

on "dashboard/[serverid]/user/[userid]" I don't have a user banner. You don't get a user banner when you query the "user" data.

Steps To Reproduce

add "console.log("user", user);" on the file ./apps/dashboard/app/dashboard/[server]/user/[id]/page.jsx
Run the Dashboard & bot

Software Version

latest

Expected Behavior

ehh.. the User banner? xD

Actual Behavior

nothing. No banner, no User color

Screenshots

No response

Severity

Major

Priority

Medium

Type

Functional

Reproducible

• Yes
• No

Additional Information

No response

Describe the bug

Expected behavior
Open the website...

Desktop (please complete the following information):

• OS: Arch Linux
• Browser: Firefox

What is the improvement or update you wish to see?

I want to use mongodb

Is there any context that might help us understand?

I want to use mongodb

How to run Dashboard, API and Bot at the same time?

npm run majo:bot <- Bot Run
npm run majo:dashboard <- Dashboard Run
npm run majo:api <- API Run
while true; do npm run majo:web; sleep 2; done <- Dashboard and API Run

But I don't know how to run all three in the same command (If I just add --bot it crashes)

/app/utilities/client/anti-crash.js:42
username: ${client.user.username} Error,
^

TypeError: Cannot read properties of null (reading 'username')
at process. (/app/utilities/client/anti-crash.js:42:29)
at process.emit (node:events:526:28)
at process._fatalException (node:internal/process/execution:164:13)

As You Can Tell From Looking At The Screenshot provided Its Not Loading The StyleSheet Properly or the functions
If you look in the Inspect Element On The Side You Will Notice the Issue With It Only grabbing The Port
I have put the DOMAIN=
in the .env file
The Bot Passes all checks in console

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

Open

These updates have all been created already. Click a checkbox below to force a retry/rebase of any.

• Update pnpm to v7.18.1

Detected dependencies

• Check this box to trigger a request for Renovate to run again on this repository

Since many user having error with mysql database,why don't u make a verson using mongoDB instead?,it's much easier

Replit: Updating package configuration

--> npm install

[email protected] install /home/runner/majobot/node_modules/canvas
node-pre-gyp install --fallback-to-build

node-pre-gyp ERR! install response status 403 Forbidden on https://github.com/Automattic/node-canvas/releases/download/v2.8.0/canvas-v2.8.0-node-v83-linux-glibc-x64.tar.gz
node-pre-gyp WARN Pre-built binaries not installable for [email protected] and [email protected] (node-v83 ABI, glibc) (falling back to source compile with node-gyp)
node-pre-gyp WARN Hit error response status 403 Forbidden on https://github.com/Automattic/node-canvas/releases/download/v2.8.0/canvas-v2.8.0-node-v83-linux-glibc-x64.tar.gz
/bin/sh: 1: pkg-config: not found
gyp: Call to 'pkg-config pixman-1 --libs' returned exit status 127 while in binding.gyp. while trying to load binding.gyp
gyp ERR! configure error
gyp ERR! stack Error: gyp failed with exit code: 1
gyp ERR! stack at ChildProcess.onCpExit (/usr/local/lib/node_modules/npm/node_modules/node-gyp/lib/configure.js:351:16)
gyp ERR! stack at ChildProcess.emit (events.js:400:28)
gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:277:12)
gyp ERR! System Linux 5.11.0-1018-gcp
gyp ERR! command "/home/runner/majobot/node_modules/node/bin/node" "/usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "configure" "--fallback-to-build" "--module=/home/runner/majobot/node_modules/canvas/build/Release/canvas.node" "--module_name=canvas" "--module_path=/home/runner/majobot/node_modules/canvas/build/Release" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v83"
gyp ERR! cwd /home/runner/majobot/node_modules/canvas
gyp ERR! node -v v14.17.6
gyp ERR! node-gyp -v v5.1.0
gyp ERR! not ok
node-pre-gyp ERR! build error
node-pre-gyp ERR! stack Error: Failed to execute '/home/runner/majobot/node_modules/node/bin/node /usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js configure --fallback-to-build --module=/home/runner/majobot/node_modules/canvas/build/Release/canvas.node --module_name=canvas --module_path=/home/runner/majobot/node_modules/canvas/build/Release --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83' (1)
node-pre-gyp ERR! stack at ChildProcess. (/home/runner/majobot/node_modules/canvas/node_modules/@mapbox/node-pre-gyp/lib/util/compile.js:89:23)
node-pre-gyp ERR! stack at ChildProcess.emit (events.js:400:28)
node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:1055:16)
node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
node-pre-gyp ERR! System Linux 5.11.0-1018-gcp
node-pre-gyp ERR! command "/home/runner/majobot/node_modules/node/bin/node" "/home/runner/majobot/node_modules/canvas/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp ERR! cwd /home/runner/majobot/node_modules/canvas
node-pre-gyp ERR! node -v v14.17.6
node-pre-gyp ERR! node-pre-gyp -v v1.0.5
node-pre-gyp ERR! not ok
Failed to execute '/home/runner/majobot/node_modules/node/bin/node /usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js configure --fallback-to-build --module=/home/runner/majobot/node_modules/canvas/build/Release/canvas.node --module_name=canvas --module_path=/home/runner/majobot/node_modules/canvas/build/Release --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83' (1)
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: [email protected] (node_modules/fsevents):
npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for [email protected]: wanted {"os":"darwin","arch":"any"} (current: {"os":"linux","arch":"x64"})

npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] install: node-pre-gyp install --fallback-to-build
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! /home/runner/.npm/_logs/2021-09-21T06_23_34_642Z-debug.log
exit status 1

Replit: Package operation failed.

Error: The module '/home/runner/TexturePack/node_modules/canvas/build/Release/canvas.node'
was compiled against a different Node.js version using
NODE_MODULE_VERSION 83. This version of Node.js requires
NODE_MODULE_VERSION 72. Please try re-compiling or re-installing
the module (for instance, using npm rebuild or npm install).
at Object.Module._extensions..node (internal/modules/cjs/loader.js:1057:18)
at Module.load (internal/modules/cjs/loader.js:863:32)
at Function.Module._load (internal/modules/cjs/loader.js:708:14)
at Module.require (internal/modules/cjs/loader.js:887:19)
at require (internal/modules/cjs/helpers.js:74:18)
at Object. (/home/runner/TexturePack/node_modules/canvas/lib/bindings.js:3:18)
at Module._compile (internal/modules/cjs/loader.js:999:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1027:10)
at Module.load (internal/modules/cjs/loader.js:863:32)
at Function.Module._load (internal/modules/cjs/loader.js:708:14)Hint: hit control+c anytime to enter REPL.
[SQL] Connected to the MySQL server! Connection ID: 5587103
[SQL] Fetched table logs! Status: Success
[SQL] Fetched table welcome! Status: Success
[SQL] Fetched table reputation! Status: Success
[SQL] Fetched table leave! Status: Success
[SQL] Fetched table stats! Status: Success
/home/runner/TexturePack/node_modules/mysql/lib/protocol/Parser.js:437
throw err; // Rethrow non-MySQL errors
^

Error: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JSON NOT NULL, PRIMARY KEY (id))' at line 1
at Query. (/home/runner/TexturePack/index.js:51:17)
at Query. (/home/runner/TexturePack/node_modules/mysql/lib/Connection.js:526:10)
at Query._callback (/home/runner/TexturePack/node_modules/mysql/lib/Connection.js:488:16)
at Query.Sequence.end (/home/runner/TexturePack/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
at Query.ErrorPacket (/home/runner/TexturePack/node_modules/mysql/lib/protocol/sequences/Query.js:92:8)
at Protocol._parsePacket (/home/runner/TexturePack/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/home/runner/TexturePack/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/home/runner/TexturePack/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/home/runner/TexturePack/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket. (/home/runner/TexturePack/node_modules/mysql/lib/Connection.js:88:28)
repl process died unexpectedly: exit status 1