rocketeerbkw Posted February 27, 2006 Share Posted February 27, 2006 I'm running MySQL(latest) on windows XP Pro with IIS(v5) and php(latest) installed.I'm trying to install IPB PowerBoard v2.1.3 on localhost but get this error:[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]INSERT INTO ibf_task_manager VALUES ('', 'Update Topic Views Counter', 'updateviews.php', 1141029329, -1, -1, 3, -1, 'ddce954b5ba1c163bc627ca20725b595', 0, 'Used when topic views are not incremented immediately', 1, 'updateviews', 0, 0);Out of range value adjusted for column 'task_id' at row 1[/quote]Since I haven't ever had troubles with installing this on paid hosting services, or even on my friends computer, I assume it is something I have mis-configured.Since I have checked my PHP configuration and know next to nil about MySQL configs, could this be my problem?Can anyone tell me or point me in the right direction?Much thanks! Quote Link to comment https://forums.phpfreaks.com/topic/3664-mysql-configuration-error/ Share on other sites More sharing options...
wickning1 Posted February 27, 2006 Share Posted February 27, 2006 How was the database generated? Did you have to do it by hand or was it generated by an IPB configuration script? It looks to me like the column `task_id` in table `ibf_task_manager` was not set to AUTO_INCREMENT, but I am working off of very limited information here. Quote Link to comment https://forums.phpfreaks.com/topic/3664-mysql-configuration-error/#findComment-12748 Share on other sites More sharing options...
fenway Posted February 27, 2006 Share Posted February 27, 2006 Since there is no column list in your INSERT, it's hard to guess which value goes with which field. But it sounds to me like you're putting too big a number in a particular field. Post the table structure for the table in question. Quote Link to comment https://forums.phpfreaks.com/topic/3664-mysql-configuration-error/#findComment-12811 Share on other sites More sharing options...
rocketeerbkw Posted February 27, 2006 Author Share Posted February 27, 2006 All the information I have is what you have.It's an automated install script that has worked on every other site or IIS i've been on.That's what I thought too wickning1, but since I can't tell it to set it that way, I assume its mysql that's not getting it right.Thanks... Quote Link to comment https://forums.phpfreaks.com/topic/3664-mysql-configuration-error/#findComment-12862 Share on other sites More sharing options...
fenway Posted February 27, 2006 Share Posted February 27, 2006 I don't know what you mean -- get the table structure for ibf_task_manager using SHOW CREATE TABLE, and post it here. That's all the info that we'll need. Quote Link to comment https://forums.phpfreaks.com/topic/3664-mysql-configuration-error/#findComment-12886 Share on other sites More sharing options...
rocketeerbkw Posted February 28, 2006 Author Share Posted February 28, 2006 Thanks Fenway but It's automated install....meaning it does it by itself, I can't run any queries...oh well.I fixed this by turning strict mode to OFF. So it was a config error.Thanks for all your help! Quote Link to comment https://forums.phpfreaks.com/topic/3664-mysql-configuration-error/#findComment-12951 Share on other sites More sharing options...
fenway Posted February 28, 2006 Share Posted February 28, 2006 Glad you got it working -- I just figured the table creation must have occured before the insert, so I thought that might give a clue. All's well that ends well, I guess. Quote Link to comment https://forums.phpfreaks.com/topic/3664-mysql-configuration-error/#findComment-12960 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.