Bootstrap 4 table and security

Server Side Components
#1

I am able to create a responsive table only on the user table after setting up security. But no other tables work. If I create an identical query but for a different table no data displays. I can easily delete the user query and add another in its place and still wont display data. All settings mirrored from the user table I get working with no issues. Again I am using security so the table links to a security id that is mirrored in the query. I dont want to revert to Dreamweaver due to its simplicity to editing the sql scripts and I am pretty sure this is an issue and not me missing something cause I can put two tables on one page and script identical except for different tables and one has data (users) and others do not. I am at a frustrated level with this since I have restarted the project 4 times. I am not seeing a benefit to wappler at this point in regards to database projects. The backend of a site is still easier to build in DW. Let me know if its a bug or you have to do something special when security is on and using different tables in a database. The steps I have taken

  1. In steps

    • Add DB Connection
    • Add Security Provider (Linked)
    • Add Security Restrictions (ALL Logged IN)
    • Add Query create select table and rows then in conditions select userid = {{lsl_security.identity}}

  2. On page under App add Server Connection and in action (add the query)

  3. In the content area add the bootstrap4 table populate with query

preview on the user table all the data is shown on any other table nada.

Please help let me know if it needs to be something else

#2

Is the issue that you can not recreate some BS4 tables in new files?
If yes maybe you should just make sure to add any query parameters needed etc.

Thank you!

#3

One thing is not clear to me - is this ‘other table’ query, filtered by the logged user ID as well?

#4

Also check through the debugger if queries run and if not check the response tab for errors

#5

No new and current files. The problem is not the query I can run it in navicat and it will return results. Also it doesn’t work even if I just try to return just the table.

#6

The table has the userid in it as well. It doesn’t work even if I leave off the condition.

#7

Please check the following part of our docs and see what the debug info shows on your page: Debugging Problems

#8

1.js:7 Uncaught TypeError: jQueryMs.getJSON is not a function
at Object.load_config (1.js:7)
at Object.init (1.js:5)
at 1.js:51

#9

This is not the error message.

Please check the exact error message (IF ANY) returned by your action file under XHR tab - just like shown in the docs.

#10
  1. code: “HY000”
  2. file: “/home/swkhflwq86ac/public_html/dmxConnectLib/lib/db/Connection.php”
  3. line: 82
  4. message: “SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared”
  5. trace: “#0 /home/swkhflwq86ac/public_html/dmxConnectLib/lib/db/Connection.php(82): PDOStatement->execute()↵#1 /home/swkhflwq86ac/public_html/dmxConnectLib/modules/dbconnector.php(67): lib\db\Connection->execute(‘SELECT `Ticket …’, Array)↵#2 /home/swkhflwq86ac/public_html/dmxConnectLib/lib/App.php(159): modules\dbconnector->select(Object(stdClass), ‘opentix2’)↵#3 /home/swkhflwq86ac/public_html/dmxConnectLib/lib/App.php(128): lib\App->execSteps(Object(stdClass))↵#4 /home/swkhflwq86ac/public_html/dmxConnectLib/lib/App.php(98): lib\App->execSteps(Array)↵#5 /home/swkhflwq86ac/public_html/dmxConnectLib/lib/App.php(71): lib\App->exec(Object(stdClass))↵#6 /home/swkhflwq86ac/public_html/dmxConnect/api/HelpDesk/opentix.php(8): lib\App->define(Object(stdClass))↵#7 {main}”
#11

Yes this is a known issue. Has to do with your PHP version. There is an alternative but I would highly recommend you upgrade your php version

#12

Thanks, I will give it a try.

#13

Check this out Using mysql views gives error
I think it will help

#14

My Current PHP version: 7.2 its the highest I can go and that is what it was on. Should I be on a lower version?

#15

No this should be ok

#16

Are you using a MySQL view and what is the MySQL server version?

We’ve seen this issue (which appears to be a MySQL bug) in some specific cases like myslq server version lower than 5.7 and when using views.
If you update your MySQL server to v5.7 the bug is fixed, also if you use normal tables (not views) it should be working fine.

We are trying to find a solution for this specific case.

#18

I have tried both. I am using 5.6

#19

So with a table it happens again? It doesn’t make sense if it works for a specific table and not for another. Can you make sure it’s not a view?
Also - can you switch to 5.7?

#20

I have tried . The only table that runs is the user table that is why i am perplexed

#21

Sorry, you tried what?
Are your tables on a same db server?