database

getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?

by

The problem is that you mapped your servlet to /register.html and it expects POST method, because you implemented only doPost() method. So when you open register.html page, it will not open html page with the form but servlet that handles the form data. Alternatively when you submit POST form to non-existing URL, web container will … Read more

When is the ‘post_content_filtered’ column in database cleared by WordPress?

by

Some WordPress plugins (although very few) use the post_content_filtered column in database to save some data related to a post. For example, Markdown on Save stores the markdown version of a post separately in the post_content_formatted column and the parsed HTML in the post_content column, so that when the plugin is deactivated the posts won’t … Read more

Keeping WP database synced across multiple developers using git

by

I’m working on improving my git workflow as it applies to my WordPress development projects. Often, when developing a content management system, I’ll create a development server (like http://dev.finalsitename.com) containing the custom post types and taxonomies that will be used in the production version. This allows my client to begin adding their content to the … Read more

Database synchronization between dev/staging and production

by

I have a problem with WordPress database synchronization between development and production and I am wondering how other people solving it. I am aware about this question but it doesn’t really cover the nastier and more realistic use case. Say I have a live WordPress website. I took a dump of everything, replicating it on … Read more

How to solve DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502

by

2015-08-28 18:12:19.047-Fri Aug 28 18:12:19 IST 2015DB2 Connection established –>[email protected] 2015-08-28 18:12:20.030-Execution failed ======> alter table BLP.COUNTER_EXTRACTION_REQUEST alter column SCHEME_ID set not null 2015-08-28 18:12:20.032-Error code for failure ======> DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=SCHEME_ID, DRIVER=3.63.123 2015-08-28 18:12:20.044-Execution failed ======> alter table BLP.COUNTER_EXTRACTION_REQUEST alter column SCHEME_TYPE set not null 2015-08-28 18:12:20.044-Error code for failure ======> … Read more

Why do I get SQLCODE=-204, SQLSTATE=42704 with DB2 LUW and WebSphere App Server?

by

The answer is case sensitivity. This answer was in fact provided by mustaccio in a comment, but they don’t seem to want to add it as an answer. If you see this, @mustaccio, please add your own answer, so I can accept it. Anyway, it turns out that WAS appears to effectively put quotes round the values you … Read more

Should I use custom post types or a custom database tables for plugin development?

by

I’m fairly new to writing wordpress plugins, but I’ve jumped in the deep end already and I want to make sure I’m doing it “right” on my upcoming big project. I’m going to be heavily extending wordpress into a pretty big web app and want to keep my data structures as native as possible to … Read more