File upload

Hi Michał,

Thank you for your quick reply, much appreciated.

The current setting for db vs local file system is at the default 4kb and interestingly if the file size for the uploaded file is less than 4k all works as expected.

I've looked in the logs (WebIssues / apache) and cannot see anything untoward.

We are attaching files up to 1GB and typically not less than 1 or 2MB.

Thanks,

Steve

I am still looking at this problem. Have updated/upgraded linux to ensure all is on the most recent version. Uses phpadmin to look for php params that may have a role in this problem (none found other than ones mentioned ealier). Looked through the mysql ini files (a challenge to figure out which is the last one it loads!), maxed out a few based on web searches. All to no avail. I have not been able to see any pattern for the failure.

The default.log records the sql and does not seem to indicate a problem - except the file is not added to the DB.
[2017-03-22 08:51:20, 192.168.6.22]

Running script: /client/issues/addattachment.php
SQL Query: SELECT server_name, server_uuid, db_version FROM rfid_server
Query execution time: 0.8 ms
Returned rows: 1
SQL Query: SELECT set_key, set_value FROM rfid_settings
Query execution time: 0.4 ms
Returned rows: 17
SQL Query: SELECT s.session_id, s.session_data, s.last_access, u.user_id, u.user_name, u.user_access FROM rfid_sessions AS s JOIN rfid_users AS u ON u.user_id = s.user_id WHERE s.session_id = ?
Query execution time: 2.0 ms
Returned rows: 1
SQL Query: SELECT pref_key, pref_value FROM rfid_preferences WHERE user_id = ?
Query execution time: 1.9 ms
Returned rows: 0
Executing page: Common_Issues_AddAttachment
SQL Query: SELECT i.issue_id, i.issue_name, i.stamp_id, i.stub_id, i.descr_id, i.descr_stub_id, f.folder_id, f.folder_name, p.project_id, p.project_name, p.is_public, t.type_id, t.type_name, s.state_id, s.read_id, s.subscription_id, sc.stamp_time AS created_date, uc.user_id AS created_user, uc.user_name AS created_by, sm.stamp_time AS modified_date, um.user_id AS modified_user, um.user_name AS modified_by, ? AS project_access FROM rfid_issues AS i JOIN rfid_stamps AS sc ON sc.stamp_id = i.issue_id JOIN rfid_users AS uc ON uc.user_id = sc.user_id JOIN rfid_stamps AS sm ON sm.stamp_id = i.stamp_id JOIN rfid_users AS um ON um.user_id = sm.user_id JOIN rfid_folders AS f ON f.folder_id = i.folder_id JOIN rfid_projects AS p ON p.project_id = f.project_id JOIN rfid_issue_types AS t ON t.type_id = f.type_id LEFT OUTER JOIN rfid_issue_states AS s ON s.issue_id = i.issue_id AND s.user_id = ? WHERE i.issue_id = ? AND p.is_archived = 0
Query execution time: 3.4 ms
Returned rows: 1
Total execution time: 31.5 ms

Any pointers as to what I could look at next?

Many thanks, Steve