It’s adding a record in the database of which version of the database is in use. This can be used in future to determine whether or not the database structure on a given site needs to be updated if the plugin changes its database structure in a future version. You’ve likely seen this yourself when … Read more
I think WP out-of-the-box does not write or store any data for non-logged in users. WP – again by default – does not write log files, that is an optional config defined in the wp-config.php file.
The “ID” of the role is the array key in wp_user_roles. The value of wp_user_roles looks like this: Array ( [administrator] => Array ( [name] => Administrator [capabilities] => Array ) => Array ( [name] => Author [capabilities] => Array ) ) In that example, administrator and author are the closest thing there is to … Read more
I’m hitting the table 2 times (if the field exists) to get its value. No, you aren’t, and there is no evidence for this. You may not be hitting the database at all if it has autoload enabled. WordPress caches things in memory during the same request, and it bulk fetches options set to autoload … Read more
As it writes, a problem with the indexes definitions of those tables. Please try a repair on the reported table and see if that helps. Have you activated a specific add-on lately or did you alter tables?
It is possible to write code to grab the user’s password on login and write it out in a different format to a different location. Over time, you would thus accumulate the passwords in a different format than WordPress itself uses (it makes use of the excellent PHPass library for password storage). To do this, … Read more
The value is a serialized php array. Further explanation is not really WordPress specific, but here you go — the ‘s’ is the length of the string representation of the succeeding array element (the length of the string in quotes). I.E. in a:2:{s:12:”twentyeleven”;s:7:”/themes”;s:9:”twentyten”;s:7:”/themes”;} the “12” in s:12 represents the length of twentyeleven.
Don’t use separate database tables in a Theme, especially for creating custom content types. Use WordPress-core Custom Post Types.
There is nothing that prevent duplicates here. When you create the table ‘church’ is a good idea set a UNIQUE sql index for field email, in this way you can rely on email address to preventing duplicate entries. As a generic PHP good practice, you should check the existence of a a variable before using … Read more
You should not use this technique to change the URL of your site : WordPress sometimes stores URLs in serialized strings. You find/replace will corrupt the serialized data and discard the whole content. You can use interconnect/it search and replace tool to change the domain without any risk. This tool even allow you to run … Read more