Problems with my VPS

salvuccicarlos · February 5, 2020, 12:18am

Hello, so I’m having several problems I’m not being able to solve with my Server.

First, I want to make clear that I do not have any problems running my webpage on my mac using MAMP. It runs perfectly.

Yesterday I upload my page to a cloud server configuration, but after a few logs to check if everything was working fine, the page retrieved me ths error: " > 1. message: “SQLSTATE[HY000] [1226] User ‘XXXX’ has exceeded the ‘max_connections_per_hour’ resource (current value: 500)”" (topic: Web error on target server).

So after some investigation, I’ve decided to buy a VPS. After configuring WHM and CPANEL and pointing the domains to the server, I uploaded my website using Wappler’s integrated FTP and transfer the database from my local computer to the VPS MySQL using NAVICAT.

After doing all that… the page is still not working, in fact after logging in it redirects to the user page but freezes completely, like if no server connect action was installed, check the screenshot… You can check what I’m saying using my testing user, please ask me the username and password privately.

I need please some help, I’m not an expert but I’ve expended a lot of many in vain… I can’t beleive I could make it work locally but not remotely on a server with these specifications:

Thanks for reading and helping

salvuccicarlos · February 5, 2020, 1:07am

I founded a part of the problem… I don’t know why but the comment wappler puts on the page it’s affecting the rest of the page itself

At the top of my page i had the following comment:

> 

I deleted it and the page works now… But deleting the comment will have negative consecuences for my page i beleive, because I have some parameters included inside it, such as the dropzone or the pagingGenerator…

I don’t understand why on my VPS the page won’t work with the comment but locally yes…

Update: It’s not just wappler comment, all comments are causing problems…

Dave · February 5, 2020, 9:01am

What if the comment is wrapped CSS comment style:

/* Wappler include is="dmx-app" appconnect="local" components="{&quot;dmxValidator&quot;:{},&quot;dmxDropzone&quot;:{},&quot;dmxBrowser&quot;:{},&quot;dmxStateManagement&quot;:{},&quot;dmxBootstrap4PagingGenerator&quot;:{},&quot;dmxBootstrap4Alert&quot;:{},&quot;dmxBootstrap4Modal&quot;:{}}" jquery_slim_33="local" fontawesome_4="local" bootstrap4="local" */

PLEASE DISREGARD THE ABOVE SUGGESTION (after reading Teodor’s comment below)!

I would imagine if this works it will break something else though… Just a brain fart really… We host all of our own servers and have never had this issue, but then again we have never included the above in a comment in such a way… Is this using the definable frameworks from within your Project Settings? Interested to know as we have never implemented this.

Teodor · February 5, 2020, 9:11am

These comments are required on the content pages. Please don’t change them in any way or remove them, they must be exactly as they are inserted by Wappler.

I see no logical reason why would they break your page. What server type are you using?
Can you provide a link to your page?

salvuccicarlos · February 5, 2020, 11:23am

I’m using CPANEL, I realized that the wappler comment needs to be after the first php include code. If you want to log in I could send you some testing credentials privately. The webpage is app.estudiobts.com.ar, It seems I could solve it, now it’s working fine.

Yet, I’m having some trouble because the server recognize uppercase and lowercase as different links… This didn’t happened on my testing environment (Mac with MAMP)

salvuccicarlos · February 5, 2020, 1:06pm

I don't understand quite well what you're asking. I uploaded the whole proyect to the server, It contains the exact files using the correct directories