Solved! I follow this tutorial: https://wordpress.org/gutenberg/handbook/designers-developers/developers/tutorials/block-tutorial/writing-your-first-block-type/ https://wordpress.org/gutenberg/handbook/designers-developers/developers/tutorials/block-tutorial/creating-dynamic-blocks/ And complimented with this: https://gist.github.com/mattheu/7cf235b4f932de891bc21cb5f3ff3de6
This isn’t really about WordPress, however you want: UPDATE wp_posts SET post_content = post_title WHERE post_content= “” AND post_type=”post”;
Fetch Data from an external MSSQL Database in a Managed WP hosting
The problem is not with the “select top 0”, but the way the query is changed behind the scenes. Even if you change it to “select * from…”, it will break. I managed to get this working by going to “wp-includes\query.php” file, and then removing the $limits variable from the query. This is not the … Read more
I setup something similar. Using IIS – look into writing a .bat file which fires off a php shell script to do whatever it is you need to accomplish. once you have that bat file working, setup a “scheduled task” in IIS http://technet.microsoft.com/en-us/library/cc721871.aspx if you are on a linux system, then use crontab https://www.freebsd.org/doc/handbook/configtuning-cron.html If … Read more
wordpress + cyrillic characters with SQL server 2008 r2 [closed]
I had the same problem. From my log file I can see its breaking on the query that returns the posts. I managed to get this working by going to “wp-includes\query.php”, and then removing the $limits variable from the query. It seems that this is breaking on sql server. Find this line: $this->request = ” … Read more
We ported WP to SQL Server almost three years and have been maintaining it ever since. Provided you are planning to use SQL Express 2012 or higher, this should be the solution you are looking for: Project Nami Simply put, replacing WPDB isn’t enough. So we went a step further and rewrote any MySQL-specific syntax … Read more
I think there is a new approach to it: https://blogs.msdn.microsoft.com/brian_swan/2010/05/12/running-wordpress-on-sql-server/ You can also use a 3rd party version of WordPress (not my cup of tea, by the way): https://code.google.com/archive/p/wordpress-mssql/ https://github.com/ProjectNami/projectnami Or follow this guide, but it might be a bit old: https://blog.building-blocks.com/installing-wordpress-on-windows-using-sql-server-2008-r2-part-1/ In the end I think the first link would be the best approach. … Read more