2. PHPRunner General questions
  3. What can cause this PHP errors on almost all Files
This topic is locked

What can cause this PHP errors on almost all Files

 		3/7/2021 9:17:57 PM
PHPRunner General questions
D
 Daniedb author

This morning when I open my Project, and Build, I receive this error on about 80% of my Tables.
I'm the only one working on the DB, and didn't do any changes to the DB or change any passwords for quite some time.
php error happened
Technical information

Error type 256

Error description Incorrect table name ''

URL localhost/hisportal/his_employee_list.php?page=list&menuItemId=73

Error file D:\xampp\htdocs\hisportal\connections\Connection.php

Error line 626

SQL query SELECT * FROM `WHERE ( ( ( (USERNAME='admin' ) ) and (TABLENAME='his_employee' ) and (TYPE`='3' ) ) )
THanks

Danie
A
 		acpan 3/7/2021

You have 2 backticks instead of table name, in your SQL statement after FROM. It could be that your table names cannot be recognized by the script, hence showed empty string. could it be character encoding issue of your OS, or your table names or field names containing unicode characters. Try to ensure all characters encoding are utf-8 in database.
Check Latin vs Unicode issue
Try using a 3rd party SQL editor, eg. SQLyog, and connect to your database and see if you can browse the data. Last resort is to export the data and try recreate the database using utf-8.
Sergey Kornilov admin 3/8/2021

It looks like an issue with dynamic permissions tables. Proceed to Dynamic Permissions settings in PHPRunner and make sure correct tables are selected there or create new ones.