The problem occurs in MySQL 5.6.20 or later, if the innodb_log_file_size in the my.ini is set too low. I changed mine to 16M and the problem went away. Thanks to @Otto for the solution. http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html
The basic technique of logging queries is that if SAVEQUERIES constant is defined to be true (it’s not by default for performance reasons) then $wpdb->queries will keep the log of queries performed. There isn’t anything on top of this that WordPress natively does. There are plenty of plugins around which work either by interpreting this … Read more
Ah, my problem ended up stemming from an issue with php5-fpm. Essentially, there were php5-fpm services running that were “old” and thus when I tried to access mysql from the web, it wasn’t detected. But when I tried to access it via cli, it was detected. That narrowed it down to php5-fpm for me, and … Read more
qwip, There is one way to update your custom table while wordpress users table in action and for that you require to code with custom function which is called while some action perform by user. You can handle it by add_action(). There are several action act by wordpress for user(viz. user_register, deleted_user, etc). See below … Read more
You should store additional user data in wp_usermeta table. For that, use add_user_meta() function. Here’s an example of how you can store locations $location = array(‘name’ => ‘example location name’, ‘street’ => ‘example street name’, ‘note’ => ‘example user note’ ); add_user_meta($user_id, ‘location’, $location); You can store as many locations as you want. To retrieve … Read more
In short, this is serialized data and this is how data is stored from a custom field (and many other datastrings) in the db. s:114 is auto generated and simply means that the value http://localhost/wp-content/uploads/woocommerce_uploads/2014/09/test-file.pdf is a string and is 114 characters long. This is used when the data is read and used. If the … Read more
I resolved creating SQL query: SELECT posts.post_title, posts.post_content, trans.element_type, trans.language_code FROM wp_posts AS posts INNER JOIN wp_icl_translations AS trans ON posts.ID = trans.element_id INNER JOIN wp_postmeta AS meta ON posts.ID = meta.post_id WHERE trans.element_type=”post_product” AND trans.language_code=”de” This is added only if you need something on post_meta: … INNER JOIN wp_postmeta AS meta ON posts.ID = … Read more
Sounds like you are trying hard to shot yourself and you will likely succeed. Every framework has its own assumptions and limitation so if the assumptions of wordpress do not fit your needs then just don’t use wordpress for the project. If you (ok, probably the client) have decided that for reasons of cost, delivery … Read more
If you only changed some CSS, then updating the CSS file on the live server should be sufficient (unless you need to clear a cache or something). If you changed/created posts on your localhost – then those posts will not be on your live site. You could overwrite the live site’s database with your localhost … Read more
Is this what you are asking for? Use it after the code you posted to create posts in loop and use thier ids to update meta fields. Replace “post_type” with your custom post type. foreach ($markers as $marker){ $post_id = wp_insert_post(array( “post_title” => “something”, “post_type” => “your-type”, “post_status” => “publish”, //by default they are drafts … Read more