Can't upload images

[rcjay2]

Hello,

I have everything installed. Just can't upload images. I get the error "Out of range value adjusted for column 'id' at row 1" when clicking the upload button.

Any suggestions?

[Connie]

please, more information!!!!!

we need the info from Admin / general info about server, version etc.

[tinyblob]

A full copy/paste of the error, or even better - a screenshot, would be helpful here.
Also, are the images you're uploading standard jpgs? Are they a reasonable filesize/dimension?

[rcjay2]

A full copy/paste of the error, or even better - a screenshot, would be helpful here.
Also, are the images you're uploading standard jpgs? Are they a reasonable filesize/dimension?

I am able to login to pixelpost/admin/install.php just fine. The problem I am having is on the admin page with I browse for an image and yes it is a standard .jpg file. I can add the image fine but when I try to click on upload, I get the error "Out of range value adjusted for column 'id' at row 1" at the bottom of the admin page.

INFO
Server 2003
MySQL 5
PHP 5
Apache
Pixelpost 1.4.3

If there is something else you guys would like me to post just let me know.

Thanks for all your help,

Rob

[tinyblob]

rcjay, that makes sense - you're running MySQL 5.

MySQL 5 adds STRICT MODE. strict mode gets upset when you try to add a blank value to the database, which we do so that the database automatically generates an id for the uploaded image.

To solve the problem i'd recommend going back to MySQL v4.*

If you can't do that and have complete shell access to the server you might try this:


1. Locate the file my.ini in your MySQL installation folder
2. Uncomment the line:
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_ SUBSTITUTION"

3. Restart the mysql service (or the computer)


but be aware that i copied and pasted that from elsewhere, and can't offer any kind of support.

you could also contact your hosting support and explain to them that STRICT MODE is causing you problems.


i am hopeful that this issue has already been resolved in v1.5 - guys?

[rcjay2]

rcjay, that makes sense - you're running MySQL 5.

MySQL 5 adds STRICT MODE. strict mode gets upset when you try to add a blank value to the database, which we do so that the database automatically generates an id for the uploaded image.

To solve the problem i'd recommend going back to MySQL v4.*

If you can't do that and have complete shell access to the server you might try this:



but be aware that i copied and pasted that from elsewhere, and can't offer any kind of support.

you could also contact your hosting support and explain to them that STRICT MODE is causing you problems.


i am hopeful that this issue has already been resolved in v1.5 - guys?


Tinyblob,

Thank you for the tip. I will try this when I get home this evening. You are speaking about the my.ini file correct?

As for the hosting support, it is me. I have the server running at home.

Thank you,
Rob

[tinyblob]

Yep, it mentions "my.ini" in the quote. I know very little about Windows 2003, so the change is up to you :)

[raminia]

Open up your MySQL configuration file and comment out the sql-mode line, it will disable the strict settings, which should make things work again.

solution from url (http://www.simplemachines.org/community/index.php?topic=55642.msg389791)

[rcjay2]

Open up your MySQL configuration file and comment out the sql-mode line, it will disable the strict settings, which should make things work again.

solution from url (http://www.simplemachines.org/community/index.php?topic=55642.msg389791)

OK...I did that and I did not get the error and got

POSTED: Sunset of nearby Creve Coeur Park
2005-11-30 20:55:18

Now how do I view the page?

[tinyblob]

That's posted the image, you can view it by going to your Pixelpost directory, for example mine is:
http://blog.touchnothing.net

[rcjay2]

That's posted the image, you can view it by going to your Pixelpost directory, for example mine is:
http://blog.touchnothing.net

Tinyblob,

Thanks for your help. Your site is awesome. I figured out how to view it and how to modify the CSS to limit the picture size. Now how do I add the browse(archive) page?

What is the proper way to upload mutiple images? I tried to upload about 8 images to see if I could flip through them. No dice. I know that I haven't set something up right. If you could provide some tips or pointers that would be great.