bServerSide issue when set to true

jeebsion

I took the php script from the example page in the datatables site and modified it to my needs. I've already verified the json at jsonlint.com to be valid. With bServerSide being false everything went okay, but when I turn it to true, the loading went forever whilst chrome reported there's a json error. I wonder what have I been missing .. the following is the link the datatables live:

http://live.datatables.net/usoruf/3/edit

Thank y

jeebsion

Just in case you need the reference for the ajaxsource .. it's here:

http://meca-moe.homeip.net/ajax/wh_by_product_list.phps

Thanx again :-)

allan

Are you able to link us to the page which is using the server-side processing? The `live` example you have above is going to suffer from cross domain Ajax access issues since your script is on a server domain from the source.

Allan

jeebsion

Sure .. I've created a temporary user account by the following credentials:

username: test
password: test123

the specific link to the said issue would be http://moe.mecacomtech.loc/wh.php?by_product=1

Hopefully you can advice me accordingly :-)

jeebsion

allan,

have you seen them already?

allan

Server address isn't resolving.

[quote]
ping moe.mecacomtech.loc
ping: cannot resolve moe.mecacomtech.loc: Unknown host
[/quote]

Allan

jeebsion

Allan,

Sorry .. my bad .. the host is http://meca-moe.homeip.net and the link would be http://meca-moe.homeip.net/wh.php?by_product=1

allan

Thanks.

The return from the server is:

> Unknown column 'products.title as product_name' in 'order clause'

So looks like an issue with the server-side processing script that is being used.

Allan

jeebsion

allan,

how did you get that error? can I produce it myself from perhaps .../ajax/wh_by_product_list.php?blabla=value&anotherblabla=anothervalue ?

allan

I loaded the page :-).

Look at the Ajax return in Firebug or Inspector.

Allan

jeebsion

Brilliant .. what I did was to explode the $aColumns by the "as" and trim it, then pass it over to be rendered within the sql statement. Do tell me if you want the ajax script for this one. Simple one though .. yet messy :-)