In checking some of my comments I get this error message: "Timestamp is not numeric, it is time. Please report this bug." I tried to change the field type to "INT" but I get this error message in phpmyadmin:
Database SDBest Error SQL-query :
ALTER TABLE `wsnlinks_members` CHANGE `time` `time` INT NOT NULL
MySQL said: #1089 - Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys
Try deleting the index, then try again. Next version will prevent it from creating any index on id or duplicates on the same column in case that's a problem.
I was able to change the time field on _members to int(11) but I still get the error message on some of my comments: Timestamp is not numeric, it is time...
Does the field have a default value of 0? If so then the only possibility seems to be that the comments in question don't actually exist, but are in some unknown way getting processed. I'd have to see an example.
There seem to be no comments on that link, so the link itself would have to be the issue... yet I don't see anything unusual about link 7's data in phpmyadmin. The only way I can say anything then is site inspection: scripts.webmastersite.net/w...nlinks/?section=inspection
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Timestamp - MySQL Error: 1089
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
In checking some of my comments I get this error message: "Timestamp is not numeric, it is time. Please report this bug." I tried to change the field type to "INT" but I get this error message in phpmyadmin:
Database SDBest
Error
SQL-query :
ALTER TABLE `wsnlinks_members` CHANGE `time` `time` INT NOT NULL
MySQL said:
#1089 - Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Try
ALTER TABLE `wsnlinks_members` CHANGE `time` `time` INT(11) NOT NULL default 0;
Edit: Actually it's talking about keys again there. Check the bottom of the structure tab, what columns is wsnindex on?
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
Didn't work, same error message. wsnindex on: id, time
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Try deleting the index, then try again. Next version will prevent it from creating any index on id or duplicates on the same column in case that's a problem.
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
I was able to change the time field on _members to int(11) but I still get the error message on some of my comments: Timestamp is not numeric, it is time...
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Does the field have a default value of 0? If so then the only possibility seems to be that the comments in question don't actually exist, but are in some unknown way getting processed. I'd have to see an example.
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
The comments exist. Here one of the pages this error happens: http://www.sdbest.com/SDBest/thread/7
If you still have the pwd/user info for sdrox.com the phpmyadmin is the same only the directory is at sdbest.com/Php/
I am wondering if just doing an upgrade may fix the problem.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Updating to 4.0.14 and then submitting the settings->general page should fix all the index problems, but probably not this.
Either the links or comments table must have the non-numeric time field.
When did you send me the sdrox.com info?
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
Sent on 1/31/07 regarding:
/forums/threads/upgrade_-_lost_links-7144.html
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
There seem to be no comments on that link, so the link itself would have to be the issue... yet I don't see anything unusual about link 7's data in phpmyadmin. The only way I can say anything then is site inspection: scripts.webmastersite.net/w...nlinks/?section=inspection