Hi,
I try to delete a data in a table and his dependances in other table.
Alone the data is delete correctly
If i add a model with
Model name : vl
Related to ; fonds_id
Foreing key : id
When i try to delete I have
1109 Unknown table 'vl' in MULTI DELETE
an idea?
Thanks
I try to delete a data in a table and his dependances in other table.
Alone the data is delete correctly
If i add a model with
Model name : vl
Related to ; fonds_id
Foreing key : id
When i try to delete I have
1109 Unknown table 'vl' in MULTI DELETE
an idea?
Thanks
Hi Christophe,
The other model name is "fonds_id" ?
Best regards,
Max
The other model name is "fonds_id" ?
Best regards,
Max
Hi Max,
No it's fcpi, i change it
now i have
1052 Column 'id' in where clause is ambiguous
there is an id in twice table
thanks
No it's fcpi, i change it
now i have
1052 Column 'id' in where clause is ambiguous
there is an id in twice table
thanks
Hi Christophe,
And what are the delete conditions ? do you have the model name used in the delete conditions or not ?
Best regards,
Max
And what are the delete conditions ? do you have the model name used in the delete conditions or not ?
Best regards,
Max
Hi Max,
in the first model
model : fcpi
delete conditions: fcpi.id:{data:item_id}
in the second model
model name : vl
related to: fcpi
foreign key: id
relations conditions: vl.fonds_id={data:item_id}
Now, there is no error the fonds is deleted but not the vl related
thanks for your help
regards
in the first model
model : fcpi
delete conditions: fcpi.id:{data:item_id}
in the second model
model name : vl
related to: fcpi
foreign key: id
relations conditions: vl.fonds_id={data:item_id}
Now, there is no error the fonds is deleted but not the vl related
thanks for your help
regards
Hi Christophe,
Why do you need to use "relation conditions" ? the foreign key is not enough ? how the 2 tables are connected ?
You also should not use the request parameter item_id as its being used by Joomla.
Best regards,
Max
Why do you need to use "relation conditions" ? the foreign key is not enough ? how the 2 tables are connected ?
You also should not use the request parameter item_id as its being used by Joomla.
Best regards,
Max
Hi Max
Without "relation conditions" the fonds is delete but not the vl
The table fonds_vl is linked to fonds via a column fonds_id
I replace item_id by fonds_id : always fonds deleted but not the vl linked
(it's Item_id used by joomla)
Regards
Without "relation conditions" the fonds is delete but not the vl
The table fonds_vl is linked to fonds via a column fonds_id
I replace item_id by fonds_id : always fonds deleted but not the vl linked
(it's Item_id used by joomla)
Regards
Hi Christophe,
Very late reply, what was the relation type here ?
If the tables are not connected using the primary key of the main table then it will not work.
Best regards,
Max
Very late reply, what was the relation type here ?
If the tables are not connected using the primary key of the main table then it will not work.
Best regards,
Max
Hello Max,
The link under the bouton works well if i copy/paste in another window.
It seams it's the ajax call doesn't work. the weel turn infinite
in f12 the reponse is
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>403 Forbidden</title>
</head><body>
<h1>Forbidden</h1>
<p>You don't have permission to access /arobas2017/index.php
on this server.</p>
</body></html>
the ip use is the server ip not mine!!!
regards
The link under the bouton works well if i copy/paste in another window.
It seams it's the ajax call doesn't work. the weel turn infinite
in f12 the reponse is
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>403 Forbidden</title>
</head><body>
<h1>Forbidden</h1>
<p>You don't have permission to access /arobas2017/index.php
on this server.</p>
</body></html>
the ip use is the server ip not mine!!!
regards
Hi Christophe,
This is a permissions issue or a server setup issue, not related to Connectivity, you can ask your host admin about this.
Best regards,
Max
This is a permissions issue or a server setup issue, not related to Connectivity, you can ask your host admin about this.
Best regards,
Max
This topic is locked and no more replies can be posted.
