Inport Torrent's ERROR [Need Help]
Import Torrents from V1 to V2 on TT2
when i import the old torrents.sql has an error, i don't have search_text value
Code:
MySQL said:
#1054 - Unknown column 'search_text' in 'field list'
how can i insert a search_text value on the new sql ?
any help please!
the new sql
Code:
INSERT INTO `torrents`(`id`, `info_hash`, `name`, `filename`, `save_as`, `descr`, `image1`, `image2`, `category`, `size`, `added`, `type`, `numfiles`, `comments`, `views`, `hits`, `times_completed`, `leechers`, `seeders`, `last_action`, `visible`, `banned`, `owner`, `anon`, `numratings`, `ratingsum`, `nfo`, `announce`, `external`, `torrentlang`, `freeleech`) VALUES ([value-1],[value-2],[value-3],[value-4],[value-5],[value-6],[value-7],[value-8],[value-9],[value-10],[value-11],[value-12],[value-13],[value-14],[value-15],[value-16],[value-17],[value-18],[value-19],[value-20],[value-21],[value-22],[value-23],[value-24],[value-25],[value-26],[value-27],[value-28],[value-29],[value-30],[value-31])
old sql
Code:
INSERT INTO `torrents`(`id`, `info_hash`, `name`, `filename`, `save_as`, `search_text`, `descr`, `ori_descr`, `category`, `size`, `added`, `type`, `numfiles`, `comments`, `views`, `hits`, `times_completed`, `leechers`, `seeders`, `last_action`, `visible`, `banned`, `owner`, `numratings`, `ratingsum`, `nfo`, `free`, `smalld`, `recommended`, `poster`, `bgsubs`, `bgaudio`, `genre`, `genre1`, `genre2`, `sticky`, `pretime`, `afterpre`, `url`, `double_upload`, `seen`, `subs`, `external`, `x2`, `description`) VALUES ([value-1],[value-2],[value-3],[value-4],[value-5],[value-6],[value-7],[value-8],[value-9],[value-10],[value-11],[value-12],[value-13],[value-14],[value-15],[value-16],[value-17],[value-18],[value-19],[value-20],[value-21],[value-22],[value-23],[value-24],[value-25],[value-26],[value-27],[value-28],[value-29],[value-30],[value-31],[value-32],[value-33],[value-34],[value-35],[value-36],[value-37],[value-38],[value-39],[value-40],[value-41],[value-42],[value-43],[value-44],[value-45])
|