Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1
Web Server - Ask For Help / Wizard Validation Issue
« on: August 25, 2015, 09:58:27 PM »
Hi Bruce,
Still working on the login form here on the 'Sites' example I created a few weeks ago and have found a problem with the validation.
The problem exists when the database is in 'Single Site Mode' and not in 'Multi-Site Mode', meaning there are no real links to any sites for each user, there is only 1 site that all users log into.
If a user does not have access to login, then the validation takes the user who is logging in to the second tab to select the 'Site', instead of staying on the first tab to allow for trying again. The user can press the 'Back' button but this then disables the 'Save/Login' button and the user cannot try logging in again.
Attached is an example app. The 'Demo' user does not have access to login. The 'Test' user does have access.
What can we do here?
Regards,
Trent
[attachment deleted by admin]
Still working on the login form here on the 'Sites' example I created a few weeks ago and have found a problem with the validation.
The problem exists when the database is in 'Single Site Mode' and not in 'Multi-Site Mode', meaning there are no real links to any sites for each user, there is only 1 site that all users log into.
If a user does not have access to login, then the validation takes the user who is logging in to the second tab to select the 'Site', instead of staying on the first tab to allow for trying again. The user can press the 'Back' button but this then disables the 'Save/Login' button and the user cannot try logging in again.
Attached is an example app. The 'Demo' user does not have access to login. The 'Test' user does have access.
What can we do here?
Regards,
Trent
[attachment deleted by admin]
2
Web Server - Ask For Help / Force Save/Login Button Click on Wizard 'Next'
« on: August 13, 2015, 01:26:26 PM »
Hi Bruce,
I'm trying to force the 'Save/Login' button to be clicked if the user only has access to one site but the button is not behaving as expected.
Attached is the test app. Login with username and password 'test' and click the 'Next' button. In debugview you should see 'clicking save button to force login'. In the firebug console you should see 'save clicked' which means the click event should have happened, but the form validation does not happen and the user is directed to the next tab with the 'Site' drop.
Regards,
Trent
[attachment deleted by admin]
I'm trying to force the 'Save/Login' button to be clicked if the user only has access to one site but the button is not behaving as expected.
Attached is the test app. Login with username and password 'test' and click the 'Next' button. In debugview you should see 'clicking save button to force login'. In the firebug console you should see 'save clicked' which means the click event should have happened, but the form validation does not happen and the user is directed to the next tab with the 'Site' drop.
Regards,
Trent
[attachment deleted by admin]
3
Web Server - Ask For Help / Mobile Mode Issue Part III
« on: August 04, 2015, 01:54:08 AM »
Hi Bruce,
Here's another issue: loc:alert does not show in mobile mode on the login form. Previous webtest app uploaded in thread 'Part II' demonstrates this when you try to either click 'Next' or 'Save/Login' buttons on the login form after typing in incorrect details.
Regards,
Trent
Here's another issue: loc:alert does not show in mobile mode on the login form. Previous webtest app uploaded in thread 'Part II' demonstrates this when you try to either click 'Next' or 'Save/Login' buttons on the login form after typing in incorrect details.
Regards,
Trent
4
Web Server - Ask For Help / Mobile Mode Issues Part II
« on: July 30, 2015, 01:53:19 PM »
Hi Bruce,
The maximum size limit for attachments is 70mb. These files were only 3mb and 1.2mb in size so it's not a file size limit.
Here are the links to download them straight from my FTP:
Item 1: www.futureit.biz/downloads/testing/Item1.mp4
Item 2: www.futureit.biz/downloads/testing/Item2.mp4
I've tested both links and they play in my Firefox browser!
To be honest I got a bit mixed up before. Items 1 and 2 is the easiest to to reproduce. Fixing all of them is a priority. As Items 1 and 2 are happening when a user presses the field then I'm assuming these are actually the same issue.
Item 3 is slightly different to items 1 and 2 and is harder to reproduce. BUT it would be good to see how you would approach this as this was originally coded by my predecessor and I have not had time to revisit it for a better solution.
I am wondering why you are still testing on iOS 7. iOS 9 is almost ready to be released and you haven't upgraded to 8 yet? If you are not seeing the issues in 7 then you have to upgrade to 8 to see them and properly provide the support that we require.
When the webinar is available please point me to the link and i'll take a look at it.
Regards,
Trent
The maximum size limit for attachments is 70mb. These files were only 3mb and 1.2mb in size so it's not a file size limit.
Here are the links to download them straight from my FTP:
Item 1: www.futureit.biz/downloads/testing/Item1.mp4
Item 2: www.futureit.biz/downloads/testing/Item2.mp4
I've tested both links and they play in my Firefox browser!
To be honest I got a bit mixed up before. Items 1 and 2 is the easiest to to reproduce. Fixing all of them is a priority. As Items 1 and 2 are happening when a user presses the field then I'm assuming these are actually the same issue.
Item 3 is slightly different to items 1 and 2 and is harder to reproduce. BUT it would be good to see how you would approach this as this was originally coded by my predecessor and I have not had time to revisit it for a better solution.
I am wondering why you are still testing on iOS 7. iOS 9 is almost ready to be released and you haven't upgraded to 8 yet? If you are not seeing the issues in 7 then you have to upgrade to 8 to see them and properly provide the support that we require.
When the webinar is available please point me to the link and i'll take a look at it.
Regards,
Trent
5
Web Server - Ask For Help / Mobile Mode Issues
« on: July 22, 2015, 10:51:23 PM »
Hi Bruce,
I'm getting quite a few issues in mobile mode when testing on an actual mobile phone - I'm using an iPhone 4S:
1) On a simple login form if the user presses the 'Login' field to type in their username it automatically takes them to the 'Password' field instead.
2) Same login form, the user presses a drop list and the 'Password' field is selected instead with the keyboard showing.
3) Same login form, the user first enters the 'Login', then the 'Password', then selects the drop value, the drop does not select the value correctly and the user has to select it twice to get it to work.
All of these issues can be replicated in the app attached to this post. Please use a mobile phone when testing.
Instructions for item 1:
1) Start the webserver.
2) On a mobile phone, navigate to the website.
3) Press the 'Login' menu item.
4) Press the 'Login' field, it should go straight to the 'Password' field instead. If it does not, please refresh/reload the page then press the 'Login' field.
Instructions for item 2 - assuming you have done steps 1 to 3 above:
1) Reload the page so it has no values.
2) Press the drop list. The 'Password' field is selected instead.
Instructions for item 3:
1) Reload the page so it has no values.
2) Enter the 'Login'.
3) Enter the 'Password'.
4) Press the drop list and select a value. Notice the value is not saved and you have to repeat the selection.
Please let me know if you need more information.
Regards,
Trent
[attachment deleted by admin]
I'm getting quite a few issues in mobile mode when testing on an actual mobile phone - I'm using an iPhone 4S:
1) On a simple login form if the user presses the 'Login' field to type in their username it automatically takes them to the 'Password' field instead.
2) Same login form, the user presses a drop list and the 'Password' field is selected instead with the keyboard showing.
3) Same login form, the user first enters the 'Login', then the 'Password', then selects the drop value, the drop does not select the value correctly and the user has to select it twice to get it to work.
All of these issues can be replicated in the app attached to this post. Please use a mobile phone when testing.
Instructions for item 1:
1) Start the webserver.
2) On a mobile phone, navigate to the website.
3) Press the 'Login' menu item.
4) Press the 'Login' field, it should go straight to the 'Password' field instead. If it does not, please refresh/reload the page then press the 'Login' field.
Instructions for item 2 - assuming you have done steps 1 to 3 above:
1) Reload the page so it has no values.
2) Press the drop list. The 'Password' field is selected instead.
Instructions for item 3:
1) Reload the page so it has no values.
2) Enter the 'Login'.
3) Enter the 'Password'.
4) Press the drop list and select a value. Notice the value is not saved and you have to repeat the selection.
Please let me know if you need more information.
Regards,
Trent
[attachment deleted by admin]
6
Web Server - Ask For Help / Cancel Button Javascript Error
« on: June 04, 2014, 09:34:12 PM »
Hi Bruce,
On 8.13, getting the attached error when clicking on a 'Cancel' button on a form. Any ideas?
Regards,
Trent
[attachment deleted by admin]
On 8.13, getting the attached error when clicking on a 'Cancel' button on a form. Any ideas?
Regards,
Trent
[attachment deleted by admin]
7
Web Server - Ask For Help / Parent Child Relationships in Mobile Mode
« on: June 04, 2014, 07:27:55 PM »
Hi Bruce,
I have an issue where child records cannot be added at the same time the user adds the parent record. It works fine in desktop mode but not in mobile mode. Please see attached example, web73. It's MS SQL so you will need to create an SQL database. You will also need Geoff Bomford's AutoInc template as that's what we use instead of Clarion's AutoInc.
1) Restore the sql database included.
2) Compile and run the app.
3) Open localhost:88.
4) Click 'Customers'.
5) Add a new Customer:
5.1) Add Customer Name.
5.2) Add Customer Country.
5.3) Do NOT click 'Save'.
6) Click the 'Next' button.
7) Click the 'Add Invoice' button.
Click the 'Cancel' button. The Customer record is now lost. Even if you save the new Invoice the Customer record is lost.
Is what I'm trying to do possible in mobile mode or do I have to stop users from adding child records before the parent record is inserted and saved?
Regards,
Trent
[attachment deleted by admin]
I have an issue where child records cannot be added at the same time the user adds the parent record. It works fine in desktop mode but not in mobile mode. Please see attached example, web73. It's MS SQL so you will need to create an SQL database. You will also need Geoff Bomford's AutoInc template as that's what we use instead of Clarion's AutoInc.
1) Restore the sql database included.
2) Compile and run the app.
3) Open localhost:88.
4) Click 'Customers'.
5) Add a new Customer:
5.1) Add Customer Name.
5.2) Add Customer Country.
5.3) Do NOT click 'Save'.
6) Click the 'Next' button.
7) Click the 'Add Invoice' button.
Click the 'Cancel' button. The Customer record is now lost. Even if you save the new Invoice the Customer record is lost.Is what I'm trying to do possible in mobile mode or do I have to stop users from adding child records before the parent record is inserted and saved?
Regards,
Trent
[attachment deleted by admin]
8
Web Server - Ask For Help / Open Form from Link in Change Mode with Login Required
« on: June 03, 2014, 05:47:37 PM »
Hi Bruce,
I'm trying to allow users to open a form in change mode from a URL that has been emailed to them. What I've noticed is that this works successfully if a login is not required but fails if a login is required.
To replicate the problem:
1) Download the attached 'web3' example.
2) Compile and run.
3) Login with the demo credentials.
4) Open this link: http://localhost:88/mailboxesformcontrol?MAI:MailBoxNumber=28&PressedButton=Change_btn
5) It works!
6) Logout.
7) Open the same link above.
Login with the demo credentials.
9) An error will be displayed - it cannot fetch the record.
Is this possible when login is required?
Regards,
Trent
[attachment deleted by admin]
I'm trying to allow users to open a form in change mode from a URL that has been emailed to them. What I've noticed is that this works successfully if a login is not required but fails if a login is required.
To replicate the problem:
1) Download the attached 'web3' example.
2) Compile and run.
3) Login with the demo credentials.
4) Open this link: http://localhost:88/mailboxesformcontrol?MAI:MailBoxNumber=28&PressedButton=Change_btn
5) It works!
6) Logout.
7) Open the same link above.
Login with the demo credentials.9) An error will be displayed - it cannot fetch the record.
Is this possible when login is required?
Regards,
Trent
[attachment deleted by admin]
9
Web Server - Ask For Help / Mobile Mode 'Cancel' Button Bug
« on: May 29, 2014, 06:49:45 PM »
Hi Bruce,
The 'Cancel' button does not work on Forms when inserting a new record and you have 'used' a field on the Form, mobile mode only. Please see attached example:
1) Compile and run the 'test.exe' app.
2) Open the browser to localhost:88.
3) Click 'Browse > Workstation > Add'.
4) Type 'hello' in the 'Owner' field.
5) Press the 'Cancel' button. Nothing happens...
Regards,
Trent
[attachment deleted by admin]
The 'Cancel' button does not work on Forms when inserting a new record and you have 'used' a field on the Form, mobile mode only. Please see attached example:
1) Compile and run the 'test.exe' app.
2) Open the browser to localhost:88.
3) Click 'Browse > Workstation > Add'.
4) Type 'hello' in the 'Owner' field.
5) Press the 'Cancel' button. Nothing happens...
Regards,
Trent
[attachment deleted by admin]
10
Web Server - Ask For Help / Calendar Button Tooltip
« on: May 22, 2014, 10:49:07 PM »
Hi Bruce,
The Tooltips have been disabled for all tablet devices and this is working correctly except for on the Calendar Lookup buttons.
Regards,
Trent
The Tooltips have been disabled for all tablet devices and this is working correctly except for on the Calendar Lookup buttons.
Regards,
Trent
11
Web Server - Ask For Help / Memory Block Free'd Twice Error Part 2
« on: May 21, 2014, 05:51:21 PM »
Hi Bruce,
A client got the memory block error today but there was no GPF or Exception error log, only a C80LOG.txt file that contained:
Error: memory block free'd twice
01373EBF 0001:00082EBF ClaRUN.dll
00D7ECDB 0001:0097DCDB klws.exe
00595113 0001:00194113 klws.exe
013B0F9F 0001:000BFF9F ClaRUN.dll
013B0CC5 0001:000BFCC5 ClaRUN.dll
----------------------------------
How can I debug this further?
Regards,
Trent
A client got the memory block error today but there was no GPF or Exception error log, only a C80LOG.txt file that contained:
Error: memory block free'd twice
01373EBF 0001:00082EBF ClaRUN.dll
00D7ECDB 0001:0097DCDB klws.exe
00595113 0001:00194113 klws.exe
013B0F9F 0001:000BFF9F ClaRUN.dll
013B0CC5 0001:000BFCC5 ClaRUN.dll
----------------------------------
How can I debug this further?
Regards,
Trent
12
Web Server - Ask For Help / Memory Block Free'd Twice Error
« on: May 18, 2014, 06:19:03 PM »
Hi Bruce,
I've receiving this error message in the WebHandler.DeleteSession method which is causing my WebServer to crash all the time. There is code in the DeleteSession embed to cleanup some In-Memory tables and update the UserLogin MS SQL table:
In the debug I see something like this:
[1672] [Net] [1] NetWebServer._GarbageCollector - SessionID = wpZUvNmXJ9fW0ZGjN2SBWfmKRvxdPH has expired.
[1672] [Net] [1] NetWebServer._GarbageCollector - SessionID = XVe404gW8qMsdqxA9rm3TPHSVwNPps has expired.
[1672] [Net] [1] NetWebServer._GarbageCollector - SessionID = NEW0ZvHhFgrWejFF0rnxDwlfHKExDG has expired.
[1672] [Net] [3] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [3] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [4] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [4] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [5] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [5] _NetAll._LoggingSetup - Initialisation
[1672] [KLWS] 10:44:20 Clean Up IMDD Files by SessionID
[1672] [KLWS] 10:44:20 Update User Login Record for log off
[1672] [KLWS] 10:44:20 Clean Up IMDD Files by SessionID
[1672] [KLWS] 10:44:20 Clean Up IMDD Files by SessionID
And then the crash happens. I don't see the debug that is in the 'CleanupIMDD' procedure at all.
Do you have any ideas why this is happening?
Regards,
Trent
I've receiving this error message in the WebHandler.DeleteSession method which is causing my WebServer to crash all the time. There is code in the DeleteSession embed to cleanup some In-Memory tables and update the UserLogin MS SQL table:
Code: [Select]
debug('Clean Up IMDD Files by SessionID')
start(CleanupIMDD, 25000, clip(p_web.SessionID), 'ALL') ! This just loops through each In-Memory table, finds records that are related to the SessionID, adds the record ID's to a queue, loops through the queue and deletes the In-Memory rows that match
debug('Update User Login Record for log off')
p_web.OpenFile(UserLogin)
ULG:SessionID = p_web.GSV('ULG_SessionID')
p_web.SetSqlTimeout(UserLogin,net:on)
If not access:UserLogin.tryfetch(ULG:KeySessionID)
p_web.SetSqlTimeout(UserLogin,net:off)
ULG:EndDate = today()
ULG:EndTime = clock()
ULG:EndMethod = 'Logoff'
p_web.SetSqlTimeout(UserLogin,net:on)
access:UserLogin.update()
p_web.SetSqlTimeout(UserLogin,net:off)
ELSE
p_web.SetSqlTimeout(UserLogin,net:off)
end!if
USR:SysID = p_web.GSV('UserID')
p_web.SetSqlTimeout(User,net:on)
If not access:User.tryfetch(USR:KeySysID)
p_web.SetSqlTimeout(User,net:off)
USR:SessionID = 0
USR:ComputerName = ''
USR:SessionDate = 0
USR:SessionTime = 0
p_web.SetSqlTimeout(User,net:on)
access:User.update()
p_web.SetSqlTimeout(User,net:off)
ELSE
p_web.SetSqlTimeout(User,net:off)
end!if
p_web.CloseFile(UserLogin)
In the debug I see something like this:
[1672] [Net] [1] NetWebServer._GarbageCollector - SessionID = wpZUvNmXJ9fW0ZGjN2SBWfmKRvxdPH has expired.
[1672] [Net] [1] NetWebServer._GarbageCollector - SessionID = XVe404gW8qMsdqxA9rm3TPHSVwNPps has expired.
[1672] [Net] [1] NetWebServer._GarbageCollector - SessionID = NEW0ZvHhFgrWejFF0rnxDwlfHKExDG has expired.
[1672] [Net] [3] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [3] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [4] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [4] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [5] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [5] _NetAll._LoggingSetup - Initialisation
[1672] [KLWS] 10:44:20 Clean Up IMDD Files by SessionID
[1672] [KLWS] 10:44:20 Update User Login Record for log off
[1672] [KLWS] 10:44:20 Clean Up IMDD Files by SessionID
[1672] [KLWS] 10:44:20 Clean Up IMDD Files by SessionID
And then the crash happens. I don't see the debug that is in the 'CleanupIMDD' procedure at all.
Do you have any ideas why this is happening?
Regards,
Trent
13
Web Server - Ask For Help / MS SQL Tables Locking Part 2
« on: April 30, 2014, 05:46:25 PM »Thanks, I've checked that link before and it's not very informative. Unfortunality this is for Client A and they only have SQL 2005. Makes things harder to find.
Yesterday I upgraded Client A and Client C to have the new driver string: /MULTIPLEACTIVERESULTSETS=TRUE /BUSYHANDLING=2 /BUSYRETRIES=5 /BUSYMESSAGE=The connection is busy, please try again later. /LOGONSCREEN=FALSE /VERIFYVIASELECT=TRUE
Client C has not emailed today saying that their desktop app is freezing but Client A has every desktop app freezing at the moment. I have restarted the WebServer but the app is still freezing so now I'm thinking it's not limited to the WebServer anymore... Also the BUSYMESSAGE doesn't appear, has anyone gotten this switch to work?
Delving into the desktop app now...
Regards,
Trent
I am not sure if that query will work in 2005, some of those dynamic management views may be new in 2008.
This link gives an explanation of 2005 activity monitor http://technet.microsoft.com/en-us/library/ms175518(v=sql.90).aspx
Do you have access to a 2008 server? They added quite a few tools to manager performance in 2008.
On a side not, whoever made this forum REALLY needs to fix the problem with losing topics after so many responses are added and having to post a second topic.
14
Web Server - Ask For Help / MS SQL Tables Locking
« on: April 29, 2014, 12:01:56 AM »
Hi Everyone,
I'm still having problems with MS SQL tables being locked by the WebServer which in turn causes my win32 desktop app to freeze. The strange thing is that you can continue to use the web app while it has locked the sql tables.
The driver string for both desktop and web apps is: /BUSYHANDLING=2 /BUSYRETRIES=5 /LOGONSCREEN=FALSE /VERIFYVIASELECT=TRUE
Has anybody else out there actually resolved these issues without having to constantly monitor the WebServer and restart it? I've added code to automatically restart the webserver after a certain amount of time and to save the session queue to an XML (thanks to Kevin for the code) but I've found this does not work for a webserver running as a service, the service never restarts successfully.
Any help will be greatly appreciated. I almost have no hair left...
Regards,
Trent
I'm still having problems with MS SQL tables being locked by the WebServer which in turn causes my win32 desktop app to freeze. The strange thing is that you can continue to use the web app while it has locked the sql tables.
The driver string for both desktop and web apps is: /BUSYHANDLING=2 /BUSYRETRIES=5 /LOGONSCREEN=FALSE /VERIFYVIASELECT=TRUE
Has anybody else out there actually resolved these issues without having to constantly monitor the WebServer and restart it? I've added code to automatically restart the webserver after a certain amount of time and to save the session queue to an XML (thanks to Kevin for the code) but I've found this does not work for a webserver running as a service, the service never restarts successfully.
Any help will be greatly appreciated. I almost have no hair left...
Regards,
Trent
15
Web Server - Ask For Help / Suppress Tool Tips in Desktop Mode
« on: April 22, 2014, 10:25:32 PM »
Hi Bruce,
Is there any way to suppress tool tips in desktop mode when the device is a tablet?
Regards,
Trent
Is there any way to suppress tool tips in desktop mode when the device is a tablet?
Regards,
Trent