This topic is locked
[SOLVED]

 Wizard problem with 22970

10/3/2014 8:50:56 AM
PHPRunner General questions
A
Anapolis author

I just installed build 22970 of PHPRunner 8 yesterday.
But I will now have to fall back and work with my previous version, 22724, to finish up a project over the next few days.
There are 2 project-stoppers that are showing up in my newest 22970 build.
PHP Runner Version 22970, 64 bit, for my Windows 7 development machine is producing an error and is closing just after I select the Lookup Wizard option for an Add page field.
Clicking the Wizard option causes the center popup window to go white, then the Error shows that "PHP Runner has stopped working ..." and to please Okay Closing the program.
I tried setting up brand new projects from the included samples, such as Events or Classified and and a new database and connection. No problems until going into the Edit window and selecting an Add page and choosing to use the Lookup Wizard for filling in the value of any field. Then PHPRunner 22790 whites out and cannot proceed and self-closes.
The other problem I discovered with 22790 is that when I was creating Dashboards that builds were not generating the menu with the Dashboards I had created. Even though I save project files every couple of minutes I had to Close and Save and then re-open a project and then re-build before the missing Dashboards showed up in the opening Menu.
I did not have that problem with version 22724, every Dashboard was immediately created and showed up in the next build.
In Events Viewer I see things like this
Faulting application name: PHPRunner.exe, version: 6.2.0.22790, time stamp: 0x542a43c5

Faulting module name: PHPRunner.exe, version: 6.2.0.22790, time stamp: 0x542a43c5

Exception code: 0xc0000005

Fault offset: 0x00000000001dc328

Faulting process id: 0x11dc

Faulting application start time: 0x01cfdf0331a9566e

Faulting application path: C:\Program Files\PHPRunner8.0-22790\PHPRunner.exe

Faulting module path: C:\Program Files\PHPRunner8.0-22790\PHPRunner.exe

Report Id: 4e7b3f9a-4af7-11e4-84be-bc05430dc885

A
Anapolis author 10/4/2014

I did not have that problem with version 22724, every Dashboard was immediately created and showed up in the next build.
In Events Viewer I see things like this
Faulting application name: PHPRunner.exe, version: 6.2.0.22790, time stamp: 0x542a43c5

Faulting module name: PHPRunner.exe, version: 6.2.0.22790, time stamp: 0x542a43c5

Exception code: 0xc0000005

Fault offset: 0x00000000001dc328

Faulting process id: 0x11dc

Faulting application start time: 0x01cfdf0331a9566e

Faulting application path: C:\Program Files\PHPRunner8.0-22790\PHPRunner.exe

Faulting module path: C:\Program Files\PHPRunner8.0-22790\PHPRunner.exe

Report Id: 4e7b3f9a-4af7-11e4-84be-bc05430dc885

[/quote]
It is now Saturday afternoon a day later and the problem persists with 22790. Projects load fine. Use of Lookup Wizard kills PHPRunner 8.
I tried reinstalling PHPRunner 8.0 version 22790 into the Program Files (x86) folder and it makes no difference as far as the fatal error on Lookup Wizard.

HJB 10/4/2014

It seems to me that some new features within v8.0 are NOT really welcome at some web hoster's ends ... (being too direct to their hosting system), say, while I succeeded to create a DASHBOARD a fortnight ago with an early build (say, I could generate the code, BUT, on a second call of the project file it was starving...) and later I encountered a "total freeze" on later builds, so, I installed a fresh and separate Windows 7 workstation to start from ground (I thought the problem is with Windows 8.1 at my end), yet, no success. What I have now is this at my Europe's largest web hoster's server end: When I start v8.0 and enter connection details (via connection script), the program totally ends (simply disappears with even no error message). So, I do NOT want to put a blame on the product here at all as I think, it has to do with some restrictions at the web hoster's end, making me now to believe to sooner or later strike a DEAL with Sergej on <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=75859&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' /> INSPIRUNNER <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=75859&image=2&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' /> hosting as it is more than clear to me: <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=75859&image=3&table=forumreplies' class='bbc_emoticon' alt='B)' />The new features of v8.0 are really rocking, yet, whenever something rocks, it is as well rocking the competition ..., so, the best philosophy for me now seems to be: Developer product and developer's own hosting service to bring functional DASHBOARDS under true project file progress to the market to avoid bottlenecks in configurations and else at traditional web hosting ends.

