Database field configuration

  • hansbl

    (@hansbl)


    8 years, 2 months ago

    Hello,

    I am having the following issue:

    In the admin dashboard I have no Database field configuration window anymore.
    If I open the link in a new window I get the message:

    Service Unavailable
    The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

    I have already deleted the plugin and installed it again, but no result.

    Do you have a solution?

    Thanks in advance for your help.

    Regards,
    Hans

Viewing 15 replies - 1 through 15 (of 16 total)
1 2
  • Plugin Author Roland Barker

    (@xnau)

    8 years, 2 months ago

    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)

    8 years, 2 months ago

    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)

    8 years, 2 months ago

    Yes, this is the only page that is giving problems.

    Regards,
    Hans

    Plugin Author Roland Barker

    (@xnau)

    8 years, 2 months ago

    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)

    8 years, 2 months ago

    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?

    Plugin Author Roland Barker

    (@xnau)

    8 years, 2 months ago

    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)

    8 years, 2 months ago

    No, not yet. I will and I will keep you informed.

    Thread Starter hansbl

    (@hansbl)

    8 years, 2 months ago

    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

    Plugin Author Roland Barker

    (@xnau)

    8 years, 2 months ago

    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?

    Mike Meinz

    (@mikemeinz)

    8 years, 2 months ago

    @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)

    8 years, 2 months ago

    @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

    Plugin Author Roland Barker

    (@xnau)

    8 years, 2 months ago

    thank you, I thought so.

    bazza_87

    (@bazza_87)

    8 years, 2 months ago

    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.

    Plugin Author Roland Barker

    (@xnau)

    8 years, 2 months ago

    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)

    8 years, 2 months ago

    Is it of any help to use my participants database and options table?
    Maybe you can reproduce the issue.

Viewing 15 replies - 1 through 15 (of 16 total)
1 2

The topic ‘Database field configuration’ is closed to new replies.