Strona 1 z 1
Color Ranks - Gotowe pliki do phpBB 2.0.22
: 29 lipca 2007, 20:01
autor: piterLGC
wyskoczylo mi cos takiego jak zrobilem zapytanie do sql
Kod: Zaznacz cały
Error
SQL query:
ALTER TABLE phpbb_ranks ADD `rank_color` VARCHAR( 255 ) ,
ADD `rank_bold` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_prefix` VARCHAR( 32 ) ,
ADD `rank_style` VARCHAR( 255 ) ,
ADD `rank_list` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_order` INT( 11 ) UNSIGNED NOT NULL ,
ADD `rank_onlygfx` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_titlelist` VARCHAR( 50 ) ,
ADD `rank_female` VARCHAR( 50 ) ,
ADD `rank_ignore_nick` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_ignore_rank` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_show_ekipa` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_group_ekipa` INT( 11 ) UNSIGNED DEFAULT '0' NOT NULL ;
MySQL said: Documentation
#1060 - Duplicate column name 'rank_bold'
i nie moge robic rang po wgraniu moda bo wyskakuje mi cos takiego
Kod: Zaznacz cały
Couldn't update/insert into ranks table
DEBUG MODE
SQL Error : 1054 Unknown column 'rank_color' in 'field list'
UPDATE phpbb_ranks SET rank_title = 'Administrator', rank_special = 1, rank_min = -1, rank_image = 'admin.gif' , rank_color = '0=|3=|4=|5=|6=', rank_bold = 0, rank_prefix = '', rank_style = '', rank_list = 0, rank_onlygfx = 0, rank_titlelist= '', rank_ignore_nick = 0, rank_ignore_rank = 0, rank_show_ekipa=0, rank_female='', rank_group_ekipa=1 WHERE rank_id = 1
Line : 518
File : admin_ranks.php
a mod jest napewno dobrze wgrany bo wgrywalem gotowe pliki
: 31 lipca 2007, 06:53
autor: daroPL
Pokasuj wszystkie kolumny, które tworzyć pierwszym zapytaniem i wykonaj te 1 zapytanie jeszcze raz, bo teraz pokazuje, że taka kolumna już istnieje.
: 31 lipca 2007, 09:20
autor: piterLGC
chyba cos za duzo usunelem bo mam teraz cos takiego i nie moge wejsc wogule w rangi w panelu admina
Kod: Zaznacz cały
Couldn't obtain ranks data
DEBUG MODE
SQL Error : 1054 Unknown column 'rank_min' in 'order clause'
SELECT * FROM phpbb_ranks ORDER BY rank_min ASC, rank_special ASC
Line : 296
File : admin_ranks.php
: 31 lipca 2007, 10:26
autor: daroPL
Wykonaj zapytanie SQL:
Kod: Zaznacz cały
ALTER TABLE phpbb_ranks ADD `rank_min` MEDIUMINT(8) DEFAULT '0' NOT NULL,
ADD `rank_color` VARCHAR( 255 ) ,
ADD `rank_bold` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_prefix` VARCHAR( 32 ) ,
ADD `rank_style` VARCHAR( 255 ) ,
ADD `rank_list` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_order` INT( 11 ) UNSIGNED NOT NULL ,
ADD `rank_onlygfx` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_titlelist` VARCHAR( 50 ) ,
ADD `rank_female` VARCHAR( 50 ) ,
ADD `rank_ignore_nick` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_ignore_rank` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_show_ekipa` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `rank_group_ekipa` INT( 11 ) UNSIGNED DEFAULT '0' NOT NULL;
: 01 sierpnia 2007, 10:24
autor: piterLGC
wykonalem i nie pomoglo mam ciagle taki blad
Kod: Zaznacz cały
Couldn't obtain ranks data
DEBUG MODE
SQL Error : 1054 Unknown column 'rank_min' in 'order clause'
SELECT * FROM phpbb_ranks ORDER BY rank_min ASC, rank_special ASC
Line : 296
File : admin_ranks.php
: 01 sierpnia 2007, 10:44
autor: daroPL
Kod: Zaznacz cały
ALTER TABLE phpbb_ranks ADD `rank_min` MEDIUMINT(8) DEFAULT '0' NOT NULL;
: 01 sierpnia 2007, 10:51
autor: piterLGC
po wykonaniu bylo cos takiego
Kod: Zaznacz cały
SQL query:
ALTER TABLE phpbb_ranks ADD `rank_min` MEDIUMINT( 8 ) DEFAULT '0' NOT NULL
MySQL said: Documentation
#1060 - Duplicate column name 'rank_min'
a blad jest ciagle
Kod: Zaznacz cały
Couldn't obtain ranks data
DEBUG MODE
SQL Error : 1054 Unknown column 'rank_special' in 'order clause'
SELECT * FROM phpbb_ranks ORDER BY rank_min ASC, rank_special ASC
Line : 296
File : admin_ranks.php
brakuje mi tych tabel chyba
rank_id
rank_title
rank_special
rank_image
: 01 sierpnia 2007, 13:47
autor: daroPL
Kod: Zaznacz cały
ALTER TABLE phpbb_ranks ADD `rank_id` smallint(5) unsigned NOT NULL auto_increment;
Kod: Zaznacz cały
ALTER TABLE phpbb_ranks ADD `rank_title` varchar(50) NOT NULL;
Kod: Zaznacz cały
ALTER TABLE phpbb_ranks ADD `rank_special` tinyint(1) default '0';
Kod: Zaznacz cały
ALTER TABLE phpbb_ranks ADD `rank_image` varchar(255) default NULL;
Każde zapytanie wykonuj osobno!
: 01 sierpnia 2007, 13:56
autor: piterLGC
mam taki blad teraz
Kod: Zaznacz cały
Błąd Ogólny
Could not obtain user/online information
DEBUG MODE
SQL Error : 1054 Unknown column 'r.rank_id' in 'on clause'
SELECT u.username, u.user_id, u.user_rank, u.user_posts, s.session_time, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip, s.session_page, r.rank_order, s.session_start FROM ((phpbb_sessions s LEFT JOIN phpbb_users u ON u.user_id = s.session_user_id) LEFT JOIN phpbb_ranks r ON u.user_rank=r.rank_id) WHERE s.session_time >= 1185972804 ORDER BY u.username ASC, s.session_ip ASC
Line : 531
File : functions_color_rank.php
: 01 sierpnia 2007, 15:43
autor: daroPL
Kod: Zaznacz cały
ALTER TABLE phpbb_ranks ADD `rank_id` smallint(5) unsigned NOT NULL auto_increment;
: 01 sierpnia 2007, 17:12
autor: piterLGC
niestety to nic nie dalo ciagle jest taki blad
Kod: Zaznacz cały
Błąd Ogólny
Could not obtain user/online information
DEBUG MODE
SQL Error : 1054 Unknown column 'r.rank_id' in 'on clause'
SELECT u.username, u.user_id, u.user_rank, u.user_posts, s.session_time, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip, s.session_page, r.rank_order, s.session_start FROM ((phpbb_sessions s LEFT JOIN phpbb_users u ON u.user_id = s.session_user_id) LEFT JOIN phpbb_ranks r ON u.user_rank=r.rank_id) WHERE s.session_time >= 1185984541 ORDER BY u.username ASC, s.session_ip ASC
Line : 540
File : functions_color_rank.php
w panelu admina mam jeszcze takie bledy
Kod: Zaznacz cały
Could not obtain user/online information
DEBUG MODE
SQL Error : 1054 Unknown column 'r.rank_id' in 'on clause'
SELECT u.username, u.user_id, u.user_rank, u.user_posts, s.session_time, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip, s.session_page, r.rank_order, s.session_start FROM ((phpbb_sessions s LEFT JOIN phpbb_users u ON u.user_id = s.session_user_id) LEFT JOIN phpbb_ranks r ON u.user_rank=r.rank_id) WHERE s.session_time >= 1185985495 ORDER BY u.username ASC, s.session_ip ASC
Line : 540
File : functions_color_rank.php
i
Kod: Zaznacz cały
Couldn't update/insert into ranks table
DEBUG MODE
SQL Error : 1054 Unknown column 'rank_color' in 'field list'
INSERT INTO phpbb_ranks (rank_title,rank_special, rank_min, rank_image, rank_color, rank_bold, rank_prefix, rank_style, rank_list, rank_order, rank_onlygfx, rank_titlelist, rank_ignore_nick, rank_ignore_rank,rank_show_ekipa,rank_female,rank_group_ekipa) VALUES ('Administrator', 0, 0, '', '0=|3=|4=|5=|6=', 0, '', '', 0, 0, 0, '', 0, 0,0,'',0)
Line : 518
File : admin_ranks.php
: 01 sierpnia 2007, 20:49
autor: daroPL
Wykonaj zapytania SQL:
Kod: Zaznacz cały
DROP TABLE phpbb_ranks;
CREATE TABLE `phpbb_ranks` (
`rank_id` smallint(5) unsigned NOT NULL auto_increment,
`rank_title` varchar(50) NOT NULL,
`rank_min` mediumint(8) NOT NULL default '0',
`rank_special` tinyint(1) default '0',
`rank_image` varchar(255) default NULL,
`rank_color` varchar(255) default NULL,
`rank_bold` int(2) unsigned NOT NULL default '0',
`rank_prefix` varchar(32) default NULL,
`rank_style` varchar(255) default NULL,
`rank_list` int(2) unsigned NOT NULL default '0',
`rank_order` int(11) unsigned NOT NULL,
`rank_onlygfx` int(2) unsigned NOT NULL default '0',
`rank_titlelist` varchar(50) default NULL,
`rank_female` varchar(50) default NULL,
`rank_ignore_nick` int(2) unsigned NOT NULL default '0',
`rank_ignore_rank` int(2) unsigned NOT NULL default '0',
`rank_show_ekipa` int(2) unsigned NOT NULL default '0',
`rank_group_ekipa` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`rank_id`)
);
: 01 sierpnia 2007, 21:14
autor: piterLGC
wielkie dzieki wszystko juz dziala ok