Search found 270 matches

by peebee
2021-10-07 23:26
Forum: Feature Suggestions
Topic: new version?
Replies: 7
Views: 999

Re: new version?

We're working on a maintenance release currently (AppGini 5.98) to fix several issues Not meaning to hassle but any idea of anticipated date for this maintenance release? V5.97 does appear to have a few issues (in particular the appgini_query_log table) that require immediate attention. Perhaps eve...
by peebee
2021-09-27 01:45
Forum: Advanced Customizations > Hooks
Topic: SingleEdit: Prevent concurrent edits on records.
Replies: 13
Views: 1289

Re: SingleEdit: Prevent concurrent edits on records.

Here's hoping the function is built into V6 so you wont need to spend your time Olaf :)
by peebee
2021-09-16 00:44
Forum: Advanced Customizations > Hooks
Topic: SingleEdit: Prevent concurrent edits on records.
Replies: 13
Views: 1289

Re: SingleEdit: Prevent concurrent edits on records.

The other software's implementation of record locking is excellent - all recorded in a dedicated table so Admin can override at any time. Their logic is very sound and effective. It is however extremely complex and to implement something similar into current Appgini would require massive core edits....
by peebee
2021-09-14 05:10
Forum: Feature Suggestions
Topic: Sum of time column
Replies: 4
Views: 524

Re: Sum of time column

I should however add that there are limitations to the approach above in that "time" will only allow you to record 24 hrs max per entry and 11:59:59 PM is the upper limit time before you will revert to negative values. But it will work more than adequately for recording and summing general 24 hour t...
by peebee
2021-09-14 04:22
Forum: Advanced Customizations > Hooks
Topic: SingleEdit: Prevent concurrent edits on records.
Replies: 13
Views: 1289

Re: SingleEdit: Prevent concurrent edits on records.

Have to say Olaf, I tried your solution myself, followed your instructions to the letter - didn't see any result at all? That's using V5.97, not sure if that makes any difference? I didn't actually look at any of your code, just uploaded and added defaults to hook file as recommended. Nothing happen...
by peebee
2021-09-14 01:41
Forum: Bugs/annoyances
Topic: appgini_query_log table???
Replies: 13
Views: 887

Re: appgini_query_log table???

Just to add to your confirmation of the issue Jan.... I notice that those consistent 15 x ALTER and INSERT queries into the membership_xxx tables run BEFORE a successful login, not after. Open a NEW browser window, load the login page (WITHOUT logging in) and those sql queries will run/errors will o...
by peebee
2021-09-14 00:41
Forum: Feature Suggestions
Topic: Sum of time column
Replies: 4
Views: 524

Re: Sum of time column

I was confronted with the same requirement but solved it like this. 3 x fields required: start_time, end_time and total_time start_time & end_time fields as "time" data format total_time field as "decimal" (10,2) format. In Appgini, set total_time as "caclulated field" and apply this SQL query SELEC...
by peebee
2021-09-13 05:19
Forum: Bugs/annoyances
Topic: appgini_query_log table???
Replies: 13
Views: 887

Re: appgini_query_log table???

Thanks Jan. Yes, I realise there are both "Slow Query" and "Error" logs being recorded. In my case - I don't actually have any Slow Queries, even without applying your fix. But I do have multiple and consistent Errors being reported. The same Errors are reported at every login or page load of the Lo...
by peebee
2021-08-20 04:26
Forum: Bugs/annoyances
Topic: appgini_query_log table???
Replies: 13
Views: 887

Re: appgini_query_log table???

