v1.1 install failed - 1366: Incorrect integer value

Displays character achievements

Moderator: Ulminia

v1.1 install failed - 1366: Incorrect integer value

Postby AnthonyB » Wed Jan 21, 2009 8:09 pm

Hi Ulminia,

Just downloaded v1.1 and tried to install it. Got the following error:

Database Error1366: Incorrect integer value: '' for column 'wrnet_id' at row 1
SQL:
INSERT INTO `roster_addon` VALUES (NULL,"achivements","1.1 (458)","1",0,"Player Achivements","Displays Player Achivements","a:1:{i:0;a:2:{s:4:\"name\";s:34:\"Ulminia warcraftalliance@gmail.com\";s:4:\"info\";s:33:\"Retired Roster Dev Now addon Dev!\";}}","achievement_general","",NULL);
File: lib\dbal\mysql.php
Line: 234
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

v1.1 install failed - 1366: Incorrect integer value

Postby Ulminia » Sun Jan 25, 2009 6:44 pm

i will update the installer for a 0 'wrnet_id'
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: v1.1 install failed - 1366: Incorrect integer value

Postby Crazy_Land1 » Wed Feb 11, 2009 9:53 am

Hi there

I just installed too and get the same error while trying to add it to wowroster
User avatar
Crazy_Land1
WR.net Apprentice
WR.net Apprentice
 
Posts: 20
Joined: Fri Sep 21, 2007 8:48 am
Location: Earth i Think

Re: v1.1 install failed - 1366: Incorrect integer value

Postby Crazy_Land1 » Sat Feb 28, 2009 7:33 am

Hi Ulminia

I did some looking around in the files and i founf the 'wrnet_id' and changed it to 0 and then to 1 but in the file all it had was '' no 0 or 1 in it.

When i changed it from nothing to 0 and 1 it installed but when i clicked on the icon i get this error now
Fatal error: Cannot use string offset as an array in \roster\addons\achivements\char\index.php on line 61

So i uninstall the addon then reinstall it and get this error

Install error in query 6. MySQL said:
1050: Table 'roster_addons_achivements_summary' already exists
The query was:
CREATE TABLE `roster_addons_achivements_summary` ( `id` int(11) NOT NULL auto_increment, `member_id` int(11) NOT NULL, `guild_id` int(11) NOT NULL, `total` varchar(255) NOT NULL default '', `general` varchar(10) NOT NULL default '', `quests` varchar(10) NOT NULL default '', `exploration` varchar(10) NOT NULL default '', `pvp` varchar(10) NOT NULL default '', `dn_raids` varchar(10) NOT NULL default '', `prof` varchar(10) NOT NULL default '', `rep` varchar(10) NOT NULL default '', `world_events` varchar(10) NOT NULL default '', `feats` varchar(10) NOT NULL default '', `title_1` varchar(255) NOT NULL default '', `disc_1` varchar(255) NOT NULL default '', `date_1` varchar(12) NOT NULL default '', `points_1` varchar(10) NOT NULL default '', `title_2` varchar(255) NOT NULL default '', `disc_2` varchar(255) NOT NULL default '', `date_2` varchar(12) NOT NULL default '', `points_2` varchar(10) NOT NULL default '', `title_3` varchar(255) NOT NULL default '', `disc_3` varchar(255) NOT NULL default '', `date_3` varchar(12) NOT NULL default '', `points_3` varchar(10) NOT NULL default '', `title_4` varchar(255) NOT NULL default '', `disc_4` varchar(255) NOT NULL default '', `date_4` varchar(12) NOT NULL default '', `points_4` varchar(10) NOT NULL default '', `title_5` varchar(255) NOT NULL default '', `disc_5` varchar(255) NOT NULL default '', `date_5` varchar(12) NOT NULL default '', `points_5` varchar(10) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM;

Installation of achivements failed, but rollback successful.
So i have it installing but i now have those errors, any ways just wanted you to know and thanks for all you are doing :)
Last edited by Crazy_Land1 on Sat Feb 28, 2009 7:34 am, edited 1 time in total.
Image
Image
User avatar
Crazy_Land1
WR.net Apprentice
WR.net Apprentice
 
Posts: 20
Joined: Fri Sep 21, 2007 8:48 am
Location: Earth i Think

v1.1 install failed - 1366: Incorrect integer value

Postby Anaxent » Sat Feb 28, 2009 8:00 am

Hmm I think I had the same error try uploading cp data then click on the icon to view the achievements.
User avatar
Anaxent
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 642
Joined: Tue Jul 04, 2006 6:27 am
Location: Phoenix, Az

Re: v1.1 install failed - 1366: Incorrect integer value

Postby Crazy_Land1 » Sat Feb 28, 2009 8:53 am

yep thats what i did, install, upload, clicked icon, error
User avatar
Crazy_Land1
WR.net Apprentice
WR.net Apprentice
 
Posts: 20
Joined: Fri Sep 21, 2007 8:48 am
Location: Earth i Think

v1.1 install failed - 1366: Incorrect integer value

Postby Ulminia » Sat Feb 28, 2009 10:52 am

yes i think there is no remove table info for the summary table add
Code: Select all
$installer->drop_table( $installer->table('summary') );

to the uninstall() function in the install.def.php file i have these changes made ial upload a new download version tomarrow..
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: v1.1 install failed - 1366: Incorrect integer value

Postby Crazy_Land1 » Sat Feb 28, 2009 12:20 pm

So cool thank you again Ulminia :)
User avatar
Crazy_Land1
WR.net Apprentice
WR.net Apprentice
 
Posts: 20
Joined: Fri Sep 21, 2007 8:48 am
Location: Earth i Think

Re: v1.1 install failed - 1366: Incorrect integer value

Postby Borsti » Tue Mar 03, 2009 7:09 pm

[quote="Ulminia" i have these changes made ial upload a new download version tomarrow..[/quote]

Think in other Countrys will work the Clock very slowly. :rofl:
Waiting hopefull for an update of this fine addon, :thumleft:
User avatar
Borsti
WR.net Journeyman
WR.net Journeyman
 
Posts: 87
Joined: Sat Jul 08, 2006 11:37 am
Location: Hamburg/Germany

v1.1 install failed - 1366: Incorrect integer value

Postby Ulminia » Wed Mar 04, 2009 12:04 am

armory sync is broken too im trying to maintain 6 addons bare with me
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com


Return to Achievements

Who is online

Users browsing this forum: No registered users and 0 guests

cron