Failed to load api files

Wappler General Bugs
#1

OS info

  • Operating System : Windows 10.0.19041
  • Wappler Version : 3.8.0

Problem description

Hi
After update v3.7.8, I lost server-side functionality in my sites. I’m using MS SQL.

  • I lost all database connection and received an error. I re-entered the database connection info for all sites and successfully reconnected. But the server-side data was still not displayed.
  • When I opened the various queries , I got a message that the tables could not be found. Previous versions of Wappler had not displayed the “dbo” prefix. Once I re-selected the correct tables the queries looked like they were properly configured. Still nothing worked.
  • When testing any page, I get a “Failure to load 500” message for all the API files used.

Steps to reproduce

  1. Go to https://www.acmg.ca/mentorship.asp. I’ve removed the login requirement.
  2. Click on Mentee or Mentor. The tables should populate even though you are not login
    Thanks for you help
#2

Please enable Detailed Error Reporting on your server and then follow:

#3

Sorry, should have included this screen shot in the original message. This does not help me much but maybe you can see the problem. Let me know if you need additional information. Thanks

image
image1534×542 56.3 KB

#4

You need to enable the detailed error reporting in order to see the exact error.

#5

Thanks, I’d enabled it on one of the sites but forgot to do it on this one. It is enabled now. Still not seeing a clear indication of the problem.
Under “Error” in the panel this is displayed:
“Source map error: Error: JSON.parse: unexpected character at line 1 column 1 of the JSON data
Resource URL: https://www.acmg.ca/bootstrap/4/js/popper.min.js
Source Map URL: popper.min.js.map”

Thanks again for your help.

#6

No that’s not the error.
Please follow:

#7

Hi Teodor
This process is new to me, so I have taken a series of screen shots from Chrome this time. I’m not getting the same detailed info as displayed in the help files. Where I’m I going wrong.? The Mentorship page displays fine, it just does not load any of the API files.

image
image1227×1785 209 KB

#8

This is a generic message, in order to see the real message you need to enable detailed error reporting on your server.

#9

OK , I got the provider to enable detailed reporting. Here is part of the report on one of the errors. I’m not sure how much I needed to expand. Would it be easier for you to view the full report at : https://www.acmg.ca/mentorship.asp (I removed the security for now). As I mentioned earlier this page was working until the 3.7.8 update.

image
image1200×1332 409 KB

#10

Hi Teodor

Our site was on an older server, so they moved us to a newer version in the hope that the issue could be resolved. I still get a series of 500 failure to load errors.
http://acmg.ca.plesk01.alentus.com/02mem_mentor/mentor-copy.aspx
Here is the report. Do you need any of it expanded? It is the same message for all files.

500 error 2
500 error 2979×471 26.9 KB

#11
#12

Is this a different site? I see you now have ASP.NET, we released an update a little while back for the dbo problems in ASP.NET.

#13

Hi Patrick

I may have figured out the problem. Let me play with it a little more and I’ll get back to you.
Thanks
Chris

#14
#15

Hi Patrick

I believe all issues have now been resolved. After the initial problems after the update, I continued to have issues with the server api files loading one day and not the next. This started to look like a server problem so the provider moved us to a new server. The issues still persisted but that was user error on my part. After the last response from Patrick, I realized that I had uploaded some older server-side files. Once I removed them and uploaded files corresponding to the asp.net server model, everything worked.

Thanks for the help.

Chris

#16
#17