Opened 23 months ago

Closed 3 months 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 Changed 23 months ago by Christian Franke

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 Changed 21 months ago by Pierre Fagrell

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

comment:3 Changed 20 months ago by Steve Bonds

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 20 months ago by Steve Bonds (next)

comment:4 Changed 20 months ago by Steve Bonds

Cc: Steve Bonds added

comment:5 Changed 20 months ago by Christian Franke

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 Changed 3 months ago by Christian Franke

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 Changed 3 months ago by Christian Franke

Milestone: unscheduled
Resolution: fixed
Status: newclosed

Fixed by splitting the page into three.

Note: See TracTickets for help on using tickets.