Table Join options disappear

Wappler General Bugs
#1

OS info

  • Operating System : Windows 10.0.18363
  • Wappler Version : 2.8.0

Problem description

Table Join options disappear as soon as it flashes on the screen

Steps to reproduce

  1. Create a Database Query
  2. Add a table
  3. Try to add a second table

1000×582 1.66 MB

This issue only happened since upgrading to 2.8.0. I have tried restarting Wappler.

#2

That’s strange as i just created a join locally in 2.8.0 15 minutes ago.
Can you try setting up a new server action, maybe reapply the connection and try with a new query there?

#3

Hi Teodor,

This is a completely new one, however after reviewing the vid I can see it flashes querying database.

So, I am going to restart my PC just to confirm there’s nothing wrong with the database connection.

Ray

#4

Hi Teodor,

It’s still happening. I can create query’s and the fact it’s retriving the table listings confirms a good database connection.

Any suggestions?

#5

Please send us the debug log as explained here:

#6

Hi Teodor,

I found the issue. I added this authorization rule to IIS.

<system.web>
    <authorization>
        <allow roles="Administrator"/>
        <deny users="*" />              
    </authorization>
</system.web>

I would not have thought this would block connections to MSSQL, but it must do?
chrome_debug.zip (11.1 KB)

I included the debug for you to confirm.

Thanks,
Ray

#7
#8

Yes it causing the issue:

<h2>401 - Unauthorized: Access is denied due to invalid credentials.</h2>
<h3>You do not have permission to view this directory or page using the credentials that you supplied.</h3>
#9

OK, so I just need to lock it down after I am finished using Wappler.

Sorry for incorrectly linking this to Wappler.

Ray

1 Like