Return to Answer

Try to get the user id like this:

   $user = JFactory::getUser();
   $id= $user->id; 

Try to directly add it onto your sql statement:

$query = $fieldParams->get('query', ''); // Run the query with a having condition because it supports aliases $db->setQuery($query . ' AND created_by =' . $db->q('.$id.' ));

also check permissions and everything.

1. You can try unistalling the plugin.

2. Fix the database by going to:

Extension > Manage > Database and click "fix".

3. Manually clean the tables releated to your plugin if there's still leftovers.

4. Clean the cache.

5. Verify if all files are there.

6. Verify if it's the correct database.

7. Install the plugin again.

Try to get the user id like this:

   $user = JFactory::getUser();
   $id= $user->id; 

Try to directly add it onto your sql statement:

$query = $fieldParams->get('query', ''); // Run the query with a having condition because it supports aliases $db->setQuery($query . ' AND created_by =' . $db->q('.$id.' ));

also check permissions and everything.

1. You can try unistalling the plugin.

2. Fix the database by going to:

Extension > Manage > Database and click "fix".

3. Manually clean the tables releated to your plugin if there's still leftovers.

4. Clean the cache.

5. Verify if all files are there.

6. Verify if it's the correct database.

7. Install the plugin again.

PLUS:

Instead of editing

plugins/fields/sql/tmpl/sql.php

try to edit the helper and the view file. Those are responsible for manipulating the database. That's probably the cause of the error you are getting.

Try to get the user id like this:

   $user = JFactory::getUser();
   $id= $user->id; 

Try to directly add it onto your sql statement:

$query = $fieldParams->get('query', ''); // Run the query with a having condition because it supports aliases $db->setQuery($query . ' AND created_by =' . $db->q('.$id.' ));

also check permissions and everything.

1. You can try unistalling the plugin.

2. Fix the database by going to:

Extension > Manage > Database and click "fix".

3. Manually clean the tables releated to your plugin if there's still leftovers.

4. Clean the cache.

5. Installing the plugin again .

6. Verify if all files are there.

7. Verify if it's the correct database.

Try to get the user id like this:

   $user = JFactory::getUser();
   $id= $user->id; 

Try to directly add it onto your sql statement:

$query = $fieldParams->get('query', ''); // Run the query with a having condition because it supports aliases $db->setQuery($query . ' AND created_by =' . $db->q('.$id.' ));

also check permissions and everything.

1. You can try unistalling the plugin.

2. Fix the database by going to:

Extension > Manage > Database and click "fix".

3. Manually clean the tables releated to your plugin if there's still leftovers.

4. Clean the cache.

5. Verify if all files are there.

6. Verify if it's the correct database.

7. Install the plugin again.

Try to get the user id like this:

   $user = JFactory::getUser();
   $id= $user->id; 

Try to directly add it onto your sql statement:

$query = $fieldParams->get('query', ''); // Run the query with a having condition because it supports aliases $db->setQuery($query . ' AND created_by =' . $db->q('.$id.' ));

also check permissions and everything.

1. You can try unistalling the plugin

2. Fix the database by going to

Extension > Manage > Database and click "fix"

3. Manually clean the tables releated to your plugin if there's sill leftovers.

4. Clean the cache

5. Installing the plugin again

6. Verify if all files are there.

7. Verify it's the correct database

Try to get the user id like this:

   $user = JFactory::getUser();
   $id= $user->id; 

Try to directly add it onto your sql statement:

$query = $fieldParams->get('query', ''); // Run the query with a having condition because it supports aliases $db->setQuery($query . ' AND created_by =' . $db->q('.$id.' ));

also check permissions and everything.

1. You can try unistalling the plugin.

2. Fix the database by going to:

Extension > Manage > Database and click "fix".

3. Manually clean the tables releated to your plugin if there's still leftovers.

4. Clean the cache.

5. Installing the plugin again .

6. Verify if all files are there.

7. Verify if it's the correct database.