Re: [Phpwiki-talk] cant wait to get on board - i am totally happy

[Reini U. <ru...@x-...>]

[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/