Guriddo » Topic: setAutocomplete… 404 : error. Status: error

setAutocomplete… 404 : error. Status: error

Guriddo
setAutocomplete… 404 : error. Status: error

This topic has 10 replies, 2 voices, and was last updated 10 years, 8 months ago by ariadrianto.

Creator

Topic

September 30, 2015 at 12:20 pm #124398

ariadrianto

Participant

Hi All,

I failed to implemented setAutocomplete…



require_once &#039;../jq-config.php&#039;;
$grid = new jqGridRender($conn);

$table = &#039;LEMBUR&#039;;

$grid-&gt;SelectCommand =&#039;SELECT a.LEMBURID, a.PERIODE, a.KARYAWANID, k.nama, a.JAMLEMBUR, a.JMLSPECIAL,
a.JMLDINAS
FROM LEMBUR a
left join karyawan k on a.karyawanid = k.karyawanid
left join divisi d on k.divisi = d.divisiid &#039;;

// set the ouput format to XML
$grid-&gt;dataType = &#039;json&#039;;
// Let the grid create the model
$grid-&gt;setPrimaryKeyId(&quot;LEMBURID&quot;);
$grid-&gt;setColModel();
$grid-&gt;table = $table;
// set labels in the header
$grid-&gt;setColProperty(&quot;LEMBURID&quot;, array(&quot;label&quot;=&gt;&quot;ID&quot;, &quot;hidden&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;PRIODE&quot;, array(&quot;label&quot;=&gt;&quot;Periode&quot;));
$grid-&gt;setColProperty(&quot;KARYAWANID&quot;, array(&quot;label&quot;=&gt;&quot;KaryawanId&quot;));

$grid-&gt;setAutocomplete(&quot;NAMA&quot;,&quot;#KARYAWANID&quot;,&quot;SELECT NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama &quot;,null, true, true);

$grid-&gt;setColProperty(&quot;JAMLEMBUR&quot;, array(&quot;label&quot;=&gt;&quot;Jam Lembur&quot;));
$grid-&gt;setColProperty(&quot;JMLSPECIAL&quot;, array(&quot;label&quot;=&gt;&quot;Special Day&quot;));
$grid-&gt;setColProperty(&quot;JMLDINAS&quot;, array(&quot;label&quot;=&gt;&quot;Dinas Luar&quot;));

$grid-&gt;setUrl(&#039;newEntryLembur_.php&#039;);
$grid-&gt;setGridOptions(array(&quot;rowNum&quot;=&gt;99999,&quot;rowList&quot;=&gt;array(10,20,30),&quot;sortname&quot;=&gt;&quot;KARYAWANID&quot;, &quot;width&quot;=&gt;&quot;1000&quot;));
$grid-&gt;toolbarfilter = true;
$grid-&gt;navigator = true;
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;true,&quot;add&quot;=&gt;true,&quot;edit&quot;=&gt;true,&quot;del&quot;=&gt;true,&quot;view&quot;=&gt;true));

$grid-&gt;setFilterOptions(array(&quot;stringResult&quot;=&gt;true));

$grid-&gt;renderGrid(&#039;#grid&#039;,&#039;#pager&#039;,true, null, null, true,true);

require_once '../jq-config.php';

$grid = new jqGridRender($conn);

$table = 'LEMBUR';

$grid->SelectCommand ='SELECT a.LEMBURID, a.PERIODE, a.KARYAWANID, k.nama, a.JAMLEMBUR, a.JMLSPECIAL,

a.JMLDINAS

FROM LEMBUR a

left join karyawan k on a.karyawanid = k.karyawanid

left join divisi d on k.divisi = d.divisiid ';

// set the ouput format to XML

$grid->dataType = 'json';

// Let the grid create the model

$grid->setPrimaryKeyId("LEMBURID");

$grid->setColModel();

$grid->table = $table;

// set labels in the header

$grid->setColProperty("LEMBURID", array("label"=>"ID", "hidden"=>true));

$grid->setColProperty("PRIODE", array("label"=>"Periode"));

$grid->setColProperty("KARYAWANID", array("label"=>"KaryawanId"));

$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama ",null, true, true);

$grid->setColProperty("JAMLEMBUR", array("label"=>"Jam Lembur"));

$grid->setColProperty("JMLSPECIAL", array("label"=>"Special Day"));

$grid->setColProperty("JMLDINAS", array("label"=>"Dinas Luar"));

$grid->setUrl('newEntryLembur_.php');

$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"KARYAWANID", "width"=>"1000"));

