Is this the only page that is giving you problems? When did the trouble start? Did you install any plugins recently? What php version are you using?
Thread Starter
hansbl
(@hansbl)
Thanks for your quick answer.
I am using PHP 7.0. Recently I have installed 2 plugins:
Insert PHP Code Snippet
and
Really Simple SSL
Deactivating both did not help.
Other than that I also moved the website to another ISP using “Duplicator-Wordpress Migration Plugin”. I think after this and installing “Really Simple SSL” the trouble began.
I have also deleted and installed again “Participants Database”, but that didn’t help either.
Regards,
Hans
Thread Starter
hansbl
(@hansbl)
Yes, this is the only page that is giving problems.
Regards,
Hans
OK, well,the best way to proceed here is to set up your php error log and see what comes up when you attempt to load that page.
Since it looks like a server issue, you may want to ask your web host if they see anything in the server logs that might help see what the issue is.
Thread Starter
hansbl
(@hansbl)
This is what’s report in the log:
[22-Mar-2018 08:57:16 Europe/Amsterdam] PDb_List_Admin::initialize list query= SELECT * FROM ldizl_participants_database p ORDER BY p.date_updated desc
[22-Mar-2018 08:57:23 Europe/Amsterdam] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1065105008 bytes) in /home/blaaugh278/domains/loozermarsnoord.nl/public_html/wp-includes/wp-db.php on line 3184
Increasing the php-memory-limit didn’t help.
Maybe there is something wrong in my database?
The memory error is certainly the problem, but it’s not clear what’s happening. Have you tried contacting your web host about this?
Thread Starter
hansbl
(@hansbl)
No, not yet. I will and I will keep you informed.
Thread Starter
hansbl
(@hansbl)
Degrading to PHP 5.6 solved the problem.
But I really don’t knoe if this is the right solution.
Thanks for your reaction.
Regards,
Hans
Thanks, but that is kindof bad news for me as I don’t know why. The plugin should be compatible with any php version greater than 5.3, so I want to make sure this won’t happen for other users. What php version were you running before?
@hansb
1. How many rows in the ldizl_participants_database table?
2. What does PHPADMIN SQL Query return for the query: DESCRIBE ldizl_participants_database?
Thread Starter
hansbl
(@hansbl)
@xnau webdesign
I was running PHP 7
@mikemeinz
1 46 rows
2
localhost/blaaugh278_lono/ldizl_participants_database/ http://vserver278.axc.nl/phpmyadmin/tbl_sql.php?db=blaaugh278_lono&table=ldizl_participants_database&token=*********************
De huidige selectie bevat geen unieke kolom. Functies zoals rasterbewerkingen, checkboxen, Bewerken, Kopiëren en Verwijderen, zijn niet beschikbaar.
Uw SQL-query is succesvol uitgevoerd.
DESCRIBE ldizl_participants_database
id int(6) NO PRI NULL auto_increment
private_id varchar(6) YES NULL
last_name tinytext YES NULL
address bigint(20) YES NULL
date_recorded timestamp NO current_timestamp()
date_updated timestamp YES NULL
last_accessed timestamp YES NULL
voornaam_partner tinytext YES NULL
geboortedatum bigint(20) YES NULL
geboortedatum_partner bigint(20) YES NULL
emailadres tinytext YES NULL
voornaam tinytext YES NULL
wijzig tinytext YES NULL
link text YES NULL
naam_kind_1 tinytext YES NULL
geb_datum_kind_1 bigint(20) YES NULL
naam_kind_2 tinytext YES NULL
geb_datum_kind_2 bigint(20) YES NULL
naam_kind_3 tinytext YES NULL
geb_datum_kind_3 bigint(20) YES NULL
naam_kind_4 tinytext YES NULL
geb_datum_kind_4 bigint(20) YES NULL
mobielnummer tinytext YES NULL
edit_link text YES NULL
verwijder text YES NULL
delete_record text YES NULL
vrvgsl tinytext YES NULL
I can confirm I have had this same issue on PHP 7.0 switching to 7.1 and 7.2 doesn’t fix it and going back to 5.6 does straight away.
I confirmed mbstring was running before and after as well as I had seen a similar support ticket with a similar issue.
It’s not simply a php 7 issue, I’ve been running and testing the plugin on php 7 for over a year now. I’m still trying to duplicate the issue on my system so I can understand what the exact problem is.
Thread Starter
hansbl
(@hansbl)
Is it of any help to use my participants database and options table?
Maybe you can reproduce the issue.