When I save script I get an error

[ZakharchukEduard]

Hi. I can't seem to use your plugin. I get errors. I'm trying to create a test script and when I save it I get an error.

That's the setting

That's the error

[CasN]

Attach your script to the issue and I will investigate/fix on Monday. This weekend I am out on the motorbike😁

Sent from Outlook for iOShttps://aka.ms/o0ukef

---

From: ZakharchukEduard @.> Sent: Friday, May 10, 2024 12:51:17 PM To: mantisbt-plugins/Query @.> Cc: Subscribed @.***> Subject: [mantisbt-plugins/Query] When I save script I get an error (Issue #3)

Hi. I can't seem to use your plugin. I get errors. I'm trying to create a test script and when I save it I get an error.

That's the setting default.png (view on web)https://github.com/mantisbt-plugins/Query/assets/34164109/5205870f-a7c4-4c6e-af4c-55add0b5661f

That's the error default.png (view on web)https://github.com/mantisbt-plugins/Query/assets/34164109/adb364d2-5ba5-4c42-8ffe-92278d16647d

— Reply to this email directly, view it on GitHubhttps://github.com/mantisbt-plugins/Query/issues/3, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABYLFFFROY7OSAHJB5FBI5TZBSRCLAVCNFSM6AAAAABHQNKKJ2VHI2DSMVQWIX3LMV43ASLTON2WKOZSGI4DSNBZGM2DAOI. You are receiving this because you are subscribed to this thread.Message ID: @.***>

[ZakharchukEduard]

This error appears any time you try to add a script or query. I'm in no hurry. This error doesn't interfere with my work. It's for the future I want to customize a couple of scripts.

[CasN]

This is not how it works. In the first step you only define the query. Next you click on Edit once your definition is in the list. There you put your code to be executed. Please share your code so I can check if this will be working (what I now see of the code does not look ok).

[CasN]

Also download version 2.13, there are some improvements. In case you use php 8.2, plase see the readme.

[ZakharchukEduard]

Hi. Yes I have plugin version 2.13 and PHP version 8.3. I reread the readme file, found the ADORecordSet_mysqli class in the code and I don't understand what I should replace. Can you please describe it in more detail?

[CasN]

add the following line:

[AllowDynamicProperties]

right before: class ADORecordSet_mysqli extends ADORecordSet{

[ZakharchukEduard]

I add line.

I try to add a new script.

And still get an error.

[CasN]

please download query_add.php and edit_schedule2.php again and load to your webserver. Is should work now.

[ZakharchukEduard]

I reinstalled the plugin completely. When I try to add a script I get a new error:

APPLICATION ERROR #401

Database query failed. Error received from database was #1364: Field 'query_script' doesn't have a default value for the query: INSERT INTO mantis_plugin_Query_definitions_table ( query_name,query_type,query_lvl,query_desc ) VALUES ( 'test','S', 'A','test').
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

[CasN]

That is strange, can you check the definition of the mantis_plugin_Query_definitions_table ? It should have default values, see image:

[ZakharchukEduard]

The default value has not been filled in. After filling it in, I was able to add the script to the list. Thanks for the tip.

[CasN]

Version 2.15 is on the way with a number additional improvements