Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

Forums » Features / Usability » How Can I ReRun the Install Script
 
Thread actions
Print this page
  • Print all pages

    • How Can I ReRun the Install Script

    Posted by bigjet posts: 32 United States

    Maybe it is better to ask, is it possible to Recall the Install Script? If so, how? My server is shared with only FTP access, and has phpMyAdmin - which will not run the tiki_1.8to1.9.sql script, or that is, I can't get it to run any scripts other then sql table queries and uploaded dumps. I could put php code in a file and upload to the server then execute with my browser, but that would expose the the database user name and password to every browser on the net, which makes it a very bad idea. Recalling the Tiki Install script is my only alternative other then deleting 190, reupload and try the install again from scratch.

    Anyone been down this road before and solved the problem?
    -- best regards, bigjet.

    Reads: 1260
    Posted by sylvie greverend posts: 1092

    You can rerun tiki-install.php
    and choose run tiki_1.8to1.9.sql only with no problem


    Posted by bigjet posts: 32 United States
    Thanks a million, Sylvie; it worked great first try. It seems to have copied all my 185 files and graphics, and yes, even the scripted pages are intact on the 190. This might be useful for others who want to change servers and upgrade at the same time.

    Posted by sooeydoo posts: 68

    But I've done it infinite times and I still keep getting errors. The following operations never succeed, they always pop up in the failed operations box - Ive tried them so many times without success:

    Image
    Copy to clipboard
    ALTER TABLE galaxia_instances ADD name varchar(200) default 'No Name' NOT NULL AFTER started;



    		    		 ALTER TABLE galaxia_activities ADD expirationTime int(6) unsigned default 0;



    		    		 ALTER TABLE tiki_mailin_accounts ADD anonymous char(1) NOT NULL default 'y';



    		    		 ALTER TABLE tiki_tracker_fields ADD position int(4) default NULL;



    		    		 ALTER TABLE tiki_tracker_item_attachments ADD longdesc blob;



    		    		 ALTER TABLE tiki_tracker_item_attachments ADD version varchar(40) default NULL;



    		    		 ALTER TABLE tiki_trackers ADD showComments char(1) default NULL;



    		    		 ALTER TABLE tiki_trackers ADD orderAttachments varchar(255) NOT NULL default 'filename,created,filesize,downloads,desc';



    		    		 ALTER TABLE `users_groups` ADD `usersTrackerId` INT(11) ;



    		    		 ALTER TABLE `users_groups` ADD `groupTrackerId` INT(11) ;



    		    		ALTER TABLE `tiki_tracker_fields` ADD `isSearchable` CHAR(1) NOT NULL default 'y';



    		    	ALTER TABLE `tiki_blog_posts` ADD `priv` VARCHAR( 1 );



    		    		CREATE TABLE tiki_tracker_options (
  trackerId int(12) NOT NULL default '0',
  name varchar(80) NOT NULL default '',
  value text default NULL,
  PRIMARY KEY (trackerId,name(30))
) TYPE=MyISAM ;


    		    		ALTER TABLE tiki_tracker_fields ADD isPublic varchar ( 1 ) default NULL;



    		    		ALTER TABLE `tiki_user_votings` ADD optionId int(10) NOT NULL default '0';



    		    		ALTER TABLE `tiki_blogs` ADD `show_avatar` char(1) default NULL;



    		    		INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_view_trackers_pending', 'Can view trackers pending items', 'editors', 'trackers');



    		    		 ALTER TABLE `tiki_tracker_fields` ADD `isHidden` varchar ( 1 ) DEFAULT 'n' NOT NULL ;



    		    		INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_view_trackers_closed', 'Can view trackers pending items', 'registered', 'trackers');


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;



    		    		 CREATE TABLE users_score (
  user char(40) NOT NULL default '',
  event_id char(40) NOT NULL default '',
  score int(11) NOT NULL default '0',
  expire datetime NOT NULL default '0000-00-00 00:00:00',
  tstamp timestamp(14) NOT NULL,
  PRIMARY KEY  (user,event_id),
  KEY user (user,event_id,expire)
) TYPE=MyISAM;



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('login',1,0,'General','Login',1);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('login_remain',2,60,'General','Stay logged',2);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('profile_fill',10,0,'General','Fill each profile field',3);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('profile_see',2,0,'General','See other user\'s profile',4);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('profile_is_seen',1,0,'General','Have your profile seen',5);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('friend_new',10,0,'General','Make friends (feature not available yet)',6);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('message_receive',1,0,'General','Receive message',7);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('message_send',2,0,'General','Send message',8);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('article_read',2,0,'Articles','Read an article',9);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('article_comment',5,0,'Articles','Comment an article',10);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('article_new',20,0,'Articles','Publish an article',11);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('article_is_read',1,0,'Articles','Have your article read',12);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('article_is_commented',2,0,'Articles','Have your article commented',13);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('fgallery_new',10,0,'File galleries','Create new file gallery',14);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('fgallery_new_file',10,0,'File galleries','Upload new file to gallery',15);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('fgallery_download',5,0,'File galleries','Download other user\'s file',16);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('fgallery_is_downloaded',5,0,'File galleries','Have your file downloaded',17);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('igallery_new',10,0,'Image galleries','Create a new image gallery',18);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('igallery_new_img',6,0,'Image galleries','Upload new image to gallery',19);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('igallery_see_img',3,0,'Image galleries','See other user\'s image',20);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('igallery_img_seen',1,0,'Image galleries','Have your image seen',21);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('blog_new',20,0,'Blogs','Create new blog',22);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('blog_post',5,0,'Blogs','Post in a blog',23);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('blog_read',2,0,'Blogs','Read other user\'s blog',24);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('blog_comment',2,0,'Blogs','Comment other user\'s blog',25);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('blog_is_read',3,0,'Blogs','Have your blog read',26);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('blog_is_commented',3,0,'Blogs','Have your blog commented',27);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('wiki_new',10,0,'Wiki','Create a new wiki page',28);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('wiki_edit',5,0,'Wiki','Edit an existing page',29);



    		    		 INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('wiki_attach_file',3,0,'Wiki','Attach file',30);


