I don't see such a message at that url, but it must be an old upgrade issue. Check through phpmyadmin to set your 'time' field in your links table to be int(11) if it's something else.
The error was for the comments.php, sorry I put a link to the details page. Anyway, I opened the wsn_comments table and found the last edit field for some links having the word "time" and delete it. Now it works fine. Thanks!
Change the field type to integer length 11 default value 0 (which it what it's been since 2.something but the upgrades don't change it), so that it won't be able to have 'time' in it.
Paul wrote: Change the field type to integer length 11 default value 0 (which it what it's been since 2.something but the upgrades don't change it), so that it won't be able to have 'time' in it.
I normally just click the little edit buttons in phpmyadmin and do it visually, but I think the query (if you use the default tables prefix) would be ALTER TABLE wsnlinks_comments CHANGE lastedit lastedit int(11);
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on bug - comments.php
Member
Usergroup: Customer
Joined: Mar 16, 2003
Total Topics: 13
Total Comments: 24
Not all links give this error. The error when open some comments is:
Timestamp is not numeric, it is time. Please report this bug
Link: prep4abim.com/resources/link.php?action=detail&id=154
Regards!
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I don't see such a message at that url, but it must be an old upgrade issue. Check through phpmyadmin to set your 'time' field in your links table to be int(11) if it's something else.
Member
Usergroup: Customer
Joined: Mar 16, 2003
Total Topics: 13
Total Comments: 24
The error was for the comments.php, sorry I put a link to the details page.
Anyway, I opened the wsn_comments table and found the last edit field for some links having the word "time" and delete it. Now it works fine.
Thanks!
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Change the field type to integer length 11 default value 0 (which it what it's been since 2.something but the upgrades don't change it), so that it won't be able to have 'time' in it.
Member
Usergroup: Customer
Joined: Mar 16, 2003
Total Topics: 13
Total Comments: 24
Change the field type to integer length 11 default value 0 (which it what it's been since 2.something but the upgrades don't change it), so that it won't be able to have 'time' in it.
What would be the command to run on sql?
Thanks!
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I normally just click the little edit buttons in phpmyadmin and do it visually, but I think the query (if you use the default tables prefix) would be
ALTER TABLE wsnlinks_comments CHANGE lastedit lastedit int(11);