CarnetApp / CarnetNextcloud

GNU Affero General Public License v3.0
154 stars 29 forks source link

Path length in database needs to be higher #167

Open OliverParoczai opened 3 years ago

OliverParoczai commented 3 years ago

Some of the users on my server had used paths longer than 191 characters, and this breaks the cache rebuild process.

Server output:

Server# sudo -u www-data php occ carnet:cache rebuild list of user files /username/files/Documents/QuickNote/companyname/Á###á####/#######ó á###á######/500- 700 #á#á### #####é# 6 ##á###é#. #ö###á# #6 #7 ##########á# #ö#######á#. #ő#### #######é## 800 1000 ####### ####á## ##á##ő##é# ####á# .sqd (the problematic file, private information blanked out)

In ExceptionConverter.php line 114: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'path' at row 1

In Exception.php line 26: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'path' at row 1

In Statement.php line 82: [22001]: String data, right truncated: 1406 Data too long for column 'path' at row 1

PhieF commented 2 years ago

I had a problem with some SQL version when puttin a longer path, I will need to study this a bit before mergin, sorry for being that late