flydev

Hi everyone, While enjoying every day with ProcessWire - not building websites - but native apps and API. Just to say that I have a desire for a few months that is to teach you how to build an RestAPI and a cross-platform native application for iOS, MacOS, Android, Windows and maybe Linux in some weeks by coding in Delphi (Pascal) and using our awesome CMF ProcessWire as a backend. Why Delphi ? Embarcadero released a free edition of their IDE/Compiler (the FREE Delphi Community Edition) and everyone can enjoy building real native apps. It also give me now the opportunity to share this experience with you, as the license without the free edition was starting at ~1500$ for the Pro Edition. Also, Delphi is easy to learn, in particularly the FireMonkey frameworks which will be used to build those apps. At least I think ! When I personally begun to write code in Delphi, I had years of experience of the internal Windows API and C/C++ coding background. Still, it's just a desire, and i don't know if there are people interested by this - so let's vote !

Hi @derelektrischemoench #1 - You might try to play with the htaccess on this line : # RewriteBase / Try to comment / uncomment this line on your distant server. #2 - Give a try to Duplicator, make a package on your local setup then upload it to your server and use his installer to check that everything required is ok, then continue the package installation Download link of the module (use the 1.3.12 or 1.3.13) : https://processwire.com/talk/applications/core/interface/file/attachment.php?id=18643

Thanks @Autofahrn ???? @adrian About the issue "MySQL server gone away". Its quite hard to determine from where come this issue - and just saying - I still not found the way to track down this issue. FYI I also got this issue on a new MariaDB server on Windows (a boosted server where the PW setup contain more than 1.5 millions pages), and also sometime on my local MAMP setup. (The issue does not concern only Duplicator). I remember also two weeks ago, I got this issue on a shared server (another setup with about 260k pages). ATM the only two hints which come to my mind is that the issue mostly appear when using the API - which can lead us to another hint: a server memory issue Thing to test: Disabled TracyDebugger Other thing to check: I mostly work with InnoDB databases and I remember that adjusting some MariaDB parameters helped. Parameters to check : max_allowed_packet innodb_log_file_size innodb_buffer_pool_size innodb_log_buffer_size PS: To adjust the settings, check this reply : What say the MySQL devs : Let me know - thanks guys ??

https://codepen.io/flydev/pen/LYEeEdR this with a bit of css/js solve your issue.

@Gadgetto maybe I have misread you and/or you didn't tested the technique I told you, check this demo : https://codepen.io/flydev/pen/ZEYvYKZ

set debug to true then tell us the file which trigger this error. You certainly have a call to that class bad typed. let's see. Where we should look at ?

Correct, the trick here is to disable all options except the one which need to be submited. <select> <option value="1" disabled>one</option> <option value="2" disabled>two</option> <option value="3" selected>three</option> </select>

@theqbap Then add the string "JSON" before the config : JSON{ "name": "Testing the import", "input": { "type": "csv", "delimiter": ",", "header": 1, "limit": 10 }, "fieldmappings": { "title": 1 }, "pages": { "template": "Data", "selector": "title=@title" } }

@theqbap The YAML example converted to JSON with an online tool give us this config : { "name": "Testing the import", "input": { "type": "csv", "delimiter": ",", "header": 1, "limit": 10 }, "fieldmappings": { "title": 1 }, "pages": { "template": "Data", "selector": "title=@title" } }

@theqbap The YAML thing is an extension of PHP which need to be activated on your server configuration.

Hi @wbmnfktr It seem that your are using the wrong version - try the 1.3.12-ATO version on the dev branch please, it work as expected.

Yeah thanks, I remember a post about that but sorry for not explaining my main issue. The issue is not performances about creating page, but importing those 300k files without being able to use the PCNTL functions, and thus, I ran into memory limit and max execution time issue. PS: I have not control for these two settings.

Hi Peter, take a look a at this thread :

Hello guys, I need to import about 300K text files (each file has ~256 bytes) and turn them into pages on a website hosted on a shared host. I know I could use the PCNTL extension functions to do this job but its not available (I asked the support to enable it but I think that the answer will be negative). Do you guys have/know a work-around, script or any other idea I am not thinking of now ? Thanks ?

$mydb = new Database('localhost', 'user', 'pass', 'my_other_dbname'); $result = $mydb->query("SELECT * FROM a_table"); [...]

Damn, too much work coming on ? Thanks for the new version @dadish ?

Hi Abdul, The solution is already in this thread ?

Hi @Christophe Badoux It sound like a permission or maybe a server cache issue, but we need more information about your hosting. Things to check : browser cache disk space available value of session.save_path and permission of this value permission of site/assets server caching (depending on the server setup, could be NGINX, Squid, Varnish, Memcached, etc..) I bet on the last one. Oh and Welcome to the forum ?

@Tyssen you could try to add <?php namespace ProcessWire on the top of the module file.

Hi @Marcel, please tell me which version of Duplicator, ProcessWire and PHP you are on.

I hope its just a corrupted database. if you encounter again the same problem, in a terminal, enter in mysql shell then type `show databases;` Is there a table name `PLEASE_READ` ?

Hi, sorry the module does not support ReCaptcha v3 at this moment. If you are using FormBuilder I should have a working code example.

https://wiki.php.net/rfc/nullable_types https://www.php.net/manual/en/migration71.new-features.php

@Sebi Really great additions ! There is a small issue, in site/api/Routes.php, the call require_once wire('config')->paths->RestApi . "RestApiHelper.php"; should be require_once wire('config')->paths->RestApi . "classes/RestApiHelper.php"; I really like the idea of applications key. I didn't spotted problems using it yesterday but still need to be tested deeply - I have three mobile native apps in which I will test it ? The Process Module is cool, I vote to stay with it.

I am using this module in all my install now (it's a modified version with Basic Auth implemented) and all these additions look super ! Looking into it this afternoon, I will give my opinion. Thanks guys for the hard work ?