Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

obet's avatar
Level 1

Curl error (code 3)

Hi! I have just updated my Laravel using composer update, unfortunately, I run into this problem. I wonder what went wrong?

[2019-02-21 11:52:43] local.ERROR: Curl error (code 3): <url> malformed {"exception":"[object] (RuntimeException(code: 0): Curl error (code 3): <url> malformed at C:\xampp\htdocs\psi\vendor\monolog\monolog\src\Monolog\Handler\Curl\Util.php:45)
[stacktrace]
#0 C:\xampp\htdocs\psi\vendor\monolog\monolog\src\Monolog\Handler\SlackWebhookHandler.php(97): Monolog\Handler\Curl\Util::execute(Resource id #259)
#1 C:\xampp\htdocs\psi\vendor\monolog\monolog\src\Monolog\Handler\AbstractProcessingHandler.php(37): Monolog\Handler\SlackWebhookHandler->write(Array)
#2 C:\xampp\htdocs\psi\vendor\monolog\monolog\src\Monolog\Logger.php(337): Monolog\Handler\AbstractProcessingHandler->handle(Array)
#3 C:\xampp\htdocs\psi\vendor\monolog\monolog\src\Monolog\Logger.php(616): Monolog\Logger->addRecord(400, 'Curl error (cod...', Array)
#4 C:\xampp\htdocs\psi\vendor\laravel\framework\src\Illuminate\Log\Logger.php(179): Monolog\Logger->error('Curl error (cod...', Array)
#5 C:\xampp\htdocs\psi\vendor\laravel\framework\src\Illuminate\Log\Logger.php(90): Illuminate\Log\Logger->writeLog('error', 'Curl error (cod...', Array)
#6 C:\xampp\htdocs\psi\vendor\laravel\framework\src\Illuminate\Log\LogManager.php(519): Illuminate\Log\Logger->error('Curl error (cod...', Array)
#7 C:\xampp\htdocs\psi\vendor\laravel\framework\src\Illuminate\Foundation\Exceptions\Handler.php(113): Illuminate\Log\LogManager->error('Curl error (cod...', Array)
#8 C:\xampp\htdocs\psi\app\Exceptions\Handler.php(35): Illuminate\Foundation\Exceptions\Handler->report(Object(RuntimeException))
#9 C:\xampp\htdocs\psi\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(314): Psi\Exceptions\Handler->report(Object(RuntimeException))
#10 C:\xampp\htdocs\psi\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(118): Illuminate\Foundation\Http\Kernel->reportException(Object(RuntimeException))
#11 C:\xampp\htdocs\psi\public\index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#12 {main}
"}
0 likes
9 replies
jaythanki's avatar

url supplied may be invalid or something isn't properly urlencoded in curl request

obet's avatar
Level 1

@jaythanki currently project hosted on the server is working fine. I cloned it and copy to my desktop then with command composer install to install dependencies. I still have the same problem.

obet's avatar
Level 1

all error display Curl error (code 3) even though the actual error is different. Example: the error is an unknown column it will display Curl error (code 3)

obet's avatar
Level 1

example this code returns the said error.

@extends('layouts.user')

@section('page_title', 'Add Chemical Analysis for Soil/Water')

@section('navbar')
    @include('layouts.navbar')
@endsection

@section('page_script')
    <script src="{{ asset('js/menus/test-chemicals/chemical-analysis/soil-waters/create.js') }}" defer></script>
@endsection

@section('content')
    <div class="row vertical-align-center" style="padding-left: 15px;padding-right: 15px;">
        <div class="col-md-6">      
            <h3 class="head">Add Chemical Analysis for Soil/Water</h3>
        </div>

        <div class="col-md-6 text-right">
            <a href="/user/menus/test-chemicals/chemical-analysis/soil-waters" class="btn btn-info"><span class="glyphicon glyphicon-th-list"> Browse</a>
        </div>
    </div>

    <form id="add-chemical-analysis-form" class="disable-on-validation">    
        <div class="row">
            
            @include('layouts.input-fields.job-order-information')

            <div class="col-md-4">
                <div class="panel panel-primary">
                <div class="panel-heading">Test Information</div>
                    <div class="panel-body">
                        <table class="table-form">
                            <tr class="tr-field">
                                <td>Date Received</td>
                                <td>
                                    <input type="date" id="date_received" class="form-control input-sm" disabled>   
                                </td>
                            </tr>
                            <tr class="tr-field">
                                <td>Date Started</td>
                                <td>
                                    <input type="date" id="date_started" class="form-control input-sm">   
                                </td>
                            </tr>
                            <tr>
                                <td>Date Completed</td>
                                <td>
                                    <input type="date" id="date_completed" class="form-control input-sm">   
                                </td>
                            </tr>
                            <tr>
                                <td>Date Reported</td>
                                <td>
                                    <input type="date" id="date_reported" class="form-control input-sm">   
                                </td>
                            </tr>
                        </table>
                    </div>
                </div>
            </div>

            <div class="col-md-4">
                @include('layouts.input-fields.chemical-analyst-dropdown')
            </div>
        </div>
        
        <div class="row">
            <div class="col-md-12">
                <div class="panel panel-primary">
                    <div class="panel-heading form-group">Worksheet</div>
                    <div class="panel-body">

                        @include('layouts/input-fields/test-table-header-with-one-test-method')

                        <div id="ph-test" class="col-md-4 ph-test">
                            <div class="panel panel-primary">
                                <div class="panel-heading form-group">pH Test</div>
                                <div class="panel-body">
                                    <table class="table">
                                        <tr>
                                            <th>Test Method</th> 
                                            <td>
                                                <select name="ph_test_method_id" id="ph-test-method-id" disabled class="form-control input-sm" required>
                                                    <option value="" disabled selected>Select Test Method</option>
                                                        @foreach($phMeters as $phMeter)
                                                             <option value="{{$phMeter->id}}">{{$phMeter->designation}}</option>
                                                        @endforeach
                                                </select>
                                            </td> 
                                        </tr>
                                    </table>
                                    <table class="table table-bordered table-striped">
                                        <tr>
                                            <th>Requirement</th>
                                            <th>Test Result</th>                                         
                                        </tr>
                                        <tr class="tr-field">
                                            <th>pH</th>
                                            <td><input type="number" name="ph" id="ph" class="form-control input-sm requires-validation text-right"></td>
                                        </tr>
                                    </table>
                                </div>
                            </div>
                        </div>

                        <div id="sulfate-test" class="col-md-4 sulfate-test">
                            <div class="panel panel-primary">
                                <div class="panel-heading form-group">Sulfate Test</div>
                                <div class="panel-body">
                                    <table class="table">
                                        <tr>
                                            <th>Test Method</th> 
                                            <td>
                                                <select name="sulfate_test_method_id" id="sulfate-test-method-id" disabled class="form-control input-sm" required>
                                                    <option value="" disabled selected>Select Test Method</option>
                                                        @foreach($sulfates as $sulfate)
                                                             <option value="{{$sulfate->id}}">{{$sulfate->designation}}</option>
                                                        @endforeach
                                                </select>
                                            </td> 
                                        </tr>
                                    </table>

                                    <table class="table table-bordered table-striped">
                                        <tr>
                                            <th>Requirement</th>
                                            <th>Test Result</th>
                                        </tr>
                                        <tr class="tr-field">
                                            <th>Concentration After Dilution</th>
                                            <td><input type="number" name="concentration" id="concentration" class="form-control input-sm requires-validation text-right"></td>
                                        </tr>                                            
                                        <tr class="tr-field">
                                            <th>Volume of Sample Used</th>
                                            <td><input type="number" name="sample_used" id="sample-used" class="form-control input-sm requires-validation text-right"></td>
                                        </tr>                                            
                                        <tr class="tr-field">
                                            <th>Volume After Dilution</th>
                                            <td><input type="number" name="dilution" id="dilution" class="form-control input-sm requires-validation text-right"></td>
                                        </tr>
                                    </table>
                                </div>
                            </div>
                        </div>

                        <div id="chloride-test" class="col-md-4 chloride-test">
                            <div class="panel panel-primary">
                                <div class="panel-heading form-group">Chloride Test</div>
                                <div class="panel-body">
                                    <table class="table">
                                        <tr>
                                            <th>Test Method</th> 
                                            <td>
                                                <select name="chloride_test_method_id" id="chloride-test-method-id" disabled class="form-control input-sm" required>
                                                    <option value="" disabled selected>Select Test Method</option>
                                                        @foreach($chlorides as $chloride)
                                                             <option value="{{$chloride->id}}">{{$chloride->designation}}</option>
                                                        @endforeach
                                                </select>
                                            </td> 
                                        </tr>
                                    </table>

                                    <table class="table table-bordered table-striped">
                                        <tr>
                                            <th>Requirement</th>
                                            <th>Test Result</th>
                                        </tr>
                                        <tr class="tr-field">
                                            <th>Concentration After Dilution</th>
                                            <td><input type="number" name="cl_concentration" id="cl-concentration" class="form-control input-sm requires-validation text-right"></td>
                                        </tr>                                            
                                        <tr class="tr-field">
                                            <th>Volume of Sample Used</th>
                                            <td><input type="number" name="cl_sample_used" id="cl-sample-used" class="form-control input-sm requires-validation text-right"></td>
                                        </tr>                                            
                                        <tr class="tr-field">
                                            <th>Volume After Dilution</th>
                                            <td><input type="number" name="cl_dilution" id="cl-dilution" class="form-control input-sm requires-validation text-right"></td>
                                        </tr>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="row">

            <div class="col-md-5">
                
            </div>
        </div>

        @include('layouts.save-reset-form-buttons')
    </form>

    @include('modals/validation-modal')
    
@endsection
obet's avatar
Level 1

Hi jaythanki!

Sorry I lost internet service last time unable to complete uploading source code. Here are some source code I checked on from my production Pc were I push my development. I noticed the following errors after running similar modules.

*** Controller ***

<?php

namespace Psi\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Psi\Standard;
use Psi\StandardOrganization;
use Psi\StandardType;
use Psi\StandardStatus;
use Psi\StandardClassification;
use Psi\Section;
use Psi\Specimen;
use Psi\SteelTensileRequirement;
use Psi\SteelElongationRequirement;
use Psi\SteelBendingRequirement;
use Psi\SteelDeformationRequirement;
use Psi\SteelChemicalRequirement;
use Psi\ChemicalElement;

class StandardsController extends Controller {
    public function __construct() {
        $this->middleware('clearance');
    }
    
    public function index() {
        $pagination = request('search_pagination') ?? config('indexing.default_pagination');
        $standards = Standard::paginatedSearch(request('keyword'), $pagination);
        return view('menus/standards/index', compact('standards'));
    }

    public function create(){
        $standard_organizations = StandardOrganization::all();
        $standard_types = StandardType::all();
        $standard_status = StandardStatus::all();
        $standard_classifications = StandardClassification::all();
        return view('menus/standards/create', compact('standard_organizations', 'standard_types', 'standard_status', 'standard_classifications'));
    }

    public function store(Request $request) {
        $has_exceptions = DB::transaction(function() use ($request) {
            $this->validate($request, [
                'designation' => 'unique:standards',
                /*'name' => 'unique:standards',*/
            ]);

            // Insert a specification.
            $standard = Standard::create([
                'standard_organization_id' => request('standard_organization_id'),
                'designation' => request('designation'),
                'name' => request('name'),
                'description' => request('description'),
                'standard_type_id' => request('standard_type_id'),
                'standard_status_id' => request('standard_status_id'),
                'standard_classification_id' => request('standard_classification_id'),
                'last_modified_by' => request('current_user'),
                'is_deleted' => 0
            ]);
        });

        // Return the transaction response.
        $response = array('status' => (!$has_exceptions) ? 'saved' : 'not_saved');
        return response()->json($response);
    }

    public function show($id)
    {
        //
    }

    public function edit($id) {
        $standard = Standard::find($id); 
        $standard_types = StandardType::all();
        $standard_status = StandardStatus::all();
        $standard_organizations = StandardOrganization::all();
        $standard_classifications = StandardClassification::all();
        $steel_tensile_requirements = SteelTensileRequirement::where('standard_id', $id)
            ->with(['specimenClass', 'Grade', 'minYieldStrength', 'maxYieldStrength', 'minTensileStrength', 'maxTensileStrength'])
            ->get();
        $steel_elongation_requirements = SteelElongationRequirement::where('standard_id', $id)
            ->with(['Grade', 'minSize', 'maxSize', 'minElongationValue'])
            ->get();
        $steel_bending_requirements = SteelBendingRequirement::where('standard_id', $id)
            ->with(['Grade', 'minSize', 'maxSize', 'pinDiameter'])
            ->get();
        $steel_deformation_requirements = SteelDeformationRequirement::where('standard_id', $id)
            ->with(['nominalSize', 'nominalPerimeter', 'crossSectionalArea', 'averageSpacing', 'minLugs', 'maxLugs', 'maxGapsSummation', 'unitMass'])
            ->get();
        $steel_chemical_requirements = SteelChemicalRequirement::where('standard_id', $id)
            ->with(['specimenClass', 'Grade', 'minSize', 'maxSize', 'minElementValue', 'maxElementValue', 'chemicalElement'])
            ->get();
        $elements = ChemicalElement::all();
        return view('menus/standards/edit', compact(
            'standard',
            'standard_types',
            'standard_status',
            'standard_organizations',
            'standard_classifications',
            'steel_tensile_requirements',
            'steel_elongation_requirements',
            'steel_bending_requirements',
            'steel_deformation_requirements',
            'steel_chemical_requirements'
        ));
        //return $steel_tensile_requirements;
    }

    public function update(Request $request, $id) {
        // Initiate database transaction sequence.
        $has_exceptions = DB::transaction(function() use ($request, $id) {
            $standard = Standard::find($id);
            $standard->standard_organization_id = $request->standard_organization_id;
            $standard->designation = $request->designation;
            $standard->name = $request->name;
            $standard->description = $request->description;
            $standard->standard_type_id = $request->standard_type_id;
            $standard->standard_status_id = $request->standard_status_id;
            $standard->standard_classification_id = $request->standard_classification_id;
            $standard->last_modified_by = $request->current_user;
            $standard->save();
        });

        // Return the transaction response.
        $response = array('status' => (!$has_exceptions) ? 'updated' : 'not_updated');
        return response()->json($response);
    }

    public function destroy($id)
    {
        try {
            $id->delete();            
        } 
        catch(Exception $e) {            
            return response()->json(['status' => 0], 500);
        }
        return response()->json(['status' => 1]);
    }
    
    public function get() {
        return Standard::all();
    }

    public function getTestMethod(Request $request){

        $standardId=$request->standardOrganizationId;
        $specimentType=$request->specimenType;
        $test_type=$request->test_type;

        if($test_type=="MaterialFiner"){

            $designation = $this->getStandard('ASTM C 117%');
        }
        else if($test_type=="DeterminationofWaterContent"){
            $designation = $this->getStandard('ASTM D 2216%');
        }
        else if($test_type=="SpecificGravity"){
             $designation = $this->getStandard('ASTM C 110%');
        }
        else if($test_type=="SpecificGravityOfSoils"){
             $designation = $this->getStandard('ASTM D 854%');
        }
        else if($test_type=="SpecificGravityAndAbsorption"){
            if($specimentType  == 'C. A.'){
                 if($standardId==1){
                    $designation = $this->getStandard('ASTM C 127%');
                 }
                 else if($standardId==2){
                    $designation = $this->getStandard('AASHTO T 85%');
                 }

            }
            else if($specimentType=='F. A.'){
                if($standardId==1){
                   $designation = $this->getStandard('ASTM C 128%');
                 }
                 else if($standardId==2){
                    $designation = $this->getStandard('AASHTO T 84%');
                 }

            }
            else{
                //for soil
            }

        }
        else if($test_type=="AtterbergLimit"){
            if($standardId==1){
                    $designation = $this->getStandard('ASTM D 4318%');
            }
            else if ($standardId==2){
                    $designation = $this->getStandard('AASHTO T 89%');
                    //add t 90 designation here
            }
        }
        else if($test_type=="SieveAnalysis"){
         if($specimentType  == 'C. A.' || $specimentType=='F. A.'||$specimentType=='B. C.'||$specimentType=='S. B.'||$specimentType=='S. G.'){
                if($standardId==1){
                    $designation = $this->getStandard('ASTM C 136%');
                }
                else if ($standardId==2){
                    $designation = $this->getStandard('AASHTO T 27%');
                }
            } 
            else if($specimentType=='Lime'){
                $designation = $this->getStandard('ASTM C 110%');
            }
            else if($specimentType=='G. M.'||$specimentType=='F. M.'||$specimentType='B. F.'){
                if($standardId==1){
                $designation = $this->getStandard('ASTM D 422%');
                }
                else if($standardId==2){
                $designation = $this->getStandard('AASHTO T 27%');

                }    
            }
        } 
    return response()->json($designation);
    }
    public function getStandard($designation){
        $designation=Standard::select('designation','id')->where('designation','LIKE',$designation)->where('standard_status_id',1)->first();
        return $designation;
    }
}

*** Model ***

<?php

namespace Psi;

use Illuminate\Database\Eloquent\Model;

class Standard extends Model
{
    public $timestamps = false;

    protected $appends = ['value', 'label'];

    protected $fillable = [
        'id',
        'standard_organization_id',
        'designation',
        'name',
        'description',
        'standard_type_id',
        'standard_status_id',
        'standard_classification_id',
        'last_modified_by',
        'is_deleted'
    ];
   
    /* Accessors */
    public function getValueAttribute($value)
    {
        return $this->id;
    }

    public function getLabelAttribute($value)
    {
        return $this->designation;
    }

    public function getNameAttribute($value)
    {
        return ucwords($value);
    }

    public function setNameAttribute($value)
    {
        return $this->attributes['name'] = strtoupper($value);
    }

    public function getDescriptionAttribute($value)
    {
        return ucfirst($value);
    }

    /* Mutators */
    public function setDescriptionAttribute($value)
    {
        return $this->attributes['description'] = ucfirst($value);
    }

    /*
     * Relationship
     */

    public function standardOrganization()
    {
        return $this->belongsTo(StandardOrganization::class);
    }

    public function specification()
    {
        return $this->belongsTo(Specification::class, 'standard_id', 'id');
    }

    public function standardType()
    {
        return $this->hasOne(StandardType::class, 'id', 'standard_type_id');
    }

    public function standardStatus()
    {
        return $this->belongsTo(StandardStatus::class);
    }

    public function standardClassification()
    {
        return $this->belongsTo(StandardClassification::class);
    }

    /* Steel Section */
    public function steelTensileRequirement(){
        return $this->belongsTo(SteelTensileRequirement::class, 'standard_id', 'id');
    }

    public function steelElongationRequirement(){
        return $this->belongsTo(SteelElongationRequirement::class, 'standard_id', 'id');
    }

    public function steelBendingRequirement(){
        return $this->belongsTo(SteelBendingRequirement::class, 'standard_id', 'id');
    }

    public function steelDeformationRequirement(){
        return $this->belongsTo(SteelDeformationRequirement::class, 'standard_id', 'id');
    }

    /* Aggregate Section */
    public function aggregateGradingRequirement(){
        return $this->belongsTo(AggregateGradingRequirement::class, 'standard_id', 'id');
    }

    public function coarseAggregateASTMC33(){
        return $this->belongsTo(CoarseAggregateASTMC33::class, 'standard_id', 'id');
    }

    public function coarseAggregateAASHTOM43(){
        return $this->belongsTo(CoarseAggregateAASHTOM43::class, 'standard_id', 'id');
    }

    public function coarseAggregateDPWHItem311(){
        return $this->belongsTo(CoarseAggregateDPWHItem311::class, 'standard_id', 'id');
    }

    public function fineAggregateDPWHItem311(){
        return $this->belongsTo(FineAggregateDPWHItem311::class, 'standard_id', 'id');
    }

    /* Chemical Section */
    public function steelChemicalRequirement(){
        return $this->belongsTo(SteelChemicalRequirement::class, 'standard_id', 'id');
    }

    public function asphaltRequirement(){
        return $this->belongsTo(AsphaltRequirement::class, 'standard_id', 'id');
    }

    public function cementChemicalRequirement(){
        return $this->belongsTo(CementChemicalRequirement::class, 'standard_id', 'id');
    }

    public function paintRequirement(){
        return $this->belongsTo(PaintRequirement::class, 'standard_id', 'id');
    }

    public function zincCoatRequirement(){
        return $this->belongsTo(ZincCoatRequirement::class, 'standard_id', 'id');
    }

    /* Physical Section */
    public function cementPhysicalRequirement(){
        return $this->belongsTo(CementPhysicalRequirement::class, 'standard_id', 'id');
    }
    
    public function limeRequirement(){
        return $this->belongsTo(LimeRequirement::class, 'standard_id', 'id');
    }

    /* Concrete Test Methods*/
    public function beamTestMethod()
    {
        return $this->hasMany(Beam::class, 'id', 'standard_test_method_id');
    }

    public function brickTestMethod()
    {
        return $this->hasMany(Brick::class, 'id', 'standard_test_method_id');
    }

    public function chbTestMethod()
    {
        return $this->hasMany(Chb::class, 'id', 'standard_test_method_id');
    }

    public function coreTestMethod()
    {
        return $this->hasMany(Core::class, 'id', 'standard_test_method_id');
    }

    public function cubeTestMethod()
    {
        return $this->belongsTo(Cube::class, 'standard_test_method_id', 'id');
    }

    public function cylinderTestMethod()
    {
        return $this->belongsTo(Cylinder::class, 'standard_test_method_id', 'id');
    }

    /* Steel Test */
    public function rsbs()
    {
        return $this->hasMany(Rsb::class, 'id', 'standard_test_method_id');
    }

    public function prbs()
    {
        return $this->hasMany(Prb::class, 'id', 'standard_test_method_id');
    }

    public function pipes()
    {
        return $this->hasMany(Pipe::class, 'id', 'standard_test_method_id');
    }

    public function plates()
    {
        return $this->hasMany(Plate::class, 'id', 'standard_test_method_id');
    }

    public function compositeFiber()
    {
        return $this->hasMany(CompositeFiber::class, 'id', 'standard_test_method_id');
    }

    public function guyWire()
    {
        return $this->hasMany(GuyWire::class, 'id', 'standard_test_method_id');
    }

    public function rsbCoupler()
    {
        return $this->hasMany(RsbCoupler::class, 'id', 'standard_test_method_id');
    }

    public function weldedPipe()
    {
        return $this->hasMany(WeldedPipe::class, 'id', 'standard_test_method_id');
    }

    public function weldedPlate()
    {
        return $this->hasMany(WeldedPlate::class, 'id', 'standard_test_method_id');
    }

    /* Chemical Section */
    public function chemicalCementTestMethod()
    {
        return $this->belongsTo(ChemicalAnalysisCement::class, 'standard_test_method_id', 'id');
    }

    /* Physical Section */
    public function physicalFlyAshTestMethod()
    {
        return $this->belongsTo(PhysicalAnalysisFlyAsh::class, 'standard_test_method_id', 'id');
    }
    
    public function physicalCementAirContentTestMethod()
    {
        return $this->belongsTo(AirContent::class, 'standard_test_method_id', 'id');
    }

    public function physicalCementFinessByAirTestMethod()
    {
        return $this->belongsTo(FinenessByAir::class, 'standard_test_method_id', 'id');
    }

    public function physicalCementNormalConsistencyTestMethod()
    {
        return $this->belongsTo(NormalConsistency::class, 'standard_test_method_id', 'id');
    }

    public function physicalCementTimeOfSettingTestMethod()
    {
        return $this->belongsTo(TimeOfSetting::class, 'standard_test_method_id', 'id');
    }

    public function physicalCementAutoClaveExpansionTestMethod()
    {
        return $this->belongsTo(AutoClaveExpansion::class, 'standard_test_method_id', 'id');
    }

    public function physicalCementCompressiveStrengthTestMethod()
    {
        return $this->belongsTo(CompressiveStrength::class, 'standard_test_method_id', 'id');
    }

    /* Methods */
    public function getTypes()
    {
        return $this->types;
    }

    public function getStandardStatus()
    {
        return $this->status;
    }

    /* Static Methods */
    public static function findByName($name)
    {
        return self::where('name', $name)->first();
    }

    public static function paginatedSearch($keyword, $pagination)
    {
        $results = self::where(function($query) use($keyword) {
            $query->where('id', 'LIKE', "%$keyword%")
            ->orWhereHas('standardOrganization', function($query) use($keyword) {
                $query->where('short_name', 'LIKE', "%$keyword%");
            })
            ->orWhereHas('standardOrganization', function($query) use($keyword) {
                $query->where('full_name', 'LIKE', "%$keyword%");
            })
            ->orWhereHas('standardType', function($query) use($keyword) {
                $query->where('type', 'LIKE', "%$keyword%");
            })
            ->orWhereHas('standardStatus', function($query) use($keyword) {
                $query->where('status', 'LIKE', "%$keyword%");
            })
            ->orWhereHas('standardClassification', function($query) use($keyword) {
                $query->where('classification', 'LIKE', "%$keyword%");
            });
        })
        ->with(['standardOrganization', 'standardType', 'standardStatus', 'standardClassification'])
        ->orwhere('designation', 'LIKE', "%$keyword%")
        ->orWhere('name', 'LIKE', "%$keyword%")
        ->where('is_deleted', 0)
        ->paginate($pagination);

        //Generate pagination links with the correct parameters
        $results->appends([
            'keyword' => $keyword,
            'search_pagination' => $pagination
        ]);

        return $results;
    }
}

*** EDIT PAGE ***

@extends('layouts.user')

@section('page_title', 'Edit Specification')

@section('navbar')
    @include('layouts.navbar')
@endsection

@section('page_script')
    <script src="{{ asset('js/menus/standards/edit.js') }}" defer></script>
    <script src="{{ asset('js/menus/standards/form.js') }}" defer></script>
@endsection

@section('content')
    <div class="row vertical-align-center">

        <div class="col-xs-6">
            <h3>Edit Standard - ID: {{ $standard->id }}</h3>
        </div>

        <div class="col-xs-6 text-right">
            <a href="/user/menus/standards" class="btn btn-info"><span class="glyphicon glyphicon-th-list"> Browse</a>
        </div>

    </div>

    <form id="edit-standard-form" method="post">
        
        @include('menus/standards/form-fields')
        
        @if($standard->standard_type_id == 1)
            <div class="panel panel-primary">
                <div class="panel-heading">Standard Specifications</div>
                <div class="panel-body">
                    <div class="row">
                        <div class="col-sm-12">
                            @if($standard->standard_classification_id == 1)
                                <ul class="nav nav-tabs">
                                    <li class="active"><a data-toggle="tab" href="#tensile">Tensile Requirements</a></li>
                                    <li><a data-toggle="tab" href="#elongation">Elongation Requirements</a></li>
                                    <li><a data-toggle="tab" href="#bending">Bending Requirements</a></li>
                                    <li><a data-toggle="tab" href="#deformation">Deformation Requirements</a></li>
                                    <li><a data-toggle="tab" href="#chemical">Chemical Requirements</a></li>
                                </ul>
                            @elseif($standard->standard_classification_id === 2)

                            @endif
                        </div>
                    </div>

                    <div class="row">
                        <div class="col-sm-12">
                            <div class="tab-content">

                                @include('menus/standards/specifications/steels/tensiles')
                                @include('menus/standards/specifications/steels/elongations')
                                @include('menus/standards/specifications/steels/bendings')
                                @include('menus/standards/specifications/steels/deformations')
                                @include('menus/standards/specifications/steels/chemicals')

                            </div>
                        </div>
                    </div>
                </div>
            </div>
        @else

        @endif

        @include('layouts.save-reset-form-buttons')
    </form>
@endsection 

When i run this program from production PC the error return is

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'standard_id' in 'where clause' (SQL: select * from `steel_tensile_requirements` where `standard_id` = 1)

While on the development PC the error return is

RuntimeException
Curl error (code 3): <url> malformed

This problem occurred after composer update. I wonder what could be the cause.

jaythanki's avatar

@obet on production is show that you have not standard_id column in steel_tensile_requirements table

obet's avatar
Level 1

@jaythanki my problem is on the development pc I could no longer pinpoint what is wrong because all errors are now "Curl error (code 3): malformed.

Please or to participate in this conversation.