Loading...
 
Architecture / Installation

Architecture / Installation

Forum List Topic List

 
Thread actions
PDF Print this page
  • Print all pages

    • MYSQL Error during update

    Posted by travisr posts: 79 United States

    Hello,

    Yesterday I started the update from 1.8.5 to 1.9.1 and I have everything setup except when it tries to load the home page I get a mysql error. The select statement it is trying to perform is:

    "SELECT count(*) FROM 'tiki_stats' WHERE 'object'=? and 'type'=? and 'day'=?"

    The problem is that tiki_stats table does not exist in the database. I would like to know if there is something that I messed up when updating the database or if this has happen to someone before and there is a fix for it.

    Thank you,

    Travisr

    Reads: 735
    Link
    Posted by Damian Parker posts: 2881 United Kingdom

    Did you run the tiki_1.8to1.9.sql file ?

    I seem to recall its created in there wink

    See UpgradeTo19

    Damian
    http://tikihost.net

    Link

    Posted by travisr posts: 79 United States

    I did run the tiki_1.8to1.9.sql file.

    I found the problem the table create is not in that file it is in the 1.9to1.9.1.sql file.

    so there is actually 2 .sql files that should be run.

    Link