Ok so we managed to remove the FAQ module, but the problem with the SQL syntax everywhere remains and our autoresponses are still broken.
Is there a known incompatibility issue with MySQL 8.0.34 and Znuny?
Search found 7 matches
- 26 Mar 2024, 20:37
- Forum: Help
- Topic: Errors with autoresponses + FAQ + UI
- Replies: 4
- Views: 1875
- 26 Mar 2024, 20:20
- Forum: Help
- Topic: Errors with autoresponses + FAQ + UI
- Replies: 4
- Views: 1875
Re: Errors with autoresponses + FAQ + UI
Ended up fixing the interface using the Admin::Config::FixMissingFrontendFiles console command but our autoresponses are still gone... Even trying to manually add an autoresponse gives us a similar SQL syntax error as before: You have an error in your SQL syntax; check the manual that corresponds to...
- 26 Mar 2024, 20:00
- Forum: Help
- Topic: Errors with autoresponses + FAQ + UI
- Replies: 4
- Views: 1875
Re: Errors with autoresponses + FAQ + UI
Trying to install the FAQ module from package manager gives us: Backend ERROR: Znuny-CGI-10 Perl: 5.16.3 OS: linux Time: Tue Mar 26 17:59:47 2024 Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'content_ty...
- 26 Mar 2024, 19:47
- Forum: Help
- Topic: Errors with autoresponses + FAQ + UI
- Replies: 4
- Views: 1875
Errors with autoresponses + FAQ + UI
Hello, We're in a bit of a bind. We were running Znuny 6.4.3, yesterday, the DB server that the OTRS DB was on was updated from MySQL 8.0.32 to 8.0.34. Apparently, Znuny didn't like that and though the autoresponses were still in the DB tables, we couldn't see them listed at all on the interface nor...
- 20 Oct 2022, 22:18
- Forum: Help
- Topic: [solved]6.3.4 -> 6.4.3 upgrade breaks the web interface
- Replies: 3
- Views: 452
Re: 6.3.4 -> 6.4.3 upgrade breaks the web interface
Ok, progress... seems like a "lack of documentation" issue. To clarify, I used this before: https://base.url.com which would automatically redirect to https://base.url.com/index.pl Now, the base.url.com is a blank page and the base.url.com/index.pl gives a 404 error. HOWEVER, we tried simp...
- 20 Oct 2022, 21:57
- Forum: Help
- Topic: [solved]6.3.4 -> 6.4.3 upgrade breaks the web interface
- Replies: 3
- Views: 452
Re: 6.3.4 -> 6.4.3 upgrade breaks the web interface
Hi Roy, I didn't touch the file in question, I assumed it would keep using the old configuration that was already present/working before. I ran a dif, comparing both files /etc/httpd/conf/httpd.conf before and post-upgrade and both are identical. I also did the same for both before/post upgrade file...
- 20 Oct 2022, 20:43
- Forum: Help
- Topic: [solved]6.3.4 -> 6.4.3 upgrade breaks the web interface
- Replies: 3
- Views: 452
[solved]6.3.4 -> 6.4.3 upgrade breaks the web interface
Hello, We are having difficulties upgrading from 6.3.4 to 6.4.3 following this guide https://doc.znuny.org/manual/releases/installupdate/update/update-6.4.html Everything appears to work fine during the update process itself which was followed to the letter. Twice actually, the first time gave us an...