badasswp

This plugin helps you migrate legacy SQL database tables to WordPress’ Custom Post Types (CPT). It provides a user-friendly UI interface that enables users upload an SQL file which is then parsed and converted to a CPT with meta data that is recognisable within WordPress.
If you ever need to migrate a non-WordPress database table into WP, look no further. This is exactly what you need!
<h4>✔️ Features</h4>
Our plugin comes with everything you need to easily migrate SQL tables to CPTs.
✔️ Import & Convert to CPT feature. 
✔️ Quick & Lightening Fast uploads. 
✔️ Friendly, User Interface (UI). 
✔️ Custom Post Type Capabilities. 
✔️ Error Loggging Capabilities. 
✔️ Custom Hooks to help you customize plugin behaviour. 
✔️ Available in mutiple langauges such as Arabic, Chinese, Hebrew, Hindi, Russian, German, Italian, Croatian, Spanish & French languages. 
✔️ Backward compatible, works with most WP versions.
<h4>✨ Getting Started</h4>
Head over to the SQL to CPT options page. Upload an SQL file of your choice by clicking on the Import SQL File. This would analyse your SQL table and show you the table name and table columns you are about to import. Once ready, click on the Convert to CPT button to complete the process.
On import completion, you should now be re-directed to the Custom Post Type page of your newly imported data!
You can get a taste of how this works, by using the <a href="https://tastewp.com/create/NMS/8.0/6.7.0/sql-to-cpt/twentytwentythree?ni=true&origin=wp" rel="nofollow ugc">demo</a> link.
<h4>⚡ Why SQL to CPT ?</h4>
<ol>
<li>Because you need something that works great and fast!</li>
<li>Because you want to port your data across platforms easily.</li>
<li>Because you don’t want to spend hours building custom software for this.</li>
<li>Because you think SQL to CPT is cool.</li>
</ol>
NB: At the moment, the SQL to CPT plugin currently does not provide a way for users to import more than one SQL table at a time, this feature should be available in future releases as well as the option to remove unused CPTs.
<h4>🔌🎨 Plug and Play or Customize</h4>
The SQL to CPT plugin is built to work right out of the box. Simply install, activate and start using.
Want to add your personal touch? All of our documentation can be found <a href="https://github.com/badasswp/sql-to-cpt" rel="nofollow ugc">here</a>. You can override the plugin’s behaviour with custom logic of your own using <a href="https://github.com/badasswp/sql-to-cpt?tab=readme-ov-file#hooks" rel="nofollow ugc">hooks</a>.
<h3>Contribute</h3>
If you’d like to contribute to the development of this plugin, you can find it on <a href="https://github.com/badasswp/sql-to-cpt" rel="nofollow ugc">GitHub</a>.
To build, clone repo and run <code>yarn install && yarn build</code>

SQL To CPT

Import & Convert SQL tables to Custom Post Types (CPT). Migrate legacy SQL table data to WordPress custom post types of your choice. It's super fast!

Eddie Moya

