Hello again:
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_description'
The column is there:
mysql> show columns from sogojinnycru0042207df01_quick;
+------------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------+------+-----+---------+-------+
| c_name | varchar(255) | NO | PRI | NULL | |
| c_uid | varchar(255) | NO | | NULL | |
| c_startdate | int(11) | YES | | NULL | |
| c_enddate | int(11) | YES | | NULL | |
| c_cycleenddate | int(11) | YES | | NULL | |
| c_title | varchar(1000) | NO | | NULL | |
| c_participants | mediumtext | YES | | NULL | |
| c_isallday | int(11) | YES | | NULL | |
| c_iscycle | int(11) | YES | | NULL | |
| c_cycleinfo | mediumtext | YES | | NULL | |
| c_classification | int(11) | NO | | NULL | |
| c_isopaque | int(11) | NO | | NULL | |
| c_status | int(11) | NO | | NULL | |
| c_priority | int(11) | YES | | NULL | |
| c_location | varchar(255) | YES | | NULL | |
| c_orgmail | varchar(255) | YES | | NULL | |
| c_partmails | mediumtext | YES | | NULL | |
| c_partstates | mediumtext | YES | | NULL | |
| c_category | varchar(255) | YES | | NULL | |
| c_sequence | int(11) | YES | | NULL | |
| c_component | varchar(10) | NO | | NULL | |
| c_nextalarm | int(11) | YES | | NULL | |
| c_description | mediumtext | YES | | NULL | |
+------------------+---------------+------+-----+---------+-------+
23 rows in set (0.00 sec)
Regards,
Ian
Le 08/06/2015 14:02, Kamaldeep Singh a
écrit :
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
|
