Debug SQL not showing

General
1

Hi,
Running cs-cart 4.15.1.SP4 with PHP version 7.4.18. We have had an issue that I am trying to debug. So I enabled DEBUG_MODE and DEVELOPMENT. This showed the debug bar, which was great.

When I look at the debug bar, I can see SQL, logging, etcetc. But when I try and drill down and get more information, the Yellow top banner appears, the debug bar appears but everything else is blank / empty.

Any ideas on how I can get this debug information to show?

Thank you!

1 Like
2

Hi!

Are you using something other than the file for the cache_backend in the $config variable in the config.local.php file?

3

Thank you for the super quick response! This is the config we have:
$config[‘cache_backend’] = ‘file’;
$config[‘cache_redis_server’] = ‘localhost’;
$config[‘cache_redis_global_ttl’] = 0;

Thank you

1 Like
4

Thanks for the reply!

Could you please check if the var/cache/registry/debugger/ folder (and its parent ones) is writable and readable?

5

Thank you for the reply, can confirm it has read and write access. I just turned up debug again then, and it was wrote a number of files in

I don’t know if this helps, but when debug is on, the primary content just shows a blank page. I see the normal yellow bar up the top, but the rest of the site just never seems to load up

Thanks

6

Could you please let me know the size of these new files? Are they small enough (lesser than 2-3 MB)?

7

Sure can, I just turned the debugger on then. Can confirm that are around 2-3mb each

Any ideas why the site is essentially showing up as blank when I turn this on? This is what the debug bar looks like:

Thank you

8

Hi,
Just wanted to bump this so hopefully someone can help me out? Thanks so much!

9

I hope, these are the last questions :slight_smile:

  1. Are there any JS errors in the browser’s console?
  2. What is the status code of the request sent to the address index.php?dispatch=debugger (the one being sent when you click on the specific debug menu element) and its size?
10

Thank you for the reply, totally understand if you have to ask more questions :slight_smile: That is all good

  1. No js console errors at all
  2. Status code 200, size 669b

When I disable debugging, I get status code 200, size 34kb

11

Thanks! :slight_smile:

Well, 669 bytes means there really wasn’t any data in response, probably just headers. You may need to debug this. Try to start from the app/controllers/common/debugger.php controller, and the mode you are trying to view, sql for example. Check what data is being assigned there via the Tygh::$app['view']->assign method.
https://docs.cs-cart.com/latest/developer_guide/getting_started/debugging.html

I hope it will help you.