Geeklog Forums

I put up my 16th story and received an SQL error on 16 on up but the other 15 still work. Is it a title length limit? The 16th title is Reviews-Movies-AndNowtheScreamingStarts-1973

Error says:
An SQL error has occurred. Please see error.log for details.

On phpmyadmin in gl_stories, it says "PRIMARY and INDEX keys should not both be set for column `sid`"

Keyname Type Cardinality Action Field
PRIMARY PRIMARY 18 sid
stories_sid INDEX None sid

And the error message there was ... ?

bye, Dirk

To be honest, I didn't know where to get the error log. I found the index error, deleted the non primary sid table as an index. I deleted the story with the error and reentered it with a shorter id/title and it worked. I guess sql conks out after 40 character ids?

For future use, where is the the error log? I just fixed the error on a hunch.

In the logs directory, on the same level as your config.php

bye, Dirk

Ah, ok. I thought it was an SQL thing. But Dirk, what about this 40-character limit on file ids?

Here's the error log entry:

Mon 11 Sep 2006 20:46:23 MST - 1062: Duplicate entry 'Reviews-Movies-AndNowtheScreamingStarts-' for key 1. SQL in question: INSERT INTO gl_rating_totals (rt_id, item_type, score_min, score_max, count, total, created, owner_id, group_id) VALUES ('Reviews-Movies-AndNowtheScreamingStarts-1973', 'autotagged', '0', '5', '0', '0', NOW(), '1', '17')

I think it's related to the sql error: "PRIMARY and INDEX keys should not both be set for column `sid`" Somehow the entry reset an index key to the same as the primary. I don't understand if the file length did it but the story id was cut to 40 from 44 characters.

Yes, the ID is limited to 40 characters. How did you even manage to enter more than that?

bye, Dirk