Loading...
 
Architecture / Installation

Architecture / Installation

Forum List Topic List

Forums » Architecture / Installation » tiki 1.8 HEAD - Installation PROBLEM - DB Script
 
Thread actions
PDF Print this page
  • Print all pages

    • tiki 1.8 HEAD - Installation PROBLEM - DB Script

    Posted by paulap01 posts: 112 Austria

    Hi,

    I use Apache 1.3.27 - PHP 4.3.3 - MySQL 4.0.15 under Windows XP (German).

    I install a fresh 1.8 HEAD version.

    I select the "Basic Enabled Profile" and after click the OK-Button get following message in the "print operation failed box":

    -------
    Command: INSERT INTO tiki_user_preferences(user,prefName,value) VALUES ('admin','realName','System Administrator');

    1. --------------------

    1. Inserts of all default values for preferences

    INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('allowRegister','n')
    Message: Fehler in der Syntax bei ';

    1. --------------------

    1. ' in Zeile 1.



    Command: REPLACE INTO users_groups VALUES ('Admins','Administrator and accounts managers.','')
    Message: Spaltenzahl stimmt nicht mit der Anzahl der Werte ?berein in Reihe1


    Command: REPLACE INTO users_groups VALUES ('Editors','Trusted writers and features managers.','')
    Message: Spaltenzahl stimmt nicht mit der Anzahl der Werte ?berein in Reihe1

    ------

    Don't know about the effects. The system seems stable...

    paulap

    Reads: 1298
    Link
    Posted by paulap01 posts: 112 Austria

    After I logged on as admin/admin and I type the new password I got following messages:

    Warning: fopen(\/tikidebug): failed to open stream: Invalid argument in d:\wwwportal\tikiwiki\lib\search\refresh.php on line 44

    Warning: fwrite(): supplied argument is not a valid stream resource in d:\wwwportal\tikiwiki\lib\search\refresh.php on line 44

    Warning: fclose(): supplied argument is not a valid stream resource in d:\wwwportal\tikiwiki\lib\search\refresh.php on line 44

    paulap

    Link
    Posted by Damian Parker posts: 2881 United Kingdom

    Hi,

    You need to create a tmp or a temp in your tikiroot and match it up accordingly in your Admin->General

    For the record are you using 1.8 or 1.9? 1.8 is know as BRANCH-1-8 and 1.9 is known as HEAD

    Thanks

    Damian

    Link
    Posted by paulap01 posts: 112 Austria

    > Damian:
    > Hi,
    >
    > You need to create a tmp or a temp in your tikiroot and match it up accordingly in your Admin->General
    >
    > For the record are you using 1.8 or 1.9? 1.8 is know as BRANCH-1-8 and 1.9 is known as HEAD
    >
    > Thanks
    >
    > Damian

    Thx Damian,

    I forgot the story with the /temp. Sorry. Now it works.

    It is the 1.9 branch.

    paulap

    Link
    Posted by paulap01 posts: 112 Austria

    > Damian:
    > Hi,
    >
    > You need to create a tmp or a temp in your tikiroot and match it up accordingly in your Admin->General
    >
    > For the record are you using 1.8 or 1.9? 1.8 is know as BRANCH-1-8 and 1.9 is known as HEAD
    >
    > Thanks
    >
    > Damian

    Hi,

    the story with the /temp directory solve my runtime problem.

    But what is with the SQL installation messages?

    paulap

    Link
    Posted by Damian Parker posts: 2881 United Kingdom

    > Hi,
    >
    > the story with the /temp directory solve my runtime problem.
    >
    > But what is with the SQL installation messages?
    >
    > paulap
    >

    My guess is those error messages are about duplicate values? In which case they can be safely ignored.

    The allowRegister is nothing to worry about, you can set this up manually in Admin->Login

    Link
    Posted by paulap01 posts: 112 Austria

    > Damian:
    > > Hi,
    > >
    > > the story with the /temp directory solve my runtime problem.
    > >
    > > But what is with the SQL installation messages?
    > >
    > > paulap
    > >
    >
    > My guess is those error messages are about duplicate values? In which case they can be safely ignored.
    >

    I don't think so.

    The translated Message is:
    ---

    Command: REPLACE INTO users_groups VALUES ('Admins','Administrator and accounts managers.','')

    Message: Columncount doesn't comply with the count of values of "serie1"

    ---

    > The allowRegister is nothing to worry about, you can set this up manually in Admin->Login
    >
    >

    In my optinion is isn't a problem with duplicat values. It seems that the db statement is wrong.

    paulap

    Link

    Posted by Damian Parker posts: 2881 United Kingdom

    Hi,

    You need to create a tmp or a temp in your tikiroot and match it up accordingly in your Admin->General

    For the record are you using 1.8 or 1.9? 1.8 is know as BRANCH-1-8 and 1.9 is known as HEAD

    Thanks

    Damian

    Link
    Posted by paulap01 posts: 112 Austria

    > Damian:
    > Hi,
    >
    > You need to create a tmp or a temp in your tikiroot and match it up accordingly in your Admin->General
    >
    > For the record are you using 1.8 or 1.9? 1.8 is know as BRANCH-1-8 and 1.9 is known as HEAD
    >
    > Thanks
    >
    > Damian

    Thx Damian,

    I forgot the story with the /temp. Sorry. Now it works.

    It is the 1.9 branch.

    paulap

    Link
    Posted by paulap01 posts: 112 Austria

    > Damian:
    > Hi,
    >
    > You need to create a tmp or a temp in your tikiroot and match it up accordingly in your Admin->General
    >
    > For the record are you using 1.8 or 1.9? 1.8 is know as BRANCH-1-8 and 1.9 is known as HEAD
    >
    > Thanks
    >
    > Damian

    Hi,

    the story with the /temp directory solve my runtime problem.

    But what is with the SQL installation messages?

    paulap

    Link
    Posted by Damian Parker posts: 2881 United Kingdom

    > Hi,
    >
    > the story with the /temp directory solve my runtime problem.
    >
    > But what is with the SQL installation messages?
    >
    > paulap
    >

    My guess is those error messages are about duplicate values? In which case they can be safely ignored.

    The allowRegister is nothing to worry about, you can set this up manually in Admin->Login

    Link
    Posted by paulap01 posts: 112 Austria

    > Damian:
    > > Hi,
    > >
    > > the story with the /temp directory solve my runtime problem.
    > >
    > > But what is with the SQL installation messages?
    > >
    > > paulap
    > >
    >
    > My guess is those error messages are about duplicate values? In which case they can be safely ignored.
    >

    I don't think so.

    The translated Message is:
    ---

    Command: REPLACE INTO users_groups VALUES ('Admins','Administrator and accounts managers.','')

    Message: Columncount doesn't comply with the count of values of "serie1"

    ---

    > The allowRegister is nothing to worry about, you can set this up manually in Admin->Login
    >
    >

    In my optinion is isn't a problem with duplicat values. It seems that the db statement is wrong.

    paulap

    Link