Installed Trongate desktop on mac studio; OS 13.2.1 (22D68) Mysql is installed via brew and is up and running.
I can access mysql via Laravel apps as well as with TablePlus. Create new app name test, db connections standard stuff. host" : "127.0.0.1", "port" : 3306, "user" : "root", "password" : "root", "database" : "tron"' database tron has been created via TablePlus. user root pw root.
TYPEERROR: CONN.QUERY IS NOT A FUNCTION.
NOTE: Function: Modify Existing App works and loads app that I downloaded. HOWEVER: Open Query Build hangs at ACTIVATING QUERY BUILDER. Please advise on problem 1. CONN.QUERY.
03/31: I uninstalled and reinstalled mysql with Brew. Same issue. I can, however "Modify Existing App"; one that I downloded.
Thanks for help, everyone. I'm on an M1 with production applications. No place to switch to MariaDB. I did try xampp and mamp with no help. Even tried on an intel machine. Nope, for whatever reason I can't get this app to run.
No big deal. I like the Trongate structure. Still interested in porting my Laravel app to this platform. Seems cool to strip down the app to basic PHP and CSS, albeit, I still really like Tailwind...hope that not a 8 character word...
CONN.QUERY ERROR WITH TRONGATE MAC APP
3 years ago
3 years ago
#1
3 years ago
#2
Hi Ralph,
This seams to be a common issue with Mac, Brew and MySQL. I haven't been able to replicate your issue on my Mac (Intel on OS v13.2.1), which works fine with MySQL installed with Brew. Is your Mac an Intel or Apple silicon?
Can you show me your running brew services?
Are they run as root from boot or do you run them as needed?
I'm thinking it's a Node.js thing on a Mac or an issue with the setup of MySQL and Brew.
Is it possible you try installing Xampp on the Mac or try MariaDB via brew?
This seams to be a common issue with Mac, Brew and MySQL. I haven't been able to replicate your issue on my Mac (Intel on OS v13.2.1), which works fine with MySQL installed with Brew. Is your Mac an Intel or Apple silicon?
Can you show me your running brew services?
Are they run as root from boot or do you run them as needed?
I'm thinking it's a Node.js thing on a Mac or an issue with the setup of MySQL and Brew.
Is it possible you try installing Xampp on the Mac or try MariaDB via brew?
3 years ago
#3
Hello,
I apologise for that issue. The query.conn thing has showed up a few times. It's usually caused because there's more than one instance of the desktop app running.
My advice is this:
* Restart your computer and make sure there's nothing else running that could potentially hog your database connection. Examples of things running in the background that could potentially cause problems are; multiple instances of the desktop app running, database management software running in the background and Skype.
* If that doesn't work, the next step would be to run the desktop app again but with the inspector open and the command line open. Unfortunately, you can't do this now. However, the desktop app is going to be made fully open source within the next ten days or so. When that time comes, I'll post a YouTube video that teaches how to run it as a Node.js app. So, you'll be able to see the code for yourself and regardless of whether or not you're comfortable with JavaScript, it'll be a million times easier for all of us to identify and fix issues like the one you've experienced.
* If none of the above is acceptable and you're desperate for a solution then I think you're going to require one on one live help. That will involve a little bit of screen sharing over Skype and probably about an hour or so of time.
DC
I apologise for that issue. The query.conn thing has showed up a few times. It's usually caused because there's more than one instance of the desktop app running.
My advice is this:
* Restart your computer and make sure there's nothing else running that could potentially hog your database connection. Examples of things running in the background that could potentially cause problems are; multiple instances of the desktop app running, database management software running in the background and Skype.
* If that doesn't work, the next step would be to run the desktop app again but with the inspector open and the command line open. Unfortunately, you can't do this now. However, the desktop app is going to be made fully open source within the next ten days or so. When that time comes, I'll post a YouTube video that teaches how to run it as a Node.js app. So, you'll be able to see the code for yourself and regardless of whether or not you're comfortable with JavaScript, it'll be a million times easier for all of us to identify and fix issues like the one you've experienced.
* If none of the above is acceptable and you're desperate for a solution then I think you're going to require one on one live help. That will involve a little bit of screen sharing over Skype and probably about an hour or so of time.
DC
3 years ago
#4
Hello,
I am on a Mac M1
I ran into this issue
I solved by installing Mariabd..
Installed Mariadb through Homebrew.
There is a conflict on files somewhere. Unfortunately I am not sure where.
Reading 2 instances
Look at this post of mine.
https://trongate.io/help_bar_threads/display/FyNgZYs2wFg2
Dan
I am on a Mac M1
I ran into this issue
I solved by installing Mariabd..
Installed Mariadb through Homebrew.
There is a conflict on files somewhere. Unfortunately I am not sure where.
Reading 2 instances
Look at this post of mine.
https://trongate.io/help_bar_threads/display/FyNgZYs2wFg2
Dan