cant update table - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: cant update table (/showthread.php?tid=658951)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: cant update table (/showthread.php?tid=658951)
cant update table - DarkMythHunter - 17.09.2018
Код:
[18:28:13] [DEBUG] pushed value 'Cannot add or update a child row: a foreign key constraint fails (`samp6452_dayznew`.`holster`, CONSTRAINT `fk_htrid` FOREIGN KEY (`AccountID`) REFERENCES `accountstest` (`AccountID`) ON DELETE CASCADE ON UPDATE CASCADE)' onto AMX stack
Re: cant update table - iLearner - 17.09.2018
Basically means you have 2 or more tables that are connected using keys (primary for primary table (e.g users) and foreign key for secondary table (e.g player inventory)).
And that also means:
- you cannot delete an item from primary table if it has correlated items in secondary table.
- and can't edit as above ^