Upgrade phplist problem

xristoskon · May 21, 2018, 2:27pm

I just tried to upgrade phplist database , but for my hell , it got timed out , and now i get

phpList is in maintenance mode.
Please try again in half an hour.

can i remove the maintenance mode ?

duncanc · May 21, 2018, 3:05pm

@xristoskon Look in the config table for a row whose item field is “maintenancemode”, then set the value to an empty string.

xristoskon · May 22, 2018, 12:38pm

thank you
it was just this easy

xristoskon · May 22, 2018, 2:05pm

i also have problem with greek encoding , as shown , any ideas ?

duncanc · May 22, 2018, 5:01pm

@xristoskon encoding problems can sometimes be solved by making a change to the config.php file, see BUG / Hotmail / phplist 3.2.3

xristoskon · May 23, 2018, 1:43pm

i tried to edit it many times , but i still just paste in html the following

σημερα είναι τετάρτη

and phplist translates it to:

<p>σημερα είναι τετάρτη</p>

please help me

duncanc · May 23, 2018, 4:01pm

@xristoskon You need to configure CKEditor to not use html entities for greek characters.

To do that create a custom ckeditor configuration file, e.g. ckcustom.js, containing

CKEDITOR.editorConfig = function( config ) {
    config.entities_greek = false;
};

and put that file somewhere on the web site. Then tell the CKEditor plugin the location of the file. See https://resources.phplist.com/plugin/ckeditor#custom_configuration

When first composing a campaign you should refresh the browser cache using F5.

xristoskon · May 24, 2018, 7:52am

didnt work
i tried to make it that , but the email still gets out with the special chars

duncanc · May 24, 2018, 9:16am

@xristoskon The change seems to work for me. In the email that I received the greek characters are displayed directly not html entities

<p>σημερα είναι τετάρτη</p>

xristoskon · May 24, 2018, 9:40am

thanks a lot , i will try to reverse to older working version , i hope i have no issue , cause im tired with this

manjanjap · February 12, 2019, 6:08pm

Dear Duncan,

I particularly find it quite strange that usually the solution is for one to go into the databases and modify a value, even with the problem of the processque which from time to time, stalls, one must go to the process queue table and delete the stalled process, why can we not get a classic solution to these problems, such as ,

the process queue dont stall, I use also other bulk email software like Sendy, it does not stall yet I be sending email to 200k subscribers via Amazon, but larks certain features of PHPList
Maintenance mode, question once again is what causes this? Why does the process stall?

Thank you.

duncanc · February 13, 2019, 9:49am

@manjanjap Are you referring to the “sendprocess” table? If you need to remove rows from that table then it indicates a problem with the phplist processqueue page not completing successfully, such as being killed by the operating system.
The problem should correct itself after 5 or 10 minutes, not sure exactly, but phplist should “time-out” rows on that table.

Regarding point 2) you should raise an issue on Mantis for phplist to provide a way to reset the maintenance mode.

sasciame · June 26, 2019, 12:53pm

Hello,

Normally I upgrade phplist manually, but this time I chose the new auto-updater feature. Phplist seemed to hang at the Updating Templates stage (+1hr). I am now getting the message, " phpList is in maintenance mode.
Please try again in half an hour."

I looked through the config table and did not see the field labeled maintenancemode
mysql> describe phplist_config;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect…
Connection id: 65763947
Current database: achchi_phpl1

I looked through most of the other tables as well. Where would I find the maintenancemode field in order to clear it?

Any help would be much appreciated.

duncanc · June 26, 2019, 2:20pm

The item column has the value “maintenancemode”. The value column should be set to 0 to clear it.

sasciame · June 27, 2019, 7:33pm

Thank you for the reply. I eliminated the behavior by following the advice on another thread to delete the entire line. How to end the maintenance mode

It sounds like you are recommending something different. Should I put it back, but with the value set to 0? Will the deletion of that line cause problems for me in the future?

duncanc · June 27, 2019, 8:45pm

No, that is fine. phplist will handle either case.