WordPress.org

Ready to get started?Download WordPress

Forums

amr users
[resolved] Errors on rebuilt (4 posts)

  1. martine_m
    Member
    Posted 1 year ago #

    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;\">

  2. Excluding where: ID=1,
  3. <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;\">

  4. Excluding where: ID=1,
  5. <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;\">

  6. Excluding where: ID=1,
  7. <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/

  • martine_m
    Member
    Posted 1 year ago #

    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...]

  • anmari
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Martine,

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

    It sounds like you are having data base problems.

  • martine_m
    Member
    Posted 1 year ago #

    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.

  • Topic Closed

    This topic has been closed to new replies.

    About this Plugin

    About this Topic

    Tags

    No tags yet.