Hi Ian,
Please run this script as a sogo user.
Thanks,
Kamaldeep Singh
On Monday 08 June 2015 04:47 PM, Ian wrote:
Hello Kamaldeep, and thanks for the reply.
My /usr/share/doc/sogo contains the following:
apache.conf sql-update-1.2.2_to_1.3.0-mysql.sh
sql-update-20070724.sh
changelog.Debian.gz sql-update-1.2.2_to_1.3.0.sh
sql-update-20070822.sh
changelog.gz sql-update-1.3.11_to_1.3.12-mysql.sh
sql-update-20080303.sh
copyright sql-update-1.3.11_to_1.3.12.sh
sql-update-2.0.4b_to_2.0.5-mysql.sh
NEWS.gz sql-update-1.3.16_to_1.3.17-mysql.sh
sql-update-2.1.17_to_2.3.0-mysql.sh
SOGo-apple-ab.conf sql-update-1.3.16_to_1.3.17.sh
sql-update-2.1.17_to_2.3.0.sh
sogo-backup.sh sql-update-1.3.3_to_1.3.4-mysql.sh updates.php
sql-update-101_to_102.sh sql-update-1.3.3_to_1.3.4.sh
I ran sql-update-2.1.17_to_2.3.0-mysql.sh, but I'm still getting errors:
Jun 08 11:14:33 sogod [12323]: [ERROR] <0x0xb8012e90[GCSFolder]>
-[GCSFolder _generateInsertStatementForRow:adaptor:tableName:]: no
type found for column name c_description
2015-06-08 11:14:33.128 sogod[12323] <MySQL4Channel[0x0xb7a28078]
connection=0x0xb7ad7be0> SQL: INSERT INTO
sogojinnycru0042207df01_quick (c_isopaque, c_partstates, c_isallday,
c_nextalarm, c_participants, c_status, c_sequence, c_component,
c_priority, c_enddate, c_description, c_category, c_iscycle,
c_location, c_title, c_uid, c_partmails, c_classification,
c_startdate, c_orgmail, c_name) VALUES (1, '0', 0, 0, 'Jinny
Crum-Jones', 1, 2, 'vevent', 0, 1433746200, 'Divers', 0, '', 'Test
event', '08877588-fd70-4a0e-94bf-976524d02966', '[email protected]',
0, 1433742600, '[email protected]',
'08877588-fd70-4a0e-94bf-976524d02966.ics');
2015-06-08 11:14:33.128 sogod[12323] <MySQL4Channel[0x0xb7a28078]
connection=0x0xb7ad7be0> ERROR: Column count doesn't match value count
at row 1
Regards
Ian
Le 08/06/2015 12:44, Kamaldeep Singh a écrit :
Hi Ian,
If you had upgraded the SOGO to 2.3 then you need to run database
upgrade script which may be located in /usr/share/doc/sogo-2.3.0.
Thanks,
Kamaldeep Singh
On Monday 08 June 2015 08:53 AM, Ian wrote:
Hello!
I am getting errors like the following:
SQL: INSERT INTO sogojinnycru0060246e923_quick (c_isopaque,
c_partstates, c_isallday, c_nextalarm, c_status, c_sequence,
c_component, c_priority, c_enddate, c_iscycle, c_category,
c_description, c_location, c_title, c_uid, c_classification,
c_startdate, c_orgmail, c_name) VALUES (1, '', 0, 0, 1, 0, 'vevent',
0, 1438187220, 0, null, 'ORD to MCO', 'flight:',
'743058BD-AA78-477E-B1A2-9732E73ED4B3', 0, 1438177200, '',
'743058BD-AA78-477E-B1A2-9732E73ED4B3.ics');
2015-06-08 03:15:10.261 sogod[9757] <MySQL4Channel[0x0xb98d33e8]
connection=0x0xb999d580> ERROR: Column count doesn't match value
count at row 1
And indeed, if you count the fields and values there are 19 and 18
respectively. Any suggestions?
Thanks,
Ian
dpkg -s sogo
Package: sogo
Status: install ok installed
Priority: optional
Section: web
Installed-Size: 12577
Maintainer: Inverse Support <[email protected]>
Architecture: i386
Multi-Arch: same
Version: 2.3.0-1
--
Kamaldeep Singh
System Administrator
Direct: +91 124 4548380
Tel: +91 124 4548383 Ext- 1007
UK: +44 845 0047 142 Ext- 5010
TBS Website <http://www.techbluesoftware.co.in>
Techblue Software Pvt. Ltd
The Palms, Plot No 73, Sector 5, IMT Manesar,
Gurgaon- 122050 (Hr.)
www.techbluesoftware.co.in <http://www.techbluesoftware.co.in>
TBS Facebook
<https://www.facebook.com/pages/Techblue-Software-Limited/441777369284888>
TBS Twitter <https://twitter.com/TechbluSoftware> TBS Google+
<https://plus.google.com/+TechblueSoftwareCoIn> TBS Linked In
<https://www.linkedin.com/company/techblue-softwares-pvt-ltd>
TBS Branding <http://www.techbluesoftware.co.in>
--
Kamaldeep Singh
System Administrator
Direct: +91 124 4548380
Tel: +91 124 4548383 Ext- 1007
UK: +44 845 0047 142 Ext- 5010
TBS Website <http://www.techbluesoftware.co.in>
Techblue Software Pvt. Ltd
The Palms, Plot No 73, Sector 5, IMT Manesar,
Gurgaon- 122050 (Hr.)
www.techbluesoftware.co.in <http://www.techbluesoftware.co.in>
TBS Facebook
<https://www.facebook.com/pages/Techblue-Software-Limited/441777369284888>
TBS Twitter <https://twitter.com/TechbluSoftware> TBS Google+
<https://plus.google.com/+TechblueSoftwareCoIn> TBS Linked In
<https://www.linkedin.com/company/techblue-softwares-pvt-ltd>
TBS Branding <http://www.techbluesoftware.co.in>
--
[email protected]
https://inverse.ca/sogo/lists