And just to add to above report; This error that is logged every time any User logs in is kind of disturbing? ag-screenshot-2.jpg Full Error log: INSERT INTO `membership_users` SET `memberID`='ACTUAL ADMIN USERNAME', `passMD5`='ACTUAL HASHED ADMIN PASSWORD', `email`='ACTUAL ADMIN EMAIL', `signUpDate...
by peebee
2021-08-20 04:11
Forum: Bugs/annoyances
Topic: appgini_query_log table???
Replies: 13
Views: 887

Re: appgini_query_log table???

Thanks Jan for taking a look and your quick suggested fix. Have to say though that I've applied your patch and it is not working for me? Identical errors still being registered in the Error log. Errors appear to be generated via the actual login process. It's worth pointing out that these are DB ins...
by peebee
2021-08-18 06:24
Forum: Bugs/annoyances
Topic: appgini_query_log table???
Replies: 13
Views: 887

Re: appgini_query_log table???

Must admit I hadn't noticed that table either until reading this? Just checked the Change log for V5.97 and read this: Add pageQueryLogs.php to view log of slow and error queries for debugging (Admin area > Utilties menu > Query logs) Sounds like a good idea - although I see that table fills with Er...
by peebee
2021-07-29 01:47
Forum: Bugs/annoyances
Topic: Delete/Remove Image button doesn't work
Replies: 18
Views: 2609

Re: Delete/Remove Image button doesn't work

Ahmad, for testing purposes, please find the link below to a simple test app and AXP file It contains one table with two fields (id and image). Zero edits. I've tested it on a remote web server. It works other than uploaded images are failing to delete on Save. I've included the AXP file and all App...
by peebee
2021-07-29 01:14
Forum: Bugs/annoyances
Topic: Delete/Remove Image button doesn't work
Replies: 18
Views: 2609

Re: Delete/Remove Image button doesn't work

Hmmm? Updated to Appgini 5.97 Revision 1142 and I too can confirm that I am experiencing the same issue of images not being deleted on Save? Hadn't noticed until I read this thread. Multiple image upload fields in multiple tables and none are deleting. Absolute standard image upload fields that I've...
by peebee
2021-07-15 23:34
Forum: Bugs/annoyances
Topic: 403 Forbidden Error...
Replies: 1
Views: 185

Re: 403 Forbidden Error...

403 Forbidden error will most likely be the server security/firewall blocking you. Most likely a false-positive. If your server has a firewall installed (like ModSecurity for example) you may need to check your IP address against the security log. See if your IP has been blocked, check the security ...
by peebee
2021-06-29 06:38
Forum: Tips And Tricks
Topic: where is google maps API key?
Replies: 2
Views: 366

Re: where is google maps API key?

Since V5.93 (changelog: https://bigprof.com/appgini/release-log) "Move the setting of Google Maps API key to the admin settings page (storing it in config.php) to prevent hard-coding the API key into generated code, making it safer to distribute your app to third parties." google-api-screenshot.jpg
by peebee
2021-06-09 22:20
Forum: Bugs/annoyances
Topic: Previous login failed
Replies: 32
Views: 2042

Re: Previous login failed

Just had a quick scan through this thread to see what's going on. Whilst I haven't read the entire thing, I did see this which could possibly be a cause of problems: I decided to rebuild my main db in the test db I set up and it was working fine until I almost finished with all my data ported over w...
by peebee
2021-06-04 04:35
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 42
Views: 14470

Re: Force Strong Passwords - Appgini V5.96 attached

Appgini Version 5.96 strong passwords attached. Same overwriting of generated files required as per previous instructions - please read previous posts and be aware. Important Note: These are NOT hook files . You will be replacing generated core Appgini files and they will need to be replaced again i...
by peebee
2021-06-03 01:31
Forum: Bugs/annoyances
Topic: All $Translation strings (and image folder) available to view in source code?
Replies: 3
Views: 346

Re: All $Translation strings (and image folder) available to view in source code?

OK, I've found the first problem caused by deleting the header script mentioned above. Some modals no longer work and generate the following error (mass delete for example): Uncaught TypeError: Cannot read property '_map' of undefined at mass_delete (common.js:937) I presume the same is going to hap...
by peebee
2021-06-02 22:43
Forum: Bugs/annoyances
Topic: Can't save a new record
Replies: 10
Views: 662

Re: Can't save a new record

I can't explain why it isn't working but have you tried editing the structure of that particular field in phpMyAdmin - check the Auto Increment box and Save? See what happens? Do you have more than one auto increment field in that table? That wont work. I'm pretty sure that the only three files in y...
by peebee
2021-06-02 06:47
Forum: Bugs/annoyances
Topic: All $Translation strings (and image folder) available to view in source code?
Replies: 3
Views: 346

All $Translation strings (and image folder) available to view in source code?

I've just jumped a couple of AppGini versions to update an app to current V5.96 I notice that now included in the header.php is this new <script> which I haven't seen before: <script> <?php // make a UTF8 version of $Translation $translationUTF8 = $Translation; if(datalist_db_encoding != 'UTF-8') $t...
by peebee
2021-02-01 07:29
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 42
Views: 14470

Re: Force Strong Passwords - Appgini V5.81

V5.94 attached. Same routine to install - replace generated core files with attached. Most files to replace have minor changes from 5.92 to 5.94 except for admin/pageSettings.php which looks to have had a major rebuild. Done forget to edit the $app_name = 'YourAppName'; variable in membership_signup...
by peebee
2021-02-01 06:00
Forum: Advanced Customizations > Others
Topic: Security - Data Encryption - At Rest
Replies: 3
Views: 501

Security - Data Encryption - At Rest

Just wondering if anybody has successfully implemented any current standard data encryption for data stored "at rest"? I need to encrypt/decrypt just some fields (name, etc) within a table at rest and I'm wondering what is the quickest/easiest method that would ultimately pass a security audit if it...
by peebee
2021-01-04 06:01
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 42
Views: 14470

Re: Force Strong Passwords - Appgini V5.81

I would prefer an option like "Force strong passwords". It could be enough to have it in config.php. If you can spend more time on this, I think minimum password lengths (configurable) and the existence of certain characters/special characters (configurable) would be interesting options, too. Sure,...
by peebee
2020-12-23 04:43
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 42
Views: 14470

Re: Force Strong Passwords - Appgini V5.92

For anybody interested, you can try the attached files for V5.92 THESE ARE CORE APPGINI FILES - NOT HOOKS! They WILL be overwriten and need to be replaced if you regenerate your app. There is no removal of any generated code - just minimal additional code added. Search for "Strong Password" in the c...
by peebee
2020-02-13 22:56
Forum: Tips And Tricks
Topic: Force Strong Passwords - Appgini V5.81
Replies: 42
Views: 14470

Re: Force Strong Passwords - Appgini V5.81

PS: I realise that this is far from a perfect fix for the issue in that there are now 7 x core files that require editing, ALL of which will need to be replaced if your app is regenerated/overwritten. Strong password policy is a requirement for me (and probably should be for most applications) but u...