[SOLVED] Fatal error message!

[schwagal]

Hi there,

I did an update recently - 1.3.6.0 to 1.4.0.17

Now everytime I want to add an image to a new or existing product I always get this error message: Fatal error (StockMvt -> id_stock_mvt_reason = -1)

Any ideas?

[shokinro]

there are many things could cause fatal error. some time run out of memory also cause this.
try set to following parameter in /comfig/config.inc.php to see if you can see any errors

@ini_set('display_errors', 'on');

[schwagal]

there are many things could cause fatal error. some time run out of memory also cause this.
try set to following parameter in /comfig/config.inc.php to see if you can see any errors

@ini_set('display_errors', 'on');

Hi,

Thanks for the reply - Turned the debugging "display errors" on but doesn't make any difference of the error output, just says the same thing, when I try to upload another image.

Any other idea or pointer in some direction, where to look at would be appreciated..

Cheers

[shokinro]

Have no idea what is the cause.
from the error message, it seem that related to stock change. (but why upload image will affect stock?)
seem trying to insert a StockMvt record, but id_stock_mvt_reason = -1
maybe database related error.

The in same config/config.inc.php, there is another parameter set as following, see if there any database error.

define('_PS_DEBUG_SQL_', true);

[shokinro]

Can you also check database table "ps_stock_mvt_reason_lang" to see if the stock_mvt_reason have all the lanugages you are using at your store?

If you install some new language after store installation, maybe the stock_mvt_reason for new language is not added.
and so there is record and id_stock_mvt_reason becomes -1? (just guess)

[schwagal]

Have no idea what is the cause.
from the error message, it seem that related to stock change. (but why upload image will affect stock?)
seem trying to insert a StockMvt record, but id_stock_mvt_reason = -1
maybe database related error.

The in same config/config.inc.php, there is another parameter set as following, see if there any database error.

define('_PS_DEBUG_SQL_', true);

Thanks again, flicked that on but doesn't give me any more details about what could be going wrong.

Apache doesn't need a graceful/restart or anything, right?

[schwagal]

Can you also check database table "ps_stock_mvt_reason_lang" to see if the stock_mvt_reason have all the lanugages you are using at your store?

If you install some new language after store installation, maybe the stock_mvt_reason for new language is not added.
and so there is record and id_stock_mvt_reason becomes -1? (just guess)

Yeah I can poke around a bit, not too familiar with the schema and my SQL foos are a bit weak but I'll post possible informations about it, Thanks.

[schwagal]

I found many duplicate bug reports about this on the bugtracker but also some pointers into the forum, where people discussed this.

http://www.prestashop.com/forums/viewthread/97616/installing_prestashop/solved_fatal_error_stockmvt__id_stock_mvt_reason__1

^^ With setting - the default stock movement reason from “order” to “increase” - I managed to be able to upload images again.

Hope that helps others, too.

Cheers...

[shokinro]

thanks for feedback and sharing the information. So the issue IS stock movement related.
please mark it as SOLVED if you think your issue has been fixed. thanks

[schwagal]

Yeah looked like it.

I'll mark this thread as solved, thanks.

[websitedesignerss]

I got an idea from your posts. Thank you for your information.

[Bella]

Thanks, Schwagal, that did the trick!