This topic is locked

Save and Build Crashes

11/12/2020 6:37:02 AM
PHPRunner General questions
C
CWDATA author

I have been working on a project for a few days. Yesterday I opened my Project to start work on it and got the following error message.
"Missing File" D:\Freelance Work\PPH - ADEPT\Database\Adept\subversion\PAGES.sqlite
This has occurred completely out of the blue. What would cause the file to suddenly disappear?

I have restored a previous version from the backup file which opens ok. Some of my work i.e. Field Configurations. I tried configuring on one table and saving it. On that occasion, it worked. But when I built the project it Hung and then crashed and I was back to square one.

I tried again but this time it hung and crashed at the Save stage.
Anyone had this and have a solution?

K
kohle 11/13/2020

Hi,
You should get in contact with the Support (support@xlinesoft.com)
I had some issues too. Normally phprunner builds a dump file which you can send to xlinesoft.

I changed to phprunner 64bit and added more memory to my virtal VMWARE machine.

In my case, with the 64bit version the intern intern webwerver dont work and I use now Wamp64 for local testing.
I had to return to an older copy of my work and did the work again.
Before I work on a project or make many changes I use "save as" to save the project in a new project folder, like "project1,project2,project3....)

Outputfolder is always the same, like c:\wamp\www\project
Good luck.

C
CWDATA author 11/13/2020



Hi,
You should get in contact with the Support (support@xlinesoft.com)
I had some issues too. Normally phprunner builds a dump file which you can send to xlinesoft.

I changed to phprunner 64bit and added more memory to my virtal VMWARE machine.

In my case, with the 64bit version the intern intern webwerver dont work and I use now Wamp64 for local testing.
I had to return to an older copy of my work and did the work again.
Before I work on a project or make many changes I use "save as" to save the project in a new project folder, like "project1,project2,project3....)

Outputfolder is always the same, like c:\wamp\www\project
Good luck.


Thank you for sharing your experience. I have been using 10.3 for a while now and built a few projects without this occouring. This literally happened out of the blue.

HJB 11/13/2020

Simply speaking, did you check under the FILE EXLORER on your system

whether indeed the file is missing (deleted?). NB: What backups under

PHPRUNNER load or not is irrelevant as during the project development phase,

PHPRUNNER is running it's own built-in server to be able to edit and view pages.
Only once you CREATE fresh PHP code, PHPRUNNER starts looking for the

configured path to go (to upload the code into the non-PHPRUNNER server

environment, say, if that non-PHPRUNNER server configuration is not properly

working, the failure is ooriginating from there).
I peronally guess, you are using external storage media (USB stick or

external harddisk) by seeing D: as a partition, in other words, if you

unplugged the external storage media and plugged other external things

into the USB ports, the Windows System reallocates the drive's D: naming,

in short, once you add your project file storage media later on, it could

get the E: or else drive naming and so, the configured path is no longer

working under PHPRUNNER at all.
In my opinion, the fault is definitely NOT with the PHPRUNNER product at all,

moreover you said, it worked before for some time. Next to it, PHPRUNNER does

not delete any file at random, but even saves manually deleted files within a

history files section to get them back into the system if wished.
Workaround: Copy the SQLITE file into the said path from the saved projects

directory or create a new database connection anyway for testing purposes.

C
CWDATA author 11/16/2020



Simply speaking, did you check under the FILE EXLORER on your system

whether indeed the file is missing (deleted?). NB: What backups under

PHPRUNNER load or not is irrelevant as during the project development phase,

PHPRUNNER is running it's own built-in server to be able to edit and view pages.
Only once you CREATE fresh PHP code, PHPRUNNER starts looking for the

configured path to go (to upload the code into the non-PHPRUNNER server

environment, say, if that non-PHPRUNNER server configuration is not properly

working, the failure is ooriginating from there).
I peronally guess, you are using external storage media (USB stick or

external harddisk) by seeing D: as a partition, in other words, if you

unplugged the external storage media and plugged other external things

into the USB ports, the Windows System reallocates the drive's D: naming,

in short, once you add your project file storage media later on, it could

get the E: or else drive naming and so, the configured path is no longer

working under PHPRUNNER at all.
In my opinion, the fault is definitely NOT with the PHPRUNNER product at all,

moreover you said, it worked before for some time. Next to it, PHPRUNNER does

not delete any file at random, but even saves manually deleted files within a

history files section to get them back into the system if wished.
Workaround: Copy the SQLITE file into the said path from the saved projects

directory or create a new database connection anyway for testing purposes.


Thank you for taking the time to reply and your advice. I will take a look.

Kind regards

C
CWDATA author 11/16/2020



Thank you for taking the time to reply and for your advice. I will take a look.

Kind regards


Thought I may have discovered the reason for this. I had recently installed MS My SQL Server. So I removed it in its entirety and loaded the newest backup I had of my project that would load without Error. As it happened it was more up to date than I thought it would be. So I have been working on it all morning saving frequently. Then completely out of the blue I did some formatting in the designer page, did a save, and yet again green barred to about 25% hung for a few mins then crashed again. By the way, I am not using any external devices. Tried to reload and yet again PAGES.sqlite missing. I went back to the previous back up but several files were missing from the subversion folder. Went back to the next Backup and that appeared to be fine so loaded it with no problems. Made a single change in the designer page, saved and it crashed again.

HJB 11/17/2020

D:\Freelance Work\PPH - ADEPT\Database\Adept\subversion\PAGES.sqlite
Makes sure, that indeed the above path has the PAGES.sqlite file in place

and that PHPRunner connection to that very database file is correct.
P.S. https://www.geeksforgeeks.org/difference-between-sqlite-and-ms-sql-server/
Hard to say of what kind of production server environment you are running, yet

fact remains, I would be truly surprised if a commercial product by M$ would aim

to provide 100% down-compatibility and support to an open source (freeware) like

SQLITE. In between is PHPRUNNER's built-server which allows you load, view and work

backups, yet you try to blame it for being unable to know your production server

oriented environment, say, make sure, PHPRunner is connected to the database file

within a PHP code supported (OUTSIDE PHPRunner's built-in server) from where you

finally want to display things to the globe.

E
Eddy Keuninckx 12/25/2020

Could it be caused by cloud synchronization software like Ondedrive or Synology?