Jump to content

Archived

This topic is now archived and is closed to further replies.

rocketeerbkw

MySQL configuration error?

Recommended Posts

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!

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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...

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.