Error

SQL-query :

CREATE TABLE xoops__PDlinks_indexpage(

indeximage varchar( 255 ) DEFAULT 'blank.png' NOT NULL ,
indexheading varchar( 255 ) DEFAULT 'PD-Links' NOT NULL ,
indexheader text NOT NULL ,
indexfooter text NOT NULL ,
nohtml tinyint( 8 ) DEFAULT '1' NOT NULL ,
nosmiley tinyint( 8 ) DEFAULT '1' NOT NULL ,
noxcodes tinyint( 8 ) DEFAULT '1' NOT NULL ,
noimages tinyint( 8 ) DEFAULT '1' NOT NULL ,
nobreak tinyint( 4 ) DEFAULT '0' NOT NULL ,
indexheaderalign varchar( 25 ) DEFAULT 'left' NOT NULL ,
indexfooteralign varchar( 25 ) DEFAULT 'center' NOT NULL ,
KEY indexheading( indexheading ) ,
KEY indexheader( indexheader ) ,
KEY indexfooter( indexfooter )
)

MySQL said:


BLOB column 'indexheader' used in key specification without a key length

"I saw @ the XOOPS roadmap that the new 2.1 is planned with global category support...
and that is answering (probably) all dificulties"

from:TZvook

bd_csmc
this thread is what I was talking about .... I just found it.
Herko, skalpa, Bunny and the rest saw the need @ 2002 and for some reason all was forgotten.
If you ask me it's one thing XOOPS can't live without beacuse in most cases you need your content to be folowed by categories and not by modules

And to be acurate:
today XOOPS sites looks like this

Homepage
module 1:
- category one
- category 2
- category 3

module 2:
- category one
- category 2
- category 3

module 3:
- category one
- category 2
- category 3

Now, it's good for a few sites, but not for most.
The natural content flow is :

Site category 1:
- module one category 1
- module 2 category 1
- module 2 category 1

Site category 2:
- module one category 2
- module 2 category 2
- module 3 category 2

Quote:

-- subjuct one
- articles
- news
- photos (gallery or so..)
- forum
- all others

-- subjuct two
- articles
- news
- photos (gallery or so..)
- forum
- all other.......[

This brought me to a situation that every time I want to use XOOPS for a project, I ends up giving it to a much worse cms, but with a better "content flow" and I feel very bad about it, XOOPS is the best in functionality and stability, but ..... in the end what counts is the content, the CMS is just serving the content.

$whathost=$_SERVER["HTTP_HOST"];
if($whathost != "www.aviary.info")
{
header("HTTP/1.1 301 Moved Permanently");
header("Location:http://www.aviary.info".$_SERVER["REQUEST_URI"]);
exit();
}