Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   Torrent Trader (http://www.bvlist.com/forumdisplay.php?f=29)
-   -   Inport Torrent's ERROR [Need Help] (http://www.bvlist.com/showthread.php?t=8863)

Extremlym 9th February 2013 22:56

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: http://www.php-myadmin.com/themes/dot.gif
  #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])

Crazzy 20th February 2013 09:49

Close this trhead i resolved this problem


All times are GMT +2. The time now is 07:33.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.