New answers tagged

0

Why did it happen? It's hard to tell for sure because there are lots of variables to consider: mistakes made in exporting or importing, MySQL version etc. This is rather specific MySQL database question and doesn't have much to do with WordPress itself. To get a specific non-speculative answer to question why, I suggest to ask it in SO or DBA with plenty ...


2

Try putting the table name inside quotes, like this SELECT * FROM `sparte-bogensport` Edit More info on why this happens: http://dev.mysql.com/doc/refman/5.7/en/identifiers.html


1

Personaly I would go with one table for all users. Having more tables with the same columns seems like a strange idea to me. The database will be a complete mess after you gwt more users. Make sure that the user_id is an index for the table and all your select/update/delete will be fine. The insert might have a very short but unsignificant delay after the ...


0

you can export tables of your database that you want to transfer, and Import to another database, then you should change Prefixes of those .


0

Scheduled Post Guardian solved it. I guess scheduling strictly from database is not possible.


2

You can not replace the URL in the database using ctrl+f or any other "direct" method. You have to do a search & replace in the whole database in a way capable of keeping the validity of serialized data. There are several tools to do that serialized seach & replace. For example: Plugins like Better Search Replace, Velvet Blues Update URLs or ...


0

I don't think Visual Composer is the problem. Have you installed a logging plugin? Open phpMyAdmin and simply delete them. They are likely a post type you dont use. You can use the following query DELETE FROM wp_posts WHERE wp_posts.post_type='suspected_posttype' Make sure you don't remove the posta that are used by your site. Check what post types you ...


1

Alright! I understand that there is a custom wordpress login url. Also you need to login to a user's profile. If that's the case, I suggest a simple hack(If you legally have rights to access/modify the database). Try this: Go to cpanel and login to phpmyadmin and open the database for your website/blog. Find 'wp_options' table and search for a record ...


0

First you create table of your required form field in database than Put the code inside your newly created custom template. <?php if (!empty($_POST)) { global $wpdb; $table = table_name; $data = array( 'name' => $_POST['yourname'], 'chord' => $_POST['chord'] ); ...


0

Just noticed you're using $global $wpdb instead of global $wpdb, so I'm guessing your insert code isn't running.


1

This is probably the root cause - https://core.trac.wordpress.org/changeset/36510. Core have moved from saving menus in $_POST to sending them as json encoded and then decode it into $_POST. I am not very familiar with how menus are sent to the server, but you probably either use the wrong hook, use the right hook but too early, or there is a bug in core.


0

You will probably receive as many plugin recommendations as the number of WordPress users that you ask. For forms I personally use Gravity Forms, a commercial(paid ~ $40/yr) plugin. A similar option is Ninja Forms, free for basic capability and paid upgrades for added capabilities. For generating tables in a WordPress page or post I recommend the ...


0

Since you are a first timer (Welcome to the Wordpress World, by the way) an easy way to achieve that is using plugins. For forms, I recommend Contact Form 7 (https://wordpress.org/plugins/contact-form-7/). It will allows you to create almost any type of form. To record the data into database and display as table, you can use the Contact Form DB plugin ...


0

I reviewed Wordpress' advice on phpMyAdmin and it seems I was adding one extra step which was causing the problem – ticking Add CREATE DATABASE / USE statement. Exporting without checking this box and results in SQL that imports without any problems.


2

No, that isn't normal for 23 posts. Note that "posts" is pretty wide concept in modern WordPress. Many things are posts without being obvious as such, for example parts of navigation menus. While 60k entries does sound excessive for a small site, there is no telling without examining actual data to determine which post types it belongs to and if those ...


0

We ported WP to SQL Server almost three years and have been maintaining it ever since. Provided you are planning to use SQL Express 2012 or higher, this should be the solution you are looking for. Project Nami


0

If you want to use WordPress you can download a custom post type plugin (such as Custom Post Type UI), create your Book post type; another plugin to generate your form for adding books (Gravity Forms + this looks good, or a similar solution, or create a form by hand). Then tweak the default WordPress search feature to search through Book post type only (you ...


0

Today, I was trying to insert an imported data into WordPress. I was using wp_insert_post to insert data, and it threw the following error: WP_Error Object ( [errors] => Array ( [db_update_error] => Array ( [0] => Could not update post in the database ) ) [error_data] => Array ...



Top 50 recent answers are included