A
Anapolis author 10/5/2014

It is Sunday afternoon in Buchholz, "suburb" of Hamburg. I have not tried this latest project yet at 1und1.de in Germany. I have a Managed server account with a dedicated machine and all connections are mysqli.
I think that between build 22724 and 22790 of Runner 8.0 that the connection method has changed. Which would explain why the Lookup Wizard is causing a crash and dump.
I am still testing on the localhost Windows 7 development machine at home.
Here is the latest crash when I tried to reopen a 22724 phpr with build 22790
Connection string
DRIVER=/MySQL ODBC 5.3 Unicode Driver};Server=localhost,Uid=root,Pwd=,Database=pohlboskamp,OPTION=3
Connection string examples (more samples)
PHPRunner popup error
Unable to connect to the database
SQL ErrorState:IM002,Native Error Code:0, ODBC Error:[Microsoft][ODBC Driver Manger] Data source3 name not found and no default driver specified
Connection string examples (more samples)

MS Access 2007

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\databases\sample.accdb;Persist Security Info=False;
MS Access 2003 and older

Driver={Microsoft Access Driver (.mdb, .accdb)};DBQ=C:\databases\sample.mdb;Uid=admin;Pwd=
MS Excel

Driver={Microsoft Excel Driver (.xls, .xlsx, .xlsm, .xlsb)};DBQ=C:\spreadsheets\data.xlsx
SQL Server

Provider=SQLNCLI;Server=server;Uid=sa;Pwd=password;Database=cars
Crash Dump file is saved to

path to .../StandartPHPRunner22790_1.dmp

HJB 10/5/2014

Heartfelt greetings to Buchholz from Glinde ..., 1st, I always use CONNECTION SCRIPT since years now as to avoid "... works at home ...", crashes "abroad" issues. 2nd, in regard to 1&1 hosting, fact remains, even the professional and especially silent buddies of SOURCEGUARDIAN and IONCUBE, including their clever WIZARD TOOLS, could NOT bring an answer of what exact LOADER version should/could be used in regard to 1&1 LLinux based hosting while 1&1 FAQ pages are telling you something else (say, their page content is outdated, but who cares?). 3rd, you know that D is "service desert" of its own (world) class ..., so, either you able to solve the problem by yourself or you look for alternatives of functional hosting, say, maybe be "inspired" by INSPIRUNNER, to simply forget about wasting time on troubleshooting and delays in project development to finally at divine hosting facilities, driven by the software developers and their slogan "... making the web easier ...". In other words, the software developer is seeing his product running at his end like a charm while "good old Europe" buddies like us are trying to nip in the bud. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=75867&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' />

A
Anapolis author 10/5/2014



Heartfelt greetings to Buchholz from Glinde ..., 1st, I always use CONNECTION SCRIPT since years now as to avoid "... works at home ...", crashes "abroad" issues. 2nd, in regard to 1&1 hosting, fact remains, even the professional and especially silent buddies of SOURCEGUARDIAN and IONCUBE, including their clever WIZARD TOOLS, could NOT bring an answer of what exact LOADER version should/could be used in regard to 1&1 LLinux based hosting while 1&1 FAQ pages are telling you something else (say, their page content is outdated, but who cares?). 3rd, you know that D is "service desert" of its own (world) class ..., so, either you able to solve the problem by yourself or you look for alternatives of functional hosting, say, maybe be "inspired" by INSPIRUNNER, to simply forget about wasting time on troubleshooting and delays in project development to finally at divine hosting facilities, driven by the software developers and their slogan "... making the web easier ...". In other words, the software developer is seeing his product running at his end like a charm while "good old Europe" buddies like us are trying to nip in the bud. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=75868&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' />


