Loading...
 
Architecture / Installation

Architecture / Installation


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

posts: 11 Canada

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%27

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!

posts: 10

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

posts: 11 Canada

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


posts: 1817 Catalan Countries

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.