Support » Plugin: amr users » Errors on rebuilt

  • Resolved martine_m

    (@martine_m)


    Hello,

    I’m a very new WP user, and not so experimented in programming I hope you will forgive any stupid question….

    Since I installed the AMR USERS plugin, I encounter database errors.
    I upgraded my WP version to 3.5 but it remains the same.

    I put an example of errors when I try to rebuilt a list, have you any suggestion for me ?

    Thank
    MM.

    WordPress database error: [Query execution was interrupted]
    SELECT DISTINCT(COLUMN_NAME) FROM information_schema.COLUMNS WHERE TABLE_NAME = “wp_users”

    Warning: Invalid argument supplied for foreach() in /homez.359/icomej/www/wp-content/plugins/amr-users/includes/ameta-includes.php on line 222

    WordPress database error: [Lost connection to MySQL server during query]
    SELECT * FROM wp_usermeta

    WordPress database error: [MySQL server has gone away]
    SELECT ID, user_login, user_nicename, user_email, user_url, user_registered, display_name FROM wp_users

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = ‘a:3:{s:7:\”user-02\”;a:6:{s:5:\”start\”;i:1356286962;s:4:\”name\”;s:16:\”Users: Directory\”;s:3:\”end\”;i:1356286965;s:5:\”lines\”;i:4;s:7:\”peakmem\”;s:8:\”19.25 MB\”;s:8:\”headings\”;s:396:\”\n<div class=\”wrap\” style =\”clear: both; text-align: center; font-size:largest;\”><!– heading wrap –>\nUsers: Directory<ul class=\”report_explanation\” style=\”list-style-type:none;\”>

  • Excluding where: ID=1,
  • <li class=\”sort\”> Cache sorted by: User Registered<li class=\”selected\”>4 Users processed from total of 5\n</div><!– heading wrap –>\n\”;}s:7:\”user-01\”;a:2:{s:5:\”start\”;i:1356286965;s:4:\”name\”;s:14:\”Users: Details\”;}s:7:\”user-03\”;a:4:{s:5:\”start\”;i:1356287131;s:4:\”name\”;s:34:\”New list copy of Users: Details #3\”;s:3:\”end\”;i:1356287134;s:5:\”lines\”;i:-1;}}’ WHERE option_name = ‘amr-users-cache-status’

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = ‘a:3:{s:7:\”user-02\”;a:6:{s:5:\”start\”;i:1356286962;s:4:\”name\”;s:16:\”Users: Directory\”;s:3:\”end\”;i:1356286965;s:5:\”lines\”;i:4;s:7:\”peakmem\”;s:8:\”19.25 MB\”;s:8:\”headings\”;s:396:\”\n<div class=\”wrap\” style =\”clear: both; text-align: center; font-size:largest;\”><!– heading wrap –>\nUsers: Directory<ul class=\”report_explanation\” style=\”list-style-type:none;\”>

  • Excluding where: ID=1,
  • <li class=\”sort\”> Cache sorted by: User Registered<li class=\”selected\”>4 Users processed from total of 5\n</div><!– heading wrap –>\n\”;}s:7:\”user-01\”;a:2:{s:5:\”start\”;i:1356286965;s:4:\”name\”;s:14:\”Users: Details\”;}s:7:\”user-03\”;a:5:{s:5:\”start\”;i:1356287131;s:4:\”name\”;s:34:\”New list copy of Users: Details #3\”;s:3:\”end\”;i:1356287134;s:5:\”lines\”;i:-1;s:7:\”peakmem\”;s:7:\”25.5 MB\”;}}’ WHERE option_name = ‘amr-users-cache-status’

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = ‘a:3:{s:7:\”user-02\”;a:6:{s:5:\”start\”;i:1356286962;s:4:\”name\”;s:16:\”Users: Directory\”;s:3:\”end\”;i:1356286965;s:5:\”lines\”;i:4;s:7:\”peakmem\”;s:8:\”19.25 MB\”;s:8:\”headings\”;s:396:\”\n<div class=\”wrap\” style =\”clear: both; text-align: center; font-size:largest;\”><!– heading wrap –>\nUsers: Directory<ul class=\”report_explanation\” style=\”list-style-type:none;\”>

  • Excluding where: ID=1,
  • <li class=\”sort\”> Cache sorted by: User Registered<li class=\”selected\”>4 Users processed from total of 5\n</div><!– heading wrap –>\n\”;}s:7:\”user-01\”;a:2:{s:5:\”start\”;i:1356286965;s:4:\”name\”;s:14:\”Users: Details\”;}s:7:\”user-03\”;a:6:{s:5:\”start\”;i:1356287131;s:4:\”name\”;s:34:\”New list copy of Users: Details #3\”;s:3:\”end\”;i:1356287134;s:5:\”lines\”;i:-1;s:7:\”peakmem\”;s:7:\”25.5 MB\”;s:8:\”headings\”;s:333:\”\n<div class=\”wrap\” style =\”clear: both; text-align: center; font-size:largest;\”><!– heading wrap –>\nNew list copy of Users: Details #3<ul class=\”report_explanation\” style=\”list-style-type:none;\”><li class=\”selected\”>0 Users processed from total of 1\n</div><!– heading wrap –>\nNo users found for list 3\”;}}’ WHERE option_name = ‘amr-users-cache-status’

    WordPress database error: [MySQL server has gone away]
    DELETE FROM wp_amr_reportcachelogging WHERE eventtime <= ‘2012-12-22 18:25:34’

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_amr_reportcachelogging ( eventtime, eventdescription ) VALUES (‘2012-12-23 18:25:34′,’Completed user-03 in 2.64 microseconds‘)

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = ‘_transient_amr_users_cache_3’

    At 2.637 seconds, peak mem= 25.5 mb real_mem=25.5 mb – Release in progress flag for 3

    WordPress database error: [MySQL server has gone away]
    DELETE FROM wp_amr_reportcachelogging WHERE eventtime <= ‘2012-12-22 18:25:34’

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_amr_reportcachelogging ( eventtime, eventdescription ) VALUES (‘2012-12-23 18:25:34′,’At 2.637 seconds, peak mem= 25.5 mb real_mem=25.5 mb – Release in progress flag for 3’)

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = ‘_transient_amr-users-html-for-list-3’
    No lines found.

    http://wordpress.org/extend/plugins/amr-users/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hello again,

    I have the same errors when I display the page containing the list.
    But those errors are sporadics. If I try several times, it works after a while.
    Can you help me ?

    Error when displaying the list :

    WordPress database error: [Query execution was interrupted]
    SELECT DISTINCT(COLUMN_NAME) FROM information_schema.COLUMNS WHERE TABLE_NAME = “wp_users”

    Warning: Invalid argument supplied for foreach() in /homez.359/icomej/www/wp-content/plugins/amr-users/includes/ameta-includes.php on line 222

    WordPress database error: [MySQL server has gone away]
    SELECT wp_users.* FROM wp_users WHERE 1=1 ORDER BY user_login ASC

    Warning: Invalid argument supplied for foreach() in /homez.359/icomej/www/wp-content/plugins/amr-users/includes/ameta-building.php on line 460

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = ‘a:4:{s:7:\”user-01\”;a:6:
    [To be continued…]

    Plugin Author anmari

    (@anmari)

    Hi Martine,

    please google https://www.google.com/search?q=mysql+server+has+gone+away

    It sounds like you are having data base problems.

    Hello Anmari,
    Thank you for your response.
    I thought it could be a problem with the plug-in “amr users” since the error mentioned ameta-includes.php routine.
    I read on Google that it could be a problem with a timeout or something like that…
    The problem is not occurring today, I think I’m going to have a long time searching!
    Thanks!
    Martine.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Errors on rebuilt’ is closed to new replies.