Yes, I am well aware of 1&1 in the States and Germany. But in this case I do not have a problem yet with the connection script to the online linux server. It is Runner 8 Version 22790 that is unusable to me in the development stage and I am back to using 22724. Because I have so many Runner applications operating at one website for some corporate clients I do not use a connection script for the mysql database until I have got a "similar" hosting environment working at home.
To test my application I have to WRITE data to the database and perform joins, etc. Too cumbersome with my slow internet connection to be reading and writing and querying over my ISP. So far with the newer editions of PHPRunner connections have been a lesser problem with this server.

HJB 10/6/2014

Build 22833 just tested to run FINE in regard to LOOKUP WIZARD on ADD Page..., so..., my advice is to run a WORKAROUND via XAMPP, creating and testing ..., then under BUILD PAGE of PHPR v8.0 to EDIT the connection details to e.g. 1&1 MySQL one..., to build the files again and finally to import ZIP formatted SQL DUMP FILE (a.k.a. "Create SQL Script" link inside the UPLOAD Page of PHPR V8.0) into the 1&1 environment. Since ZIPPED SQL DUMP FILE is usually very small compared to the original one..., even bigger projects do not create create a bottleneck situation on slow Internet connection at all. This solved my problem too on DASHBOARD creation via connection script with 1&1 web hoster ..., okay, not elegant like connection script way, yet it works the other way and that's what counts here at my end.

A
Anapolis author 10/6/2014



Build 22833 just tested to run FINE in regard to LOOKUP WIZARD on ADD Page..., so..., my advice is to run a WORKAROUND via XAMPP, creating and testing ..., then under BUILD PAGE of PHPR v8.0 to EDIT the connection details to e.g. 1&1 MySQL one..., to build the files again and finally to import ZIP formatted SQL DUMP FILE (a.k.a. "Create SQL Script" link inside the UPLOAD Page of PHPR V8.0) into the 1&1 environment. Since ZIPPED SQL DUMP FILE is usually very small compared to the original one..., even bigger projects do not create create a bottleneck situation on slow Internet connection at all. This solved my problem too on DASHBOARD creation via connection script with 1&1 web hoster ..., okay, not elegant like connection script way, yet it works the other way and that's what counts here at my end.


A project I just built and uploaded with 22724 has stopped letting me in as admin or any other user.
I spent the last hour logging in as tests with different accounts. Then I logged out and now no entry.
My permissions tables look fine.
When I re-opened the last project file and tried a build it stopped with an error ...
c:\Program Files (x86) PHPRunner8.0\source\connections\ConnectionManager.php couldn't find element strCode
There is "something" that keeps showing up with the connectionmanager that is linked to my earlier problems with 22790.

Sergey Kornilov admin 10/6/2014

The problem with this issue as well as with may similar ones is that providing a meaningful answer without having access to project file and/or generated files. All we can do is to make educated guesses. If you need help you definitely need to contact support. Posting this kind of info here is pointless.

A
Anapolis author 10/6/2014



The problem with this issue as well as with may similar ones is that providing a meaningful answer without having access to project file and/or generated files. All we can do is to make educated guesses. If you need help you definitely need to contact support. Posting this kind of info here is pointless.


Thank you, Sergey. And thank you for the latest upgrade. I just installed it.
Unfortunately, for the first time in a few years I have a project which loops around and around after the login is filled in and submitted.
I have rebuilt this, tried dynamic permissions with new tables, tried static permissions, tried just one login hardcoded.
And an hour and a half ago I was constantly logging in and out with no problem.
Thanks for working on the latest version! I will stagger through this mystery..

A
Anapolis author 10/17/2014

I am very grateful that PHPRunner has solved this issue for me! I am using the latest version now and the same problem I had had with it has been solved. Extra considerate work to discover the source of my problem and to fix it!
Thanks so much!