Fixing 404 Errors for RSForm!Pro Uploaded Files After Server Migration
When migrating a Joomla website that uses RSForm!Pro, you may notice that uploaded files from before the migration return a 404 error, even though they still exist on the server. Files uploaded after the migration usually work correctly.
Why This Happens?
This usually happens because files were copied correctly via FTP but the stored file paths in the database still point to the old server location.
Although RSForm!Pro provides a backup and restore feature for forms and submissions, uploaded files require additional manual handling. You can read more about the backup / restore functionality here.
Steps to take:
1. Make sure that all previously uploaded files are located in the correct directory on the new server. By default, RSForm!Pro stores uploaded files in:
/components/com_rsform/uploads/
If you customized the upload path in your File Upload fields, make sure to use that custom directory instead.
2. Update File Paths in the Database. RSForm!Pro stores uploaded file paths in the database table:
#__rsform_submission_values
More precisely:
- FieldName: contains the name of your File Upload field
- FieldValue: contains the stored file path
Open your database manager (e.g., phpMyAdmin) and locate the table #__rsform_submission_values. Here, search for entries related to your form (you can filter by submission ID if needed). Then, identify records where FieldName matches your File Upload field and FieldValue contains the old file path.
You can run an SQL query to update old paths to the new server path.
Always perform a full database backup before running SQL queries.
An SQL Query example would look similar to:
UPDATE #__rsform_submission_values SET FieldValue = REPLACE(FieldValue, 'old/path/', 'new/path/');
Make sure to adjust the paths according to your server configuration.
If you're unsure what the correct file path should look like, create a simple test form with a File Upload field and submit a file through the form. Then, check the #__rsform_submission_values table, locate the new entry and inspect the FieldValue. This will show you the correct format and path structure used by your current server setup.
