Travis fails
https://travis-ci.org/joomla/joomla-cms/jobs/22698038

Error is: 816PDOException: SQLSTATE[HY000]: General error: 1 no such column: p.client_id

Can you give all the message to verify all the query.
When we did that, that was for the menu.
I would like to see if you have another table name that would not contain the column "client_id"

Click on the link from JM or the "Details" link after the "Failed - The Travis CI build failed" message. That will bring you to the Travis test.

The full message is:

1) JTableNestedTest::testGetPath

PDOException: SQLSTATE[HY000]: General error: 1 no such column: p.client_id

/home/travis/build/joomla/joomla-cms/libraries/joomla/database/driver/pdo.php:702
/home/travis/build/joomla/joomla-cms/libraries/joomla/table/nested.php:141
/home/travis/build/joomla/joomla-cms/tests/unit/suites/libraries/joomla/table/JTableNestedTest.php:110

2) JTableNestedTest::testRebuildPath

PDOException: SQLSTATE[HY000]: General error: 1 no such column: p.client_id

/home/travis/build/joomla/joomla-cms/libraries/joomla/database/driver/pdo.php:702
/home/travis/build/joomla/joomla-cms/libraries/joomla/table/nested.php:1383
/home/travis/build/joomla/joomla-cms/tests/unit/suites/libraries/joomla/table/JTableNestedTest.php:497

I have saw that but we don't have the full query.
So I don't know what is executed.

If you check the "menu" table in the Joomla 2.5 and 3.2, the field "client_id" exists.

So if this script report an error, it would be good to have the full detail and I don't know who can provide the full detail of the SQL statement that is executed and that fails.

Perhaps that it is executed on a table that does not contain the "client_id".

What I see here, is that it is reported with PDO and not mysql.
So perhaps that PDO table has a difference in the description of the table.

As I don't use PDO, I can not tell you.

From what I see you do the change in the JTableNested class, but this one is used for any nested tables. Like also for the categories one. However the client_id is only available in the menus table, not in each nested table.

So you would have to make the change in the table for menus, and not in the JTableNested class.

As a result of @Bakual comment above and no updates I am closing this