- This topic has 6 replies, 2 voices, and was last updated 4 years, 6 months ago by
.
-
Posts
-
-
Hi Piklist team,
I just update from 0.9.4.28 to 0.9.9.12 and I’m following the instructions to update the serialized data, however, the script freezes with the following info on the screen:
Active Plugin Versions Updated…
Legacy post_relationships Table Deleted…
Settings Updated…
piklist_core – shortcode_ui
piklist_wp_helpers – remove_dashboard_widgets_new
piklist_wp_helpers – redirect_404
piklist_wp_helpers – delay_feedThe browser still active but nothing else happens after several minutes.
I’ve check the server and this is a the error I see on the logs:
[Sun Jul 16 21:12:12.278002 2017] [:error] [pid 8937] [client 75.74.226.76:65468] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query SELECT sysid FROM wp_so_sysref WHERE object_id = /* From [orderdesigndpt.staging.wpengine.com/wp-admin/admin-ajax.php] in [/nas/content/staging/orderdesigndpt/wp-content/themes/order_system/piklist/parts/meta-boxes/purchase-order-number.php:14] */ made by do_action(‘wp_ajax_piklist_update_0_9_9’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Piklist_Update_0_9_9->ajax, include(‘/themes/order_system/piklist/parts/meta-boxes/purchase-order-number.php’), referer: http://orderdesigndpt.staging.wpengine.com/wp-admin/admin.php?page=piklist_update_0_9_9
I’m running WP 4.8
Can you help me to figure out what is going wrong?
Thank you in advance and keep up with the great work.
-
-
this is line 14:
$porder_id = str_pad($wpdb->get_var(“SELECT sysid FROM $table_name WHERE object_id = “.$post->ID),5,0,STR_PAD_LEFT);and below you have the entire script. Note that the script was working prior to the update.
<?php
/*
Title: Purchase Order Number
Post Type: purchaseorder
Collapse: false
Locked: true
Context: side
Order: 1
*/
?><?php
$table_name = $wpdb->prefix . ‘so_sysref’;
$porder_id = str_pad($wpdb->get_var(“SELECT sysid FROM $table_name WHERE object_id = “.$post->ID),5,0,STR_PAD_LEFT);
?>
<h1 style=”text-align:center;”><?php echo $porder_id; ?></h1> -
-
It didn’t work. Now I have this error on the log: [Mon Jul 17 22:56:49.566414 2017] [:error] [pid 19745] [client 108.241.61.30:40578] WordPress database error Table ‘snapshot_orderdesigndpt.wp_post_relationships’ doesn’t exist for query SELECT post_id, has_post_id FROM wp_post_relationships /* From [orderdesigndpt.staging.wpengine.com/wp-admin/admin-ajax.php] in [/nas/content/staging/orderdesigndpt/wp-content/plugins/piklist/parts/updates/0.9.9.php:159] */ made by do_action(‘wp_ajax_piklist_update_0_9_9’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Piklist_Update_0_9_9->ajax, referer: http://orderdesigndpt.staging.wpengine.com/wp-admin/admin.php?page=piklist_update_0_9_9
-
It looks like you don’t have one of the legacy tables anymore. Let’s try this:
1) Delete your current version of Piklist
2) Go to the Piklist download page, choose version 0.9.4.31, download and install.
3) Activate version 0.9.4.31, and the deactivate it. Just the act of activating will create the table.
4) Now upgrade Piklist to the latest version and try running the updater again. -
-
- You must be logged in to reply to this topic.