Some kind of bug..

Discovered a bug? If not sure, please post question in the support forum.

Some kind of bug..

Postby oldo » Wed Sep 07, 2005 4:21 pm

Image

8O
oldo
 
Posts: 53
Joined: Wed Aug 10, 2005 8:11 am

Re: Some kind of bug..

Postby aba » Wed Sep 07, 2005 8:21 pm

It seems like the path for the files is over 255 chars long. (Which is
the maximum in the database.)

You can alter the 'tbl_search' database, the field is called 'dirname'. You should change it to the MySQL type 'text' which can contain more data.

Åge
aba
Site Admin
 
Posts: 2325
Joined: Wed May 08, 2002 9:19 am

Postby oldo » Sun Sep 25, 2005 12:50 pm

Can't seem to Chnage this value to TEXT format.
Gives error: can't use defalt value with TEXT field.
Ok so i remove the default value and then get this error:

#1170 - BLOB/TEXT column 'dirname' used in key specification without a key length
oldo
 
Posts: 53
Joined: Wed Aug 10, 2005 8:11 am

Postby aba » Sun Sep 25, 2005 3:09 pm

oldo wrote:Can't seem to Chnage this value to TEXT format.
Gives error: can't use defalt value with TEXT field.
Ok so i remove the default value and then get this error:

#1170 - BLOB/TEXT column 'dirname' used in key specification without a key length


You need to drop any INDEXes in the tbl_search table that has anything to do with dirname.

Åge
aba
Site Admin
 
Posts: 2325
Joined: Wed May 08, 2002 9:19 am

Postby oldo » Mon Sep 26, 2005 6:25 pm

Ah yeh. Snorted!
oldo
 
Posts: 53
Joined: Wed Aug 10, 2005 8:11 am


Return to Bugs



cron