datatables / editor-php Goto Github PK

With latest versions of Composer, a warning appears when getting the library:

Deprecation Notice: Class DataTables\Vendor\htmLawed located in hidden/vendor/datatables.net/editor-php\Vendor\htmLawed\htmLawed.php does not comply with psr-4 autoloading standard. It will not autoload anymore in Composer v2.0. in phar://hidden/composer.phar/src/Composer/Autoload/ClassMapGenerator.php:201

As htmLawed.php is in Vendor/htmLawed folder, it should be in a namespace DataTables\Vendor\htmLawed, I think. Or be in the parent folder?

Best regards

Hi!.

When the library gets the records from the DB, the library filter all the rows with null values, I figured out the cause and created a Pull request for you guys here.

Thanks.

Hi, I'm having issues connecting to and RDS using token authentication

The error reported by the server was: SQLSTATE[HY000] [1045] Access denied for user 'iam_user'@'xx.xxxx.xx.xxx' (using password: YES)

So far my investigation down to:

• Connect by using user and password (no the generated RDS token ) - works
• Connect by using user and RDS token - does not works
• Run a test using php mysqli instead PDO with (user and RDS token) - works

Example of token generated:
myDatabase-dev-cluster.cluster-cwujoxa2wlgn.us-east-1.rds.amazonaws.com:3306/?Action=connect&DBUser=iam_user&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKLIOLRyTos5FYBGXRKLA%2F20200314%2Fus-east-1%2Frds-db%2Faws4_request&X-Amz-Date=20200314T031933Z&X-Amz-SignedHeaders=host&X-Amz-Expires=900&X-Amz-Signature=a7373b21f52361addef02848382yg1232c538c730f1273d35fe84af947a12d2

I am wondering if a PDO issue and if is possible to use RDS Token with datatable somehow

Currently, SearchPaneOptions of Fields in Mjoin-Class are ignored.

Would be very helpful if there was a workarround for this.

PHP 8.1
MYSQL 8.0.30

Recently we booted up a fairly big project this includes Datatables Editor PHP being one of them.

It worked pretty great so far, but we stumbled upon one fairly big problem. This concludes where we use the set method after instantiating a field and providing it's validators. We set it to usually Field::SET_CREATE, but in some use cases this does not work and only works in certain conditions let me provide u with an example.

For example: I define a field LEFT JOIN method from editor, the left join works but for some reason if I set the field of that joined field on Field::SET_CREATE datatables editor does not seem to comply when I create a new row. Instead completed the row as expected but leaves that value to a null or default value provided by the database (MYSQL).

My question was have there been any problems reported relevant to this if not? Could u maybe highlight if u ever fixed a problem like this we're gonna update datatables editor package via composer as of right now after this post is made. I just would like to know.