Improved CSWeb reconfiguration
Posted: June 11th, 2024, 6:29 pm
Today I had to change the DNS and IP of my server, where I had several surveys half done. After this, I tried to reconfigure CSWeb without deleting the database (for obvious reasons) and I ran into several problems, which I list below:
1- The triggers are created with "CREATE TRIGGER" and not with "CREATE TRIGGER IF NOT EXISTS", which causes an error that the trigger already exists.
2- The new CSWeb administrator password is inserted ignoring it if the user already exists, which makes it impossible for the new password to overwrite the previous one.
Other issues though, these were with CSWeb 8.0.0, but not CSWeb 8.0.1. Therefore, I never really found out what caused these, as i resolved my problem using a clean and new CSWeb 8.0.1. That problem also occurs to me with CSWeb 7.6 but not occurs if i use a clean install of 7.6. So, it's related with some information that are generated and that is causing the issue. Probably is needed a deletion of the whole internal files of the folder var, and not just the cache. Or is related with something in apps/config. I don't know really, It need more investigation.
Hope, that help to enhanced that procedure a bit.
1- The triggers are created with "CREATE TRIGGER" and not with "CREATE TRIGGER IF NOT EXISTS", which causes an error that the trigger already exists.
2- The new CSWeb administrator password is inserted ignoring it if the user already exists, which makes it impossible for the new password to overwrite the previous one.
Other issues though, these were with CSWeb 8.0.0, but not CSWeb 8.0.1. Therefore, I never really found out what caused these, as i resolved my problem using a clean and new CSWeb 8.0.1. That problem also occurs to me with CSWeb 7.6 but not occurs if i use a clean install of 7.6. So, it's related with some information that are generated and that is causing the issue. Probably is needed a deletion of the whole internal files of the folder var, and not just the cache. Or is related with something in apps/config. I don't know really, It need more investigation.
Hope, that help to enhanced that procedure a bit.