PavelRadvan

I uninstalled and also updated my server.
Now is module installed again and it seems it is ok.

Thanks for support

OK.
I have found but do not have that TraceApiData.proceduralFunctions:

Should I set some settings on or off?

Hi.
Where is possible to have this panel you sent screenshot ?
I cannot find which panel it is ...
Here is screen from my panel config of tracy:

How to see that you posted?
Thanks
Pavel

Thanks for reply.
I installed php-tokenizer extension and now there is another error :

ErrorException: Undefined array key "pwFunctions" in /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/includes/PwApiData.php:25
Stack trace:
#0 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/includes/PwApiData.php(25): Tracy\Bar->Tracy\{closure}(2, '...', '...', 25)
#1 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/TracyDebugger.module.php(3082): TracyPwApiData->getApiData('...')
#2 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/panels/ConsolePanel.php(154): TracyDebugger::getApiData('...')
#3 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/tracy-2.10.x/src/Tracy/Bar/Bar.php(143): ConsolePanel->getPanel()
#4 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/tracy-2.10.x/src/Tracy/Bar/Bar.php(115): Tracy\Bar->renderPanels('')
#5 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/tracy-2.10.x/src/Tracy/Bar/Bar.php(89): Tracy\Bar->renderPartial('...')
#6 /usr/local/www/apache24/data/site/modules/TracyDebugger/tracy-2.10.x/src/Tracy/Debugger/DevelopmentStrategy.php(123): Tracy\Bar->render(Object(Tracy\DeferredContent))
#7 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/tracy-2.10.x/src/Tracy/Debugger/Debugger.php(319): Tracy\DevelopmentStrategy->renderBar()
#8 [internal function]: Tracy\Debugger::shutdownHandler()
#9 {main}

My server is on FreeBSD 14, PHP 8.3, MySQL81

pwFunctions should be defined somewhere?

Hi.
I have from Tracy some strange error :

Error: Call to undefined function token_get_all() in /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/includes/PwApiData.php:337
Stack trace:
#0 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/includes/PwApiData.php(118): TracyPwApiData->getFunctionsInFile('...')
#1 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/includes/PwApiData.php(25): TracyPwApiData->getProceduralFunctions('...')
#2 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/TracyDebugger.module.php(3082): TracyPwApiData->getApiData('...')
#3 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/panels/ConsolePanel.php(154): TracyDebugger::getApiData('...')
#4 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/tracy-2.10.x/src/Tracy/Bar/Bar.php(143): ConsolePanel->getPanel()
#5 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/tracy-2.10.x/src/Tracy/Bar/Bar.php(115): Tracy\Bar->renderPanels('')
#6 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/tracy-2.10.x/src/Tracy/Bar/Bar.php(89): Tracy\Bar->renderPartial('...')
#7 /usr/local/www/apache24/data/site/modules/TracyDebugger/tracy-2.10.x/src/Tracy/Debugger/DevelopmentStrategy.php(123): Tracy\Bar->render(Object(Tracy\DeferredContent))
#8 /usr/local/www/apache24/data/site/assets/cache/FileCompiler/site/modules/TracyDebugger/tracy-2.10.x/src/Tracy/Debugger/Debugger.php(319): Tracy\DevelopmentStrategy->renderBar()
#9 [internal function]: Tracy\Debugger::shutdownHandler()
#10 {main}
 

How to solve this ?

Thanks for answer.

Pavel

OK. Thanks for notice. I will try to find some logs. I wanted to just try your module.
I will use Form Builder from Ryan, but your module also appears interesting.
 

52 minutes ago, Juergen said:

Hello @PavelRadvan

Thanks for your info at first. I have not discovered problems like this til now and I guess other users do not run into problems like this too. Otherwise someone has informed me about such a behavior.

I only run this module on PHP 8.1, but there I have no problems at all. The code should run on 8.3 too, but I have only tested the syntax on PHP-Storm and not in live situation - so the code should be valid for PHP 8.3 too.