$grid->toolbarfilter = true;

$grid->navigator = true;

$grid->setNavOptions('navigator', array("excel"=>true,"add"=>true,"edit"=>true,"del"=>true,"view"=>true));

$grid->setFilterOptions(array("stringResult"=>true));

$grid->renderGrid('#grid','#pager',true, null, null, true,true);

when start typing on column “NAMA”, 404:error. Status : error …

I’m using : jqGridAdoDB

Best Regards,

Creator

Topic

Viewing 10 replies - 1 through 10 (of 10 total)

Author

Replies

October 1, 2015 at 9:55 am #124404

guriddo.support

Participant

Hello,

404 error means the the requested url is not found .

Please be a sure you have all the needed modules and you have pointed to a valid file in setUrl option.

This server specific error and we can not go too much with this.

Could yo please look in the console what is exactly the error returned from the server.

Kind Regards,

Will

Guriddo Support Team

October 1, 2015 at 12:07 pm #124407

ariadrianto

Participant

Oh No…

what did I missed ?
if i change

$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama ",null, true, true);

with

$grid->setColProperty(“NAMA”, array(“label”=>”Nama”));

Everything is fine…

I’ve tried to debug using netbeans and nothing found.

This reply was modified 10 years, 8 months ago by ariadrianto. Reason: bad format
This reply was modified 10 years, 8 months ago by ariadrianto. Reason: bad format 2

October 1, 2015 at 12:15 pm #124410

ariadrianto

Participant

Oh No…

what did I missed ?
if i change


