Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > SZ Edition
Reply
  #1  
Old 9th July 2008, 22:14
Fynnon's Avatar
Fynnon Fynnon is offline
xxx
 
Join Date: Nov 2007
P2P
Posts: 984
Default 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]--
--
Reply With Quote
  #2  
Old 10th July 2008, 07:04
Nafania Nafania is offline
TB Dev SZ Developer
 
Join Date: Feb 2008
Posts: 31
Default Re: database problems
1)
Code:
INSERT INTO `categories` (`id`, `name`, `image`, `torrents_limit`, `anonymous_view`) VALUES
(1, 'Test Category', '', 0, 1);
2)
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);
3)
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).
Reply With Quote
  #3  
Old 10th July 2008, 11:58
Fynnon's Avatar
Fynnon Fynnon is offline
xxx
 
Join Date: Nov 2007
P2P
Posts: 984
Default 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!
Attached Thumbnails
nfd1.png   nfd2.png  
Reply With Quote
  #4  
Old 10th July 2008, 18:30
Nafania Nafania is offline
TB Dev SZ Developer
 
Join Date: Feb 2008
Posts: 31
Default 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.
Reply With Quote
Reply

Tags
database , problems

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
database xDev BT.Manager (phpMyBitTorrent) 3 18th February 2010 14:20
database error movietorrent BT.Manager (phpMyBitTorrent) 6 14th January 2010 03:28
Database transfer rulebreaker Template Shares 2 8th March 2009 07:49
Database streetrace777 Yuna Scatari Edition (YSE) 0 6th September 2008 22:59
Database Backup kp380lv Yuna Scatari Edition (YSE) 2 4th July 2008 22:36



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