TOPIC: Add/Edit in Admin mode not working if alias for table has been specified

Hello Team

Using v3.9.7, if trying to save an edited DB record from the admin-view for a DB-table with an alias set, I get:

1054 Unknown column 'alias' in 'where clause'

I do not expercience this error if no alias is set for the DB-table.

Looking into the code of:

administrator/components/com_joodb/helpers/form.php

I feel in function checkAlias() this line:

$db->setQuery("SELECT `".$jb->fid."` FROM `".$jb->table."` WHERE alias=".$db->quote($item->{$falias}));

should look like this:

$db->setQuery("SELECT `".$jb->fid."` FROM `".$jb->table."` WHERE $falias=".$db->quote($item->{$falias}));

At least the above change fixed the error. ;)

Cheers/Tschüss
/alk

alk wrote: $db->setQuery("SELECT `".$jb->fid."` FROM `".$jb->table."` WHERE $falias=".$db->quote($item->{$falias}));

Thank you for reporting this bug. I never recognized it because my alias field is always alias!

But I wouldn't write variables directly in the SQL String and escape the variable..

Dirk wrote: ... because my alias field is always alias!

I almost thought so. ;)

/alk

Dirk wrote:

.$db->eacape($falias)

Typo alert above!