Node.js: Can't get a simple single query to display on remote (Knex?)

Wappler General Need Help
1

Node.js (v18.18.2 on remote)
MySQL
https://sandbox.lawryk.ca/websockets

Very simple page that works well on local Wappler server but the scores query gets a 500 error on remote server. I have debug enabled so that maybe someone can decipher the error message.

It’s just a very simple api that returns one record. Should show the scores and assign the values to the form inputs as well.

I’m stumped. Should be a very simple task.

Thanks in advance for any help.

Update: Updating the form also throws an error

This is what it should show from local server:

Screenshot 2024-01-27 at 4.04.35 PM
Screenshot 2024-01-27 at 4.04.35 PM1650×474 25 KB

@George @Teodor @patrick

2

Hi Brad,

Just tried the url in your post and I also got the Knex error.

I have never tried hosting a node.js app via cPanel. Do you need to install Knex manually on the hosting server?

3

There should be a button on your control panel to install NPM modules, click it

Error for future reference:

Knex: run\n$ npm install mysql --save\nCannot find module 'mysql'
4

Yes, there is a button and everything installs ok without errors.

Screenshot 2024-01-27 at 4.54.31 PM
Screenshot 2024-01-27 at 4.54.31 PM1598×302 10.5 KB

5

It’s time to summon George or Teodor to ask why “mysql” is not in package.json, they’re the ones that understand why Wappler does things a certain way :smile:

1 Like
6

I regularly have to manually install mysql on newly created node servers. So used to it I stopped thinking of it as a bug
Normally just:

npm install mysql --save

fixes issues

1 Like
7

Thanks Brian, and where do you run that? In cPanel terminal?

8

Yes, I open terminal from the cPanel menu and type it there

9

Screenshot 2024-01-27 at 5.06.03 PM
Screenshot 2024-01-27 at 5.06.03 PM924×162 8.73 KB

10

In the NodeJS section of your cPanel, do you find any information regarding a “virtual environment”? There should be a command you have to run first

Or, you can find npm’s binary here:

/opt/cpanel/ea-nodejs**/bin/

But the ** need to be replaced with the NodeJS version. It’s better if you cd /opt/cpanel and then type ls to list the folders, and there you find the NodeJS version and cd into it. But you can’t run install mysql here in this directory, you need to go your project’s directory, and call the npm binary from there using the full path of it

Reference:

11

Sorry Brad, no access to a computer at present (using phone) so can’t investigate further.

1 Like
12

No problem, I appreciate your time. It’s not critical. It’s just a hard sell for me to move to node if I can’t get a simple query to work :wink:

13

Or an easier solution is just to manually modify package.json to add “mysql” - check how’s on your local computer (you could even copy the entire file). And then click the button to install NPM modules

14

Wouldn’t the packages file on the server already be the same as on local? I’m not comfortable editing that file as I have no idea what any of it means :wink:

15

It should, but isn’t, otherwise Knex would be working

Copy from local to remote

Wappler tries to optimize package.json to remove packages that are unused. Somehow, Wappler think MySQL isn’t needed on the remote, that’s the explanation to your problem, the reason why this happens needs to be explained by George or Teodor

16

Hmmm, there is nothing in the local package file referring to MySQL either.

17

Aren’t you using MySQL locally? Is the query running locally?

18

Everything works perfectly locally. The database is a remote database on the server.

19

It’s weird there’s no mention of “mysql” in the local package.json, maybe it was removed sometime later, for unknown reasons…

Well, then my help terminates here :slight_smile: Your only option is to run that NPM command, or if you can wait for George/Teodor…

1 Like
20

Thanks @Apple, much appreciated. I will await help from the team. It’s pretty much :beers: time anyways.