Update from v2.0.2 to v3.4.0RC4

[steinm]

tblDirPath (and tblPathList) are obsolete, Do the other tables work?

I got this error with 2 tables tblDirPath and tblDocumentContent.

Error: #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

John

Hi Uwe, can you please give me an advise how I should go on with this problem?

Can you give me the output of

show create table tblDocumentContent;

in your mysql console?

Uwe

[John_k22]

Hi, the outbut is:

Code:

SQL-Abfrageergebnis
Host: localhost
Datenbank: letodms3311
Erstellungszeit: 10. Dez 2012 um 18:48
Erstellt von: phpMyAdmin 3.5.3 / MySQL 5.1.49
SQL-Befehl: show create table tblDocumentContent;
Datensätze: 1

Table: tblDocumentContent
Create Table:
CREATE TABLE `tblDocumentContent` (
`document` int(11) NOT NULL DEFAULT '0',
`version` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`comment` text,
`date` int(12) DEFAULT NULL,
`createdBy` int(11) DEFAULT NULL,
`dir` varchar(255) NOT NULL DEFAULT '',
`orgFileName` varchar(150) NOT NULL DEFAULT '',
`fileType` varchar(10) NOT NULL DEFAULT '',
`mimeType` varchar(100) DEFAULT NULL,
PRIMARY KEY (`document`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

[steinm]

Hi, the outbut is:

Code:

SQL-Abfrageergebnis
Host: localhost
Datenbank: letodms3311
Erstellungszeit: 10. Dez 2012 um 18:48
Erstellt von: phpMyAdmin 3.5.3 / MySQL 5.1.49
SQL-Befehl: show create table tblDocumentContent;
Datensätze: 1

Table: tblDocumentContent
Create Table:
CREATE TABLE `tblDocumentContent` (
`document` int(11) NOT NULL DEFAULT '0',
`version` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`comment` text,
`date` int(12) DEFAULT NULL,
`createdBy` int(11) DEFAULT NULL,
`dir` varchar(255) NOT NULL DEFAULT '',
`orgFileName` varchar(150) NOT NULL DEFAULT '',
`fileType` varchar(10) NOT NULL DEFAULT '',
`mimeType` varchar(100) DEFAULT NULL,
PRIMARY KEY (`document`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Try this

alter table tblDocumentContent change version version smallint(5);
alter table tblDocumentContent drop primary key;
alter table tblDocumentContent add unique index (`document`, `version`);
alter table tblDocumentContent engine=innodb;

This should make the table upgradable for 3.4.0

Uwe

[John_k22]

great, tblDocumentContent is now innoDB without any error

Should I do the same with tblDirPath ? Or just leave it on myisam?

All tables language is latin1_swedish_ci. Should I change them to utf8_general_ci?

John

[steinm]

great, tblDocumentContent is now innoDB without any error

Should I do the same with tblDirPath ? Or just leave it on myisam?

All tables language is latin1_swedish_ci. Should I change them to utf8_general_ci?

No need to care about tblDirPath. Setting the collation to utf8_general_ci isn't crucial but is in general a good idea.

Uwe

[John_k22]

ok, thanks Uwe