caylean

Would something like this “WP Database Optimizer” also does the Job?

I just was in the PHPMyAdmin and searched around and i could only find something to optimize when i selected a specific Table/Subtable or how it should be called, going to “Operation” and then at “Table maintenance” was the button “Optimize table” That was So damn fast done, that i had the feeling that nothing was done at all, but i did got the message “Your SQL query has been executed successfully”
Is it meant to be like that?

Uhm, i just have checked the Website with https://validator.w3.org/ and it said that i have exactly 1 Error:
<li><g:plusone></g:plusone></li>
And before i made the test i was 100% sure that the tool would say that there are TONS of problems -.-
I should check also other validators. Doctype: XHTML 1.0 Transitional — There should definately more than one error o.O.. Whatever I add manually to the code is PLAIN html like <center></center> <font color="#fff"></font> and other stuff like that.

So it is an just automatic process, okay.
I was just scared to do any kind of manual work in the DB.
DB Backups are done automatically every 15 Days with MySQLDumper.

And i do nearly nothing without a live backup and additional the second last backup, just in case ?? .. Kind of too much in stake to mess with things what are very hard to get them back to work again when something IS damaged.

Thank you and so i’ll do as said.

Out of curiosity. How SQL Error happen? I did never touch SQL DB’s besides of doing backups.

Core files were nearly never touched. Once i did modify the wp-includes/post.php to get the scheduled postings back to work.
I did modify the template, but mainly just simple translations.
I will check that again, maybe i find somethings to do better, especially validating, i belive my site is everything, but not calid ^-^
But the biggest question and a thing what i totally don’t know….
How to optimize a Database?

From the Moment i made the last posting till now the debug.log got its size increased to 128.848.545 Bytes around 122MB thats … wow. Really nobody has any idea how to get some of the messages gone?

But it SEEMS that this is just the debug.log what writes here everything down. There is no error_log to find anymore. Would that mean that it is just the debugging of WordPress that is that sensitive?

Greetings