Some question:

Does the problem consist on every page request?

Do you have tried to close all browser windows and open the website after that again (sometimes PW runs into performance issues, with an unknown issue and after "re-start" everything works as expected)?

Does this problem persists if you are calling only the backend (without forms output on the frontend).

Maybe you could give me some infos about that.

Best regards Jürgen

 

 

Hi.

Thanks for you answer.
I did not have any chance to do more, because whole system had problem immediately after installation.
After I clicked on settings of your module, it was after few moments stuck in loading and loading......

So after circa 10 minutes I canceled all and restarted mysql and apache + php.
Then after login to administration of PW it happened again...
So finally I had to restart whole HW
I had to check configuration of mysql and reinstall it because there was some strange damage to its install...
In logs was only that MySQL shutted down and no extra info more...
What do you think of it ?
Pavel

Hi.
Today I installed your module on latest DEV PW
HW is FreeBSD14, PHP 8.3.1(PHP-FPM), MySQL8.1, 32GB RAM, 8-core CPU
After install of your module RAM of server was suddenly from 10% to 95% and whole system was unstable.
Do you have any problems with your module like this ?
Is PHP 8.3.1 supported ?
Thanks for answer
Pavel

Hi.
I really like this options in date ranges.
I do not know if my question is right, but I will explain here, so it will be nice to have some info from your if what I want is possible.
I have customer with restaurant and he has from me whole site and I used Form Builder Pro from Ryan for reservations.
That customer has requirement to disable specific days which are visible in data picker.
For example he wants to disable every Sundays and Mondays and some public holidays.
On these days his restaurant is closed and thus not available for reservations.
Is it possible with that new Date ranges  ?
What do you think ?
Thanks for answer

1 hour ago, bernhard said:

I disagree, but I don't know the tools you mentioned @dotnetic

But I don't see any reason why PW would not be a great fit for such a project. In general I think that PW is a brilliant replacement for MS Access databases. Only thing missing in my opinion is RockGrid for displaying data in an excel-like manner with sorting and filtering features.

This has nothing to do with my modules. RockMigrations has a different purpose. It's not about migrating data from other systems to PW it is about migrating changes that you added on your development system to staging or production systems.

So for example if you were done with the move from MS Access to PW and the client was already working on your system and then one day he/she comes to you and says: "nice, everything works great, but we want another feature XY!".

You know that this feature will take 3 weeks to develop. What would you do?

One option would be to take the live site offline for that 3 weeks and then, when you are done, upload everything to the live server. That's usually not a good solution.

The other option is to leave the site online and develop everything locally in parallel using the power of RockMigrations. All the database changes (creating templates, fields, roles, etc) can be done in code and that means once you are done you can just upload your changes to the live server, migrations will kick in and create all the changes that are necessary and your system will work just like it did on your local development and your client will get the update with zero downtime.

That answers the question related to RockMigrations I guess. Everything else is offtopic, so please either create a new topic and ask the community for help or write me a PM if you want to purchase consulting from me personally. Thx.

All the best for your project. It sounds interesting and fun 🙂 

Thanks for your answer and explanation. I certainly will use PW and now I clearly know that your modules are also very usable in my project.

1 hour ago, dotnetic said:

Hello @PavelRadvan. I don't know how much experience with ProcessWire you have, and why you chose it. You can definetly develop an application to search through the database, but as much as I love ProcessWire, I think there are better tools for this task.

First you have to export the data from Access to a MySQL or MariaDB.

Then I would recommend using a tool like Directus (free, open source), with which you could Add Directus to an Existing Database (learndirectus.com)

Or Filament (free, open source) which is a nice admin for databases and CRUD functionality.

Or Laravel Nova.

Hi.
Thanks very much for your answer. Tools your writing are interesting, but application I want is not only for searching in database. I do not have vast experience with PW, but I have several sites built with it and I have to say it is wonderfull system.
For me it is decided selection.

7 hours ago, bernhard said:

