Bug? Unable to Edit a Specific Product

  • Resolved steve49589

    (@steve49589)


    5 years, 11 months ago

    So today I ran into an issue where I could not open up a specific product. Was getting an Error 500 when trying to get to the Edit page. All other products – no problem.

    Checked the error logs and found nothing related, so I created a development environment and started turning off plugins. By deactivating Product Customer List for WooCommerce, the problem went away.

    Note that I was able to duplicate the product and had no issues opening/editing the product.

    There was no issues seen on the front end of the site.

    Any suggestions?

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Kokomo

    (@kokomoweb)

    5 years, 11 months ago

    HI @steve49589,

    that’s a weird one! Is there anything you notice that is different in that product? Is it a variable product and others a simple products? Can you please try to list the differences in this product vs. the other ones so I can look into it?

    Also, can you activate debug on your website and reactivate the plugin and let me know if there’s a particular error that shows?

    https://codex.wordpress.org/Debugging_in_WordPress

    Thanks for your help

    Thread Starter steve49589

    (@steve49589)

    5 years, 11 months ago

    Nothing really special about the product. It’s a variable product with six variations.

    Tried turning on debugging. Instead of showing …

    This page isn’t working
[website] is currently unable to handle this request.
HTTP ERROR 500

    All we get is a white, blank page when we try to open the product. No error message.

    Note that I created a development environment with an exact copy of the site, and got the same issue with that specific product.

    • This reply was modified 5 years, 11 months ago by steve49589.
    Plugin Author Kokomo

    (@kokomoweb)

    5 years, 11 months ago

    Do you happen to have the error logs of your hosting by any chance?

    Thread Starter steve49589

    (@steve49589)

    5 years, 11 months ago

    https://spidercreations.net/log-20180511.txt

    Just provided today’s entries.

    Plugin Author Kokomo

    (@kokomoweb)

    5 years, 11 months ago

    Hi Steve,

    I’m assuming this is the part when your website crashed? Can you confirm the time?

    [11-May-2018 13:55:41 UTC] PHP Warning:  Error while sending QUERY packet. PID=19975 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 14:54:54 UTC] PHP Warning:  Error while sending QUERY packet. PID=36697 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 14:59:48 UTC] PHP Warning:  Error while sending QUERY packet. PID=38159 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:01:14 UTC] PHP Warning:  Error while sending QUERY packet. PID=38559 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:02:49 UTC] PHP Warning:  Error while sending QUERY packet. PID=39175 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:04:23 UTC] PHP Warning:  Error while sending QUERY packet. PID=39665 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:05:49 UTC] PHP Warning:  Error while sending QUERY packet. PID=40034 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:07:26 UTC] PHP Warning:  Error while sending QUERY packet. PID=40441 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:08:51 UTC] PHP Warning:  Error while sending QUERY packet. PID=40978 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:10:23 UTC] PHP Warning:  Error while sending QUERY packet. PID=41398 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:11:58 UTC] PHP Warning:  Error while sending QUERY packet. PID=41794 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:13:43 UTC] PHP Warning:  Error while sending QUERY packet. PID=42348 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:15:08 UTC] PHP Warning:  Error while sending QUERY packet. PID=42785 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:16:46 UTC] PHP Warning:  Error while sending QUERY packet. PID=43206 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:18:29 UTC] PHP Warning:  Error while sending QUERY packet. PID=43641 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:19:55 UTC] PHP Warning:  Error while sending QUERY packet. PID=44098 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:21:30 UTC] PHP Warning:  Error while sending QUERY packet. PID=44516 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:23:06 UTC] PHP Warning:  Error while sending QUERY packet. PID=44813 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:24:39 UTC] PHP Warning:  Error while sending QUERY packet. PID=45342 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:26:13 UTC] PHP Warning:  Error while sending QUERY packet. PID=45683 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
[11-May-2018 15:27:01 UTC] PHP Warning:  Error while sending QUERY packet. PID=46120 in /home/grayguns/public_html/wp-includes/wp-db.php on line 1924\
    Plugin Author Kokomo

    (@kokomoweb)

    5 years, 11 months ago

    Also, can you confirm the issue is still there if you only activate my plugin and woocommerce?

    Thread Starter steve49589

    (@steve49589)

    5 years, 11 months ago

    I’ve been diving into this turning stuff on and off. Sure enough, with Product Customer List for WooCommerce the ONLY plugin running with WooCommerce, there is no problem.

    So I started turning on other plugins one at a time. It’s very hard to understand, but the issue seems to be a conflict with BackupBuddy. When all of my needed plugins are active – including Product Customer List for WooCommerce – and I deactivate BackupBuddy, the problem goes away. Activate BackupBuddy and the problem – again, ONLY with this specific product – happens again. I just can not open it to edit.

    Then I went to the next step. Deactivated everything but WooCommerce, Product Customer List for WooCommerce, and BackupBuddy. There was NO PROBLEM opening the product.

    I appreciate your help today, and I’m going to have to revisit this at another time. Spent a good portion of the day on this and I’ve got some other pressing issues.

    There seems to be a conflict somewhere, but for it to be localized to one product is super strange.

    Plugin Author Kokomo

    (@kokomoweb)

    5 years, 11 months ago

    Wow!

    Yeah that is mind boggling, hope you figure it out, i’m here if you need anything. If the product is not too complex I’d try re-building it from scratch.

    Plugin Author Kokomo

    (@kokomoweb)

    5 years, 11 months ago

    Hi @steve49589,

    I think I might have figured out what was causing the issue. Please update to the latest version, it should fix it.

    Thread Starter steve49589

    (@steve49589)

    5 years, 10 months ago

    Updated, but unfortunately the same problem still exists.

    As hinted to earlier, I’m totally swamped with work right now and since this is not a critical thing, I have to put off troubleshooting.

    I updated your plugin, optimized the database, and the issue still exists. I deactivate your plugin and the problem – again, with that one product – goes away.

    For other readers … note that it is not clear this plugin is the issue. Lots going on.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Bug? Unable to Edit a Specific Product’ is closed to new replies.