Simple – if you do not want duplicate information then before you insert anything check if such data is already present. Just query for it and see if there is a match. From WP perspective however, you seem to be looking at technique (database table) that you will rarely need in practice. WordPress offers wealth … Read more
This seems to be a problem with “orphaned SELECT statements”. It is described here in more detail. One solution would be to create a temporary table and modify my_acquireuserpasswd to save data to temp_table BEGIN DECLARE passwdtemp VARCHAR(64); DECLARE temp VARCHAR(4000); START TRANSACTION; SELECT id, passwd INTO uid1, passwdtemp FROM users WHERE name = name1; … Read more
MySQL errors after a WordPress clone
A good pointer would be to enable debugging in WordPress. Add this to your wp-config.php: define( ‘WP_DEBUG’, true );. By default WordPress does not show much debug information. More on this here.
two wordpress sites, two themes, one database, same content
Try this : $value = get_post_custom_values( ‘banda_postmeta’, $post->ID ); $value = unserialize(“$value”); print_r($value); echo $value[‘social_networks_url’][‘twitter_url’]; Your social_networks_url are blank, so try echoing these values, it will echo the value. echo $value[‘page_builder_settings’].”<br />”; echo $value[‘date_of_birth’].”<br />”; echo $value[‘location’].”<br />”; Output : array (size=7) ‘social_networks_url’ => array (size=9) ‘twitter_url’ => string ‘wr’ (length=2) ‘facebook_url’ => string ” … Read more
I think you might be new with WP Multisite. That is OK. I’m using Multisite for last few years and I really don’t know any way to put the different site tables in different database. The way WP Multisite works is a single WP installation for multiple WP site. Now suppose you have a database … Read more
Well it’s really not good practise, but this depends on how you’re accessing the other databases. For example, I have a server that hosts 10+ different WordPress sites. I have two options for connecting to the databases: Use the root login in all my wp-config.php files as it’s easier Create a user and logins associated … Read more
Why do you want to go for a custom MYSQL database altogether? You can simply use custom post types for products. Please check http://codex.wordpress.org/Post_Types You can add images, custom fields such as review, ratings etc. There are many plugins that can help you create custom post types easily. https://wordpress.org/plugins/custom-post-type-ui/ https://premium.wpmudev.org/project/custompress/ There is another plugin you … Read more
As long as you aren’t passing out the plugin and other people don’t have access to it, you should be fine. You might add something like the following to the top of the file just in case though: defined(‘ABSPATH’) or die(‘Access denied’); That will simply make sure that the file is loaded via wordpress (e.g. … Read more