CREATE TABLE tiki_logs (
  logId int(8) NOT NULL auto_increment,
  logtype varchar(20) NOT NULL,
  logmessage text NOT NULL,
  loguser varchar(200) NOT NULL,
  logip varchar(200) NOT NULL,
  logclient text NOT NULL,
  logtime int(14) NOT NULL,
  PRIMARY KEY  (logId),
  KEY logtype (logtype)
) TYPE=MyISAM;



    		    		
CREATE TABLE `tiki_shoutbox_words` (
  word VARCHAR( 40 ) NOT NULL ,
  qty INT DEFAULT '0' NOT NULL ,
  PRIMARY KEY ( `word` )
) TYPE=MyISAM;



    		    		ALTER TABLE `users_groups` ADD `usersFieldId` INT( 11 ), ADD `groupFieldId` INT( 11 );



    		    		ALTER TABLE `tiki_tracker_fields` ADD `isMandatory` varchar ( 1 ) DEFAULT 'n' NOT NULL ;



    		    		ALTER TABLE `tiki_articles` ADD `topline` VARCHAR( 255 ) AFTER `articleId` ;



    		    		 ALTER TABLE `tiki_articles` ADD `subtitle` VARCHAR( 255 ) AFTER `title` ;



    		    		 ALTER TABLE `tiki_articles` ADD `linkto` VARCHAR( 255 ) AFTER `subtitle` ;



    		    		 ALTER TABLE `tiki_articles` ADD `image_caption` TEXT AFTER `image_name` ;



    		    		 ALTER TABLE `tiki_submissions` ADD `topline` VARCHAR( 255 ) AFTER `subId` ;



    		    		 ALTER TABLE `tiki_submissions` ADD `subtitle` VARCHAR( 255 ) AFTER `title` ;



    		    		 ALTER TABLE `tiki_submissions` ADD `linkto` VARCHAR( 255 ) AFTER `subtitle` ;



    		    		 ALTER TABLE `tiki_submissions` ADD `image_caption` TEXT AFTER `image_name` ;



    		    		ALTER TABLE `tiki_articles` ADD `lang` VARCHAR( 16 ) AFTER `linkto` ;



    		    		 ALTER TABLE `tiki_submissions` ADD `lang` VARCHAR( 16 ) AFTER `linkto` ;



    		    		 ALTER TABLE `tiki_article_types` ADD `show_topline` CHAR( 1 ) AFTER `show_size` ;



    		    		 ALTER TABLE `tiki_article_types` ADD `show_subtitle` CHAR( 1 ) AFTER `show_topline` ;



    		    		 ALTER TABLE `tiki_article_types` ADD `show_linkto` CHAR( 1 ) AFTER `show_subtitle` ;



    		    		 ALTER TABLE `tiki_article_types` ADD `show_image_caption` CHAR( 1 ) AFTER `show_linkto` ;



    		    		 ALTER TABLE `tiki_article_types` ADD `show_lang` CHAR( 1 ) AFTER `show_image_caption` ;



    		    		INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_admin_sheet', 'Can admin sheet', 'admin', 'sheet');



    		    		 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_edit_sheet', 'Can create and edit sheets', 'editors', 'sheet');



    		    		 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_view_sheet', 'Can view sheet', 'basic', 'sheet');



    		    		 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_view_sheet_history', 'Can view sheet history', 'admin', 'sheet');



    		    		CREATE TABLE tiki_sheet_values (
  sheetId int(8) NOT NULL default '0',
  begin int(10) NOT NULL default '0',
  end int(10) default NULL,
  rowIndex int(4) NOT NULL default '0',
  columnIndex int(4) NOT NULL default '0',
  value varchar(255) default NULL,
  calculation varchar(255) default NULL,
  width int(4) NOT NULL default '1',
  height int(4) NOT NULL default '1',
  UNIQUE KEY sheetId (sheetId,begin,rowIndex,columnIndex),
  KEY sheetId_2 (sheetId,rowIndex,columnIndex)
) TYPE=MyISAM;



    		    		 CREATE TABLE tiki_sheets (
  sheetId int(8) NOT NULL auto_increment,
  title varchar(200) NOT NULL default '',
  description text,
  author varchar(200) NOT NULL default '',
  PRIMARY KEY  (sheetId)
) TYPE=MyISAM;



    		    		ALTER TABLE `tiki_quicktags` ADD `tagcategory` CHAR( 255 ) AFTER `tagicon` ;



    		    		 ALTER TABLE `tiki_quicktags` ADD INDEX `tagcategory` (`tagcategory`);



    		    		 ALTER TABLE `tiki_quicktags` ADD INDEX `taglabel` (`taglabel`);



    		    		CREATE TABLE tiki_sheet_layout (
  sheetId int(8) NOT NULL default '0',
  begin int(10) NOT NULL default '0',
  end int(10) default NULL,
  headerRow int(4) NOT NULL default '0',
  footerRow int(4) NOT NULL default '0',
  className varchar(64) default NULL,
  UNIQUE KEY sheetId (sheetId,begin)
) TYPE=MyISAM;



    		    		 ALTER TABLE `tiki_pages` ADD `lang` VARCHAR( 16 ) AFTER `page_size` ;



    		    		
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_send_newsletters', 'Can send newsletters', 'admin', 'newsletters')



    		    		
ALTER TABLE `tiki_quizzes` ADD `immediateFeedback` char(1) default NULL ;



    		    		 ALTER TABLE `tiki_quizzes` ADD `showAnswers` char(1) default NULL ;



    		    		 ALTER TABLE `tiki_quizzes` ADD `shuffleQuestions` char(1) default NULL ;



    		    		 ALTER TABLE `tiki_quizzes` ADD `shuffleAnswers` char(1) default NULL ;



    		    		 ALTER TABLE `tiki_quizzes` ADD `publishDate` int(14) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `expireDate` int(14) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `bDeleted` char(1) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `nVersion` int(4) NOT NULL ;



    		    		 ALTER TABLE `tiki_quizzes` ADD `nAuthor` int(4) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `bOnline` char(1) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `bRandomQuestions` char(1) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `nRandomQuestions` tinyint(4) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `bLimitQuestionsPerPage` char(1) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `nLimitQuestionsPerPage` tinyint(4) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `bMultiSession` char(1) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `nCanRepeat` tinyint(4) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `sGradingMethod` varchar(80) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `sShowScore` varchar(80) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `sShowCorrectAnswers` varchar(80) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `sPublishStats` varchar(80) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `bAdditionalQuestions` char(1) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `bForum` char(1) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `sForum` varchar(80) default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `sPrologue` text default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `sData` text default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `sEpilogue` text default NULL;



    		    		 ALTER TABLE `tiki_quizzes` ADD `passingperct` int(4) default 0;



    		    		 CREATE TABLE `tiki_user_answers_uploads` (
  `answerUploadId` int(4) NOT NULL auto_increment,
  `userResultId` int(11) NOT NULL default '0',
  `questionId` int(11) NOT NULL default '0',
  `filename` varchar(255) NOT NULL default '',
  `filetype` varchar(64) NOT NULL default '',
  `filesize` varchar(255) NOT NULL default '',
  `filecontent` longblob NOT NULL,
  PRIMARY KEY  (`answerUploadId`)
) TYPE=MyISAM;



    		    		ALTER TABLE tiki_sheet_values ADD format varchar(255) default NULL;



    		    		CREATE TABLE tiki_translated_objects (
  traId int(14) NOT NULL auto_increment,
  type varchar(50) NOT NULL,
  objId varchar(255) NOT NULL,
  lang varchar(16) default NULL,
  PRIMARY KEY (type, objId),
  KEY ( traId)
) TYPE=MyISAM AUTO_INCREMENT=1;



    		    		 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_list_users', 'Can list registered users', 'registered', 'community');



    		    		 CREATE TABLE tiki_friends (
  user char(40) NOT NULL default '',
  friend char(40) NOT NULL default '',
  PRIMARY KEY  (user,friend)
) TYPE=MyISAM;



    		    		 CREATE TABLE tiki_friendship_requests (
  userFrom char(40) NOT NULL default '',
  userTo char(40) NOT NULL default '',
  tstamp timestamp(14) NOT NULL,
  PRIMARY KEY  (userFrom,userTo)
) TYPE=MyISAM;



    		    		
ALTER TABLE users_score RENAME TO tiki_users_score;



    		    		 ALTER TABLE users_users ADD score int4 NOT NULL default 0;



    		    		
