Color Ranks - Gotowe pliki do phpBB 2.0.22

piterLGC · Post autor: **piterLGC** » 29 lipca 2007, 20:01

wyskoczylo mi cos takiego jak zrobilem zapytanie do sql

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

daroPL · Post autor: **daroPL** » 31 lipca 2007, 06:53

Pokasuj wszystkie kolumny, które tworzyć pierwszym zapytaniem i wykonaj te 1 zapytanie jeszcze raz, bo teraz pokazuje, że taka kolumna już istnieje.

piterLGC · Post autor: **piterLGC** » 31 lipca 2007, 09:20

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

daroPL · Post autor: **daroPL** » 31 lipca 2007, 10:26

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;

piterLGC · Post autor: **piterLGC** » 01 sierpnia 2007, 10:24

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

daroPL · Post autor: **daroPL** » 01 sierpnia 2007, 10:44

Kod: Zaznacz cały

ALTER TABLE phpbb_ranks ADD `rank_min` MEDIUMINT(8) DEFAULT '0' NOT NULL;

piterLGC · Post autor: **piterLGC** » 01 sierpnia 2007, 10:51

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

daroPL · Post autor: **daroPL** » 01 sierpnia 2007, 13:47

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!

piterLGC · Post autor: **piterLGC** » 01 sierpnia 2007, 13:56

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

daroPL · Post autor: **daroPL** » 01 sierpnia 2007, 15:43

Kod: Zaznacz cały

ALTER TABLE phpbb_ranks ADD `rank_id` smallint(5) unsigned NOT NULL auto_increment;

piterLGC · Post autor: **piterLGC** » 01 sierpnia 2007, 17:12

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

daroPL · Post autor: **daroPL** » 01 sierpnia 2007, 20:49

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`)
);

piterLGC · Post autor: **piterLGC** » 01 sierpnia 2007, 21:14

wielkie dzieki wszystko juz dziala ok