WordPress.org

Ready to get started?Download WordPress

Forums

AVH Extended Categories Widgets
Lots of errors being recorded in error.log by this plugin (18 posts)

  1. wpress2010
    Member
    Posted 7 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/

  2. petervanderdoes
    Member
    Plugin Author

    Posted 7 months ago #

    Do you have a group with the slug "all"?

  3. petervanderdoes
    Member
    Plugin Author

    Posted 7 months ago #

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

  4. wpress2010
    Member
    Posted 7 months ago #

    Yes to "all" - should I change the slug?

    No to "home"

  5. petervanderdoes
    Member
    Plugin Author

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

  6. wpress2010
    Member
    Posted 7 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.

  7. wpress2010
    Member
    Posted 7 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

  8. petervanderdoes
    Member
    Plugin Author

    Posted 7 months ago #

    It should be fixed in v3.9.1

  9. wpress2010
    Member
    Posted 7 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

  10. wpress2010
    Member
    Posted 7 months ago #

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

  11. wpress2010
    Member
    Posted 7 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...

  12. wpress2010
    Member
    Posted 7 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.

  13. petervanderdoes
    Member
    Plugin Author

    Posted 6 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.

  14. wpress2010
    Member
    Posted 6 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.

  15. petervanderdoes
    Member
    Plugin Author

    Posted 6 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.

  16. wpress2010
    Member
    Posted 6 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...

  17. wpress2010
    Member
    Posted 6 months ago #

    Hmmm. On the site that throws errors, the AVI Extended plugin, under Category Groups, shows only 2:

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

    On a clone of the site running on a different server, (which does not throw any errors) there are these Category Groups:

    Name: All Slug: all-2
    Name: All Slug: all-3
    Name: All Slug: all-4

    ...and so on through all-18!!

    Name: Home Slug: home

    What about totally removing the plugin from the problematic site, removing the entire folder, and then reinstalling?

    Thanks again for your help.

  18. zignjny
    Member
    Posted 3 months ago #

    New install today of 3.9.3 into 3.8.1 WP. The plugin is working but error log looks awefully similar to this thread.

    [Thu Apr 10 01:19:24 2014] [error] [client 67.87.104.134] 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 '7),(,9),(,23),(,35),(,42),(,53),(,69),(,70),(,80),(,81),(,126),(,147),(,149),(,1' at line 1 for query INSERT INTO wp_nfpp3acw1f_avhec_category_groups (group_term_id, term_id) VALUES (,7),(,9),(,23),(,35),(,42),(,53),(,69),(,70),(,80),(,81),(,126),(,147),(,149),(,153),(,159),(,160),(,183),(,184),(,188),(,194),(,220),(,225),(,226),(,227),(,230),(,231),(,288),(,291),(,301),(,314),(,337),(,339),(,341),(,349),(,361),(,363),(,375),(,376),(,432),(,433),(,460),(,466),(,500),(,501),(,504),(,507),(,510),(,526),(,527),(,528),(,529),(,541),(,565),(,566),(,581),(,594),(,605),(,624),(,625),(,658),(,686),(,688),(,711),(,712),(,722),(,727),(,730),(,731),(,732),(,733),(,736),(,737),(,738),(,763),(,766),(,775),(,776),(,792),(,2213) /* From [klc.wpengine.com/wp-admin/admin.php?page=wpe-user-portal] in [/nas/wp/www/cluster-2709/klc/wp-content/plugins/extended-categories-widget/3.6/class/avh-ec.category-group.php:238] */ made by 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, referer: http://klc.wpengine.com/wp-admin/

Reply

You must log in to post.

About this Plugin

About this Topic