Adding Products fails after two.

[Saftek]

I seem to be having all sorts of problems...

The first two products added ok. Attempting to add a third results in this error

Unable to move file [C:\WINDOWS\Temp\phpC2.tmp] [C:/path to/pp-classifieds/data/3/clmax.jpg]

Replaced the real path with "path to". It is correct.

Looking at the data folder there is no "3" folder. So apparently it isn't being created. Does every product end up with a numbered folder?

[Chuck S]

Check to make sure your server does not have safe mode set to on in PHPINFO under admin. You can not have safe mode on. Now your path must be correct and permissions must be set to READ WRITE EXECUTE on the data directory for us to create your categories. When you created a new category in admin => edit categories which used the 3 variable since it was next in line your data category did not get created because permissions where not right or your path was wrong. Anyway recheck permissions delete any empty new categories that you set and did not work and recreate them. This time make note if there are any errors and record the numeric number of the new category. You can then verify through ftp it was created. If permissions are correct and it is created you should be able to upload to it.

[Saftek]

No apparently this was also caused by the strict mode statement in the my.ini file. All the problems noted in various posts seem to relate to that statement... based on my preliminary testing.

As a result, I'd post something telling folks that mysql 5 and above need to have the Strict_trans_tables entry removed from the sql mode statement in the my.ini file (and whatever the *inx version is ...)

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

SHOULD BE:

# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

[Chuck S]

Glad its sorted although I dont see why mysql strict mode would have anything to do with a directory not being created on the server.

[Saftek]

Got me.

[Chuck S]

Not a big deal glad its working I just dont see how a php action and a mysql action would have anything to do like that. I mean if the mysql action fails then we dont create a directory and then again you dont have a category created. For you to get the error you have above an entry would have to have been processed in mysql meaning you created the category through the script and it was entered fine but the php directive to create the cat directory failed which is a php issue with a bad path or something. Thats why I stated what I did.

Now unless you created that category directly in mysql to test things that would explain the issue