Search found 41 matches

by mdannatt
2023-05-03 08:46
Forum: Bugs/annoyances
Topic: Default Lookup Value 23.11 and php 8.0
Replies: 1
Views: 1451

Default Lookup Value 23.11 and php 8.0

So i upgraded from 22.x to 23.11 in the hope that the bug, in which default lookup values were not displayed in PHP8.0 (and reported on this forum), STILL hasn't been fixed. I am so disappointed. Why am I paying for "upgrades" that don't fix the issues??
by mdannatt
2023-02-22 08:49
Forum: Advanced Customizations > Others
Topic: Triggers in MySQL error
Replies: 1
Views: 809

Re: Triggers in MySQL error

As an update to this, I have replaced my trigger with equivalent code in function_after_insert. Problem solved.
by mdannatt
2023-02-21 17:11
Forum: Advanced Customizations > Others
Topic: Triggers in MySQL error
Replies: 1
Views: 809

Triggers in MySQL error

Hoping someone can help me I use a mysql trigger to update a table. The problem is that every time the creator(me) of the trigger logs out and then logs back in again, I am greeted with this message when adding a record which then tries to activate the trigger: "The user specified as a definer ('_EU...
by mdannatt
2023-01-13 08:42
Forum: Bugs/annoyances
Topic: Appgini Version update?
Replies: 0
Views: 536

Appgini Version update?

Does anyone have a timeframe for the next update with bug fixes please?
by mdannatt
2022-11-11 09:01
Forum: AppGini Plugins
Topic: AdminLTE Plugin for AppGini
Replies: 146
Views: 97885

Re: AdminLTE Plugin for AppGini

"The global search script implemented here is not hosted in the hooks folder it is located in the appginilte folder"

I understand this. I have not changed your default installation files, but I am still having problems getting the global search to work. Thx.
by mdannatt
2022-11-08 11:03
Forum: AppGini Plugins
Topic: AdminLTE Plugin for AppGini
Replies: 146
Views: 97885

Re: AdminLTE Plugin for AppGini

It doesn't work for any group, including admin. I see you have moved the default global search script out of the hooks folder. Is this an issue maybe?
by mdannatt
2022-11-04 12:55
Forum: AppGini Plugins
Topic: AdminLTE Plugin for AppGini
Replies: 146
Views: 97885

Re: AdminLTE for AppGini Plugin

My apologies. It is v .26 and not .24 as previously stated.
by mdannatt
2022-11-03 08:45
Forum: AppGini Plugins
Topic: AdminLTE Plugin for AppGini
Replies: 146
Views: 97885

Re: AdminLTE for AppGini Plugin

hi ronnie
Issue with Global Search? "Not authorized to access". The accessperms_configJSON file contains the relevant group permissions, but global-search.php seems to have an issue. v221.4 and php 7.4
by mdannatt
2022-11-01 00:06
Forum: Bugs/annoyances
Topic: Youtube field error
Replies: 3
Views: 879

Re: Youtube field error

What version of php are you using?
by mdannatt
2022-10-31 16:21
Forum: Bugs/annoyances
Topic: Dropdown default not working v22.14 and php 8.0
Replies: 2
Views: 989

Dropdown default not working v22.14 and php 8.0

setting a default for a dropdown refereing a lookup table does not work in version 22.14 and php 8.0. I have rolled back to 7.4 for the time being, which works perfectly.
by mdannatt
2022-10-31 16:18
Forum: Bugs/annoyances
Topic: help! default value for lookup
Replies: 6
Views: 884

Re: help! default value for lookup: SOLVED

I have finally found the problem. There is a compatibility problem with 22.14 and PHP 8.0 . My service provider automatically "upgraded" me to 8.0. I rolled back to 7.4 and all the drop-down defaults are now back. I will post this in bugs as a compatibility issue. Thank you so much for taking the ti...
by mdannatt
2022-10-31 12:32
Forum: Bugs/annoyances
Topic: help! default value for lookup
Replies: 6
Views: 884

Re: help! default value for lookup

i also tried with to test tables, to rule out that the existing tables are corrupted in some way. they don't work either. :shock: :(
by mdannatt
2022-10-31 11:55
Forum: Bugs/annoyances
Topic: help! default value for lookup
Replies: 6
Views: 884

Re: help! default value for lookup

maybe removing the "unsigned" from the PAIN field helps? I don't think my dropdowns have that option checked. -Made no difference The primary key (PK) of the harris_pain table should probably be an integer autoincrement. COnfirm is is autoincrement Might there be a space character (" ") after the de...
by mdannatt
2022-10-31 08:42
Forum: Bugs/annoyances
Topic: help! default value for lookup
Replies: 6
Views: 884

Re: help! default value for lookup

