Opened 4 years ago

Closed 3 years ago

#1288 closed defect (fixed)

Could not add entry to USB page

Reported by: Ben Chociej Owned by:
Priority: minor Milestone:
Component: wiki Version:
Keywords: Cc: Steve Bonds

Description

Attempted to add the following line to https://www.smartmontools.org/wiki/Supported_USB-Devices :

|| Rosewill RX234 SATA III USB 3.0 docking station || JMicron || 0x152d:0x2578 || JMicron Technology Corp. / JMicron USA Technology Corp. USB to SATA bridge || -d sat || Linux 4.19 || bchociej || ||

Upon either submitting or attempting to review changes, the following error was displayed:

Trac detected an internal error:
DataError: (1406, "Data too long for column 'request' at row 1")

Change History (7)

comment:1 by Christian Franke, 4 years ago

Milestone: unscheduled

Looks like the page reached some size limit.

I removed some dead links which freed ~3KB. Please retry your additions.

Please leave the ticket open as a reminder. We will either increase the limit or split the page.

comment:2 by Pierre Fagrell, 4 years ago

This problem is back. I tried to add an entry to the USB page and get the DataError.

comment:3 by Steve Bonds, 4 years ago

I hit the same error also. This error appears to be passed back from the underlying MySQL database.

https://trac.edgewall.org/ticket/3884

https://stackoverflow.com/questions/18897420/data-too-long-for-column-why

Trimming down some of the longer comments would allow me to make my entry, but as a new user, I'm not a good judge of what can/should be trimmed or if it would be better to simply allow the database to accept the larger page.

I've elected not to make my entry, but instead I'll save it here for later when this issue is resolved:

|| WD My Passport (USB 3.0) 1TB || ? || 0x1058:0x25e3 (0x1019) || Western Digital Elements / My Passport (USB, AF) || -d sat || FreeBSD || sevan || smartctl 6.6 2017-11-05 r4594 on FreeBSD 11.2-RELEASE-p2 amd64] || 
|| [https://support-en.wd.com/app/products/product-detail/p/119 WD My Book WDBBGB] || ? || 0x1058:0x25ee (0x4007) || Western Digital / My Book Desktop || -d sat || Linux || Steve Bonds || || 
Version 0, edited 4 years ago by Steve Bonds (next)

comment:4 by Steve Bonds, 4 years ago

Cc: Steve Bonds added

comment:5 by Christian Franke, 4 years ago

The size limit is 82111+N bytes for some small N > 0.

I removed or shortened some comments and moved the "Unsupported Devices" table to a new page. This freed ~10KB.

comment:6 by Christian Franke, 3 years ago

The "Supported Devices" page was split into two about one year ago. There is now ~40KB or more free space on each page.

comment:7 by Christian Franke, 3 years ago

Milestone: unscheduled
Resolution: fixed
Status: newclosed

Fixed by splitting the page into three.

Note: See TracTickets for help on using tickets.