So, I transfered the Domain to an other Server and the Domain is running totally fine! (By the way. Both Servers are running now fine o.O

But yes, the Domain spams really much error Messages after i had activated the debug in the wp-config.php

Just in less than One SECOND there were 52 Messages and 25 Seconds later came the next bunch of 30 Messages. So the debug_log.txt gets filled like hell. But mostly with messages i don’t even get what he wants from me. I checked the Template, there is none of the functions to found:

[28-Jan-2013 01:54:27] PHP Notice:  register_sidebar_widget ist seit Version 2.8 <strong>veraltet</strong>! Benutze stattdessen wp_register_sidebar_widget(). in /home/USERNAME/public_html/DOMAIN.COM/wp-includes/functions.php on line 2824
[28-Jan-2013 01:54:27] PHP Notice:  js_escape ist seit Version 2.8 <strong>veraltet</strong>! Benutze stattdessen esc_js(). in /home/USERNAME/public_html/DOMAIN.COM/wp-includes/functions.php on line 2824
[28-Jan-2013 01:54:27] PHP Notice:  __ngettext ist seit Version 2.8 <strong>veraltet</strong>! Benutze stattdessen _n(). in /home/USERNAME/public_html/DOMAIN.COM/wp-includes/functions.php on line 2824
[28-Jan-2013 01:54:27] PHP Notice:  clean_url ist seit Version 3.0 <strong>veraltet</strong>! Benutze stattdessen esc_url(). in /home/USERNAME/public_html/DOMAIN.COM/wp-includes/functions.php on line 2824

Example the Sidebar Widget, it is called with:
<div id="rightnav"><?php include (TEMPLATEPATH . '/sidebar2.php'); ?></div>
Sorry for having the Error messages in German, but the whole Blog is German and so also the WP on it.

But i also get a strange message that my SQL has errors
[28-Jan-2013 01:54:27] WordPress-Datenbank-Fehler 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 '' at line 1 für Abfrage SELECT rating_username, rating_rating, rating_ip FROM wp_ratings WHERE rating_postid = von require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/TEMPLATENAME/index.php'), the_post, WP_Query->the_post, do_action_ref_array, call_user_func_array, get_comment_authors_ratings

And last but not least also two plugins are spamming:

[28-Jan-2013 01:54:27] PHP Notice:  Undefined index:  rate in /home/USERNAME/public_html/DOMAIN.COM/wp-content/plugins/postratings-custom/postratings-custom.php on line 559
[28-Jan-2013 01:54:27] PHP Notice:  Undefined index:  pid in /home/USERNAME/public_html/DOMAIN.COM/wp-content/plugins/postratings-custom/postratings-custom.php on line 560
[28-Jan-2013 01:54:27] PHP Notice:  Undefined index:  ws_plugin__qcache_menu_pages_css in /home/USERNAME/public_html/DOMAIN.COM/wp-content/plugins/quick-cache/includes/classes/admin-css-js.inc.php on line 20
[28-Jan-2013 01:54:27] PHP Notice:  Undefined index:  ws_plugin__qcache_menu_pages_js in /home/USERNAME/public_html/DOMAIN.COM/wp-content/plugins/quick-cache/includes/classes/admin-css-js.inc.php on line 28

The rest is just double, tripple and unlimited more of the same Text over and over.
The error_log doesn’t look that much different.
Could someone explain me some of that strange language ?? .. i have tried to understand the most of it, mut thats a part.. especially the sql part what i totally do not understand.

Kind Regards

Okay, there seems to be more with it than i tought. The Serverload is back up on very high and i am back at the Support Chat of Hostgator. *sigh*

Timeline without Timestamps ??
1. WP Update from 3.5 to 3.5.1
2. Serverload gets gigantic!
3. Deactivated ALL Plugins
4. Went to hostgator, tried to kill processes, just popped up again. Did two Forceful Restarts. Nothing Changed. Still gigantic Serverload.
5. Hostgator checked the Server, everything seemed to be fine, sugestion to get an Cache Plugin.
6. Cache Plugin uploaded. Nothing changed. Forceful reset after an hour. Still gigantiv load.
7. WP Downgrade from 3.5.1 to 3.5 by just uploading the original install Data from the old WP 3.5 with a modified post.php (to get Scheduled Postings back to work)
8. Forceful Serverreset.
9. Till now, Serverload back to normal!

Uhm, i didn’t had a Caching Plugin before at all!

I only installed it AFTER Hostgatr told me that this could help to get the Serverload again back to normal.

And i did deactivate ALL Plugins in ALL WordPress Installs after i made a hard reset of the server. And i did a second hard reset afterwards.
The server load climbed in minutes back to max with dozens of [php] <defunct> processes and two to three other really huge ones.

I activated ALL Plugins + the new Baching Plugin, took my old 3.5 WP, renamed the wp-config.php to _wp-config.php and uploaded the whole plain WP over the old one (3.5 OVER 3.5.1) – I made a new Hardreset and till now the server is completely fine.

So you really want to say it has nothing to do with 3.5.1?
Sorry, but i mist disagree.

1st Step: I tried to use W3 Total Cache, this one just spammed me Red Header messages that a lot of things wouldn’t be function. Kicked it and swiched to “Quick Cache” Server Load was slightly lowered. Load Averages around: 12.28 25.18 25.12 — Still much too high. Sites could be opened already, but with long load times.

2nd Step: I have made an Downgrade to an modified 3.5 (had the post.php changed that the scheduled postings are running normally) + Quick Cache still running: Load Averages down to: 0.07 0.15 0.88

Sites are again running really smooth as they did before.

I had already a lot (10-12 Plugins running) and i checked only if there were a change in the Load averages yesterday by turning everything off. but that didn’t help.

And now after the downgrade back to 3.5 and it is running seems to me as a sign that the 3.5.1 HAS a problem somehow. Where, i can’t tell.

Is there a solution we can use as long there is no update?

I just tried it with 22944.3.patch
Copy the table content into Notepad++ -> Copy the Notepad++ Content to Excel -> Copy Line C to Notepad++ -> Delete Line 25 and 4 -> Replace Line 3010 to 3027 with the Code

Hopefully it works, because whats right now just su…. doesn’t do it ??

LAST EDIT AND RESULT
The way i just did it was successful on my testblog. Scheduled Postings are again with the code as intended.

Nobody any idea? It kind of really messes everything up right now on my site. Whatever i plan to post at a special time/day, the embedded Video is Gone ??

As far as i understood it was a feature that most user didn’t used anymore. I believe most ppl didn’t knew about it only.

The good thing is, you don’t need it anymore. Open your “Create a Post” or Article or however it was called in English to write and there you find in the bottom right side of the Textwindow a small triangle, this you can pull down. You don’t have to do that every time again, because it is saved in your Browser Cookies and whenever you write again, it will be automatically again the size you had chosen before.

So all in all no big loss, just irritating in the first place.

It was 100% a core ability from WordPress pre 3.5! I found already several Blogs where they wrote about that and why i said that i found a solution for it. Before you could already pull the Article screen down to have a bigger window, but to Fix it to a specific value you had to do that in the Option Writings in Settings. Not it is managed by cookie, one time you pull the edit screen to the desired size and it will be there as long no cookies deleted

Okay, found a solution, maybe it would be nice to have an information about that in the settings -.-

Hehe, thats indeed very easy, if you know that there yould be .’ before and a ‘ behind it *g*
Without it, you generate again just crap ??

Thanks s_ha_dum for your kindness and fast help!