Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • Installing Mod Aulawiki 1.6 error - Unknown column 'admin' in 'field list'

    Posted by Michael Franzen

    I am trying to install the Aulawiki 1.6 into TikiWiki v1.9.11. I am getting the following after running the install on line:

    An error occured in a database query!

    Context:
    File tiki-mods.php
    Url tiki-mods.php?action=install&package=features-aulawiki
    Query:
    INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_admin_assignments','Can admin assignments','admin','assignments','NULL');
    Values:
    Message:
    Error Message Unknown column 'admin' in 'field list'

    Now I was reading a few issues that I thought were similar, and found
    http://tikiwiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=26714&highlight=Unknown%20column%20%27admin%27%20in%20%27field%20list%27Question

    which may be a similar situation. If that is the case can I get a little help on what I should be doing exactly to create another addition to msql database. I was going to add an "admin", but then there were a bunch of parameters that I was not sure of and also I am not sure if the above part of the error, that shows the Query has anything to do with the adding the admin to the database?

    ... maybe I am on the wrong track all together, but when I was checking the database it did start installing some tables with-in the database:
    aulawiki_assignment
    aulawiki_gradebook
    aulawiki_period
    aulawiki_period_type

    I did not see aulawiki_p_admin_assignments anywhere as shown in the above query, nor did I see any of the values that were to be inserted into users_permissions table, so I don't know if that is also another issue?

    Can some one suggest if I do have to add something to the msql table or what. Oh, and I did go into the system admin and clear the cach's which did not help any.

    Help please and thanks!

    Reads: 2180
    Posted by tasmaniac

    Sounds like the version of Aulawiki you have is geared more towards TikiWiki 2.0 as from what I can see TW 1.9 didnt have an admin column in users_permissions. Where as TW2.0 does have it. You could add a column but wether that would break something else I couldnt tell you. Oh and users_permission table is actually a TW table not a Aulawiki table.

    Peter J

    Posted by Michael Franzen

    Thanks Peter,

    A little insight goes a long way, as I was not aware of that.

    I'll upgrade to version 2 as I have not really done much with the current released version.

    Michael


    Posted by Xavier de Pedro

    Oups, I missed that thread months ago...
    Last AulaWiki version for Tiki 1.9.x was AulaWiki 1.5, afaik
    Starting from 1.6 (last stable is AulaWiki 1.6.2) , they are ready for Tiki 2.x.

    If still using Tiki 1.9.x, see at AulaWiki where to get this mod version from.

    Hope this helps.