Installation problems

[adkboards]

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.

[Chuck S]

this might help your issue on mysql issue.

Mysql 5 Compatibility

as far as create write the data and uploads directories need to be READ WRITE EXECUTE per the install instructions and you want to use forward slashes in paths not backslashes

[adkboards]

Thanks for the reply. you will have to forgive me, as I am VERY unfamiliar with all this stuff. Where would I go to change the MySQL .ini files like you indicated in the other post? I am using a hosting service for my site, wouldn't this mean they would have to change the version of MySQL on their servers? Wouldn't this affect every one else that has a database on the same machine as me? Or would it just affect my database? Also, if I choose method three from your post; "Execute the query SET GLOBAL sql_mode='MYSQL40'", Would this affect the rest of my message board's features? I am running vBulletin3, with v3 Arcade and some other plug-ins.

As for the direction of the 'slashes', I did not enter that directory path anywhere, it had already been filled in for me on the 'Step1' installation page, correctly I think. But when the error message came up in 'Step4', the last slash was printed opposite from the others and the beginning of the path was spelled wrong. Is it picking up an incorrect path name from somewhere? and how would I fix it if it was?

[Chuck S]

Hello

The suggestions for paths and urls are suggestions that we get from the server it is always up to the user on install to verify these. Windows will always give paths as backslashes and there is nothing we can do about that. Simply correct the path to /

If your host is using MYSQL 5 in strict mode it is not compatible yet and the post I noted should allow things to work. It would not break anything else.

You can ask your host if they are willing to try this. Just place the line in bold under the line noted in the mysql config file and restart the server

Content visible to verified customers only.

[adkboards]

My hosting company said they could not make the change you suggested to their server. They gave me a long-winded response but the gist of it was they are afraid it will affect other customers. Is there anything I could try through MyPHPAdmin to alter my database manually to allow for these errors?

[adkboards]

Hi, are you still out there? I fixed the 'backslash' problem and got the product to install but I can't add any categories, I'm assuming because of the MySQL errors I listed previously. Is there anything I can do short of going through my hosting providor? They are not much help. Is it possible to use a SQL script that has information in it for an existing category, so I wouldn't be trying to add 'Null' values to a table. I could just remove this category later through the Admin panel. Thanks again.

[Chuck S]

We have not released a product compatible with MYSQL5 STRICT MODE which is why we posted this very announcement on our site about this new mysql 5 issue.

Your host will not break anyone's site making that change 99% of servers out there run mysql 4 series and the posted note to not run mysql in strict mode comes right off the mysql support site.

[adkboards]

I found my own work-around for this problem. All I had to do was manually enter a new row in the pp-categories table through myphpadmin. Just enter a unique id number and the name of the category. The new category will then be editable through the 'Edit Categories' link in the photopost admin panel. Everything else seems to be working fine.