Notice (8): Trying to access array offset on value of type null [APP/Controller/PagesController.php, line 382]
Warning (512): Unable to emit headers. Headers sent in file=/home/cmdotnet/public_html/vendor/cakephp/cakephp/src/Error/Debugger.php line=954 [CORE/src/Http/ResponseEmitter.php, line 71]
Warning (2): Cannot modify header information - headers already sent by (output started at /home/cmdotnet/public_html/vendor/cakephp/cakephp/src/Error/Debugger.php:954) [CORE/src/Http/ResponseEmitter.php, line 168]
Warning (2): Cannot modify header information - headers already sent by (output started at /home/cmdotnet/public_html/vendor/cakephp/cakephp/src/Error/Debugger.php:954) [CORE/src/Http/ResponseEmitter.php, line 197]
Error: json_decode() expects parameter 1 to be string, null given

json_decode() expects parameter 1 to be string, null given 📋

TypeError
Toggle Vendor Stack Frames
APP/Controller/PagesController.php Toggle Arguments
        $markets = TableRegistry::get('markets');
        $results = TableRegistry::get('results');
        $marketData = $markets->find('all')->select(['id','name','week_days'])->where(['name'=>'Shri Kalyan'])->first();
        $marketWeekData = $marketData['week_days'];
        $marketWeekData = json_decode($marketWeekData,true);
        $flipData = array_flip($marketWeekData);
        $start_date = '2020-11-30';
        $connection = ConnectionManager::get('default');
        $sql = "select id,bet_type,panna,CASE when DAYNAME(declare_date) = 'Sunday' THEN Week(declare_date) ELSE Week(declare_date)+1 END as week ,result_value,final_value,declare_date, DAYNAME(declare_date) as day_name,DATE_FORMAT(declare_date,'%Y-%m-%d') as result_date from results where market_id = $marketData->id and DATE(declare_date) >= '$start_date' order by declare_date ASC";
Error in: ROOT/src/Controller/PagesController.php, line 383

Could this be caused by using Auto-Tables?

Some of the Table objects in your application were created by instantiating "Cake\ORM\Table" instead of any other specific subclass.

This could be the cause for this exception. Auto-Tables are created for you under the following circumstances:

  • The class for the specified table does not exist.
  • The Table was created with a typo: $this->getTableLocator()->get('Atricles');
  • The class file has a typo in the name or incorrect namespace: class Atricles extends Table
  • The file containing the class has a typo or incorrect casing: Atricles.php
  • The Table was used using associations but the association has a typo: $this->belongsTo('Atricles')
  • The table class resides in a Plugin but no plugin notation was used in the association definition.

Please try correcting the issue for the following table aliases:

  • markets
  • results

If you want to customize this error message, create templates/Error/error500.php