Loading...
 
Architecture / Installation

Architecture / Installation


Errors upon Upgrading from 1.8.5 to 1.9.1

posts: 84 Singapore

Hi, so sorry. I posted this topic in the Features/Usability forum. Have finally upgraded to 1.9.1.

However, after running the 1.8 to 1.9 upgrade script, I see two types of error:

<b>1. Print operations failed:</b>

Command: ALTER TABLE tiki_mailin_accounts ADD anonymous char(1) NOT NULL default 'y'
Message: Duplicate column name 'anonymous'

Command: # added on 2004-10-20 by gg. added event registration to 1.9

  1. removed on 2005-04-01 by gg. removed poor implementation of events


alter table `tiki_calendars` drop `customevent`
Message: Can't DROP 'customevent'. Check that column/key exists

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

Command: ALTER TABLE `tiki_pages` DROP column `lock`
Message: Can't DROP 'lock'. Check that column/key exists

<b>2. Warning: mysql error: Unknown column 'tikihost' in 'field list' in query:</b>

insert into `tiki_sessions`(`sessionId`,`timestamp`,`user`,`tikihost`) values(?,?,?,?)
in /home/../public_html/tiki/lib/tikidblib.php on line 134

An error occured in a database query!

Context:

File /index.php
Url /
Query:
insert into `tiki_sessions`(`sessionId`,`timestamp`,`user`,`tikihost`) values(?,?,?,?)
Values:
0 4703f5842f8a74d88a604f3108d8274e
1 1128289047
2
3 (my tiki website's URL)
Message:
Error Message Unknown column 'tikihost' in 'field list'

<b>I went ahead anyway to run the 1.9 to 1.9.1 upgrade script.</b>
My tiki site seems to be running fine.

Is there anything that I should do about the two error messages?

posts: 30

I also get that error


Warning: mysql error: Unknown column 'tikihost' in 'field list' in query:

insert into `tiki_sessions`(`sessionId`,`timestamp`,`user`,`tikihost`) values(?,?,?,?)


I haven't found a solution yet.


posts: 30

I figured this one out. I had my DB Admin run the 1.8 to 1.9 sql script, but not the 1.9 to 1.9.1. I got that error.

Then I ran the 1.9 to 1.9.1 from the tiki-install.php web page, but it would not work because my DB user account could not alter any tables. I had to ask the DB Admin to run the script and now everything is fine. razz


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