Table exits not created

GHoSti · Post by **GHoSti** » Wed Dec 12, 2007 8:27 pm

Hi!

As I was wondering why exits weren't counted I've found a thread where someone asked for data from the exits table. I've logged into my phpMyAdmin and haven't found this table. So I deceided to look into the Serendipity db.sql file and tried to install it by hand.

All was fine, since I've tried to define the primary keys. Now I've got entry_id, day and path working. If I try to define host first and then path it says the key is to long and it could only be 1000 bytes. I've tried many things and the above and host instead of path is working.

Can someone give me a solution for this? I really don't know if it's working without host or path in primary key.

Sry for my english

Hopefully you understand what I'm trying to explain.

Ciao...
GHoSti

/EDIT: Tried it and now topexits counts, but I'm unsecure if it can give some trouble without hosts as primary key

Post by **garvinhicking** » Thu Dec 13, 2007 2:10 pm

Hi!

I'm afraid this can happen with new MySQL 5 versions that Use UTF-16 byte allocation even vor usual varchar() columns and thus exceeds index limitations...

There is a syntax that decreases index length on the "host" char, so that it doesn't exceed 1000 characters, sadly I have no experience with that yet.

REgards,
Garvin

GHoSti · Post by **GHoSti** » Thu Dec 13, 2007 4:27 pm

I'm afraid to say that I'm using MySQL 4.1.10a

Post by **garvinhicking** » Thu Dec 13, 2007 4:37 pm

Hi!

Dependin on the config, this could also already happen with 4.1 - but it's definitely A UTF-16 issue.

Regards,
Garvin

GHoSti · Post by **GHoSti** » Thu Dec 13, 2007 5:46 pm

Sry, but I have to contradict

I'm using UTF-8 and a friend of mine found this: http://bugs.mysql.com/bug.php?id=4541

Related to this article you have: 128Bytes + 255Bytes = 383Bytes * 3Bytes ( for UTF-8 ) = 1149Bytes > 1000Bytes.

I will try to alter all tables to latin1 charset for default and convert them this evening. After that I'll report.

I'm still wondering why install didn't get me any errors.

GHoSti · Post by **GHoSti** » Thu Dec 13, 2007 9:56 pm

Changed all Tables now to latin1_general_ci with the following command:

Code: Select all

ALTER TABLE `table` DEFAULT CHARSET=latin1, COLLATE latin1_general_ci

After that I changed every column with "utf8_general_ci" to latin1_general_ci with phpMyAdmin.
Then I edited the exits primary key and added hosts to it -> working
All german characters in my blog are fine, the blog is working as far as I can see now without any strange behaviour.

Table exits not created

Table exits not created

Re: Table exits not created