Lots of errors being recorded in error.log by this plugin

  • wpress2010

    (@wpress2010)


    10 years, 4 months ago

    This plugin seems to work, but it has dumped many identical entries into my site’s error log, such as:

    [19-Dec-2013 13:51:43] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘2),(,3),(,4),(,5),(,6),(,7),(,8),(,10),(,11),(,12),(,13),(,14),(,15),(,16),(,17)’ at line 1 for query INSERT INTO wp_avhec_category_groups (group_term_id, term_id) VALUES (,2),(,3),(,4),(,5),(,6),(,7),(,8),(,10),(,11),(,12),(,13),(,14),(,15),(,16),(,17),(,18),(,20),(,21),(,22),(,23),(,24),(,25),(,26),(,27),(,28),(,29),(,30),(,31),(,32),(,33),(,34),(,35),(,36),(,37),(,38),(,39),(,40),(,41),(,42),(,43),(,44),(,45),(,46),(,47),(,48),(,49),(,50),(,51),(,52),(,53),(,54),(,55),(,56),(,58),(,59),(,60),(,61),(,62),(,63),(,64),(,65),(,66),(,67),(,68),(,69),(,70),(,71),(,72),(,73),(,74),(,75),(,76),(,77),(,78),(,79),(,80),(,81),(,82),(,83),(,84),(,85),(,86),(,87),(,88),(,89),(,90),(,91),(,92),(,93),(,94) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, AVH_EC_Category_Group->doSetupOptions, AVH_EC_Category_Group->setCategoriesForGroup

    I need to fix this!

    TIA for your help.

    http://wordpress.org/plugins/extended-categories-widget/

Viewing 15 replies - 1 through 15 (of 17 total)
1 2
  • Plugin Author petervanderdoes

    (@petervanderdoes)

    10 years, 4 months ago

    Do you have a group with the slug “all”?

    Plugin Author petervanderdoes

    (@petervanderdoes)

    10 years, 4 months ago

    And do you also have a group with the slug “home”?

    Thread Starter wpress2010

    (@wpress2010)

    10 years, 4 months ago

    Yes to “all” – should I change the slug?

    No to “home”

    Plugin Author petervanderdoes

    (@petervanderdoes)

    10 years, 4 months ago

    yes there should be group with the slug home.
    I just did some code that would not make you need to have a group with home. If you can wait like 30 mins, a new version will be uploaded.

    Thread Starter wpress2010

    (@wpress2010)

    10 years, 4 months ago

    Where can I find Category Group names? I checked online, and there are references to editing Category Group Names from the Dashboard, but I do not see this control anywhere.

    Thanks.

    Thread Starter wpress2010

    (@wpress2010)

    10 years, 4 months ago

    Hmm. I just went to edit a Category, and it seems that ALL of the posts are in the Category Group “Home.” The only other two Category Groups I can choose in the dropdown on the Edit Category page are “All” and “None.”

    I have taken over maintenance of this site from someone else, so I do not know how it was set up initially.

    Also, the web host took a look at the error log and reports that they think it could be a question of the MySQL version. The host is running MySQL 5.5

    Plugin Author petervanderdoes

    (@petervanderdoes)

    10 years, 4 months ago

    It should be fixed in v3.9.1

    Thread Starter wpress2010

    (@wpress2010)

    10 years, 4 months ago

    Updated and now BIG problem when trying to view site:

    Fatal error: Cannot use object of type WP_Error as array in /home/whitmanf/public_html/wp-content/plugins/extended-categories-widget/3.6/class/avh-ec.category-group.php on line 123

    Thread Starter wpress2010

    (@wpress2010)

    10 years, 4 months ago

    More BIG problems: can’t get into Dashboard anymore, and site is completely broken! Need some help on this ASAP!

    Thread Starter wpress2010

    (@wpress2010)

    10 years, 4 months ago

    OK, deactivated all plugins, got back to Dashboard, deleted v3.9.1, reinstalled v3.9.0 from backup. Something apparently amiss in 3.9.1
    The error log, when I updated to v.3.9.1, shows entries like this:

    [20-Dec-2013 19:58:08] PHP Fatal error: Cannot use object of type WP_Error as array in /home/mysite/public_html/wp-content/plugins/extended-categories-widget/3.6/class/avh-ec.category-group.php on line 123

    Just to go back a bit, I DO have Category GROUPS named “Home” and “All”.

    I misread your initial post: I had a Category with the slug “All,” which I have since changed.

    The site’s error log is growing by about 4MB per day, just from this repeating MySQL syntax failure…

    Thread Starter wpress2010

    (@wpress2010)

    10 years, 4 months ago

    Is this issue being addressed? This one plug-in is generated hundreds of identical syntax error lines in the error log file every day. I would like to continue to use it, and recommend it to our team of developers, but cannot do so if it continues to add several MB to the WP error log file every day.

    Plugin Author petervanderdoes

    (@petervanderdoes)

    10 years, 3 months ago

    Well that just tells me not to do any bug fixes right before a vacation 🙂

    I just released 3.9.3. This version catches the WP_Error and if you turn on WP_DEBUG you can see what the error is.

    There is a problem in the setup you have, I just don’t know what as the WP_Error message was never displayed. This version should give some insight to the problem, if you turn on WP_DEBUG.

    Thread Starter wpress2010

    (@wpress2010)

    10 years, 3 months ago

    Hello again. Do you think the new version will stop the MySQL query syntax errors? I don’t think it is a question of PHP version, as noted previously.

    The problem is, the plug-in apparently is working fine, as far as the site’s functionality is concerned.

    If I Deactivate, Update and Activate, I don’t want to have to go in and deactivate all plugins just to regain access to the Dashboard, as this makes the site look and function very badly until I can fix it.

    Plugin Author petervanderdoes

    (@petervanderdoes)

    10 years, 3 months ago

    Probably not. Something is going wrong when trying to create the Group “All” in your setup, this is a default group that should always exists. In the program we fill this group with all categories. This is your MySQL error, as the group is not created.

    In your setup it can’t find the slug “all” for a category group and so it tries to create it. For some reason this creates a WP-Error in v3.9.1, and as we don’t display the WP-Error, we don’t know what it is.

    v3.9.3 Checks if there is a WP-Error and if there is, we skip the line what used to be 123 and we trigger a PHP error. This error won’t be displayed unless you turn on WP_DEBUG.

    What this means in the overall use of the plugin is hard to predict. The “all” slug is checked in other places. But unless we know what the WP_Error message is we can’t debug any further unfortunately.

    Thread Starter wpress2010

    (@wpress2010)

    10 years, 3 months ago

    Hmm. I just checked, and on the site where I have the errors, there are just 2 Category Groups shown in the plugin panel:

    Name: All Slug: all-2
    Name: HomeSlug: Home

    On a clone of the site I have on a different server, there are 18 Category Groups, one “Home” and 18 copies of All, with slugs such as “all-2,” “all-3,” “all-4,” etc. But this site throws no errors…

Viewing 15 replies - 1 through 15 (of 17 total)
1 2
  • The topic ‘Lots of errors being recorded in error.log by this plugin’ is closed to new replies.