Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > Template Shares > Mods & Themes
Reply
  #11  
Old 13th January 2012, 16:22
smoky28's Avatar
smoky28 smoky28 is offline
Senior Member
 
Join Date: Aug 2010
Hungary
Posts: 82
Default
This is because something can not be sent to mysql mysql takeupload.php look att the input line because something is missing or not correctly placed in the top.
__________________
Sky-Tech Developer Team Hungary

Reply With Quote
  #12  
Old 5th March 2012, 17:06
PAX's Avatar
PAX PAX is offline
Senior Member
 
Join Date: Nov 2010
P2P
Posts: 41
Default
Mysql puked: Column count doesn't match value count at row 1 .
something is missing, that's for sure, but what is missing in the database? I do not know

CREATE TABLE IF NOT EXISTS `torrents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`info_hash` char(20) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`filename` varchar(255) NOT NULL DEFAULT '',
`descr` text NOT NULL,
`category` int(10) unsigned NOT NULL DEFAULT '0',
`size` bigint(20) unsigned NOT NULL DEFAULT '0',
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`numfiles` int(10) unsigned NOT NULL DEFAULT '0',
`comments` int(10) unsigned NOT NULL DEFAULT '0',
`hits` int(10) unsigned NOT NULL DEFAULT '0',
`times_completed` int(10) unsigned NOT NULL DEFAULT '0',
`leechers` int(10) unsigned NOT NULL DEFAULT '0',
`seeders` int(10) unsigned NOT NULL DEFAULT '0',
`last_action` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`visible` enum('yes','no') NOT NULL DEFAULT 'yes',
`banned` enum('yes','no') NOT NULL DEFAULT 'no',
`owner` int(10) unsigned NOT NULL DEFAULT '0',
`free` enum('yes','no') DEFAULT 'no',
`anonymous` enum('yes','no') NOT NULL DEFAULT 'no',
`sticky` enum('yes','no') NOT NULL DEFAULT 'no',
`offensive` enum('yes','no') NOT NULL DEFAULT 'no',
`silver` enum('yes','no') NOT NULL DEFAULT 'no',
`t_image` varchar(255) NOT NULL DEFAULT '',
`t_link` text NOT NULL,
`isnuked` enum('yes','no') NOT NULL DEFAULT 'no',
`WhyNuked` varchar(255) NOT NULL DEFAULT 'Bad quality!',
`isrequest` enum('yes','no') NOT NULL DEFAULT 'no',
`ts_external` enum('yes','no') NOT NULL DEFAULT 'no',
`ts_external_url` varchar(128) NOT NULL DEFAULT '',
`ts_external_lastupdate` int(10) unsigned NOT NULL DEFAULT '0',
`allowcomments` enum('yes','no') NOT NULL DEFAULT 'yes',
`doubleupload` enum('yes','no') NOT NULL DEFAULT 'no',
`isScene` int(11) unsigned NOT NULL DEFAULT '0',
`moderated` enum('yes','error','no') NOT NULL DEFAULT 'no',
`moderator` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`error` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`genre` varchar(255) NOT NULL DEFAULT 'genre',
`Torrent név Eng` varchar(80) DEFAULT NULL,
`ido` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`sebesseg` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `info_hash` (`info_hash`),
KEY `category` (`category`),
KEY `times_completed` (`times_completed`,`leechers`,`seeders`),
KEY `visible` (`visible`,`banned`),
KEY `t_image` (`t_image`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=929 ;
Reply With Quote
  #13  
Old 6th March 2012, 10:46
smoky28's Avatar
smoky28 smoky28 is offline
Senior Member
 
Join Date: Aug 2010
Hungary
Posts: 82
Default
PHP Code:
CREATE TABLE `torrents` (
  `
idint(10unsigned NOT NULL auto_increment,
  `
info_hashchar(20NOT NULL default '',
  `
namevarchar(255NOT NULL default '',
  `
filenamevarchar(255NOT NULL default '',
  `
descrtext NOT NULL,
  `
categoryint(10unsigned NOT NULL default '0',
  `
sizebigint(20unsigned NOT NULL default '0',
  `
addeddatetime NOT NULL default '0000-00-00 00:00:00',
  `
numfilesint(10unsigned NOT NULL default '0',
  `
commentsint(10unsigned NOT NULL default '0',
  `
hitsint(10unsigned NOT NULL default '0',
  `
times_completedint(10unsigned NOT NULL default '0',
  `
leechersint(10unsigned NOT NULL default '0',
  `
seedersint(10unsigned NOT NULL default '0',
  `
last_actiondatetime NOT NULL default '0000-00-00 00:00:00',
  `
visibleenum('yes','no'NOT NULL default 'yes',
  `
bannedenum('yes','no'NOT NULL default 'no',
  `
ownerint(10unsigned NOT NULL default '0',
  `
freeenum('yes','no') default 'no',
  `
anonymousenum('yes','no'NOT NULL default 'no',
  `
stickyenum('yes','no'NOT NULL default 'no',
  `
offensiveenum('yes','no'NOT NULL default 'no',
  `
silverenum('yes','no'NOT NULL default 'no',
  `
t_imagevarchar(255NOT NULL default '',
  `
t_linktext NOT NULL,
  `
isnukedenum('yes','no'NOT NULL default 'no',
  `
WhyNukedvarchar(255NOT NULL default 'Bad quality!',
  `
isrequestenum('yes','no'NOT NULL default 'no',
  `
ts_externalenum('yes','no'NOT NULL default 'no',
  `
ts_external_urlvarchar(128NOT NULL default '',
  `
ts_external_lastupdateint(10unsigned NOT NULL default '0',
  `
allowcommentsenum('yes','no'NOT NULL default 'yes',
  `
doubleuploadenum('yes','no'NOT NULL default 'no',
  `
isSceneint(11unsigned NOT NULL default '0',
  `
recomandatenum('Igen','Nem'NOT NULL default 'Nem',
  `
subenum('Igen','Nem'NOT NULL default 'Nem',
  `
seedboxenum('Igen','Nem'NOT NULL default 'Nem',
  `
trteamenum('Igen','Nem'NOT NULL default 'Nem',
  `
tubetext NOT NULL,
  `
genrevarchar(40NOT NULL,
  `
nfovarchar(255NOT NULL,
  `
ellenorizveenum('yes','error','nincs'NOT NULL default 'nincs',
  `
ellenoriztevarchar(40character set latin1 collate latin1_general_ci NOT NULL,
  `
elcommentvarchar(40character set latin1 collate latin1_general_ci NOT NULL,
  `
sebessegvarchar(80character set utf8 NOT NULL,
  `
idovarchar(80character set utf8 NOT NULL,
  `
portvarchar(80NOT NULL,
  
PRIMARY KEY  (`id`),
  
KEY `info_hash` (`info_hash`),
  
KEY `category` (`category`),
  
KEY `times_completed` (`times_completed`,`leechers`,`seeders`),
  
KEY `visible` (`visible`,`banned`),
  
KEY `t_image` (`t_image`)
ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=
Bump: My torrent sql table

PHP Code:
CREATE TABLE `torrents` (
  `
idint(10unsigned NOT NULL auto_increment,
  `
info_hashchar(20NOT NULL default '',
  `
namevarchar(255NOT NULL default '',
  `
filenamevarchar(255NOT NULL default '',
  `
descrtext NOT NULL,
  `
categoryint(10unsigned NOT NULL default '0',
  `
sizebigint(20unsigned NOT NULL default '0',
  `
addeddatetime NOT NULL default '0000-00-00 00:00:00',
  `
numfilesint(10unsigned NOT NULL default '0',
  `
commentsint(10unsigned NOT NULL default '0',
  `
hitsint(10unsigned NOT NULL default '0',
  `
times_completedint(10unsigned NOT NULL default '0',
  `
leechersint(10unsigned NOT NULL default '0',
  `
seedersint(10unsigned NOT NULL default '0',
  `
last_actiondatetime NOT NULL default '0000-00-00 00:00:00',
  `
visibleenum('yes','no'NOT NULL default 'yes',
  `
bannedenum('yes','no'NOT NULL default 'no',
  `
ownerint(10unsigned NOT NULL default '0',
  `
freeenum('yes','no') default 'no',
  `
anonymousenum('yes','no'NOT NULL default 'no',
  `
stickyenum('yes','no'NOT NULL default 'no',
  `
offensiveenum('yes','no'NOT NULL default 'no',
  `
silverenum('yes','no'NOT NULL default 'no',
  `
t_imagevarchar(255NOT NULL default '',
  `
t_linktext NOT NULL,
  `
isnukedenum('yes','no'NOT NULL default 'no',
  `
WhyNukedvarchar(255NOT NULL default 'Bad quality!',
  `
isrequestenum('yes','no'NOT NULL default 'no',
  `
ts_externalenum('yes','no'NOT NULL default 'no',
  `
ts_external_urlvarchar(128NOT NULL default '',
  `
ts_external_lastupdateint(10unsigned NOT NULL default '0',
  `
allowcommentsenum('yes','no'NOT NULL default 'yes',
  `
doubleuploadenum('yes','no'NOT NULL default 'no',
  `
isSceneint(11unsigned NOT NULL default '0',
  `
recomandatenum('Igen','Nem'NOT NULL default 'Nem',
  `
subenum('Igen','Nem'NOT NULL default 'Nem',
  `
seedboxenum('Igen','Nem'NOT NULL default 'Nem',
  `
trteamenum('Igen','Nem'NOT NULL default 'Nem',
  `
tubetext NOT NULL,
  `
genrevarchar(40NOT NULL,
  `
nfovarchar(255NOT NULL,
  `
ellenorizveenum('yes','error','nincs'NOT NULL default 'nincs',
  `
ellenoriztevarchar(40character set latin1 collate latin1_general_ci NOT NULL,
  `
elcommentvarchar(40character set latin1 collate latin1_general_ci NOT NULL,
  `
sebessegvarchar(80character set utf8 NOT NULL,
  `
idovarchar(80character set utf8 NOT NULL,
  `
portvarchar(80NOT NULL,
  
PRIMARY KEY  (`id`),
  
KEY `info_hash` (`info_hash`),
  
KEY `category` (`category`),
  
KEY `times_completed` (`times_completed`,`leechers`,`seeders`),
  
KEY `visible` (`visible`,`banned`),
  
KEY `t_image` (`t_image`)
ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=
Bump: My torrent sql table


PHP Code:
CREATE TABLE `torrents` (
  `
idint(10unsigned NOT NULL auto_increment,
  `
info_hashchar(20NOT NULL default '',
  `
namevarchar(255NOT NULL default '',
  `
filenamevarchar(255NOT NULL default '',
  `
descrtext NOT NULL,
  `
categoryint(10unsigned NOT NULL default '0',
  `
sizebigint(20unsigned NOT NULL default '0',
  `
addeddatetime NOT NULL default '0000-00-00 00:00:00',
  `
numfilesint(10unsigned NOT NULL default '0',
  `
commentsint(10unsigned NOT NULL default '0',
  `
hitsint(10unsigned NOT NULL default '0',
  `
times_completedint(10unsigned NOT NULL default '0',
  `
leechersint(10unsigned NOT NULL default '0',
  `
seedersint(10unsigned NOT NULL default '0',
  `
last_actiondatetime NOT NULL default '0000-00-00 00:00:00',
  `
visibleenum('yes','no'NOT NULL default 'yes',
  `
bannedenum('yes','no'NOT NULL default 'no',
  `
ownerint(10unsigned NOT NULL default '0',
  `
freeenum('yes','no') default 'no',
  `
anonymousenum('yes','no'NOT NULL default 'no',
  `
stickyenum('yes','no'NOT NULL default 'no',
  `
offensiveenum('yes','no'NOT NULL default 'no',
  `
silverenum('yes','no'NOT NULL default 'no',
  `
t_imagevarchar(255NOT NULL default '',
  `
t_linktext NOT NULL,
  `
isnukedenum('yes','no'NOT NULL default 'no',
  `
WhyNukedvarchar(255NOT NULL default 'Bad quality!',
  `
isrequestenum('yes','no'NOT NULL default 'no',
  `
ts_externalenum('yes','no'NOT NULL default 'no',
  `
ts_external_urlvarchar(128NOT NULL default '',
  `
ts_external_lastupdateint(10unsigned NOT NULL default '0',
  `
allowcommentsenum('yes','no'NOT NULL default 'yes',
  `
doubleuploadenum('yes','no'NOT NULL default 'no',
  `
isSceneint(11unsigned NOT NULL default '0',
  `
recomandatenum('Igen','Nem'NOT NULL default 'Nem',
  `
subenum('Igen','Nem'NOT NULL default 'Nem',
  `
seedboxenum('Igen','Nem'NOT NULL default 'Nem',
  `
trteamenum('Igen','Nem'NOT NULL default 'Nem',
  `
tubetext NOT NULL,
  `
genrevarchar(40NOT NULL,
  `
nfovarchar(255NOT NULL,
  `
ellenorizveenum('yes','error','nincs'NOT NULL default 'nincs',
  `
ellenoriztevarchar(40character set latin1 collate latin1_general_ci NOT NULL,
  `
elcommentvarchar(40character set latin1 collate latin1_general_ci NOT NULL,
  `
sebessegvarchar(80character set utf8 NOT NULL,
  `
idovarchar(80character set utf8 NOT NULL,
  `
portvarchar(80NOT NULL,
  
PRIMARY KEY  (`id`),
  
KEY `info_hash` (`info_hash`),
  
KEY `category` (`category`),
  
KEY `times_completed` (`times_completed`,`leechers`,`seeders`),
  
KEY `visible` (`visible`,`banned`),
  
KEY `t_image` (`t_image`)
ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=
__________________
Sky-Tech Developer Team Hungary

Reply With Quote
  #14  
Old 6th March 2012, 15:18
PAX's Avatar
PAX PAX is offline
Senior Member
 
Join Date: Nov 2010
P2P
Posts: 41
Default
thank you very much for the information, tonight I experimented and check. I greet


upgraded base, tomorrow they're going to be a script, yesterday did not give advice ...

Bump: smoky28 i can't deal with file takeupload.php, i make a mistake somewhere in code. I ask for help to fix this problem, I don't know what I did wrong.


ps. I can't edited preview post, so i write under the next post`sorry
Attached Files
File Type: php takeupload.php (17.1 KB, 6 views)

Last edited by PAX; 7th March 2012 at 11:44.
Reply With Quote
  #15  
Old 12th March 2012, 09:17
Omenke Omenke is offline
Senior Member
 
Join Date: May 2010
Hungary
Posts: 35
Thumbs up
Quote:
Originally Posted by PAX View Post
thank you very much for the information, tonight I experimented and check. I greet


upgraded base, tomorrow they're going to be a script, yesterday did not give advice ...

Bump: smoky28 i can't deal with file takeupload.php, i make a mistake somewhere in code. I ask for help to fix this problem, I don't know what I did wrong.


ps. I can't edited preview post, so i write under the next post`sorry

Hi!
Fixed a bug in it for you
Attached Files
File Type: php takeupload.php (17.7 KB, 7 views)
Reply With Quote
The Following User Says Thank You to Omenke For This Useful Post:
PAX (12th March 2012)
  #16  
Old 12th March 2012, 15:55
PAX's Avatar
PAX PAX is offline
Senior Member
 
Join Date: Nov 2010
P2P
Posts: 41
Default
Step 2 is fine, but step 3 = white page

Bump: done step by step and nothing .. hheeheh, does not work. horror ... heheheee, any idea?
Reply With Quote
Reply

Tags
56 , mod , seed , speed , time , tsse

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 23:57. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.