[Solved] Problems with Mysql Database editing/new entries in Prestashop 1.4.0.17

[walkies]

It would seem that Prestashop will not edit products or create new products and save them back to the mysql database.

I am getting no errors however, if I click on Save & Stay when editing a product it will take me back to the catalogue.

If I clone a product then it does clone it but any editing fails to save in the database.
When I create a new product it fails to save the product in the database.


Can anyone give a suggestion why this might be happening and how to fix please ?

[PrestaDesigner.com]

Why not trying an update to 1.4.2.5? Also what's your server spec's?

[walkies]

well the last time I upgraded I lost the entire shop and had to rebuild it.

Server information

Prestashop Version: 1.4.0.17
Server information: Linux #61-Ubuntu SMP Fri Apr 8 18:24:35 UTC 2011 i686
Server software Version: Apache/2.2.14 (Ubuntu)
PHP Version: 5.3.2-1ubuntu4.9
MySQL Version: 5.1.41-3ubuntu12.10

Prestashop is SO slow uploading images also... anyway to speed that up?

[walkies]

OK Problem solved!

If you have an internal server and are working from a Windows machine you should add a line to your hosts file... so in my case it was

192.168.0.21 www.dogcrafts.co.uk

and save it

run a command window and type in the following:


ipconfig /flushdns

This appeared to do the following:

Random issues solved, in my case; allowing new products to be saved, fast uploading of images was attained and editing of products to be completed successfully. The whole editing of dogcrafts is now fast with no issues with graphics or anything else that I can see at this time.

It appears that prestashop was trying to upload to my router instead of the server and adding that line into your hosts file (windows only) resolved the problem...

So if anyone else is having unexplained random problems on Prestashop then you could try this solution...... it worked for me!