The post_type field is an internal feld, you shouldn’t be giving it values that require longer column lengths, and there’s no need for it to be user facing. WP allows you to override everything about it, from the query variable name, rewrite rules, to the wording displayed. But more importantly, you shouldn’t modify WP core. … Read more
That’s not JSON, it’s serialised PHP data. If you try to store a value that isn’t a primitive string/number, such as an object or array, WordPress serializes it using PHP. How do we decode this structure deserialize( … ); However, I do not recommend relying on this for practical and security reasons. Don’t store structured … Read more
WordPress is unaware of what kind of database server you’re using, as long as it accepts MySQL flavour SQL, can be communicated with via the mysqli PHP extension, and supports the feature set of the minimum requirements, WordPress is happy. As a result, none of the concerns you need to worry about are related to … Read more
Check the wp_config.php file… look for a line that reads: $table_prefix = ‘qfo_’; Or… $table_prefix = ‘wpax_’; Which ever one is set in wp_config.php is the one that your WordPress site is using. If the tables aren’t being used then they’re not really doing any harm other than taking up space, but once you’re sure … Read more
If your custom product catalog is written by you, then you have to do it manually, you can write a script to automate that product if your catalog database is big. Also, there is a plugin to do that you can give a try but this solution is not error-proof, a wrong step will destroy … Read more
These tables aren’t indexed These tables are indexed For example, the post meta table has these indexes: https://codex.wordpress.org/Database_Description#Indexes_5 You’re more likely to cause issues or reduce performance through bad indexing by adding new indexes. WP already specifies indexes for tables “dbmain” “wp_mf_post_meta” “post_id” “Not indexed” “dbmain” “wp_mf_custom_fields” “custom_group_id” “Not indexed” Those are not WordPress tables, … Read more
Going by the description for the $format argument An array of formats to be mapped to each of the value in $data. If string, that format will be used for all of the values in $data. A format is one of ‘%d’, ‘%f’, ‘%s’ (integer, float, string). If omitted, all values in $data will be … Read more
wpdb detects the type of query and returns the result if it starts with select, else the affected rows. Since yours starts by call, it’s probably mistaking it for an insert, update, delete, etc. statement. Try this (might trick wpdb into thinking it’s a select statement: /* select */ call …; Or this (not sure … Read more
Are you moving WP to new server and domain or new server only? I mean will URL remain the same or will be changed? There are several things that can go wrong and it is hard to say from details you provided. Basically: there might be something wrong with your new WP installation, had you … Read more
If you’ve got a lot of hosts with tons of databases, perhaps it’s time to upgrade to a dedicated server? I host with Liquid Web and have been VERY happy.