Bravo List - database problems

Bravo List (http://www.bvlist.com/index.php)

- SZ Edition (http://www.bvlist.com/forumdisplay.php?f=24)

- - database problems (http://www.bvlist.com/showthread.php?t=589)

database problems

I looked inside the database today after updating it and i found 3 "problems":

1.

Code:

--

-- Dumping data for table `categories`

--



INSERT INTO `categories` (`id`, `name`, `image`, `torrents_limit`, `anonymous_view`) VALUES

(1, '???????? ???????', '', 0, 1);



-- --------------------------------------------------------

because:
[code]--
--

Re: database problems

Code:

INSERT INTO `categories` (`id`, `name`, `image`, `torrents_limit`, `anonymous_view`) VALUES

(1, 'Test Category', '', 0, 1);

Code:

INSERT INTO `forum_groups` VALUES(385, 1, 'Users', '', 1, 0);

INSERT INTO `forum_groups` VALUES(56, 1, 'Power Users', '', 1, 0);

INSERT INTO `forum_groups` VALUES(7, 1, 'Moderators', '', 1, 0);

INSERT INTO `forum_groups` VALUES(387, 1, 'Leechers', '', 1, 0);

INSERT INTO `forum_groups` VALUES(55, 1, 'Uploaders', '', 1, 0);

INSERT INTO `forum_groups` VALUES(6, 1, 'Administration', '', 1, 0);

INSERT INTO `forum_groups` VALUES(386, 1, 'VIP', '', 1, 0);

INSERT INTO `forum_groups` VALUES(1, 1, 'Anonymous', 'Personal User', 1, 0);

INSERT INTO `forum_groups` VALUES(2, 1, 'Admin', 'Personal User', 1, 0);

INSERT INTO `forum_groups` VALUES(126, 1, '', 'Personal User', 1, 0);

Code:

INSERT INTO `sitelog` (`id`, `added`, `txt`, `log_view_level`) VALUES

(1, 1215633328, '??????? 1 (???????? ?????) ?????? ???????? (??? ?????????? ??? 7 ????)', 0);

I don't know what is it, but i think it's a
Torrent 1 (here_the_torrent_name) was deleted by System (no activity for 7 days)

4) You must set up default language of tracker to english in admin cp and confirmation will be in english (and site log messages too).

Re: database problems

[hr:2196m58f]
A. At point 4, after you login and go to your Profile to change your language it doesn`t matter anymore in what language you have received the confirmation cause you already have confirmed your account ~

I changed in the database (before importing it) the default languge from russian to english but it seems to not work

B. We also have a problem with categories:

Code:

--

-- Insers data for the table  `categories`

--



INSERT INTO `categories` (`id`, `name`, `image`, `torrents_limit`, `anonymous_view`) VALUES

(1, 'Test Category ', '', 0, 1);

I changed in the database before importing as you said to: Test Category but i still get instead of that : ??????????

If i look in my database i see this:

[attachment=1:2196m58f]nfd1.png[/attachment:2196m58f]

but if i look on my browse page i see this:

[attachment=0:2196m58f]nfd2.png[/attachment:2196m58f]

Thank You!

Re: database problems

Quote:

I changed in the database (before importing it) the default languge from russian to english but it seems to not work

Quote:

B. We also have a problem with categories:

In this source i using powerful caching system, and so, there is many queries store in cache and if you edit database directly you must delete cache or edit this settings through admin cp.
To delete cache you must delete all *.php files from yours cache directory.

In next versions of tbdev sz will be feature to delete cache etc diretly from admin cp, but now you must do it manually.