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!