Loading...
 
Architecture / Installation

Architecture / Installation


During 6.3→7.0: Two SQL statements return errors

posts: 26

I'm in the process of updating an almost empty installation of TW 6.3 to TW 7.0.

While running tiki-install.php, in step 6 two SQL statements return errors:

SQL
Copy to clipboard
ALTER TABLE `tiki_sefurl_regex_out` ADD UNIQUE `left` (`left`(128)) Duplicate key name 'left' ALTER TABLE `tiki_polls` ADD `anonym` ENUM( 'a', 'u', 'i', 'c' ) NOT NULL DEFAULT 'u' Duplicate column name 'anonym'


The TW 6.3 installation at hand was a »fresh« installation – it was not updated from an earlier TW version.

The website runs on Fedora 14 Linux / Apache 2.2.17 / PHP 5.3.6 / mySQL 5.1.56, and indeed uses the SEFURL feature, but I'm not sure if this really is a problem as such, but rather it seems the operator »left« was unintentionally duplicated in the code base, so this might be an error which shows up with other environments as well.

Regarding the second error, the website in question doesn't make use of polls (the feature is disabled).

So, If you think that the errors of a patch can be ignored, please check the checkbox associated to it before clicking on continue is truely a good question – but I've no idea what to answer. eek

Any hints?
Thx! – Dan

posts: 1001 Canada
These are known problems. You can check the boxes.
posts: 26

Thx. for the prompt reply, Chealer9!
Cheers – Dan.


posts: 2

I have 4 tables with error: "Incorrect table definition; there can be only one auto column and it must be defined as a key"
(tiki_acct_journal , tiki_acct_stack , tiki_acct_statement , tiki_acct_tax )

To solve it I had to add ENGINE=MyISAM

Like:

CREATE TABLE IF NOT EXISTS tiki_acct_tax (
taxBookId int(10) unsigned NOT NULL,
taxId int(10) unsigned NOT NULL AUTO_INCREMENT,
taxText varchar(63) NOT NULL,
taxAmount double NOT NULL DEFAULT '0',
taxIsFix enum('y','n') NOT NULL DEFAULT 'n',
PRIMARY KEY (taxBookId,taxId)
) ENGINE=MyISAM


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting