Edit or torrent update error
Hi guys,
some idea about this error when I try to editing / updating my torrent: Code:
Database Error in torrents-edit.php on line 188: |
Whats the column definition for freeleech? It's expecting something and getting a string. I suspect it's supposed to be an int.
So, the query should probably be freeleech = 0, not freeleech = ''. |
Quote:
Row 188: SQL_Query_exec("UPDATE torrents SET " . join(",", $updateset) . " WHERE id = $id"); https://i.postimg.cc/htggTKH4/Untitled.png |
:)
Quote:
Very general would look like the code of i3on and TTCE |
Quote:
I suspect the value of $updatedset is what you posted. The column definition can be found by running, in mysql: Code:
SHOW CREATE TABLE torrents |
Quote:
This is resultate Code:
CREATE TABLE `torrents` ( |
As you can see it requires freeleech to be either 0 or 1 not and empty string.
In you code, change freeleech = '' to freeleech = 0 |
If freeleech (or other options) is not checked I have that error.
Like that: Freeleech -> unckecked = error Freeleech -> ckecked = OK Webseed -> unckecked = error Webseed -> ckecked = OK Recommended -> unckecked = error Recommended -> ckecked = OK .... .... .... |
Quote:
|
well First off lets start with what version of Torrent Trader are you working with?
fast way please show the file torrents-edit.php seems like this file is trying to enter yes no rather then 0 1 so the error needs to be traced down. |
All times are GMT +2. The time now is 08:41. |
Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.