linus1976
Forum Replies Created
-
Forum: Plugins
In reply to: [UpdraftPlus: WP Backup & Migration Plugin] Table Backup – Format changeThat’s an awesome fix! I believe I might be using Updraft in a pretty non-standardized manner but thanks for releasing the option 🙂
Happy Thanksgiving!
Forum: Plugins
In reply to: [UpdraftPlus: WP Backup & Migration Plugin] Table Backup – Format changeThanks, I’ve marked this thread as resolved, thanks again for the technical details
Forum: Plugins
In reply to: [UpdraftPlus: WP Backup & Migration Plugin] Table Backup – Format changeHi David
Gotcha, so I was probably lucky before. The split at 1,000 rows did align nicely with the restrictions of SQL Server, into which I imported the data for further analysis. I don’t think this restriction exists in MariaDB/MySQL.
I assume that there is no way to force 1,000 per import statement?
Linus
Forum: Plugins
In reply to: [UpdraftPlus: WP Backup & Migration Plugin] Table Backup – Format changeHi David,
Thanks for looking into this.
I have a table from WP Data Table, consisting of approximately 7.2k rows, which should be modest(?).
In the backup file I see the following, where the row count seems to be wrong (if I do a count(*) on the table, I do get the 7.2k).
Data contents of table
wp_wpdatatable_1Approximate rows expected in table: 5054The first six insert statements correctly contain 1,000 entries, but the last one contains 1,200+ entries which breaks the SQL code.
Here is the table structure and the preceding code:
DROP TABLE IF EXISTS
wp_wpdatatable_1; Table structure of tablewp_wpdatatable_1CREATE TABLE
wp_wpdatatable_1(wdt_IDint(11) NOT NULL AUTO_INCREMENT,managervarchar(255) DEFAULT NULL,strategyvarchar(255) DEFAULT NULL,datedate DEFAULT NULL,rordecimal(16,4) DEFAULT NULL,aumint(11) DEFAULT NULL,useridint(11) DEFAULT NULL,estimatedvarchar(2000) DEFAULT NULL,
UNIQUE KEYwdt_ID(wdt_ID)
) ENGINE=InnoDB AUTO_INCREMENT=186330736 DEFAULT CHARSET=utf8 ;Forum: Plugins
In reply to: [WooCommerce] Single Products No longer displaying correctlyI can report that this now seems to work, after the most recent update.
Forum: Plugins
In reply to: [WooCommerce] Single Products No longer displaying correctlyI was advised to switch components and have done so on that page. For a case where it doesn’t work see: https://nilssonhedge.com/index/daily-indices/daily-cta-index/
Basically, when linking to a product, via the product page, it usually displayed the product nicely. No longer so.
Forum: Plugins
In reply to: [WooCommerce] Single Products No longer displaying correctlyHi @maykato
I’ve changed the display, from a link to the page (which used to display nicely) to a “selected product” (naming might be wrong). This is apparently a known issue for Chrome-based browsers (e.g Chrome, Edge and whatnot). It displays correctly on Safari-based browsers. So, the issue still outstanding…but solvable
Forum: Plugins
In reply to: [WooCommerce] Single Products No longer displaying correctlyHi
I’ve tried using the approach, troubleshoot mode, with two “twenty” themes, but it fails to load properly even when all the plugins are disabled.
Adding to the mystery, it works on my iPhone, but not on two different PC. The page renders correctly when I’m previewing it via the page menu in the admin interface, but not when I’m viewing it as a page in a separate browser tab. I have tried changing browsers, cleaning the cache, java update, and what not, but no success.
Forum: Plugins
In reply to: [WooCommerce] Single Products No longer displaying correctlyThanks for your reply. You are capturing the problem correctly. No sorry, tried with one of the “twenty” themes, but it didn’t solve the problem. I’m using Maisha, one of the themes supplied by WP.