timestamp: WSN Support

Version:

timestamp

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/13/04 - 11:36 PM:	#1
Timestamp is not numeric, it is 1227454684. Please report this bug. got the above when tried to click memberlist from within admin panel

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 10/14/04 - 06:24 AM:	#2
Apparently another of your upgrade problems. In phpmyadmin viewing your wsnlinks_members table, what does it show in the 'time' field? More importantly, what's the type of that field? It's int(11) in new versions, the message implies that it's set as text for you.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/14/04 - 04:28 PM:	#3
yes, it was set to text and the entry was 1227454684 also I have {IP} in ip field and I looked in setup.sql and it sais there: `ip` text NOT NULL, but should not it be int(11) also? the time fiesd in setup.sql says int...

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 10/16/04 - 03:26 AM:	#4
IP is properly supposed to be text. time is supposed to be int.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/16/04 - 08:24 AM:	#5
I removed {IP} from the ip field for admin (everyone else had numbers) was I right to to that?

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 10/17/04 - 04:01 PM:	#6
May as well. Having your IP there (or blank, or anything else) doesn't really make much difference to anything though.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.