LetoDMS Community Forum
Update from v2.0.2 to v3.4.0RC4 - Printable Version

+- LetoDMS Community Forum (https://community.letodms.com)
+-- Forum: LetoDMS Support (https://community.letodms.com/forumdisplay.php?fid=4)
+--- Forum: General Questions (https://community.letodms.com/forumdisplay.php?fid=15)
+--- Thread: Update from v2.0.2 to v3.4.0RC4 (/showthread.php?tid=594)

Pages: 1 2 3

RE: Update from v2.0.2 to v3.4.0RC4 - steinm - 12-10-2012

(12-09-2012, 07:53 PM)John_k22 Wrote:
(12-05-2012, 02:35 AM)John_k22 Wrote:
(12-04-2012, 01:38 PM)steinm Wrote: 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

RE: Update from v2.0.2 to v3.4.0RC4 - John_k22 - 12-10-2012

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


RE: Update from v2.0.2 to v3.4.0RC4 - steinm - 12-11-2012

(12-10-2012, 11:34 PM)John_k22 Wrote: 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

RE: Update from v2.0.2 to v3.4.0RC4 - John_k22 - 12-11-2012

great, tblDocumentContent is now innoDB without any error Smile

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

RE: Update from v2.0.2 to v3.4.0RC4 - steinm - 12-11-2012

(12-11-2012, 03:25 AM)John_k22 Wrote: great, tblDocumentContent is now innoDB without any error Smile

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

RE: Update from v2.0.2 to v3.4.0RC4 - John_k22 - 12-12-2012

ok, thanks Uwe Smile