HI Olaf I have tried: Clearing cache Changing browsers Reinstalling Appgini (didn't delete old version, simply did a new install over old version) Toggling the "required" field Uploading to live site as well as my basic test mirror site (has no active plugins or javascript helper , etc) Praying for ...
by mdannatt
2022-10-30 08:53
Forum: Bugs/annoyances
Topic: help! default value for lookup
Replies: 6
Views: 884

help! default value for lookup

i am absolutely out of ideas and hoping someone can help me. Using appgini 22.14. I have a table with several drop downs, whuch are lookups on other tables. To save time, I set the default value to the most common answer, which is used 90% of the time. Suddenly, these default entries are nowhere to ...
by mdannatt
2022-09-22 20:49
Forum: AppGini Plugins
Topic: AdminLTE Plugin for AppGini
Replies: 146
Views: 97885

Re: AdminLTE for AppGini Plugin

Thanks for the reply Ronnie. I will have another look at it Maybe I have a typo somewhere. Is this compatible with other plugins ? (specifically calendar)
by mdannatt
2022-09-20 10:19
Forum: AppGini Plugins
Topic: AdminLTE Plugin for AppGini
Replies: 146
Views: 97885

Re: AdminLTE for AppGini Plugin

I agree that mixing Bootstrap versions is not recommended. Interesting the Landini version of LTE preserves your js layout in DV, Jan. But sadly, Landini is missing a few key php scripts from its last version. Frustrating for me because I think AdminLTE is (visually) an absolute treat (as do my clie...
by mdannatt
2022-09-17 17:02
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: AppGini Helper JavaScript Library & Admin LTE
Replies: 2
Views: 1148

AppGini Helper JavaScript Library & Admin LTE

Hi Jan I hope you are keeping well. I was looking at implementing Admin LTE to get a left hand menu (found at https://adminlte.io/ ). More specifically, the AppGini Version vt rngoda ( https://forums.appgini.com/phpbb/viewtopic.php?t=4792 ). Sadly, I have run into a problem I can't seem to solve. WI...
by mdannatt
2022-09-17 07:24
Forum: AppGini Plugins
Topic: AdminLTE Plugin for AppGini
Replies: 146
Views: 97885

Re: AdminLTE for AppGini Plugin

Hi Ronnie I'm looking at using this, but have few concerns. 1. Is there a way to get this to this work with appginihelper? I see that tabs still render, there is a problem control with the width and location of fields ,for example ,in filename-dv.js i have:: var dv = new AppGiniDetailView(); var row...
by mdannatt
2022-03-17 14:56
Forum: AppGini Plugins
Topic: Calendar custom WHERE clause? Advice needed
Replies: 0
Views: 605

Calendar custom WHERE clause? Advice needed

Hi All Looking for some advice. I have a table SUBJECT, which contains two columns: ID, SUBJECT and TEACHER. For each subject added, admin must also add a teacher from a dropdown menu linked to table TEACHERS (containing ID and TEACHER NAME) I have set up a calendar based on a third table, called SC...
by mdannatt
2022-03-08 09:47
Forum: AppGini Plugins
Topic: Calendar Change Background Color By Status?
Replies: 0
Views: 848

Calendar Change Background Color By Status?

Hello all I am trying, without success, to change the background color of a calendar entry based on its STATUS. My lookup table has ID, Status, hex value My appointment table has ID, name, start-date&time, end-date&time, type, STATUS (from lookup table), hex (autofill) My status values are: Open, Cl...
by mdannatt
2021-11-08 08:20
Forum: AppGini Plugins
Topic: How to set up 15 minute increments and axis labels in Calendar.
Replies: 3
Views: 1527

Re: How to set up 15 minute increments and axis labels in Calendar.

I am working my way through this idea:

https://newbedev.com/jquery-fullcalenda ... ring-event

but I haven't made much progress. If I get it working, I will post it here.
by mdannatt
2021-11-07 14:33
Forum: AppGini Plugins
Topic: How to set up 15 minute increments and axis labels in Calendar.
Replies: 3
Views: 1527

How to set up 15 minute increments and axis labels in Calendar.

I've seen a few posts asking how to set 15 minute increments in Calendar. Here is how I did it. 1. I am assuming you know how to install calendar correctly. 2. Set up your tables correctly, making sure you have a start datetime (format type datetime in AG) and end datetime(format type datetime in AG...
by mdannatt
2021-10-19 12:41
Forum: Tips And Tricks
Topic: mySQL JSON JS Apexcharts
Replies: 1
Views: 1506

mySQL JSON JS Apexcharts

I have recently started looking at the excellent Apexcharts Library with a view to building a dashboard. I wrote a mySQL query and then built my JSON data with: $result = mysqli_query($query); $json_array = array(); while($row = mysqli_fetch_assoc($query)) { $json_array[] = $row; } $json = json_enco...