Opened 7 months ago

Last modified 4 months ago

#1288 new defect

Could not add entry to USB page

Reported by: Ben Chociej Owned by:
Priority: minor Milestone: unscheduled
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 (5)

comment:1 Changed 7 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 5 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 4 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:

|| [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 4 months ago by Steve Bonds (previous) (diff)

comment:4 Changed 4 months ago by Steve Bonds

Cc: Steve Bonds added

comment:5 Changed 4 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.

Note: See TracTickets for help on using tickets.