database error

  • blizcreak

    (@blizcreak)


    12 years, 6 months ago

    I love this plugin!

    But I noticed today that I am getting these errors listed. Any suggestions on what is happening here? Needless to say the rest of my site is working fine, so the DB is accessible.

    Error number: 2
    Error type: Run-time warnings (non-fatal errors). Execution of the script is not halted.
    Error Msg: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user ‘tasty888’@’localhost’ (using password: NO)
    File name: /home/tasty888/public_html/blog/files/plugins/permalink-finder/includes/pf-404.php
    Line Number: 621
    ———————

    Also, I am a bit puzzled by some of the redirects. for example, I have a real page: /product/cinnamon-raisin-tastyvite-bars-box-of-10

    if I type in the following URL’s they all get directed, as one would expect, to the above page:

    /product/cinnamon-raisin
    /product/cinnamon

    But if I type in the following URL’s:
    /product/tastyvite-bars-box-of-10
    /product/raisin
    /product/raisin-tastyvite-bars-box-of-10

    I get directed to
    /simple_survey
    witch has the page title “how to win a free supply of tastyvite”

    but looking at the logs, it says the fixed link is
    /blog/product/raisin-tastyvite-bars-box-of-10/http://tastyvite.com/blog/simple-survey (sic – all in one line) which, when you click on it, sends one to the survey.

    so there is something fishy going on here. any suggestions?

    Noel

    http://ww.wp.xz.cn/plugins/permalink-finder/

Viewing 2 replies - 1 through 2 (of 2 total)
  • xotihcan

    (@xotihcan)

    12 years, 2 months ago

    I have the same problem!!

    PHP Warning: mysql_real_escape_string(): A link to the server could not be established in […]/wp-content/plugins/permalink-finder/includes/pf-404.php on line 760

    Line 760:
    $sql=$sql." if(INSTR(LCASE(post_name),'".mysql_real_escape_string($ss[$j])."'),1,0)+" ;

    You should change mysql_real_escape_string with other data validation funcion http://codex.ww.wp.xz.cn/Data_Validation

    Plugin Author Keith P. Graham

    (@kpgraham)

    12 years, 2 months ago

    I am pretty sure that I fixed this. I have not released a new version to the WordPress repository.

    Please check at http://www.blogseye.com and go to the beta page. I keep the current working versions there, even if I have not sent it off to WordPress. I will verify and if I have not fixed it, I will put the fix there some time tonight.

    I have not been releasing new versions of my plugins. I am getting out of the plugin game.

    Keith

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘database error’ is closed to new replies.