Fehler beim hochladen

1st Official Post
    Affected Version
    WoltLab Suite 3.1

    Hallo und guten tag

    habe ein problem beim hochladen in unsere Filbase folgende meldung erhalen wir in der log

    Display Spoiler

    Fri, 07 Feb 2020 11:32:52 +0000

    Message: Could not execute statement 'INSERT INTO filebase1_file_upload

    (userID,filename,fileType,fileHash,filesize,uploadTime)

    VALUES (?,?,?,?,?,?)'

    PHP version: 7.2.5

    WoltLab Suite version: 3.1.11

    Request URI: /filebase/index.php?ajax-upload/&t=7e8d47b2238771aa22c5a9e16284a54601b9aae4

    Referrer: https://www.team-rheinlandpfalz.com/filebase/index…ersion-add/185/

    User Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0

    Peak Memory Usage: 4760536/268435456

    ======

    Error Class: wcf\system\database\exception\DatabaseQueryExecutionException

    Error Message: Could not execute statement 'INSERT INTO filebase1_file_upload

    (userID,filename,fileType,fileHash,filesize,uploadTime)

    VALUES (?,?,?,?,?,?)'

    Error Code: 22003

    File: /srv/www/htdocs/www.team-rheinlandpfalz.com/wcf/lib/system/database/statement/PreparedStatement.class.php (105)

    Extra Information: YTo2OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjE7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO3M6Mjk6IidGUzE5X0lyZ2VuZHdvX2luX0V1cm9wYS56aXAnIjt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7czoxNzoiJ2FwcGxpY2F0aW9uL3ppcCciO31pOjM7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDQiO2k6MTtzOjQyOiInZmRiZWQ4Zjk4YzdhNjJkNGE3OTY3NzhmZTllZjk2MTQ3ZWFiNDc4ZiciO31pOjQ7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDUiO2k6MTtpOjIxNDkxODUwOTY7fWk6NTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNiI7aToxO2k6MTU4MTA3NTE3Mjt9fQ==

    Stack Trace: [{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/data\/DatabaseObjectEditor.class.php","line":36,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/filebase\/lib\/data\/file\/upload\/FileUploadAction.class.php","line":103,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"userID":"[redacted]","filename":"[redacted]","fileType":"[redacted]","fileHash":"[redacted]","filesize":"[redacted]","uploadTime":"[redacted]"}]},{"function":"upload","class":"filebase\\data\\file\\upload\\FileUploadAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":104,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/filebase\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["filebase"]}]

    ======

    Error Class: PDOException

    Error Message: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'filesize' at row 1

    Error Code: 22003

    File: /srv/www/htdocs/www.team-rheinlandpfalz.com/wcf/lib/system/database/statement/PreparedStatement.class.php (93)

    Extra Information: -

    Stack Trace: [{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/data\/DatabaseObjectEditor.class.php","line":36,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/filebase\/lib\/data\/file\/upload\/FileUploadAction.class.php","line":103,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"userID":"[redacted]","filename":"[redacted]","fileType":"[redacted]","fileHash":"[redacted]","filesize":"[redacted]","uploadTime":"[redacted]"}]},{"function":"upload","class":"filebase\\data\\file\\upload\\FileUploadAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":104,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/srv\/www\/htdocs\/www.team-rheinlandpfalz.com\/filebase\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["filebase"]}]

    das problem taucht mit Mozila so wie chrome auf

    Wie groß ist denn die Datei, welche hochgeladen werden sollte und wie hoch ist das Uploadlimit deines Webspaces?

    Greetz

    Dark

    Mit dem Ende naht der Anfang mit etwas Neuen, um dann wieder zu sagen „Nach dem Update ist vor dem Update“. :S

    Prüfe doch mal in der PhpInfo, was dort post_max_size und upload_max_filesize sagen.

    Greetz

    Dark

    Mit dem Ende naht der Anfang mit etwas Neuen, um dann wieder zu sagen „Nach dem Update ist vor dem Update“. :S

    Quote from Layz

    Auf eigene Gefahr könnte man in der DB die Tabelle filebase1_file_upload - Filesize auf bigint stellen um größere Dateien hochzuladen.

    Es sind zwei Spalten, welche geändert werden müssen, habe es in meiner Testumgebung ebenfalls getestet und habe dann zwei Dateien mit 2,7 GB und 5 GB hochgeladen. Aber es hat sicher seine Gründe weshalb dies nicht geändert wird oder wurde, also sollte dies über einen Test nicht hinausgehen.

    Greetz

    Dark

    Mit dem Ende naht der Anfang mit etwas Neuen, um dann wieder zu sagen „Nach dem Update ist vor dem Update“. :S

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login