Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

You are viewing a reply to upgrading 1.9.3 to 1.9.5
 
Thread actions
Print this page
  • Print all pages

    • Re: upgrading 1.9.3 to 1.9.5

    Posted by Gary Cunningham-Lee

    > I had 1.9.3 and I wanted to upgrade to 1.9.5 because of an upcoming upgrade to mysql 5. I downloaded 1.9.5, unpacked the archive, copied the files over, cleaned the cache, templates_c and other directories, ran tiki-install.php and selected to execute tiki-1.8to1.9.sql, and then went into tiki-admin.php (but didn't have any changes to make).
    >
    > I think that's all the steps for the upgrade. Yet when I logged in and tried a few links, I got a couple errors. Here are 2.
    >
    > I tried to read an article and got this message:
    > An error occured in a database query!
    >
    > Context:
    > File /departments/imsr/tiki/tiki-read_article.php
    > Url /departments/imsr/tiki/tiki-read_article.php?articleId=2616
    > Query:
    > update `tiki_articles` set `nbreads`=`nbreads`+1 where `articleId`=?
    > Values:
    > 0 2616
    > Message:
    > Error Message Unknown column 'nbreads' in 'field list'

    This indicates the database update wasn't complete. "nbreads" is the new name of the column that formerly was "reads". I guess you can run the db upgrade script again, or you can submit just these statements, using phpMyAdmin or another db client:
    Copy to clipboard
    # fixed reserved word use in mysql
ALTER TABLE `tiki_articles` change `reads` `nbreads` int(14) default NULL ;
ALTER TABLE `tiki_submissions` change `reads` `nbreads` int(14) default NULL ;
ALTER TABLE `tiki_articles` DROP INDEX `reads`, ADD INDEX `nbreads` ( `nbreads` ) ;
ALTER TABLE `tiki_submissions` DROP INDEX `reads`, ADD INDEX `nbreads` ( `nbreads` ) ;


    > I also tried the Admin types link and got this message:
    > The requested URL /departments/imsr/tiki/tiki-articles_types.php was not found on this server.
    >
    > As far as I can tell, that file exists.
    >
    > Did I miss something in the upgrade?

    The name of the file is tiki-article_types.php, and a search through the Tiki files turns up no instance of the string "tiki-articles_types.php" so I wonder where the plural version came from in your installation. Was this link address input by hand, or is the link in a standard Tiki menu? One way or the other, the URL in the link should be corrected.

    > One thing to add: I logged in as admin and tried to view an article. I was able to view it, but I got this message at the top.
    > Notice: Undefined index: nbreads in /usr/local/apache/htdocs/departments/imsr/tiki/tiki-read_article.php on line 120

    That's related to the first question. Once the db update is completed, this will go away.

    -- Gary

    Reads: 422