[question from a fan forwarded to the phpwiki-talk list]
jobst müller schrieb:
> hello Rurban, good day
>
>
> just saw your name on the subscriber - confrimation page over at sourceforge.
>
> just subscribed to the list - and now i am waitin for more instructions - i am totally happy that
> i found the wiki-script and that i found this great great open source-community;
Waiting is wrong, reading is better. And asking the wrong email
addresses is bad. I forwarded your question to the list.
Please first subscribe, then ask. If you don't like it, unsubscribe.
It's a matter of minutes.
> Rurban, many thanks for creating the wiki-module ! i love it very much! It gives me the right tool for my community! Rurban i want to ask for a little help in installation matters: I wanna set up the base wiki module and run it as a standalone!
>
> I have grabbed the newest release 1.3.12 p2
>
>
> I created a db with the phpMyadmin-frontend tool. AFterwards i wanted to create the tables.
>
> while doing that; i ran into troubles. well
>
> irun MySQL 3.23.58
>
>
> 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_INCREMENT ,
> -- for mysql => 4.1 define the charset here
> -- this is esp. needed for mysql 4.1.0 up to 4.1.6.
> -- not yet confirmed, at least since 4.1.8 it's okay with binary.
> -- pagename VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_bin 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=upgrade convert your data
> cached_html MEDIUMBLOB,
> PRIMARY KEY ( id ) ,
> UNIQUE KEY ( pagename )
> ) CHARSET = latin1
>
> MySQL responds
>
>
> #1064 - You have an error in your SQL syntax near 'CHARSET=latin1' at line 12
>
> well Rurban i want to run it in Germany (good old Europe) - should i set up something with the
> language or shouldn Žt i?! I am pretty glueless.
>
> Well if i - how should i to do that?
delete the offending property from this statement.
...
PRIMARY KEY ( id ) ,
UNIQUE KEY ( pagename )
);
CHARSET is for newer mysql servers.
> Rurban many thanks in advance for any and all help - keep up the great project - it rocks !!
>
>
> hopefully i am soon on the list - then i can post this on the list!
>
> dear Rurban - i love the great great wiki-script.
>
>
> regards
>
>
> flobee you wiki -fan
--
Reini Urban
http://phpwiki.org/ http://murbreak.at/
http://helsinki.at/ http://spacemovie.mur.at/
|
