Another WordPress Error!

Nothing like getting a dreaded wordpress error message. At first I was going to document how I solved my problem. 26 frustrating hours later, I decided to just point you in the right direction because the answer isn’t a one size fits all answer.

The only drawback to wordpress is that it is open source. What that means is that developers are free to fiddle with it. It means we get hundreds of fun free plugins. Unfortunately it also means we are doomed to constantly battle different errors.

WordPress Submit Review Error

Besides not being able to edit my post, I also wasn’t able to publish my post. It was as if I was just a contributor on my own blog, not admin. Man, this problem really threw me for a loop.

The problem really started when I tried to upload an image. The image wouldn’t upload, so at first I tried to figure out what was causing my images to not upload.

While I think you can find the answer to almost anything simply by googling. Sometimes though you end up worse than when you started. This is true in my case, I spent some crazy amount of hours trying all types of solutions provided by google and the internet community.

The Solution To My WordPress Problem and Maybe Yours

Here are the some of the symptoms

• Can’t publish post, just get error message “You Are Not Allowed To Publish Post”
• Can’t upload images “Nothing happens after uploading, the image never appears
• Can’t comment without getting a 404 error
• Your publish button vanishes and you are left with submit for review button “but still get the same not allowed to publish post”

There may be a few more but though are the major issues. Pretty big issues actually! This shit pissed me off, I think I am still bitter over it as I write this.  Okay sorry bout that…

This isn’t a new problem in fact I found solutions for this issue from way back in 2005.  It’s like going to the doctor and telling him you have a fever and stuffy nose and achy joints.. LOLS it could be anything!@!!

So I started my trouble shooting by, turning off all my plugins.. that didn’t help! Then I switched themes, that just made me loose my settings. GRRRR!! That didn’t help either.

Okay so now I rolled up my sleeves, I started digging into my mysql database not that I have a frigging clue what I am doing there.  But there are times when you must do what you must.  I repaired my database, I deleted rows and tables, I changed command threads..

Since I was scared shitless I might corrupt everything I backed up as much as I could. My database my wordpress folders figuring worse case scenerio I have to pay a professional to fix my shiz.

Thank goodness for friends. I called up my buddy and told her my wordpress woes. She suggested I run WP_Debugger. Why didn’t I think of that I told myself. I guess when your pissed your mind gets pre-occupied and you miss the obvious.

So I debugged, and got and insert command error. Now we are getting somewhere! That lead me to realize it was some sort of memory error or something of that nature. Best my non techy ass could come up with.

So I went into my control panel for my hosting and started rooting through my msql databases and realized profitonknowledge only has 100mb database. DOH!

I had went over my limit big time. Makes sense looking back because this blog started running slower, errors popped on me from nowhere all the time.

Of course my hosting company upgraded there stuff and I can now make 1000mb mysql databases. So now I said forget about rolling my sleeves up, I have to get down and dirty with this one.

I had to access ssh shell, export my old data, import by way of putty. If non of that makes sense, don’t worry if you have a good hosting company give them a call. They should be able to help you.

CAUTION!!!! Do not sound timid with those people you are paying them for their service. Curse at them, threaten them, ask to speak to supervisor. If not you are going to get a wishy washy answer and blown off.

(They can find out what the problem is much much faster than you can if they can’t they shouldn’t be working for a hosting company.)

So ya… My problem was my database was to small, wordpress simply had no more room to grow. Switched databases, changes my wp-config file to point to the new database and BAM it works…

In order to fix your problem if your database is to small you will need access to.

• MyPhpAdmin
• FTP client
• Putty.exe
• access to your ssh

I think older wordpress builds have different issues but the newer version of wordpress is pretty clean. If you have been blogging for awhile and this problem starts occuring, I recommend downloading WP_Debugger . It can save you time looking for what your problem is.

Note: I am not sure if it’s all hosting companies are the same, but mine only allowed me to upload 50mb through myphpadmin. In order to get bigger databases imported  you will have to use third party scripts or programs to upload big files.

At the very least I hope this post gives you some idea how to debug your wordpress errors.

Resources

https://kb.edgewebhosting.net/KnowledgebaseArticle53024.aspx

http://wordpress.org/support/topic/admin-getting-you-are-not-allowed-to-edit-this-post-on-save-draft

http://wordpress.org/support/topic/you-do-not-have-sufficient-permissions-to-access-this-page-1/page/3#post-422005

http://www.mydigitallife.info/how-to-backup-and-restore-export-and-import-mysql-databases-tutorial/

http://www.wanderings.net/notebook/Main/HowToImportLargeMySQLDataFiles