$grid-&gt;setAutocomplete(&quot;NAMA&quot;,&quot;#KARYAWANID&quot;,&quot;SELECT   NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama &quot;,null, true, true);

$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama ",null, true, true);

with :
$grid->setColProperty(“KARYAWANID”, array(“label”=>”KaryawanId”));

Everything is fine…

October 3, 2015 at 11:36 am #124417

ariadrianto

Participant

Here’s all my structure file :

jq-config.php


define(&#039;ABSPATH&#039;, &#039;../&#039;);
// Form settings
$SERVER_HOST = &quot;&quot;; // the host name
$SELF_PATH = &quot;&quot;; // the web path to the project without http
$CODE_PATH = &quot;../php/PHPSuito/&quot;; // the physical path to the php files

// include the jqGrid Class
require_once ABSPATH.&quot;php/PHPSuito/jqGrid.php&quot;;
require_once ABSPATH.&quot;php/PHPSuito/DBdrivers/jqGridAdodb.php&quot;;
//require_once ABSPATH.&quot;php/PHPSuito/jqGridUtils.php&quot;;
require_once ABSPATH.&quot;php/PHPSuito/jqAutocomplete.php&quot;;
// include the driver class
define(&#039;ADODB_ASSOC_CASE&#039;, 2);
require_once ABSPATH.&quot;php/PHPSuito/External/adodb5/adodb.inc.php&quot;;
require_once ABSPATH.&quot;php/PHPSuito/External/adodb5/adodb-exceptions.inc.php&quot;;
require_once ABSPATH.&quot;php/PHPSuito/External/phpexcel/PHPExcel.php&quot;;

try {
$conn = ADONewConnection(&quot;firebird&quot;);
$conn-&gt;Connect(&#039;localhost&#039;,DB_USER,DB_PASSWORD, &#039;/var/lib/firebird/2.5/data/testing.fdb&#039;);
} catch (exception $e) {
var_dump($e);
adodb_backtrace($e-&gt;gettrace());

}

define('ABSPATH', '../');

// Form settings

$SERVER_HOST = ""; // the host name

$SELF_PATH = ""; // the web path to the project without http

$CODE_PATH = "../php/PHPSuito/"; // the physical path to the php files

// include the jqGrid Class

require_once ABSPATH."php/PHPSuito/jqGrid.php";

require_once ABSPATH."php/PHPSuito/DBdrivers/jqGridAdodb.php";

//require_once ABSPATH."php/PHPSuito/jqGridUtils.php";

require_once ABSPATH."php/PHPSuito/jqAutocomplete.php";

// include the driver class

define('ADODB_ASSOC_CASE', 2);

require_once ABSPATH."php/PHPSuito/External/adodb5/adodb.inc.php";

require_once ABSPATH."php/PHPSuito/External/adodb5/adodb-exceptions.inc.php";

require_once ABSPATH."php/PHPSuito/External/phpexcel/PHPExcel.php";

try {

$conn = ADONewConnection("firebird");

$conn->Connect('localhost',DB_USER,DB_PASSWORD, '/var/lib/firebird/2.5/data/testing.fdb');

} catch (exception $e) {

var_dump($e);

adodb_backtrace($e->gettrace());

}

newEntryLembur.php

.... html stuff
include (&quot;newEntryLembur_.php&quot;);

.... html stuff

include ("newEntryLembur_.php");

and newEntryLembur_.php


&lt;!--?php require_once &#039;../jq-config.php&#039;; $grid = new jqGridRender($conn); $table = &#039;LEMBUR&#039;; $grid-&gt;SelectCommand =&#039;SELECT a.LEMBURID, a.PERIODE, a.KARYAWANID, k.nama, a.JAMLEMBUR, a.JMLSPECIAL,&lt;br ?--&gt; a.JMLDINAS
FROM LEMBUR a
left join karyawan k on a.karyawanid = k.karyawanid
left join divisi d on k.divisi = d.divisiid &#039;;

$grid-&gt;dataType = &#039;json&#039;;

$grid-&gt;setPrimaryKeyId(&quot;LEMBURID&quot;);
$grid-&gt;setColModel();
$grid-&gt;table = $table;

$grid-&gt;setColProperty(&quot;LEMBURID&quot;, array(&quot;label&quot;=&gt;&quot;ID&quot;, &quot;hidden&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;PRIODE&quot;, array(&quot;label&quot;=&gt;&quot;Periode&quot;));
$grid-&gt;setColProperty(&quot;KARYAWANID&quot;, array(&quot;label&quot;=&gt;&quot;KaryawanId&quot;));

$grid-&gt;setAutocomplete(&quot;NAMA&quot;,&quot;#KARYAWANID&quot;,&quot;SELECT NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama &quot;,null, true, true);
;
$grid-&gt;setColProperty(&quot;JAMLEMBUR&quot;, array(&quot;label&quot;=&gt;&quot;Jam Lembur&quot;));
$grid-&gt;setColProperty(&quot;JMLSPECIAL&quot;, array(&quot;label&quot;=&gt;&quot;Special Day&quot;));
$grid-&gt;setColProperty(&quot;JMLDINAS&quot;, array(&quot;label&quot;=&gt;&quot;Dinas Luar&quot;));

$grid-&gt;setGridOptions(array(&quot;rowNum&quot;=&gt;99999,&quot;rowList&quot;=&gt;array(10,20,30),&quot;sortname&quot;=&gt;&quot;KARYAWANID&quot;, &quot;width&quot;=&gt;&quot;1000&quot;));

$grid-&gt;toolbarfilter = true;
$grid-&gt;navigator = true;
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;true,&quot;add&quot;=&gt;true,&quot;edit&quot;=&gt;true,&quot;del&quot;=&gt;true,&quot;view&quot;=&gt;true));

$grid-&gt;setFilterOptions(array(&quot;stringResult&quot;=&gt;true));
$grid-&gt;setUrl(&#039;newEntryLembur_.php&#039;);
$grid-&gt;renderGrid(&#039;#grid&#039;,&#039;#pager&#039;,true, null, null, true,true);

<!--?php require_once '../jq-config.php'; $grid = new jqGridRender($conn); $table = 'LEMBUR'; $grid->SelectCommand ='SELECT a.LEMBURID, a.PERIODE, a.KARYAWANID, k.nama, a.JAMLEMBUR, a.JMLSPECIAL, a.JMLDINAS

FROM LEMBUR a

left join karyawan k on a.karyawanid = k.karyawanid

left join divisi d on k.divisi = d.divisiid ';

$grid->dataType = 'json';

$grid->setPrimaryKeyId("LEMBURID");

$grid->setColModel();

$grid->table = $table;

$grid->setColProperty("LEMBURID", array("label"=>"ID", "hidden"=>true));

$grid->setColProperty("PRIODE", array("label"=>"Periode"));

$grid->setColProperty("KARYAWANID", array("label"=>"KaryawanId"));

$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama ",null, true, true);

;

$grid->setColProperty("JAMLEMBUR", array("label"=>"Jam Lembur"));

$grid->setColProperty("JMLSPECIAL", array("label"=>"Special Day"));

$grid->setColProperty("JMLDINAS", array("label"=>"Dinas Luar"));

$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"KARYAWANID", "width"=>"1000"));

$grid->toolbarfilter = true;

$grid->navigator = true;

$grid->setNavOptions('navigator', array("excel"=>true,"add"=>true,"edit"=>true,"del"=>true,"view"=>true));

$grid->setFilterOptions(array("stringResult"=>true));

$grid->setUrl('newEntryLembur_.php');

$grid->renderGrid('#grid','#pager',true, null, null, true,true);

404 : error always appear when I started typing on search or adding or edit.
All I know is that 404 is URL not found, but which URL ?
I’m only using this 3 files…

October 5, 2015 at 9:30 am #124418

guriddo.support

Participant

Hello,

When you start typing you can see the requested url in the console.

This can be in FireFox with FireBug installed or in Chrom if you press Shit-Control-I.

Kind Regards,

Will

Guriddo Support Team

October 5, 2015 at 9:41 am #124421

ariadrianto

Participant

wow thanks…

it’s strange… looking for this :

http://localhost/test/jqGridRender.php?term=a&acelem=NAMA&oper=autocmpl

should be find : newEntryLembur_.php.

why looking for jqGridRender.php ??

October 5, 2015 at 11:53 am #124422

guriddo.support

Participant

Hello,

I do not know. Look at your code carefully and see where you set the url.

Regards,

Will

Guriddo Support Team

October 6, 2015 at 9:10 am #124423

ariadrianto

Participant

solved…

After debugging your jqGridRender.php , found this :


// source code deleted due license violation
..

// source code deleted due license violation

just put setURL up, after selectCommand and everything would be fine just before setColProperty :



.......

$grid-&gt;SelectCommand =&#039;SELECT a.LEMBURID, a.PERIODE, a.KARYAWANID, k.nama, a.JAMLEMBUR, a.JMLSPECIAL,
a.JMLDINAS
FROM LEMBUR a
left join karyawan k on a.karyawanid = k.karyawanid
left join divisi d on k.divisi = d.divisiid &#039;;

$grid-&gt;setUrl(&#039;newEntryLembur_.php&#039;);

$grid-&gt;dataType = &#039;json&#039;;

$grid-&gt;setPrimaryKeyId(&quot;LEMBURID&quot;);
$grid-&gt;setColModel();
$grid-&gt;table = $table;

$grid-&gt;setColProperty(&quot;LEMBURID&quot;, array(&quot;label&quot;=&gt;&quot;ID&quot;, &quot;hidden&quot;=&gt;true));

......

.......

$grid->SelectCommand ='SELECT a.LEMBURID, a.PERIODE, a.KARYAWANID, k.nama, a.JAMLEMBUR, a.JMLSPECIAL,

a.JMLDINAS

FROM LEMBUR a

left join karyawan k on a.karyawanid = k.karyawanid

left join divisi d on k.divisi = d.divisiid ';

$grid->setUrl('newEntryLembur_.php');

$grid->dataType = 'json';

$grid->setPrimaryKeyId("LEMBURID");

$grid->setColModel();

$grid->table = $table;

$grid->setColProperty("LEMBURID", array("label"=>"ID", "hidden"=>true));

......

This reply was modified 10 years, 8 months ago by tony.

October 6, 2015 at 12:34 pm #124424

guriddo.support

Participant

Hello,

From what I see, you will need to use setAutocomplete after setUrl and not as you write, before selectCommand.

Anyway Thank you for this notification.

P.S Please in the future do not write the source code in the public forums – you can send us the code to the support at guriddo dot net

Kind Regards,

Will

This reply was modified 10 years, 8 months ago by guriddo.support.

Guriddo Support Team

October 7, 2015 at 8:54 am #124428

setAutocomplete… 404 : error. Status: error

Search Forum

Recent Replies

Forum Statistics

UserOnline