Can't Manage Products From Admin Panel

Hello,

I am having an issue in managing the produts from admin panel it shows me this error when i click to products:

This page isn’t working

is currently unable to handle this request.

HTTP ERROR 500

Can you please help me why is might happen, i checked the error log from cpanel but seems that nothing its goging wrong there

Thanks in advance!

Hello.

There may be different reasons. Turn on debug mode and show what you see.

In config.local.php set

ini_set('display_errors', 1);

and in file config.php please find "DEVEL" and replace

//define('DEVELOPMENT', true);

on

define('DEVELOPMENT', true);

and try again your operation.

Please show result.

Best regards

Robert.

Hello.

There may be different reasons. Turn on debug mode and show what you see.

In config.local.php set

ini_set('display_errors', 1);

and in file config.php please find "DEVEL" and replace

//define('DEVELOPMENT', true);

on

define('DEVELOPMENT', true);

and try again your operation.

Please show result.

Best regards

Robert.

Thanks,

I followed your instructions, now i dont get the error message but only a blank page :(

Hello.

Have you set the flag in php display_errors=on?

Best regards

Robert.

Hello.

Have you set the flag in php display_errors=on?

Best regards

Robert.

database error
error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asc, product_id ASC LIMIT 0, 24' at line 1 (1064)

i get this message in logs, from the admin panel, do you think this has something to do with my issue, i can access all the other section for admin, categories too, only when i click the products i get the error in my first message,

Please do you have any idea how to fix?

Hello.

Send me login details to the panel and to ftp if you can. We will check what the problem is.

office@cs-cart.pl

Best regards.

Robert.

Hello.

Send me login details to the panel and to ftp if you can. We will check what the problem is.

office@cs-cart.pl

Best regards.

Robert.

I just provided the credential to this email,

Thank you very much

Before you go digging too deep, disalble any 3rd party addons and see if problem goes away. If so, enable 1 by 1 till problem returns and then contact the vendor of that addon.

Please post the whole sql query here

Please post the whole sql query here

Hello,

This is the whole error i get in the logs continuosly:

Database (error)
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asc, product_id ASC LIMIT 0, 24' at line 1 (1064)
Query: SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, IF(images_links.detailed_id IS NULL OR images_links.detailed_id=0, 0, 1) as images FROM cscart_products as products LEFT JOIN cscart_images_links AS images_links ON products.product_id = images_links.object_id AND images_links.type="M" AND images_links.object_type="product" LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') WHERE 1 AND companies.status = 'A' AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.approved = 'Y' AND IF(images_links.detailed_id IS NULL OR images_links.detailed_id=0, 1, 0)=0 GROUP BY products.product_id ORDER BY images desc, asc, product_id ASC LIMIT 0, 24

Backtrace››

index.php (fn_dispatch): 25
app/functions/fn.control.php (fn_run_controller): 460
app/functions/fn.control.php (include): 702
app/addons/bestsellers/controllers/frontend/products.post.php (fn_get_products): 66
app/functions/fn.catalog.php ({closure}): 7110
app/functions/fn.catalog.php (db_get_array): 7027
app/functions/fn.database.php (call_user_func_array): 32
app/Tygh/Database/Connection.php (getArray): 229
app/Tygh/Database/Connection.php (query): 489

Do you use addon which allows to find products without images? Look like it causes the issue

Do you use addon which allows to find products without images? Look like it causes the issue

No i dont use any :( any other idea why might happen?

Before you go digging too deep, disalble any 3rd party addons and see if problem goes away. If so, enable 1 by 1 till problem returns and then contact the vendor of that addon.

I did it the issue is still the same :(

Did you also disable my_changes addon? Many times developers will use it instead of a separate addon if they consider the change to be smallish. You're obviosouly missing a column name in the ORDER BY clause. Generally internal cs-cart SQL will NOT use lower case for SQL keywords.

ORDER BY images desc, asc, product_id ASC LIMIT 0, 24

Hello.

Did you enable display_errors on it?

Best regards

Robert.

No i dont use any :( any other idea why might happen?

Anyway, this request is not default and was modified. Search for changes in the core files or disable 3rd party addons one by one

Did you also disable my_changes addon? Many times developers will use it instead of a separate addon if they consider the change to be smallish. You're obviosouly missing a column name in the ORDER BY clause. Generally internal cs-cart SQL will NOT use lower case for SQL keywords.

ORDER BY images desc, asc, product_id ASC LIMIT 0, 24

Yes i did and the issue its still the same :(

Before you go digging too deep, disalble any 3rd party addons and see if problem goes away. If so, enable 1 by 1 till problem returns and then contact the vendor of that addon.

Hi all

I disable all addons

after i work something else, i click ENABLE all addon ... and broke with same 500 error

if i rename ADDONS folder name i can login to admin and see all my orders and details of them

but i don`t have top menu with settings, design, etc

Thanks

This is my develop log

Fatal error: Uncaught Error: Class 'Tygh\Enum\Addons\Discussion\DiscussionObjectTypes' not found in /home/ambalaj1/public_html/app/addons/discussion/schemas/permissions/admin.post.php:34 Stack trace: #0 /home/ambalaj1/public_html/app/functions/fn.common.php(2347): include() #1 /home/ambalaj1/public_html/app/functions/fn.common.php(5593): fn_get_schema('permissions', 'admin') #2 /home/ambalaj1/public_html/app/functions/fn.common.php(2372): fn_get_permissions_schema('admin') #3 /home/ambalaj1/public_html/app/functions/fn.control.php(317): fn_check_permissions('orders', 'details', 'admin', 'GET', Array) #4 /home/ambalaj1/public_html/alex.php(27): fn_dispatch() #5 {main} thrown in /home/ambalaj1/public_html/app/addons/discussion/schemas/permissions/admin.post.php on line 34

Thanks

[06-May-2020 09:35:24 Europe/Bucharest] PHP Fatal error: Uncaught Error: Class 'Tygh\Enum\Addons\Discussion\DiscussionObjectTypes' not found in /home/ambalaj1/public_html/app/addons/discussion/schemas/permissions/admin.post.php:34
Stack trace:

0 /home/ambalaj1/public_html/app/functions/fn.common.php(2347): include()
1 /home/ambalaj1/public_html/app/functions/fn.common.php(5593): fn_get_schema('permissions', 'admin')
2 /home/ambalaj1/public_html/app/functions/fn.common.php(2372): fn_get_permissions_schema('admin')
3 /home/ambalaj1/public_html/app/functions/fn.control.php(317): fn_check_permissions('orders', 'manage', 'admin', 'GET', Array)
4 /home/ambalaj1/public_html/alex.php(27): fn_dispatch()
5
thrown in /home/ambalaj1/public_html/app/addons/discussion/schemas/permissions/admin.post.php on line 34