PhotoPost Community - View Single Post

adkboards · March 20th, 2006, 06:05 PM

Hi, I am having a couple of problems with my installation, first here is the list of database errors that were generated:

Step 3: MySQL error reported: [INSERT INTO pp_categories VALUES (1,'Main','',1,'no',0,NULL,NULL,NULL,NULL,NULL,NULL,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
Database: adkboards

Step 3: MySQL error reported: [INSERT INTO pp_categories VALUES (2,'A Category','Products of a particular type',1,'yes',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','','');]
Result: Out of range value adjusted for column 'thumbnail' at row 1
Database: adkboards

Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (179,'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter the offset here.', '0', 25, 1)]
Result: Data too long for column 'description' at row 1
Database: adkboards

Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (216, 'WorldPay Installation ID', 'wp_instid', 'The Install ID that is generated by the WorldPay CMS for the subscription callback.
You must set your callback url to point to your payment.php script', '', 8, 12)]
Result: Data too long for column 'description' at row 1
Database: adkboards

Step 3: MySQL error reported: [INSERT INTO pp_cache VALUES (1,'',null,null,null,null,null,null,null)]
Result: Out of range value adjusted for column 'timestamp' at row 1
Database: adkboards

Also, I got this error message on the next step:

Unable to create/write to D:\.......\adkboards.com\adkboards.com\....../data! Check your data directory permissions before continuing. My hosting service claims to have set the permissions on this directory correctly, (obviously I have edited part of the actual directory to post here). It seems that the last backslash is going the wrong direction could that be a problem? Also the beginning of the address was also incorrect on the error message, why would it misspell this?

Sorry for the long post, and thank you for any help you can give me.

March 20th, 2006, 06:05 PM	#1 (permalink)
adkboards Junior Member Verified Customer Join Date: Mar 2006 Posts: 24	Installation problems Hi, I am having a couple of problems with my installation, first here is the list of database errors that were generated: Step 3: MySQL error reported: [INSERT INTO pp_categories VALUES (1,'Main','',1,'no',0,NULL,NULL,NULL,NULL,NULL,NULL,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 Database: adkboards Step 3: MySQL error reported: [INSERT INTO pp_categories VALUES (2,'A Category','Products of a particular type',1,'yes',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','','');] Result: Out of range value adjusted for column 'thumbnail' at row 1 Database: adkboards Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (179,'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter the offset here.', '0', 25, 1)] Result: Data too long for column 'description' at row 1 Database: adkboards Step 3: MySQL error reported: [INSERT INTO pp_settings VALUES (216, 'WorldPay Installation ID', 'wp_instid', 'The Install ID that is generated by the WorldPay CMS for the subscription callback. You must set your callback url to point to your payment.php script', '', 8, 12)] Result: Data too long for column 'description' at row 1 Database: adkboards Step 3: MySQL error reported: [INSERT INTO pp_cache VALUES (1,'',null,null,null,null,null,null,null)] Result: Out of range value adjusted for column 'timestamp' at row 1 Database: adkboards Also, I got this error message on the next step: Unable to create/write to D:\.......\adkboards.com\adkboards.com\....../data! Check your data directory permissions before continuing. My hosting service claims to have set the permissions on this directory correctly, (obviously I have edited part of the actual directory to post here). It seems that the last backslash is going the wrong direction could that be a problem? Also the beginning of the address was also incorrect on the error message, why would it misspell this? Sorry for the long post, and thank you for any help you can give me.