nicknormal

This too changed on me 2 days ago. Everything for 3+ years working fine, no system updates or plugin changes on my end, and now nothing will Schedule-and-post properly. Would appreciate any advice.

Thank you for all your help keesiemeijer.

After some back and forth with the host, I had to resolve the issue myself. Luckily it wasn’t anything too drastic.

The MySQL database user’s privileges had become corrupt. I had to remove that user, add a new user, attach the new user to the database and then simply update my wp-config.php file with the new details.

I don’t know how the user’s privileges became corrupt, but I’m glad I didn’t have to edit any tables or start messing with .htaccess etc. Sometimes the Internet is an absolute mystery! Case closed.

Cheers!

It is a single site; and I set phpMyAdmin to show all rows (598 total), so they’re all visible on one screen, and I organized numerically by option_id by clicking that column (which is how I found ‘home’ at #39).

I will edit and report back.

Thank you for your advice keesiemeijer – I want a Thanksgiving without any server errors!!

okay I found option_name=home and it was #39; but I do not see option_name=siteurl which I see according to the Changing the Site URL codex should be in the database. Do you recommend inserting this option_name and option_value and if so, do you recommend a process to do this correctly?

THank you.

The file is uncompressed.

Thanks for the other topic’s tip; I noticed sidarcy recommends the following:

UPDATE YOUR DATABASE NAME.wp_options SET option_value = ‘https://YOURURL’ WHERE wp_options.option_id =2 LIMIT 1 ;

I know what he is referring to, and I actually DO NOT have a site URL option_value in my wp_options table!! Could this somehow be the problem? In fact, I don’t have anything with option_id=2 – it’s unclear to me if I make a new option table if it MUST be id=2 or if any id number is okay, and the option_value is more important?

I will avoid modifying the database until I hear back from the host, but it is good to know this might be something to troubleshoot.

Thanks.

hi keesiemeijer,

I have made a backup of my database – in cPanel’s MySQLDatabases tab it says my database is 506.64MB; when I export the database via phpMyAdmin the file is only 67.7MB – does this sound faulty or correct?

I have tried ‘checks’ and ‘repairs’ of the database via phpMyAdmin and everything returns OK.

I currently have a support ticket with my host; this was on a managed dedicated server, not shared, so I’m not sure where the corruption took place. Everything was fine last night. Any other ideas on where I might look?

Thank you.

thank you alchymyth! brilliant bit of code that!

that is particularly annoying. I’ve seen other places handle the layouts with CSS, but I don’t have a solution myself, sorry.

gotcha!

the post has to be duplicated in the_excerpt()’s box in the respective post, else it automatically cuts off at 55 words.

that’s the definition I was looking for! I get it now.

thanks samboll

okay, that’s sort of what I thought should happen, but on my end the more tag is cutting off the post prematurely.

It’s inserting “[…]” in RSS, in one instance at the 55 word/344 character mark; 52 words or 276 characters before my inserted <!–more–> tag.

When I set admin->settings->reading to “full” the entire post shows up in RSS, including what is after <!–more–> which sometimes contains elements that do not work in RSS (javascript, iframe, etc.) and I want to use <!–more–> to direct people to the original post.

Does that clarify the specific problem I’m having? Thanks for any advice!

bu bu bump

I too would like this resolved. The error only occurs when Ad Order is set to Random in the plugin’s settings.

I want to put 5 ads in each slot; and have 2 slots. I don’t want to ‘default’ to appear at all. I have everything set accordingly but quite often the default image appears.

please fix!

Nevermind, clearly the problem was my webhost.

I just got some ‘database connection error’ then waited, refreshed and went back to doing blog maintenance. A few other hiccups clearly on the server end happened and now the un-ticking issue has completely disappeared.

I didn’t suspect my webhost because they’re generally well-revered and didn’t send any email informing me of maintenance today. However I might have to consider moving because I’ve had a few too many of these hiccups lately. So, if you’re listening, MediaTemple, quit it!

PS I followed all the suggested hints at this thread:
https://www.ads-software.com/support/topic/252107?replies=15

to no avail.

but Bad Behavior breaks the flash uploader:

https://www.ads-software.com/support/topic/164999?replies=1

see response #5.

well, another spam comment came through today, same IP, same domain:
Author : Halloween Costumes (IP: 82.146.49.61 , wordpressmassinstaller.net)