[Phpwiki-talk] troubles while running the installation - cant create the tables

[<Fl...@we...>]

Hello Dear Wiki user


new to this list- just subscribed to the list=20

many thanks for creating the wiki-module ! i love it very much! It gives m=
e the  right tool for my ideas. I want to ask for a little help in install=
ation matters: again; i found the wiki-script and that i found this great =
great open source-community;=20
I wanna set up the wiki and run it on my website:=20

I have grabbed the newest release 1.3.12 p2  I created a db with the phpMy=
admin-frontend tool.   =20

Afterwards i wanted to create the tables.=20

while doing that; i ran into troubles. well=20

I run MySQL 3.23.58  on my server.

And while proceeding /(executing ) the -- $Id: mysql-initialize.sql,v 1.8 =
2005/06/21 05:59:18 rurban Exp $

i got the following result ,,,, Error in proceeding the sql-statement:

CREATE TABLE page(

id INT NOT NULL AUTO=5FINCREMENT ,
-- for mysql =3D> 4.1 define the charset here
-- this is esp. needed for mysql 4.1.0 up to 4.1.6.=20
-- not yet confirmed, at least since 4.1.8 it's okay with binary.
-- pagename VARCHAR(100) CHARACTER SET latin1 COLLATE latin1=5Fbin NOT NULL,=

-- otherwise use the old syntax to do case-sensitive comparison
pagename VARCHAR( 100 ) BINARY NOT NULL ,
hits INT NOT NULL DEFAULT 0,
pagedata MEDIUMTEXT NOT NULL DEFAULT '',
-- dont add that by hand, better let action=3Dupgrade convert your data
cached=5Fhtml MEDIUMBLOB,
PRIMARY KEY ( id ) ,
UNIQUE KEY ( pagename )=20
) CHARSET =3D latin1=20

MySQL responds=20


#1064 - You have an error in your SQL syntax near 'CHARSET=3Dlatin1' at line=
 12=20

well I want to run it in Germany (good old Europe) - should i set up somet=
hing with the language or shouldn =B4t i=3F! I am pretty glueless.  Well if i =
- how should i to do that=3F =20


Ahhh dear Wiki-fans, many thanks in advance for any and all help - keep up=
 the great project - it rocks=20


regards=20

flobee you wiki-fan
=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F
Verschicken Sie romantische, coole und witzige Bilder per SMS!
Jetzt bei WEB.DE FreeMail: http://f.web.de/=3Fmc=3D021193