Data Errores: Column 'path' Cannot Be Null <B>(1048)</b>

Hi,



When I finished the upgrade process, appear this error, does any one have same problem? how to fix it? And in the data base I search



SELECT *

FROM cscart_seo_names

WHERE TYPE = 'p'

AND object_id =398



There is nothing.





Base de datos (error)

Errores: Column 'path' cannot be null (1048)

Query: INSERT INTO cscart_seo_names (name, type, object_id, dispatch, lang_code, path, company_id) VALUES ('3-en-1-cortador-tarjetas-sim-baku-7302', 'p', 398, '', 'es', NULL, 1) ON DUPLICATE KEY UPDATE name = '3-en-1-cortador-tarjetas-sim-baku-7302', type = 'p', object_id = 398, dispatch = '', lang_code = 'es', path = NULL, company_id = 1



index.php (fn_dispatch): 25

app/functions/fn.control.php (display): 611

app/Tygh/SmartyEngine/Core.php (display): 54

app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php (fetch): 394

app/Tygh/SmartyEngine/Core.php (fetch): 70

app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php (content_559c1608dc7870_99358426): 188

var/cache/templates/vivashop/b223a894919027469671d7502daa7f936a0d96c3.tygh.index.tpl.php (smarty_block_hook): 125

app/functions/smarty_plugins/block.hook.php (fetch): 94

app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php (content_559c160d17a453_97781483): 188

var/cache/templates/vivashop/d64218a9b17d248cef15f35adc3d85124c39c245.tygh.et_content.pre.tpl.php (smarty_function_render_location): 50

app/functions/smarty_plugins/function.render_location.php (render): 48

app/Tygh/BlockManager/RenderManager.php (_renderContainer): 146

app/Tygh/BlockManager/RenderManager.php (_renderGrids): 181

app/Tygh/BlockManager/RenderManager.php (_renderGrid): 230

app/Tygh/BlockManager/RenderManager.php (_renderGrids): 289

app/Tygh/BlockManager/RenderManager.php (_renderGrid): 230

app/Tygh/BlockManager/RenderManager.php (_renderGrids): 289

app/Tygh/BlockManager/RenderManager.php (_renderGrid): 230

app/Tygh/BlockManager/RenderManager.php (renderBlocks): 293

app/Tygh/BlockManager/RenderManager.php (renderBlock): 335

app/Tygh/BlockManager/RenderManager.php (renderBlockContent): 400

app/Tygh/BlockManager/RenderManager.php (fetch): 552

app/Tygh/SmartyEngine/Core.php (fetch): 70

app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php (content_559c161157c660_87421214): 188

var/cache/templates/vivashop/c44adcdd2c3717367fb3819a2afdca1eee9cc0db.tygh.products_scroller.tpl.php (fn_url): 161

app/functions/fn.common.php (fn_set_hook): 3283

app/functions/fn.control.php (call_user_func_array): 144

app/addons/seo/func.php (fn_seo_url_post): 1133

app/addons/seo/func.php (fn_create_seo_name): 894

app/addons/seo/func.php (db_query): 236

app/functions/fn.database.php (call_user_func_array): 130

app/Tygh/Database.php (query): 359

Please check

I'm also facing this issue. @eComLabs, so, what you're saying is just edit the table structure and allow NULL values into the path column? Does that not harm other things?

[quote name='larrezz91' timestamp='1436778363' post='222660']

I'm also facing this issue. @eComLabs, so, what you're saying is just edit the table structure and allow NULL values into the path column? Does that not harm other things?

[/quote]



We did not examine this issue, so please ask kickoff3pm if he faced any problems later

Cs-cart have fixed my problem by replacing the following part of code:

" AND IF(products.tracking = ?s, inventory_b.amount >= 1, products.amount >= 1) OR (products.tracking = 'D')“,



with this one:

" AND (IF(products.tracking = ?s, inventory_b.amount >= 1, products.amount >= 1) OR (products.tracking = 'D'))”,



in the func.php file located in the app/addons/bestsellers directory of your CS-Cart installation.



I don´t know if it is the same problem.

Hi all,



@eComLabs thanks for your reply. I think I will not alter the table at this point, seems a bit risky…

@senove also thanks for your reply. Unfortunately, this did not solve the issue for us.

The issue is confirmed by CS-Cart and they're working on it.

Hi all,

We fixed the problem by checking if all the products are in the right category which must belong to the correct store.

So the category must be from the same store, otherwise it give this fault.

To find the wrong products which are causing the problem, you have to make an export of the products (in cs-cart) with only the tablets: category, storeID and SEO_name (which comes from the SEO add-on).

Then you have to export this data to excel, make a table of it and filter all the data on column SEOname which have a blank field. So the SEO name is blank in the fields. All these products have a wrong category/storeID and this causes the problem that there is "path" whichone is null.

When you correct all these products, the dataexport is working again, so are the cronjobs working again.

If you have any questions, please let us know!