Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Update from v2.0.2 to v3.4.0RC4
12-10-2012, 01:34 PM,
#21
RE: Update from v2.0.2 to v3.4.0RC4
(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
Reply
12-10-2012, 11:34 PM,
#22
RE: Update from v2.0.2 to v3.4.0RC4
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
Reply
12-11-2012, 02:16 AM,
#23
RE: Update from v2.0.2 to v3.4.0RC4
(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
Reply
12-11-2012, 03:25 AM, (This post was last modified: 12-11-2012, 03:26 AM by John_k22.)
#24
RE: Update from v2.0.2 to v3.4.0RC4
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
Reply
12-11-2012, 10:52 PM,
#25
RE: Update from v2.0.2 to v3.4.0RC4
(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
Reply
12-12-2012, 08:12 PM,
#26
RE: Update from v2.0.2 to v3.4.0RC4
ok, thanks Uwe Smile
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)

Contact Us | LetoDMS Community Forum | Return to Top | | Lite (Archive) Mode | RSS Syndication