Re: bitflux-cms Digest, Vol 35, Issue 7

On Sat, 15 Apr 2006 12:00:07 +0200 (CEST), [email protected] wrote:
> Send bitflux-cms mailing list submissions to
> 	[email protected]
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://lists.bitflux.ch/cgi-bin/listinfo/bitflux-cms
> or, via email, send a message with subject or body 'help' to
> 	[email protected]
> 
> You can reach the person managing the list at
> 	[email protected]
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of bitflux-cms digest..."
> 
> 
> Today's Topics:
> 
>    1. Installation Problem with MySQL (Adri?n Ribao)
>    2. Mod_rewrite error (Herbert Kluge)
>    3. Re: Mod_rewrite error (Alain Petignat)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Fri, 14 Apr 2006 19:13:57 +0100
> From: Adri?n Ribao <[email protected]>
> Subject: [bitflux-cms] Installation Problem with MySQL
> To: [email protected]
> Message-ID: <[email protected]>
> Content-Type: text/plain;  charset="utf-8"
> 
> Hello, I got this error with the mysql:
> CREATE TABLE `##bxcms_##properties` (
>  `path` VARCHAR( 255 ) NOT NULL DEFAULT '',
>  `name` VARCHAR( 120 ) NOT NULL DEFAULT '',
>  `ns` VARCHAR( 120 ) NOT NULL DEFAULT 'DAV:',
>  `value` TEXT,
>  `value_date` DATETIME DEFAULT NULL ,
>  `value_int` INT( 11 ) DEFAULT NULL ,
>  UNIQUE KEY `prim` ( `path` , `name` , `ns` ) ,
>  KEY `path` ( `path` ) ,
>  KEY `name-ns` ( `name` , `ns` ) ,
>  FULLTEXT KEY `value` ( `value` )
> );
> 
>  #1071 - Specified key was too long; max key length is 1000 bytes
> 
> I am using MySQL 4.1.15
> 
> Thank you!
> 

It's a UTF-8 problem, change to Latin1 your default mysql locale or edit : div/db/bxcms.sql

and change to: UNIQUE KEY `prim` ( path(100) , name(75) , ns(75) ) ,

---------
CREATE TABLE `##bxcms_##properties` (
   `path` VARCHAR( 255 ) NOT NULL DEFAULT '',
   `name` VARCHAR( 120 ) NOT NULL DEFAULT '',
   `ns` VARCHAR( 120 ) NOT NULL DEFAULT 'DAV:',
   `value` TEXT,
   `value_date` DATETIME DEFAULT NULL ,
   `value_int` INT( 11 ) DEFAULT NULL ,
   UNIQUE KEY `prim` ( path(100) , name(75) , ns(75) ) ,
   KEY `path` ( `path` ) ,
   KEY `name-ns` ( `name` , `ns` ) ,
   FULLTEXT KEY `value` ( `value` )
 );
---------

to limit index key length.

>  KEY `path` ( `path` ) ,


> 
> ------------------------------
> 
> Message: 2
> Date: Fri, 14 Apr 2006 22:47:52 +0200
> From: Herbert Kluge <[email protected]>
> Subject: [bitflux-cms] Mod_rewrite error
> To: [email protected]
> Message-ID: <[email protected]>
> Content-Type: text/plain; charset=ISO-8859-15
> 
> Hello!
> 
> I get a "500 Internal Server Error" after installing Bxcms.
> 
> Apache errorfile says: "[error] [client 127.0.0.1] mod_rewrite: maximum
> number of internal redirects reached. Assuming configuration error. Use
> 'RewriteOptions MaxRedirects' to increase the limit if neccessary."
> 
> Does anybody know this error?
> 
> Greets Herbert
> 
> 
> ___________________________________________________________
> Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Fri, 14 Apr 2006 23:12:32 +0200
> From: Alain Petignat <[email protected]>
> Subject: Re: [bitflux-cms] Mod_rewrite error
> To: Herbert Kluge <[email protected]>
> Cc: [email protected]
> Message-ID: <[email protected]>
> Content-Type: text/plain; charset=ISO-8859-15; format=flowed
> 
> Hi Herbert
> 
> Herbert Kluge wrote:
>> I get a "500 Internal Server Error" after installing Bxcms.
>>
>> Apache errorfile says: "[error] [client 127.0.0.1] mod_rewrite: maximum
>> number of internal redirects reached. Assuming configuration error. Use
>> 'RewriteOptions MaxRedirects' to increase the limit if neccessary."
>>
>> Does anybody know this error?
> 
> Hmm, try to add "RewriteBase /" just after "RewriteEngine on" in
> .htaccess.
> 
> Kind of depends on your serverconfig, but above might do it...
> 
> hth
> Alain
> 
> --
> ________________________________________________________________________
>                                                            www.sequenz.ch
> 
> 
> ------------------------------
> 
> _______________________________________________
> bitflux-cms mailing list
> [email protected]
> http://lists.bitflux.ch/cgi-bin/listinfo/bitflux-cms
> 
> 
> End of bitflux-cms Digest, Vol 35, Issue 7
> ******************************************

-- 
bitflux-cms mailing list
[email protected]
http://lists.bitflux.ch/cgi-bin/listinfo/bitflux-cms