json format error

zombie23

hello first post here im using thsi wonderfull plugin to use serverside data to my table but i get the error i check whit firebug and i got this results :

( ! ) Notice: Undefined index: sSearch in C:\wamp\www\busqueda.php on line 87
Call Stack
# Time Memory Function Location
1 0.0019 159208 {main}( ) ..\busqueda.php:0

( ! ) Notice: Undefined index: bSearchable_0 in C:\wamp\www\busqueda.php on line 104
Call Stack
# Time Memory Function Location
1 0.0019 159208 {main}( ) ..\busqueda.php:0

( ! ) Notice: Undefined index: bSearchable_1 in C:\wamp\www\busqueda.php on line 104
Call Stack
# Time Memory Function Location
1 0.0019 159208 {main}( ) ..\busqueda.php:0

( ! ) Notice: Undefined index: bSearchable_2 in C:\wamp\www\busqueda.php on line 104
Call Stack
# Time Memory Function Location
1 0.0019 159208 {main}( ) ..\busqueda.php:0

( ! ) Notice: Undefined index: bSearchable_3 in C:\wamp\www\busqueda.php on line 104
Call Stack
# Time Memory Function Location
1 0.0019 159208 {main}( ) ..\busqueda.php:0

( ! ) Notice: Undefined index: bSearchable_4 in C:\wamp\www\busqueda.php on line 104
Call Stack
# Time Memory Function Location
1 0.0019 159208 {main}( ) ..\busqueda.php:0

( ! ) Notice: Undefined index: bSearchable_5 in C:\wamp\www\busqueda.php on line 104
Call Stack
# Time Memory Function Location
1 0.0019 159208 {main}( ) ..\busqueda.php:0

( ! ) Notice: Undefined variable: sOrder in C:\wamp\www\busqueda.php on line 124
Call Stack
# Time Memory Function Location
1 0.0019 159208 {main}( ) ..\busqueda.php:0

( ! ) Notice: Undefined index: sEcho in C:\wamp\www\busqueda.php on line 158
Call Stack
# Time Memory Function Location
1 0.0019 159208 {main}( ) ..\busqueda.php:0
{"sEcho":0,"iTotalRecords":3,"iTotalDisplayRecords":3,"aaData":[["lol ","lololololl","2013-03-21","09:46:35.125","lololll ","20020200"],["jujujuj ","lololooloool","2013-03-21","09:46:51.843","\u00f1lololo ","201010101"],["uuuiuiii ","iuiuiiuiiiuii","2013-03-21","09:47:04.78","iuiuiiiui ","999"]]}

i didnt know you have to change those values since in the postgres example from here on server side data doesnt say anything what can i do to fix this i can see the json has data but i can show it properly, this is what i have on busqueda.php:

<?php
/*
* Script: DataTables server-side script for PHP and PostgreSQL
* Copyright: 2010 - Allan Jardine
* License: GPL v2 or BSD (3-point)
*/

/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Easy set variables
*/

/* Array of database columns which should be read and sent back to DataTables. Use a space where
* you want to insert a non-database field (for example a counter or static image)
*/
$aColumns = array( 'usuario', 'ip', 'fecha', 'hora', 'actividad','expediente_afectado' );

/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "id";

/* DB table to use */
$sTable = "historial";

/* Database connection information */
$gaSql['user'] = "postgres";
$gaSql['password'] = "postgres";
$gaSql['db'] = "postgres";
$gaSql['server'] = "127.0.0.1";



/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* If you just want to use the basic configuration for DataTables with PHP server-side, there is
* no need to edit below this line
*/

/*
* DB connection
*/
$gaSql['link'] = pg_connect(
" host=".$gaSql['server'].
" dbname=".$gaSql['db'].
" user=".$gaSql['user'].
" password=".$gaSql['password']
) or die('Could not connect: ' . pg_last_error());


/*
* Paging
*/
$sLimit = "";
if ( isset( $_GET['iDisplayStart'] ) && $_GET['iDisplayLength'] != '-1' )
{
$sLimit = "LIMIT ".intval( $_GET['iDisplayStart'] )." OFFSET ".
intval( $_GET['iDisplayLength'] );
}


/*
* Ordering
*/
if ( isset( $_GET['iSortCol_0'] ) )
{
$sOrder = "ORDER BY ";
for ( $i=0 ; $i $iFilteredTotal,
"aaData" => array()
);

while ( $aRow = pg_fetch_array($rResult, null, PGSQL_ASSOC) )
{
$row = array();
for ( $i=0 ; $i

as you can see i only changed what the example sayed i dont know why i get those undefined variable errors thax in advance and sry for me being a noob at this

o and none of the fields on the db are boolean

zombie23

oo i used the datatables debug tool here is the code plz plz help azaqox

zombie23

o its me again sry this is not spam i just saw the example code you here http://www.datatables.net/development/server-side/php_postgres is outdated , it doesnt work whit the lates datatable version (which i have) i dont want to be mean but can you plz update it , i think thtas the reason behind my undefined index errors

zombie23

na i got a version 1.6 and it still gets me the same errors someone plz help

zombie23

plz help plz help plzzzz anyone helpppp HELPPPPPPPPPP HELPPPPPPPPP HELPPPPPPPPPP

zombie23

still no help but its ok i know its difficult to answer ,im still stuck

allan

If you want an answer, you need to link to a test case - see: http://datatables.net/forums/discussion/12899/post-test-cases-when-asking-for-help-please-read . It sounds like you haven't enabled the bServerSide option, or it is being POSTed, but without a test case we have absolutely no idea, and are just guessing, wasting everyone's time. please link to a test page.

Allan

zombie23

im sry dude desperation can make a man go dump you know and more if you have no one to ask in your work place , now im getting a new error ill post the code i was working on lathe again im sry is the price i pay for being a noob