Can't get Meta Box Custom Table to work

This topic has 6 replies, 2 voices, and was last updated 4 years, 9 months ago by Anh Tran.

Viewing 7 posts - 1 through 7 (of 7 total)

Author

Posts
July 26, 2018 at 7:53 PM #10742
kesit
Participant
Hi,
would you mind to suggest where do I go wrong?

I've placed below code in functions.php
```
add_action( 'init', 'prefix_create_table' );

function prefix_create_table() {
    global $wpdb;
    
    if ( ! class_exists( 'MB_Custom_Table_API' ) ) {
        return;
    }
    MB_Custom_Table_API::create( $wpdb->prefix.'data_khusus', array(
        'test_column' => 'TEXT NOT NULL'  ,
        'test_column2' => 'TEXT NOT NULL'  ,    
    ), array( 'test_column' ) );
}
```
But the above code is not working. No table is created and, of course, no data saved.
Is there any idea to fix my code here?

Thanks

Add New Note to this Reply
July 27, 2018 at 5:47 PM #10753
Anh Tran
Keymaster
Hi,

In the docs:

BLOB and TEXT columns also can be indexed, but a fixed length must be given. Make sure you set the length when you want to index a text column.

In your code, you make the test_column indexed, but it doesn't have a fixed length. So the code won't run. Change it to the following code will work:
```
MB_Custom_Table_API::create( $wpdb->prefix.'data_khusus', array(
    'test_column' => 'VARCHAR(20) NOT NULL',
    'test_column2' => 'TEXT NOT NULL',    
), array( 'test_column' ) );
```
Add New Note to this Reply
July 28, 2018 at 11:22 PM #10762

kesit
Participant

Ah... I missed that note. Thanks for your response

And thank you for these great plugins! keep up the good work!

Add New Note to this Reply

July 29, 2018 at 12:01 AM #10763

kesit
Participant

Sorry, I more question:

Is it possible to move existing meta value from default post meta table into custom table?

Add New Note to this Reply

July 30, 2018 at 5:28 PM #10771
Anh Tran
Keymaster
Hi kesit,

You need to write custom code to move the data from custom fields to custom table. Here is a sample code:
```
$post_id = 1;
$fields = ['field_1', 'field_2'];
$table = 'your_custom_table';

$row = ['ID' => $post_id];
foreach ( $fields as $field ) {
    $row[$field] = get_post_meta( $post_id, $field, true );
}
global $wpdb;
$wpdb->insert( $table, $row );
```
Add New Note to this Reply
August 13, 2018 at 11:27 PM #10992

kesit
Participant

Is it safe for the data?

Sorry for my late reply...

Add New Note to this Reply

August 14, 2018 at 11:33 AM #10995

Anh Tran
Keymaster

Yes, it's safe. In the code above, there's no code to remove the data. So it always there.

You should always backup the database before doing this.

Add New Note to this Reply
Author

Posts

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.