"An SQL error occurred: SQLSTATE [23000]: Integrity constraint violation: 1052 Column 'id' in field list is ambiguous"} about ssp HOT 2 CLOSED

Yes, I am having the same problem. Is there a solution to two tables who both have 'id' columns?

from ssp.

To Integrity constraint violation, I have added the option to rename any field name.
You can rename the id field for both table or whatever you need.
Like this you can define your column array.
$columns = array( array( 'db' => 'table1.id', 'dt' => 0, 'field' => 'id', 'as' => 'table1_id' ), array( 'db' => 'table2.id', 'dt' => 1 'field' => 'login', 'as' => 'table2_id'),

I think, it may help you.

from ssp.