Loading...
 
Skip to main content

1.9.1 to 1.9.3.1 upgrade pb on tiki_score table

Status
Closed
Subject
1.9.1 to 1.9.3.1 upgrade pb on tiki_score table
Version
1.9.x
Category
  • Error
Feature
Installer (profiles, upgrades and server-related issues)
Score
Resolution status
Invalid
Submitted by
pwendling
Lastmod by
pwendling
Rating
(0)
Description

The install script says to run the 1.8to1.9 SQL upgrade when upgrading from a 1.9.x to another 1.9.x release.

I have and error in that script while creating the tiki_score table, which is normal because it already exists. Then, I have a bunch of errors in the following INSERT statements because the category column is missing (along ith the desription and ordd columns). Here is the output of the failed statements:

CREATE TABLE tiki_score (
event varchar(40) NOT NULL default '',
score int(11) NOT NULL default '0',
expiration int(11) NOT NULL default '0',
category text NOT NULL,
description text NOT NULL,
ord int(11) NOT NULL default '0',
PRIMARY KEY (event),
KEY ord (ord)
) TYPE=MyISAM
Message: Table 'tiki_score' already exists


Command: INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('login',1,0,'General','Login',1)
Message: Unknown column 'category' in 'field list'

.... other similar failed INSERT


Here is the tiki_score table definition that is currently in my 1.9.1 database (extracted from a mysqldump):
CREATE TABLE tiki_score (
event varchar(40) NOT NULL default '',
score int(11) NOT NULL default '0',
expiration int(11) NOT NULL default '0',
PRIMARY KEY (event)
) TYPE=MyISAM;

Solution

columns are dropped later in the SQL script:

Command: #Added June 27th lfagundes, refactoring score to have static data in php instead of db
alter table `tiki_score` drop description
Message: Can't DROP 'description'. Check that column/key exists


Command: alter table `tiki_score` drop category
Message: Can't DROP 'category'. Check that column/key exists


Command: alter table `tiki_score` drop ord
Message: Can't DROP 'ord'. Check that column/key exists


sorry for opening this bug

Importance
5
Priority
25
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
646
Created
Friday 05 May, 2006 13:42:44 UTC
by Unknown
LastModif
Sunday 03 June, 2007 08:34:39 UTC


Show PHP error messages