Am 19.07.2015 um 14:57 schrieb Francis Lachapelle:
On Jul 19, 2015, at 6:15 AM, Ghettoblaster <[email protected]> wrote:
Am 17.07.2015 um 15:08 schrieb Francis Lachapelle:
On Jul 17, 2015, at 4:17 AM, goblin <[email protected]> wrote:
Since yesterdays update in wheezy i can't set new tasks in calendar.
Logfile shows mysql error:
Jul 17 10:04:38 sogod [2197]: <0x0x7fc00e32ddd0[GCSFolder]> ERROR(-[GCSFolder
writeContent:fromComponent:container:toName:baseVersion:]): cannot insert
content : <MySQL4Exception: 0x7fc00e579eb0> NAME:ExecutionFailed
REASON:Unknown column 'c_description' in 'field list'
Jul 17 10:04:38 sogod [2197]: [ERROR]
<0x0E37D010[SOGoAppointmentObject]:d6712da1-9b8e-4ec1-b88e-f58ba4985678.ics>
write failed: <MySQL4Exception: 0x7fc00e579eb0> NAME:ExecutionFailed
REASON:Unknown column 'c_description' in 'field list'
[...]
Jul 17 10:04:38 sogod [2197]: |SOGo| starting method 'REPORT' on uri '/SOGo/
dav/user@sogoserver/Calendar/89D-54C21700-1-762C1380/'
Jul 17 10:04:38 sogod [2197]: <0x0x7fc00e0e5440[SOGoCache]> an error occurred
when caching value for key 'user@sogoserver+attributes': "WRITE FAILURE"
Jul 17 10:04:39 sogod [2197]: <0x0x7fc00e0e5440[SOGoCache]> an error occurred
when caching value for key 'user@sogoserver+attributes': "WRITE FAILURE"
Jul 17 10:04:39 sogod [2197]: <0x0x7fc00e0e5440[SOGoCache]> an error occurred
when caching value for key 'user@sogoserver+settings': "WRITE FAILURE"
What can i do to solve this error?
This has been discussed many times. The database schema has changed; you must
run sql-update-2.2.17_to_2.3.0-mysql.sh. The script should under
/usr/share/doc/sogo/. Always read the 'Upgrade' section of the installation
guide when updating your installation.
https://github.com/inverse-inc/sogo/blob/master/Documentation/SOGoInstallationGuide.asciidoc#L2721
Francis--
[email protected]
https://inverse.ca/sogo/lists
Thank you for the answer. I cant execute this script. This is the result:
# sh /usr/share/doc/sogo/sql-update-2.1.17_to_2.3.0-mysql.sh
Username (root): root
Hostname (127.0.0.1): 127.0.0.1
Database (root): databasename
/usr/share/doc/sogo/sql-update-2.1.17_to_2.3.0-mysql.sh: 41:
/usr/share/doc/sogo/sql-update-2.1.17_to_2.3.0-mysql.sh: Syntax error: "("
unexpected
Line 41 in the script is the following: "function adjustSchema() {"
Here is the complete function:
function adjustSchema() {
oldIFS="$IFS"
IFS=" "
part1="`echo -e \"ALTER TABLE $table MODIFY c_partstates mediumtext;\\n\"`";
part2="`echo -e \"ALTER TABLE $table ADD COLUMN c_description
mediumtext;\\n\"`";
sqlscript="$sqlscript$part1$part2"
IFS="$oldIFS"
}
Try to explicitly use bash instead of sh.
Francis--
[email protected]
https://inverse.ca/sogo/lists
*facepalm* you are right, thank you.
Problem was sitting in front of the screen ;)
regards
Ghettoblaster
--
[email protected]
https://inverse.ca/sogo/lists
