...
Update DATABASE with your MySQL database name, USER with your MySQL database username, and PASSWORD with your MySQL password.
Do you use the plugin "Client Documents"?
The full path to documents uploaded to Blesta through the Client Documents plugin are stored in the file_name column of the client_documents table. It may be necessary to run a REPLACE query to update the path. Here's an example:
| Code Block | ||
|---|---|---|
| ||
UPDATE client_documents
SET file_name = REPLACE(file_name, "/home/YOUROLDPATH", "/home/YOURNEWPATH"); |
Replace /home/YOUROLDPATH with the original path to the parent directory of your "uploads" directory. Update /home/YOURNEWPATH to the new parent directory of "uploads".
Records that look like this:
/home/oldpath/uploads/1/client_documents/20170512T014003+0000_188634ee3bb69c9c40ae90cb52cd2fde.pdf
Would be changed to look like this:
/home/newpath/uploads/1/client_documents/20170512T014003+0000_188634ee3bb69c9c40ae90cb52cd2fde.pdf
Final Steps
You are almost done. All that remains is to re-issue your license key, double check your paths in the settings, and set up your cron.
...