Change Domain name in database
Change Domain name in database
Database
How do I find out from my database what version of WordPress I need?
Actually, you have a db_version in a “_options” table, also there are information about installed plugins and themes. With information about dates when website was disrupted you can get back to approximate versions of plugins. With these assumptions you can recover the most appropriate version of WP where that version of a plugin works correctly … Read more
Why should be SQL keywords, like CREATE TABLE and UPDATE, must be uppercase in WordPress?
Generally it does not (although it is probably a good thing to do and hopefully it is part of the coding standard. That specific quote refers to the API which lets you add or change columns in the DB. For that to work wordpress needs to compare what the definition of the table in the … Read more
mySQL database size large, but tables size less
It could be because bigger than needed because WordPress keeps in it some old stuff like post revisions, autodrafts, orphaned or duplicated meta… this could be easily cleaned using WP-Sweep plugin as long as you can run it on your site. I’m not sure how is your situation right now, are you able to use … Read more
Merging development site with live site
This is a hard one to answer without opinion entering into the equation. Generally speaking, having a staging or development site to merge the two into is best practice. You can either build this site on your own server (as you’re currently trying) or on the client’s server (where you may be able to work … Read more
blank page after update my theme
A blank page (‘white screen of death’) is usually caused by a fatal error in the PHP code. Since you said that you updated your theme (although it is not clear whether you personally updated the code, or if the theme was updated by the theme developer), then the problem is most likely in the … Read more
How do I insert content of various MySQL fields in post?
I also would vote for creating a short code. The shortcode code could pull data from a database/table, and ‘build’ the text you want with values from the table. Lots of googles on how to build shortcodes – check those out, vs me putting some sample code here. You would put the shortcode function in … Read more
Updating database with CSV file and Cron job
Updating database with CSV file and Cron job
How to handle my row actions on a custom list table in the admin section
Apparently the right way to do this is to get the suffix returned by your custom page that normally displays the table and use it to hook into the page load before any admin content is rendered. add_action(‘admin_menu’, function() { $page_hook_suffix = add_submenu_page( # or related function … function() { # content of table page … Read more
Form display in new page
Try to create a new page and put [elh-db-insert] as content. If you want to use [insert-into-db] as your shorcode, you should change add_shortcode(‘elh-db-insert’, ‘elh_insert_into_db’); to add_shortcode(‘insert-into-db’, ‘elh_insert_into_db’);