Comments 6Alex started the conversationMarch 9, 2017 at 10:22amHello I build this query for editable woocommerce table, but the site hangs when trying to edit:--------------------- SELECT woi.meta_id, woi.order_item_id, woi.meta_key, woi.meta_value, oim.order_id FROM wp_woocommerce_order_itemmeta woi, wp_woocommerce_order_items oim WHERE oim.order_item_id = woi.order_item_id-------------------- Table for edit - wp_woocommerce_order_itemmeta ID column - meta_id 1,874Miloš repliedMarch 13, 2017 at 7:18pmHi Alex,Thank you for your purchase.Can you please send me the link of that table so I can take a look.Thank you.Kind Regards, Miloš Jovanović[email protected] Rate my supportTry our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/ wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community You can try wpDataTables add-ons before purchasing on these sandbox sites: Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables 6Alex repliedMarch 13, 2017 at 10:14pmhttp://tris.head-wind.ru/test/ 1,874Miloš repliedMarch 16, 2017 at 9:41pmHi Alex,The issue is in query because I can see that there are 2 tables and only 1 table can be edited.wp_woocommerce_order_itemmeta woi, wp_woocommerce_order_items oimLike I said from the previous tickets from the documentation there are limitations for mysql tables when you try to edit more than 1.Kind Regards, Miloš Jovanović[email protected] Rate my supportTry our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/ wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community You can try wpDataTables add-ons before purchasing on these sandbox sites: Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables Sign in to reply ...
Hello
I build this query for editable woocommerce table, but the site hangs when trying to edit:
---------------------
SELECT woi.meta_id, woi.order_item_id, woi.meta_key, woi.meta_value, oim.order_id
FROM wp_woocommerce_order_itemmeta woi, wp_woocommerce_order_items oim
WHERE oim.order_item_id = woi.order_item_id
--------------------
Table for edit - wp_woocommerce_order_itemmeta
ID column - meta_id
Hi Alex,
Thank you for your purchase.
Can you please send me the link of that table so I can take a look.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
http://tris.head-wind.ru/test/
Hi Alex,
The issue is in query because I can see that there are 2 tables and only 1 table can be edited.
wp_woocommerce_order_itemmeta woi, wp_woocommerce_order_items oim
Like I said from the previous tickets from the documentation there are limitations for mysql tables when you try to edit more than 1.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables