Loading...
 
Architecture / Installation

Architecture / Installation


mssql problems

posts: 3

hi all!

i tried to install tikiwiki 1.9 on an win2k3 server and an sql server.
but in the tikiwiki package misses the sql file fpr zhe mssql server.
can anybody help me with this file or has an idea to handel it otherwise.

thx for helping!

cu elwood

posts: 2881 United Kingdom

Only 1.8 has mssql support.

I havent had time to get 1.9 sorted out for it.

Damian

posts: 2881 United Kingdom

When 1.9 is finally released it will have one, dont worry. The current 1.9 RC (developement code) releases are not meant for production sites btw.

The are snapshots from CVS and do contain problems. All RC are never meant to be totally stable.

Damian


posts: 3

thx for fast helping.

i also tried 1.8 but it neither works.

Errormassage:
Notice: Undefined index: SCRIPT_FILENAME in c:\inetpub\wwwroot\wikiprojekt\tikiwiki2\tiki-setup.php on line 43

Warning: mssql error: Line 1: Incorrect syntax near '='. in query:
select userId from users_users where login='?'
in c:\inetpub\wwwroot\wikiprojekt\tikiwiki2\lib\tikidblib.php on line 133

Fatal error: Call to a member function on a non-object in c:\inetpub\wwwroot\wikiprojekt\tikiwiki2\lib\tikidblib.php on line 151

posts: 1 Thailand

try this!

Installing TikiWiki
If you are installing TW 1.8 or later, don't follow these instuctions and move to the next section
  • Download TikiWiki
  • Using WinZip, extract to c:\ using folder names
  • Versions prior to 1.8 only Enter the following from the command line:
    • cd /d c:\tikiwiki_* (the actual directory depends on which version you have installed)
    • mkdir templates_c
    • Go to Windows Explorer and modify the security for the folder c:\tikiwiki_*\templates_c
    • Allow write access for the users whose names start with IUSR and IWAM
  • Versions 1.8 and later only Enter the following from the command line:
    • cd /d c:\tikiwiki_* (the actual directory depends on which version you have installed)
    • cd lib
    • mkdir \php4
    • xcopy /i /e pear \php4
  • Edit c:\tikiwiki_*\tiki-install.php (the actual directory depends on which version you have installed)
    • You will need to use a UNIX-linefeed-friendly editor. I use Crimson Editor
    • Change the line: $docroot = dirname($_SERVER['SCRIPT_FILENAME']);
    • To: $docroot = dirname('c:/tikiwiki_*'); // Specify the real directory based on the TikiWiki version
  • Edit c:\tikiwiki_*\tiki-setup.php (the actual directory depends on which version you have installed)
    • You will need to use a UNIX-linefeed-friendly editor. I use Crimson Editor
    • Change the line: $docroot = dirname($_SERVER['SCRIPT_FILENAME']);
    • To: $docroot = dirname('c:/tikiwiki_*'); // Specify the real directory based on the TikiWiki version
    • Change

~pp~


posts: 3

I fixed serveral mssql errors in the tiki-1.8-mssql.sql:

CREATE TABLE "tiki_language" (
"source" image NOT NULL,
"lang" char(2) default '' NOT NULL,
"tran" image default '',
PRIMARY KEY ("lang")
)

INSERT INTO tiki_menu_options ("menuId","type","name","url","position","section","perm","groupname")
VALUES (42,'o','(debug)','javascript:toggle(debugconsole)',40,'feature_debug_console','tiki_p_admin','')

INSERT INTO tiki_menus ("name","description","type")
VALUES ('Application menu','Main extensive navigation menu','d')

CREATE TABLE "tiki_untranslated" (
id numeric(14 ,0) identity,
"source" image NOT NULL,
"lang" char(2) default '' NOT NULL,
PRIMARY KEY ("lang")
)

INSERT INTO tiki_integrator_reps
VALUES ('Doxygened (1.3.4) Documentation','','index.html','doxygen.css','n','y','0','Use this repository as rule source for all your repositories based on doxygened docs. To setup yours just add new repository and copy rules from this repository :-)')

INSERT INTO tiki_integrator_rules
VALUES ('1','2','img src=(\"|\'')(?!http://)','img src=\1{path}/','y','n','i','y','Fix images path')

INSERT INTO tiki_integrator_rules
VALUES ('1','3','href=(\"|\'')(?!(--|(http|ftp)://))','href=\1tiki-integrator.php?repID={repID}&file=','y','n','i','y','Relace internal links to integrator. Dont touch an external links.')

INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon")
VALUES ('italic',' \\text\\ ','images/ed_format_italic.gif')



******************************************************

The sql file tried to create index on some columns:

Command: CREATE INDEX "tiki_articles_heading" ON "tiki_articles"("heading")
Message: Column 'heading'. Cannot create index on a column of text, ntext, or image data type.

But the columns was created like that:

CREATE TABLE "tiki_articles" (
articleId numeric(8 ,0) identity,
"title" varchar(80) default NULL NULL,
"state" char(1) default 's',
"authorName" varchar(60) default NULL NULL,
"topicId" numeric(14,0) default NULL NULL,
"topicName" varchar(40) default NULL NULL,
"size" numeric(12,0) default NULL NULL,
"useImage" char(1) default NULL NULL,
"image_name" varchar(80) default NULL NULL,
"image_type" varchar(80) default NULL NULL,
"image_size" numeric(14,0) default NULL NULL,
"image_x" numeric(4,0) default NULL NULL,
"image_y" numeric(4,0) default NULL NULL,
"image_data" image default '',
"publishDate" numeric(14,0) default NULL NULL,
"expireDate" numeric(14,0) default NULL NULL,
"created" numeric(14,0) default NULL NULL,

"heading" text default '', type : text! mistake or planed?????

"body" text default '',
"hash" varchar(32) default NULL NULL,
"author" varchar(200) default NULL NULL,
"reads" numeric(14,0) default NULL NULL,
"votes" numeric(8,0) default NULL NULL,
"points" numeric(14,0) default NULL NULL,
"type" varchar(50) default NULL NULL,
"rating" decimal(3,2) default NULL NULL,
"isfloat" char(1) default NULL NULL,
PRIMARY KEY ("articleId")

)


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting