Truncate error

Track raids, bosskills, loot with the ct_raidtracker enhanced WoW Addon

Moderators: PoloDude, Gaxme

Truncate error

Postby smurfhell » Sat Jul 28, 2007 7:55 pm

When I try to update my roster with my character profile and raidtracker, I get this message.

Database Error
1265: Data truncated for column 'end' at row 1
SQL:
INSERT INTO `roster_raids` SET `raidid` = '2007-07-27 18:32:26', `instanceid` = '895358', `zone` = 'Karazhan', `end` = '2007-07-28 0:16:28', `note` = ''
File: trigger_functions.php
Line: 91

Any suggestions or ideas?
smurfhell
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Thu Jul 13, 2006 12:22 am

Re: Truncate error

Postby smurfhell » Thu Aug 02, 2007 5:53 am

Fixed the problem by setting MySQL to not run in Strict Mode.
smurfhell
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Thu Jul 13, 2006 12:22 am

Truncate error

Postby zanix » Thu Aug 02, 2007 6:25 am

Yes, but it will still truncate the data, it just won't give you the error anymore
That field in the database need to be longer

The end field probably is a varchar field,
If so change it to varchar(20)
If it's a datetime field, it shouldn't be having this error
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Truncate error

Postby niavlys » Thu Aug 02, 2007 4:02 pm

end is an INT(12)
User avatar
niavlys
WR.net Apprentice
WR.net Apprentice
 
Posts: 58
Joined: Thu Aug 24, 2006 8:32 pm
Location: Bretagne, France

Truncate error

Postby smurfhell » Fri Aug 03, 2007 1:38 am

Oh yeah, good point on the truncating of data. I checked and it only had "2007" instead of the whole date and time. I changed that column to also be a datetime field and manually entered the date and time.
Don't know if this affects anything, everything imported correctly and looks correct.
I'll try the default MySQL settings next time I upload and see if that solves the problem.
smurfhell
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Thu Jul 13, 2006 12:22 am

Truncate error

Postby zanix » Fri Aug 03, 2007 3:38 am

Yes, change it to a datetime field
That would be the best bet
Last edited by zanix on Fri Aug 03, 2007 3:40 am, edited 1 time in total.
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to RaidTracker

Who is online

Users browsing this forum: No registered users and 1 guest

cron