Opened 3 years ago

Closed 21 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 3 years 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 3 years 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 3 years 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:

|| [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 || || 
Last edited 3 years ago by Steve Bonds (previous) (diff)

comment:4 Changed 3 years ago by Steve Bonds

Cc: Steve Bonds added

comment:5 Changed 3 years 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 21 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 21 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.