Need Help with MySQL Errors [Archive]

adk

03-23-2006, 05:45 AM

Hi, not sure if this is the correct place to post this, so if not, feel free to move it. I am trying to add the PhotoPost Classifieds system to my vB3 forum and I am running into a problem.

I received the following error during setup:

MySQL error reported: [INSERT INTO pp_categories VALUES (1,'Main','',1,'no',0,NULL,NULL,NULL,NULL,NULL,NUL L,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2',0,0,0,0 ,0,0,0,'no', 0, '', 'no', NULL, NULL,'','','');]
Result: Out of range value adjusted for column 'thumbnail' at row 1

The software developer said the problem was that 'Strict Mode' was enabled on my server, which does not allow the insertion of 'NULL' values. They suggested putting MySQL into version 4 mode by changing the .ini file on the server. The problem comes that my hosting provider will not change this. Is there anything else I can do to get this statement to work? If Photopost could give me the data necessary to create a 'real' category instead of 'NULL' values, would that help?Thanks for any help you can give me.

Thank you for visiting. This is our website archive. Please visit our main website by clicking the banner above. vBulletin FAQ is dedicated to helping the forum owner build, manage and profit from his vBulletin Forum vBulletin Web Hosting - Free skins and styles for your vBulletin - Search Engine Optimization

vBulletin FAQ Forums > Programming > PHP MySQL Development > Need Help with MySQL Errors PDA Need Help with MySQL Errors adk 03-23-2006, 05:45 AM Hi, not sure if this is the correct place to post this, so if not, feel free to move it. I am trying to add the PhotoPost Classifieds system to my vB3 forum and I am running into a problem. I received the following error during setup: MySQL error reported: [INSERT INTO pp_categories VALUES (1,'Main','',1,'no',0,NULL,NULL,NULL,NULL,NULL,NUL L,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2',0,0,0,0 ,0,0,0,'no', 0, '', 'no', NULL, NULL,'','','');] Result: Out of range value adjusted for column 'thumbnail' at row 1 The software developer said the problem was that 'Strict Mode' was enabled on my server, which does not allow the insertion of 'NULL' values. They suggested putting MySQL into version 4 mode by changing the .ini file on the server. The problem comes that my hosting provider will not change this. Is there anything else I can do to get this statement to work? If Photopost could give me the data necessary to create a 'real' category instead of 'NULL' values, would that help?Thanks for any help you can give me. noppid 03-23-2006, 10:19 AM Better contact photo post. After the last go around with them, I don't know anyone that will look at their code to help.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35