Having Problem In My Website

[Lahori_Munda]

Hi,
Well i have very weried issue on my website and i didnt find the solution. It comes sometime on site. Let me share screenshots.



This is the source code screenshot.



I talk with my hosting company and they reply.

Hi,

There wasn't a virus/malware anywhere in the code. This is from /home/munda/public_html/error_log:

[01-Aug-2012 15:04:51 UTC] 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 '<strong>2</strong> AND file_permission != -2' at line 1 for query SELECT * FROM wp_downloads WHERE file_id = <strong>2</strong> AND file_permission != -2 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/LahoriMela/index.php'), include('/themes/LahoriMela/includes/defaultindex.php'), truncate_post, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, download_shortcode, download_embedded, W3_Db->query

So there was an issue with one of the WordPress tables that was causing random characters to be displayed. I ran a MySQL repair & optimization via:

[root@server ~]# mysqlcheck -Aor

This seems to have corrected the issue. You'll want to speak with your developer as it seems your theme isn't properly terminating SQL queries and could be corrupting your tables.

Thanks,

This is my website www.lahorimela.com
Please help with this. Thanks

[dmvictoria]

There may be a better answer to come along. But, from what I see it looks like some of your posts got corrupted upon insertion into the database, i.e. when you hit the publish button. You will probably have to delete those posts and make new ones.

You may be able to retrieve the content because of the way WP auto save (auto draft) works. Basically as you are creating your article the auto save saves it to the db just like the final published one, the only difference is the one that is flagged 'publish' is the one displayed. If you have access to your db, i.e. through phpMyAdmin, find the last auto saved version and just copy and paste it out and complete any minor finishing. The only condition where auto save wouldn't work is if you created the article in a different editor and just copied and pasted it into the WP editor and hit 'Publish' thus not giving the auto save enough time to do its job. If you do find that your auto saved article contains the same gibberish as well, this could be a clue to your issue.

As to what your issue is I don't know. But, like I said, there may be a better answer to come.

A few little things I can think of is:
- Make sure you are updating the the latest version of WP
- Maybe do some searches to see if anyone has had trouble with that theme
- Are you putting in strange characters in your post? (WP usually escapes such things on insertion, but you never know.)
- You could copy the data and structure to a new db, delete the old one and rename the new one to the old one's name. Might fix a bad db.

[Lahori_Munda]

Any other one who can help with that and thanks a lot dmvictoria for your kind reply.

[JohnnyS]

it shouldn't be just a database issue because Wordpress does not save all of it's content in the database. there are physical template files.

this could be a charset issue..

create a .htaccess file or if there's already one since your using Wordpress you can just update it and try the following suggestions from this page..

http://www.w3.org/International/ques...ess-charset.en

[Lahori_Munda]

HI,
well i try and i notice that i have this problem in all my sites, that mean i having issue in my server. Coz my other webiste got this error and site working for a single time. I remove the all files and database but having still issue. Should i have to change my server or anything els?

[dxter]

this seems to be a problem with Apache and memory. Are you using any opcode accelerators for example APC?

[Jorge Oliveira]

Hello,

This seems to be problem related with php output compression.

Please check if the following php settings are disabled: zlib.output_compression and output_handler

You could upload a phpinfo page and look for that.

If those settings are enabled, you should disable them in your php.ini, zlib.output_compression must be set to 0 and output_handler must be set to empty value.

Regards,
Jorge Oliveira.

[SteveFM]

Hi,

Also try to disable APC cache. This is not a problem of wordpress. OR the language inside your database is something 'weird' (say Chinese) and the charset of your page is set to a wrong charset thus not showing the characters correctly.