ALTER TABLE `tiki_articles` ADD `bibliographical_references` TEXT DEFAULT NULL AFTER `created` , ADD `resume` TEXT DEFAULT NULL AFTER `bibliographical_references`;



    		    		 ALTER TABLE `tiki_submissions` ADD `bibliographical_references` TEXT DEFAULT NULL AFTER `created` , ADD `resume` TEXT DEFAULT NULL AFTER `bibliographical_references`;



    		    		
ALTER TABLE `tiki_mailin_accounts` ADD `article_topicId` int(4) DEFAULT NULL , ADD `article_type` varchar(50) DEFAULT NULL;



    		    		
alter table `tiki_score` drop description;



    		    		 alter table `tiki_score` drop category;



    		    		 alter table `tiki_score` drop ord;



    		    		
alter table `tiki_users_score` drop score;



    		    		
CREATE TABLE tiki_structure_versions (
  structure_id int(14) NOT NULL auto_increment,
  version int(14) default NULL,
  PRIMARY KEY  (structure_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;



    		    		 ALTER TABLE `tiki_structures` ADD `structure_id` int(14) NOT NULL AFTER `page_ref_id`;



    		    		 ALTER TABLE `tiki_structures` ADD `page_version` int(8) default NULL AFTER `page_id`;



    		    		
CREATE TABLE `tiki_download` (
  `id` int(11) NOT NULL auto_increment,
  `object` varchar(255) NOT NULL default '',
  `userId` int(8) NOT NULL default '0',
  `type` varchar(20) NOT NULL default '',
  `date` int(14) NOT NULL default '0',
  `IP` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `object` (`object`,`userId`,`type`),
  KEY `userId` (`userId`),
  KEY `type` (`type`),
  KEY `date` (`date`)
) TYPE=MyISAM ;



    		    	
ALTER TABLE `tiki_galleries` ADD `geographic` char(1) default NULL AFTER `visible`;



    		    		 ALTER TABLE `tiki_images` ADD `lat` float default NULL AFTER `description`;



    		    		 ALTER TABLE `tiki_images` ADD `lon` float default NULL AFTER `description`;



    		    	
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_view_comments', 'Can view wiki coments', 'basic', 'wiki');


    		    		 insert into users_grouppermissions (groupName,permName) values('Anonymous','tiki_p_wiki_view_comments');



    		    		
ALTER TABLE tiki_galleries ADD COLUMN (
        sortorder VARCHAR(20) NOT NULL DEFAULT 'created',
        sortdirection VARCHAR(4) NOT NULL DEFAULT 'desc',
        galleryimage VARCHAR(20) NOT NULL DEFAULT 'first',
        parentgallery int(14) NOT NULL default -1,
        showname char(1) NOT NULL DEFAULT 'y',
        showimageid char(1) NOT NULL DEFAULT 'n',
        showdescription char(1) NOT NULL DEFAULT 'n',
        showcreated char(1) NOT NULL DEFAULT 'n',
        showuser char(1) NOT NULL DEFAULT 'n',
        showhits char(1) NOT NULL DEFAULT 'y',
        showxysize char(1) NOT NULL DEFAULT 'y',
        showfilesize char(1) NOT NULL DEFAULT 'n',
        showfilename char(1) NOT NULL DEFAULT 'n',
        defaultscale varchar(10) NOT NULL DEFAULT 'o'
);



    		    		 alter table tiki_galleries_scales add column (scale int(11) NOT NULL default 0);



    		    		 update tiki_galleries_scales set scale=greatest(xsize,ysize);



    		    		 alter table tiki_galleries_scales drop column xsize;



    		    		 alter table tiki_galleries_scales drop column ysize;



    		    		
alter table `tiki_calendars` drop `customevent`;



    		    		 alter table `tiki_calendar_items` drop `evId`;



    		    		
ALTER TABLE `tiki_calendar_items` ADD `nlId` INT( 12 ) DEFAULT '0' NOT NULL AFTER `categoryId` ;



    		    		 ALTER TABLE `tiki_calendars` ADD `customsubscription` ENUM('n','y') DEFAULT 'n' NOT NULL AFTER `customparticipants` ;



    		    		
ALTER TABLE `tiki_pages` ADD `lockedby` VARCHAR(200) default NULL;



    		    		 ALTER TABLE  `tiki_pages` DROP column `lock`;



    		    		
ALTER TABLE `tiki_images_data` ADD `etag` varchar(32) default NULL;



    		    		 alter table tiki_user_modules add parse char(1) default NULL;



    		    	
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_view_ratings', 'Can view rating of wiki pages', 'basic', 'wiki');



    		    		 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_vote_ratings', 'Can participate to rating of wiki pages', 'registered', 'wiki');



    		    		 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_admin_ratings', 'Can add and change ratings on wiki pages', 'admin', 'wiki');



    		    		 CREATE TABLE `tiki_poll_objects` (
  `catObjectId` int(11) NOT NULL default '0',
  `pollId` int(11) NOT NULL default '0',
  `title` varchar(255) default NULL,
  PRIMARY KEY  (`catObjectId`,`pollId`)
) TYPE=MyISAM;



    		    		 ALTER TABLE `tiki_poll_options` ADD `position` INT( 4 ) DEFAULT '0' NOT NULL AFTER `title` ;



    		    		 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_tracker_view_ratings', 'Can view rating result for tracker items', 'basic', 'trackers');



    		    		 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_tracker_vote_ratings', 'Can vote a rating for tracker items', 'registered', 'trackers');



    		    		 CREATE INDEX urlindex ON tiki_link_cache (url(250));



    		    		
alter table tiki_files add column search_data longtext;



    		    		 alter table tiki_files add column lastModif integer(14) DEFAULT NULL;



    		    		 alter table tiki_files add column lastModifUser varchar(200) DEFAULT NULL;



    		    		CREATE TABLE tiki_file_handlers (
	mime_type varchar(64) default NULL,
	cmd varchar(238) default NULL
) TYPE=MyISAM;



    		    		CALTER TABLE tiki_mailin_accounts add column (discard_after varchar(255) default NULL);



    		    		 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES('tiki_p_admin_users', 'Can admin users', 'admin', 'user');



    		    		ALTER TABLE tiki_calendars ADD personal ENUM ('n', 'y') NOT NULL DEFAULT 'n' AFTER lastmodif;



    		    		CREATE TABLE tiki_user_tasks_history (
  belongs_to integer(14) NOT NULL,                   -- the fist task in a history it has the same id as the task id
  task_version integer(4) NOT NULL DEFAULT 0,        -- version number for the history it starts with 0
  title varchar(250) NOT NULL,                       -- title
  description text DEFAULT NULL,                     -- description
  start integer(14) DEFAULT NULL,                    -- date of the starting, if it is not set than there is not starting date
  end integer(14) DEFAULT NULL,                      -- date of the end, if it is not set than there is not dealine
  lasteditor varchar(200) NOT NULL,                  -- lasteditor: username of last editior
  lastchanges integer(14) NOT NULL,                  -- date of last changes
  priority integer(2) NOT NULL DEFAULT 3,                     -- priority
  completed integer(14) DEFAULT NULL,                -- date of the completation if it is null it is not yet completed
  deleted integer(14) DEFAULT NULL,                  -- date of the deleteation it it is null it is not deleted
  status char(1) DEFAULT NULL,                       -- null := waiting, 
                                                     -- o := open / in progress, 
                                                     -- c := completed -> (percentage = 100) 
  percentage int(4) DEFAULT NULL,
  accepted_creator char(1) DEFAULT NULL,             -- y - yes, n - no, null - waiting
  accepted_user char(1) DEFAULT NULL,                -- y - yes, n - no, null - waiting
  PRIMARY KEY (belongs_to, task_version)
) TYPE=MyISAM AUTO_INCREMENT=1 ;



    		    		 UPDATE tiki_user_tasks set title = '-'  where title IS NULL;



    		    		 INSERT INTO tiki_user_tasks_history (belongs_to, title, start, description, lasteditor, lastchanges, priority, completed, status, percentage) SELECT  taskId, title, date, description, user, date, priority, completed, status, percentage FROM tiki_user_tasks;



    		    		 ALTER TABLE tiki_user_tasks DROP description;



    		    		 ALTER TABLE tiki_user_tasks DROP title;



    		    		 ALTER TABLE tiki_user_tasks ADD last_version integer(4) NOT NULL DEFAULT 0 AFTER taskId;



    		    		 ALTER TABLE tiki_user_tasks ADD creator varchar(200) NOT NULL AFTER user;



    		    		 ALTER TABLE tiki_user_tasks ADD public_for_group varchar(30) DEFAULT NULL AFTER creator;



    		    		 ALTER TABLE tiki_user_tasks ADD rights_by_creator char(1) DEFAULT NULL AFTER public_for_group;



    		    		 ALTER TABLE tiki_user_tasks CHANGE `date` `created` integer(14) NOT NULL;



    		    		
INSERT INTO users_permissions (permName, permDesc, level,type) VALUES ('tiki_p_tasks_send', 'Can send tasks to other users', 'registered', 'user');



    		    		 INSERT INTO users_permissions (permName, permDesc, level,type) VALUES ('tiki_p_tasks_receive', 'Can receive tasks from other users', 'registered', 'user');



    		    		 INSERT INTO users_permissions (permName, permDesc, level,type) VALUES ('tiki_p_tasks_admin', 'Can admin public tasks', 'admin', 'user');


CREATE TABLE tiki_newsletter_groups (
  nlId int(12) NOT NULL default '0',
  groupName varchar(255) NOT NULL default '',
  code varchar(20),
  PRIMARY KEY  (nlId,groupName)
) TYPE=MyISAM;



    		    		 ALTER TABLE tiki_newsletter_subscriptions ADD isUser char(1) NOT NULL default 'n' AFTER subscribed;



    		    		 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_batch_upload_image_dir', 'Can use Directory Batch Load', 'editors', 'image galleries');



    		    	
CREATE TABLE messu_archive (
  msgId int(14) NOT NULL auto_increment,
  user varchar(200) NOT NULL default '',
  user_from varchar(200) NOT NULL default '',
  user_to text,
  user_cc text,
  user_bcc text,
  subject varchar(255) default NULL,
  body text,
  hash varchar(32) default NULL,
  date int(14) default NULL,
  isRead char(1) default NULL,
  isReplied char(1) default NULL,
  isFlagged char(1) default NULL,
  priority int(2) default NULL,
  PRIMARY KEY  (msgId)
) TYPE=MyISAM AUTO_INCREMENT=1 ;



    		    		
CREATE TABLE messu_sent (
  msgId int(14) NOT NULL auto_increment,
  user varchar(200) NOT NULL default '',
  user_from varchar(200) NOT NULL default '',
  user_to text,
  user_cc text,
  user_bcc text,
  subject varchar(255) default NULL,
  body text,
  hash varchar(32) default NULL,
  date int(14) default NULL,
  isRead char(1) default NULL,
  isReplied char(1) default NULL,
  isFlagged char(1) default NULL,
  priority int(2) default NULL,
  PRIMARY KEY  (msgId)
) TYPE=MyISAM AUTO_INCREMENT=1 ;



    		    	

ALTER TABLE messu_messages ADD replyto_hash varchar(32) default NULL AFTER hash;



    		    		 ALTER TABLE messu_archive ADD replyto_hash varchar(32) default NULL AFTER hash;



    		    		 ALTER TABLE messu_sent ADD replyto_hash varchar(32) default NULL AFTER hash;



    		  
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_map_view_mapfiles', 'Can view mapfiles content', 'registered', 'maps');



    		    	
ALTER TABLE tiki_history ADD version_minor int(8) NOT NULL default 0 AFTER version;



    	
ALTER TABLE `tiki_forums` ADD `outbound_mails_for_inbound_mails` CHAR( 1 ) AFTER `outbound_address` ;



    		    		 ALTER TABLE `tiki_forums` ADD `outbound_mails_reply_link` CHAR( 1 ) AFTER `outbound_mails_for_inbound_mails`;



    		
ALTER TABLE `tiki_pages` ADD `is_html` TINYINT(1) default 0;




INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_view_history', 'Can view wiki history', 'basic', 'wiki');

    Posted by sylvie greverend posts: 1092

    The errors are normal and must be ignored .
    The script is supposed to/must be safe if rerun twice.


    Posted by sooeydoo posts: 68

    Thanks Sylvie, I'll ignore the errors. But then, as I said, my Admin Modules section is not working - so I'm unable to admin my modules at all - so please help me here. The page just doesn't load! No errors!

    sooraj.