This plugin was create to work around a problem caused by certain configurations in MySQL that lead to several odd symptoms including but not limited to:
<ul>
<li>Loss of ability to create new posts</li>
<li>Loss of ability to update posts</li>
<li>Errors regarding invalid timestamps</li>
<li>Admin interface reverts to lowest permissions ex:‘Publish’ button says ‘Submit Draft’.</li>
</ul>
In addition, this problem is often accompanied by an error like the following:
<pre><code>WordPress database error: [Incorrect datetime value: '0000-00-00 00:00:00' for column 'post_date_gmt' at row 1]
INSERT INTO 'mg_posts' ('post_author','post_date','post_date_gmt','post_content','post_content_filtered','post_title',
'post_excerpt','post_status','post_type','comment_status','ping_status','post_password','post_name','to_ping','pinged',
'post_modified','post_modified_gmt','post_parent','menu_order','guid') VALUES (’1′,’2011-08-23 03:32:43′,
’0000-00-00 00:00:00′,”,”,’Auto Draft’,”,’auto-draft’,'post’,'closed’,'open’,”,”,”,”,’2011-08-23 03:32:43′,’0000-00-00 00:00:00′,’0′,’0′,”)
</code></pre>
The inability to pass zero dates breaks the ability to actually create a new post, but it also seems to have the odd secondary effect of confusing the heck out of nonces (noces are a security feature), probably because they too rely on timestamps.
This plugin strips out the sql_modes listed below from @@SESSION, thereby eliminating the problem while only effecting database sessions WordPress starts and not the whole database.
<h3>Explanation and history of the problem</h3>
The cause of this problem stems from an old (soon to be deprecated) odd behavior/feature of MySQL which WordPress came to depend on. My understanding is that it stems from problems in MySQL with regard to using the MySQL NOW() function in some contexts – so as a workaround it was decided that if a date of all zeros was entered on a column that was set as NOT NULL, then that date would not be rejected, but instead would be converted to the current date – to mimic NOW().
Subsequently this method was marginalized as generally a bad idea – and now values exist for a setting called sql_mode, which turn this behavior off and force errors when a null value is passed to a NOT NULL field. In many cases when there is an actual DBA in charge of the database, they will assign these values to the production database to force what outside of MySQL would be normal SQL behavior.
There are 3 sql_modes which will trigger the error by disabling the ability to enter zero dates.
<ul>
<li>NO_ZERO_DATE</li>
<li>NO_ZERO_IN_DATE</li>
<li>TRADITIONAL</li>
</ul>
It’s worth mentioning that the ALLOW_INVALID_DATES mode does NOT solve the problem, even though by the name of it, it would seem that it might.
<h3>The solution</h3>
This plugin solves the problem with minimal effect to the database environment. All this plugin does it check to see if the sql_modes in question are set, and if they are, it removes them.
Importantly, this plugin changes @@SESSION.sql_mode and not @@GLOBAL.sql_mode. By changing sql_mode via the session, it only takes effect on each specific connections WordPress makes with the database rather than changing it for the entire database permanently – as such this will have no effect whatsoever on any applications that might happen to be using the same database.
<h3>Other manifestations, alternative solutions.</h3>
WARNING: Whenever applicable, consult your DBA before making any changes to production databases.
This problem may (I have no idea) in fact be more common during installation. The errors are different, and although I have seen them, I do not have them handy at this time. In any case, if the sql_modes are set during installation – the process will fail from the start – because of this, it is my presumption that anyone encountering the errors as described above – has probably recently migrated to a new database, or perhaps recently acquired an enthusiastic new DBA who has made some changes.
This plugin DOES NOT FIX this problem for those encountering during installation – thats impossible because WordPress ignores all plugins during installation – so there is no way to hack around it via plugin and fix it before installation occurs.
If you are encountering this problem during installation you will need to find an alternative way to remove the modes. If this is a production environment this may require the cooperation of a DBA who may not like the idea. If met with resistance, I suggest the asking for the modes to be temporarily removed for installation, and then set back after its dont – at which point this plugin will handle the problem from then on.
If your encountering this locally, or on a environment whose database you have access to modify, you will want to make as few changes as possible, so go to whatever interface you use (command line, phpMyAdmin, whatever) and run this line of SQL:
<pre><code>SELECT @@GLOBAL.sql_mode;
</code></pre>
This will show you all the sql modes currently defined. Copy all them them but if you have NO_ZERO_DATE, NO_ZERO_IN_DATE, or TRADITIONAL remove them. Then update sql_mode with the remaining modes as such:
<pre><code>SET @@GLOBAL.sql_mode = "STRICT_TRANS_TABLES,STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO";
</code></pre>
Please don’t simply use the sql_mode definition I have shown above, this is only an example – be sure to use the modes from your database configuration. Remember to keep everything together NO SPACES ALLOWED in the definition.
Finally, if your just working locally and don’t care about these sql_modes, you can just clear them all.
<pre><code>SET @@GLOBAL.sql_mode = "";
</code></pre>
This will do the trick but is absolutely not recommended as a fix for production sites that might share environments.
Irrelevant Note: I struggled with naming this plugin, and settled on the terminology seen in the error message.

Incorrect Datetime Bug Fix

This plugin was create to work around a problem caused by certain configurations in MySQL that lead to several odd symptoms including but not limited  …

SQL To CPT vs Incorrect Datetime Bug Fix