Recently Browsing 0 members
No registered users viewing this page.
I have built a system in processwire, which has more than 600K pages.
A team of 40 people is using the system, DB is from AWS with 16GB Ram.
But still, select queries are getting locked.
It would be great if someone suggests how to solve this problem.
Also note: We have around 48 fields in one template.
Thanks in advance.
With Microsoft Azure recently releasing proper Linux and native Mysql hosting, it is becoming very easy to get processwire hosted on that platform.
By default, they force SSL connection to the managed Mysql server. This causes processwire to fail when trying to connect.
I can turn off SSL for my MySql server, but I wish there was a $config setting like $config->useSSL = true that would allow processwire to include the appropriate property in the connection string (like ssl=true or whatever).
Here is the Azure link that explains what I would like to do: https://docs.microsoft.com/en-us/azure/mysql/concepts-ssl-connection-security
Am I missing this config setting somewhere? Or would it be easy to add? Thanks.
i am newbie, so i'm sorry for silly question..
i want to insert data to my database.
this is my syntax
$pDOStatement = $database->query("INSERT INTO questions (ID_USER,TIME_Q, QUESTION) VALUES (1,NOW(), $pertanyaan)"); for $pertanyaan is my variable which string.
but, i get error (in attacment)
please help. thx
Today I have been running in mysql errors using @renobird s Module MarkupActivityLog which still uses mysqli Driver.
Although mysqli is still supported PDO driver is the default database driver in PW since https://processwire.com/about/news/introducing-processwire-2.4/
and its strongly recommend to all module authors to use/change-to PDO driver instead of mysqli.
@renobird I have sent a pull request.
A list of other affected modules not updated until now.
(I try to keep them up to date. Please help)
@apeisa ProcessTrashman, ProcessRedirects