DB permissions issue

  • Hi.

    I am seeing several errors on my Apache logs coming from different plugins that I believe were due to incorrect (too restrict) DB user permissions (I had invasion problems in the past).

    My DB permissions were set to only I the DATA ones on MySQL for a while and all seemed good, but once I checked the Apache logs I saw two types of errors from different plugins:

    [Wed Nov 04 00:18:21 2015] [error] [client 207.46.13.66] Erro de banco de dados do WordPress Table ‘sunday_db.wp_ewwwio_images’ doesn’t exist para a consulta SELECT path,results FROM wp_ewwwio_images WHERE path = ‘/vol/html/sundaycooks.com/wp-content/uploads/2012/06/freeshop01-640×316.jpg’ AND image_size = ‘67583’ feita por require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/sundaycooks-2.0/tag.php’), include(‘/themes/sundaycooks-2.0/includes/post-list.php’), vt_resize, ewww_image_optimizer, ewww_image_optimizer_check_table

    [Wed Nov 04 00:16:20 2015] [error] [client 50.17.217.178] Erro de banco de dados do WordPress Duplicate entry ‘azul’ for key ‘slug’ para a consulta INSERT INTO wp_terms (name, slug, term_group) VALUES (‘Azul’, ‘azul’, 0) feita por do_action_ref_array, call_user_func_array, _wp_batch_split_terms, _split_shared_term

    The first one comes from the EWWW plugin and a similar one for the Yuzo one. As can be seen, they are trying to save something to their tables on the DB, however those tables do not exist.

    The second error I have absolutely no idea what is causing it, but it is the cause of another issue I have which does not allow me to enter new tags for a given post. I always enter the tag, but it does not save it. I can only reuse existing tags.

    All that seems to be due to my restrict/incorrect permissions while upgrading WordPress (maybe from 3 to 4, but I’m not sure).

    Deactivating/activating or deactivating/deleting/installing/activating the plugins do not help, nor re-installing wordpress from the admin menu ??

    The site is not down and seems to be working ok so far, but something is definitely not right.

    Could anyone shed some light on this poor soul?

    Thanks a lot in advance,
    Fred Marvila

  • The topic ‘DB permissions issue’ is closed to new replies.