Sure. Why should that not be possible? But there are no GUI import/export tools or the like. But you can write your scripts and use everything that RockMigrations provides. Though maybe you wouldn't even need RockMigrations for that... Just use the PW API

Thanks for quick answer.
I would like to know what you could recommend for my current project.
For right answer I have to explain situation:
I am working on customer request to have some app for managing his business contracts and assets.
His is doing business with antiquities - so he is receiving valuable items from customers and offers them for sale.
Mainly these items are jewellery, art and other antiquities (lots of them).
Now he is using very old Windows app based on very old MS Access db.
This old app has db with all of his current and old contracts inf form of interconnected tables and also links to tons of images of items (antiquities).
So for one contract there could be several connected images. To this day there are lots of images (around 50 000 jpeg/png..) and lots of data in app.
This app is not good now for his needs. It takes very long to search anything and also working with images and data is not good..
I decided that I could use PW for his app.
And now my questions:
Is better to use PW with your modules for import data from that Windows app or is better to use some import module like ImportPagesCSV, link: https://processwire.com/modules/table-csv-import-export/ ?
Which other modules would you recommend ?
Thanks for your answer.
Pavel Radvan

Hi.
Nice module.
Is possible to use this module to import data to PW ?
As it is named "Migrations" it could migrate data (from xml/csv...or other) to PW - could it be done with it?

Hi.
I am sorry I did not get to you earlier.
Thank you very much for reply.
Regarding your answers and questions :
Customer is not doing cross selling, he just sell antiquities and lots of his clients just bring something (old ring for example) to sell to him for money or other commodities.
So my customer buy this from his client and then usually he put it on eshop to sell. This is just explaining of business of my customer - it is not intended to be incorporated in eshop.
It is very simple for him to create new product and make it available on eshop. Every product of his eshop is unique, because there are no new products, only used, returned, old and ancient pieces...

Challenges which customer has to solve - problems with current state of PS - it is so modified it is not easy to upgrade and also use it as good platform in future.
Sometimes happen that his clients cannot login to system or cannot use basket or mailing is not delivering messages. There is not much user friendly to adjust something from customer side - like  some blog posts, integration of instagram, facebook and others...there are also marketing campaigns on facebook and there is not easy to use PS as eshop as should be working...

It is very nice you have padloper already with paypal integrated...

It could be very nice to have some more options from you to have that custom code for that product reservation system - it something like a booking system in hotel - just to have option to reserve product before buying and to decide later. But is is usually with some more options - like a possible discount or another details.

So from my point of view it could be very valuable to discuss this further.
What do you need to know about whole system to have some good understanding of this project?

Pavel

Hi.
I would like to use padloper + PW for my customer to replace prestashop which is his current eshop platform.
It is shop with antique objects(atrs, rings, jewellery, pcitures ....) and is selling lots of products.
Since it is selling of antiquities there is usually also normal situation of purchasing products from customer's clients to resell them.
Shop is now integrated with paypal platform for card payments and is offering to clients to buy even without registration, which is required in our country and also by EU laws.
Prestashop as system is used by customer quite long time and I inherited it with a lots of adjustments and modifications from other developers and it is not in good state.
Last two years I keep it working but it is not possible to upgrade it easy and without problems. Customer has virtual hosted server dedicated mainly to e-shop platform.
About 2 months ago customer and his team tried to make some survey about what to do next with current system and there is no good solution for him to fulfill all needs.
Big game changer and also challenge for competitive systems is reservation system which is offering to clients option to reserve certain product for specific period (days/weeks/months).
This time is configurable in backend with also other parameters.
Reservation system also maintains some queue of people with respective order. When first client who made reservation decide to cancel it, there is option for next client in queue to make reservation.
Every client who want to reserve products has to register in system to have in his profile page details and information about reservations.
Reservation system is also sending mails to customers with notify of ending of client reservation.

I checked demo site https://demo.kongondo.com/ of padloper and it is quite interesting.

Do you think is possible to have solution based on ProcessWire and Padloper?