Jump to content


Photo

MySQL configuration error?


  • Please log in to reply
6 replies to this topic

#1 rocketeerbkw

rocketeerbkw
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 27 February 2006 - 09:19 AM

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!

#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 27 February 2006 - 04:26 PM

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.

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 27 February 2006 - 07:51 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#4 rocketeerbkw

rocketeerbkw
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 27 February 2006 - 10:27 PM

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...

#5 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 27 February 2006 - 11:25 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#6 rocketeerbkw

rocketeerbkw
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 28 February 2006 - 05:36 AM

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!

#7 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 28 February 2006 - 06:59 AM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users