Syntax error or access violation: 1305 FUNCTION

My guess is that you are running an old mysql version. 5.6?

MySql server: 5.6.26

PHP versione 7.2

JSON_EXTRACT was introduced in MySQL version 5.7 I believe, so you have to upgrade!

You cannot use json in mysql 5.6. Upgrade to 5.7 or dont use json in the database

I update my server version, let you know if it works.

Thanks

apparently my hosting does not allow me to update Mysql

}

}

public function index(Request $request)
{
    $lang = Session::get('changed_language');

    $products = DB::table('products')->join('stores', 'stores.id', '=', 'products.store_id')
        ->join('brands', 'brands.id', '=', 'products.brand_id')
        ->join('categories', 'categories.id', '=', 'products.category_id')
        ->join('subcategories', 'subcategories.id', '=', 'products.child')
        ->leftJoin('add_sub_variants', function ($join) {
            $join->on('products.id', '=', 'add_sub_variants.pro_id')->where('add_sub_variants.def', '=', '1');
        })
        ->leftJoin('variant_images', 'variant_images.var_id', '=', 'add_sub_variants.id')
        ->leftJoin('grandcategories', 'grandcategories.id', '=', 'products.grand_id')
        ->select('products.id as proid', 'products.category_id as category_id', FacadesDB::raw("json_decode(products.name, '$.$lang') as productname"), 'products.featured as featured', 'products.status as status', 'products.created_at as createdat', 'products.updated_at as updateat', 'stores.name as storename', 'brands.name as brandname', FacadesDB::raw("json_decode(categories.title, '$.$lang') as catname"), FacadesDB::raw("json_decode(subcategories.title, '$.$lang') as subcatname"), FacadesDB::raw("json_decode(grandcategories.title, '$.$lang') as childname"), "variant_images.main_image as mainimage", 'products.price as price', 'products.vender_price as vender_price', 'products.tax_r as tax_r', 'products.vender_offer_price as vender_offer_price', 'products.offer_price as offer_price', 'add_sub_variants.main_attr_id as main_attr_id', 'add_sub_variants.main_attr_value as main_attr_value')
        ->where('products.deleted_at', '=', null)
        ->get();

    if ($request->ajax()) {
        return DataTables::of($products)
            ->editColumn('checkbox', function ($row) {

                $chk = "<div class='inline'>
                      <input type='checkbox' form='bulk_delete_form' class='filled-in material-checkbox-input' name='checked[]'' value='$row->proid' id='checkbox$row->proid'>
                      <label for='checkbox$row->proid' class='material-checkbox'></label>
                    </div>";

                return $chk;
            })
            ->addIndexColumn()
            ->addColumn('image', function ($row) {

                $image = '';