Power Pixel Fórum - O melhor conteúdo você encontra aqui!
Redes Sociais:

Você não está conectado. Conecte-se ou registre-se

[TUTO] Resolver erro no registro mercury

Mensagem - Página 2 de 2

1 [TUTO] Resolver erro no registro mercury em Sex 12 Set 2014 - 19:02

Membro Ouro

Relembrando a primeira mensagem :

Bom, muitos usuários estão/estavam com esse problema, inclusive eu!
Vendo que nosso amigo xjoao não nos ajudava, eu mesmo corri atrás de resolver esse erro!
o erro é o seguinte: Unknown column 'password' in 'field list'.
Vamos lá:
1° Vá até sua db e apague a tabela user
2° vá em SQL no menu da db e execute o seguinte código:
Código:
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 04-09-2014 a las 17:00:19
-- Versión del servidor: 5.1.41
-- Versión de PHP: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de datos: `xdd`
--

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

--
-- Estructura de tabla para la tabla `users`
--

CREATE tab[b][/b]le IF NOT EXISTS `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `real_name` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(164) NOT NULL,
  `mail` varchar(50) NOT NULL DEFAULT 'defaultuser@meth0d.org',
  `auth_ticket` varchar(500) NOT NULL,
  `rank` int(11) unsigned NOT NULL DEFAULT '1',
  `credits` int(50) NOT NULL DEFAULT '50000',
  `vip_points` int(11) NOT NULL DEFAULT '0',
  `activity_points` int(11) NOT NULL DEFAULT '0',
  `activity_points_lastupdate` double NOT NULL DEFAULT '0',
  `look` varchar(250) NOT NULL,
  `gender` enum('M','F') NOT NULL DEFAULT 'M',
  `motto` varchar(50) NOT NULL,
  `last_online` int(11) NOT NULL DEFAULT '0',
  `account_created` varchar(255) NOT NULL,
  `online` enum('0','1') NOT NULL DEFAULT '0',
  `ip_last` varchar(120) NOT NULL,
  `ip_reg` varchar(120) NOT NULL,
  `home_room` int(10) unsigned NOT NULL DEFAULT '0',
  `respect` int(11) NOT NULL DEFAULT '0',
  `daily_respect_points` int(11) NOT NULL DEFAULT '3',
  `daily_pet_respect_points` int(11) NOT NULL DEFAULT '3',
  `newbie_status` int(11) NOT NULL DEFAULT '0',
  `is_muted` enum('0','1') NOT NULL DEFAULT '0',
  `mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
  `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
  `block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
  `hide_online` enum('0','1') NOT NULL DEFAULT '0',
  `hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
  `mail_verified` varchar(6) NOT NULL DEFAULT '0',
  `vip` enum('0','1') NOT NULL,
  `birth` varchar(100) NOT NULL DEFAULT '',
  `browser` text NOT NULL,
  `web_online` varchar(100) NOT NULL DEFAULT '',
  `rpx_name` varchar(100) NOT NULL DEFAULT '',
  `rpxid` varchar(200) NOT NULL,
  `rpx_type` varchar(100) NOT NULL,
  `postcount` bigint(20) NOT NULL DEFAULT '0',
  `token` varchar(20) NOT NULL DEFAULT '',
  `client_token` varchar(50) NOT NULL DEFAULT '',
  `newsletter` enum('0','1') NOT NULL DEFAULT '1',
  `predermited` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  `account_creates` int(20) NOT NULL DEFAULT '0',
  `suspend` enum('0','1') NOT NULL DEFAULT '0',
  `referid` int(120) NOT NULL DEFAULT '0',
  `RememberMeToken` text NOT NULL,
  `AddonData` text NOT NULL,
  `homeBg` varchar(120) NOT NULL DEFAULT 'b_bg_pattern_abstra ct2',
  `visibility` enum('NOBODY','EVERYONE') NOT NULL DEFAULT 'EVERYONE',
  `AccountID` text NOT NULL,
  `AccountIdentifier` text NOT NULL,
  `AccountName` varchar(255) NOT NULL DEFAULT '',
  `AccountUserName` varchar(255) NOT NULL DEFAULT '',
  `AccountPhoto` text NOT NULL,
  `lastdailycredits` char(18) NOT NULL DEFAULT '',
  `achievement_points` int(12) NOT NULL DEFAULT '0',
  `quests` varchar(200) NOT NULL DEFAULT '',
  `queststates` varchar(200) NOT NULL DEFAULT '',
  `canchangename` enum('0','1') NOT NULL DEFAULT '1',
  `passed_quiz` enum('0','1') NOT NULL DEFAULT '0',
  `FavoriteGroup` int(12) NOT NULL DEFAULT '0',
  `points_online` int(12) NOT NULL DEFAULT '0',
  `ReceptionPased` enum('0','1') NOT NULL DEFAULT '0',
  `namechanges` int(3) NOT NULL DEFAULT '0',
  `currentquestid` int(11) NOT NULL DEFAULT '0',
  `currentquestprogress` int(11) NOT NULL DEFAULT '0',
  `vinculId` int(255) NOT NULL DEFAULT '0',
  `securityTokens` varchar(255) NOT NULL DEFAULT '',
  `working` varchar(50) NOT NULL DEFAULT 'Ninguna',
  `secretcode` varchar(8) NOT NULL DEFAULT '0',
  `mymusik` varchar(100) NOT NULL DEFAULT '0',
  `getmoney_date` varchar(20) NOT NULL DEFAULT '0',
  `volume` varchar(12) NOT NULL DEFAULT '100,100,100',
  `dolares` int(11) NOT NULL DEFAULT '0',
  `powers` int(11) NOT NULL DEFAULT '0',
  `codice` text NOT NULL,
  `client_volume` varchar(255) NOT NULL DEFAULT '100,100,100',
  `last_login` int(11) NOT NULL DEFAULT '0',
  `accept_trading` enum('0','1') NOT NULL DEFAULT '1',
  `whisper_enabled` enum('0','1') NOT NULL DEFAULT '1',
  `is_guide` enum('0','1') NOT NULL DEFAULT '1',
  `last_change` int(20) NOT NULL DEFAULT '0',
  `key_colour` int(11) NOT NULL DEFAULT '0',
  `position` varchar(30) NOT NULL DEFAULT '0',
  `acc_pornbanned` enum('0','1') NOT NULL DEFAULT '0',
  `acc_flagged` enum('0','1') NOT NULL DEFAULT '0',
  `points` int(11) NOT NULL DEFAULT '0',
  `seckey` varchar(999) DEFAULT NULL,
  `belcredits` int(11) NOT NULL,
  `login` varchar(80) NOT NULL,
  `elapsedtime` varchar(20) NOT NULL,
  `block_trade` enum('0','1') NOT NULL DEFAULT '0',
  `staffpicks` int(11) NOT NULL,
  `equipo` enum('0','1') NOT NULL DEFAULT '1' COMMENT 'Diurno = 1, Nocturno = 0',
  `rangoguia` int(11) NOT NULL DEFAULT '0',
  `tarea` varchar(255) NOT NULL,
  `visible` enum('0','1') NOT NULL DEFAULT '1',
  `loyalty_points` int(11) NOT NULL DEFAULT '0',
  `mysterybox_key_colour` int(11) NOT NULL DEFAULT '0',
  `last_name_change` int(11) NOT NULL DEFAULT '0',
  `talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
  `trade_lock` enum('0','1') CHARACTER SET utf8 NOT NULL DEFAULT '0',
  `trade_lock_expire` int(11) NOT NULL DEFAULT '0',
  `vip_expire` timestamp NOT NULL DEFAULT '2014-05-13 23:59:36' ON UPDATE CURRENT_TIMESTAMP,
  `seasonal_currency` int(11) NOT NULL DEFAULT '0',
  `rares` int(15) NOT NULL,
  `nux_passed` enum('0','1') NOT NULL DEFAULT '0',
  `ltd` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `auth_ticket` (`auth_ticket`),
  KEY `online` (`online`),
  KEY `rank` (`rank`),
  KEY `ip_last` (`ip_last`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6731 ;

--
-- Volcar la base de datos para la tabla `users`
--

INSERT INTO `users` (`id`, `username`, `real_name`, `password`, `mail`, `auth_ticket`, `rank`, `credits`, `vip_points`, `activity_points`, `activity_points_lastupdate`, `look`, `gender`, `motto`, `last_online`, `account_created`, `online`, `ip_last`, `ip_reg`, `home_room`, `respect`, `daily_respect_points`, `daily_pet_respect_points`, `newbie_status`, `is_muted`, `mutant_penalty`, `mutant_penalty_expire`, `block_newfriends`, `hide_online`, `hide_inroom`, `mail_verified`, `vip`, `birth`, `browser`, `web_online`, `rpx_name`, `rpxid`, `rpx_type`, `postcount`, `token`, `client_token`, `newsletter`, `predermited`, `account_creates`, `suspend`, `referid`, `RememberMeToken`, `AddonData`, `homeBg`, `visibility`, `AccountID`, `AccountIdentifier`, `AccountName`, `AccountUserName`, `AccountPhoto`, `lastdailycredits`, `achievement_points`, `quests`, `queststates`, `canchangename`, `passed_quiz`, `FavoriteGroup`, `points_online`, `ReceptionPased`, `namechanges`, `currentquestid`, `currentquestprogress`, `vinculId`, `securityTokens`, `working`, `secretcode`, `mymusik`, `getmoney_date`, `volume`, `dolares`, `powers`, `codice`, `client_volume`, `last_login`, `accept_trading`, `whisper_enabled`, `is_guide`, `last_change`, `key_colour`, `position`, `acc_pornbanned`, `acc_flagged`, `points`, `seckey`, `belcredits`, `login`, `elapsedtime`, `block_trade`, `staffpicks`, `equipo`, `rangoguia`, `tarea`, `visible`, `loyalty_points`, `mysterybox_key_colour`, `last_name_change`, `talent_status`, `trade_lock`, `trade_lock_expire`, `vip_expire`, `seasonal_currency`, `rares`, `nux_passed`, `ltd`) VALUES
(6730, 'alberto', 'Kira Hotel', '17baad0c797eeaa8483 289d7bfb5b19f', 'alberto@hotmail.com', 'ST-058425-65476867383513485657-habbore-beta-fe0', 9, 79975, 0, 1000, 0, 'hr-3043-1344.hd-3102-7.ch-3015-107.lg-3078-110.he-1604-62.wa-2003-62.ha-3130-107-110.ca-1807-62.cc-3002-110.sh-3035-107', 'M', '', 1409832427, '1409813861', '1', '192.168.0.194', '192.168.0.194', 0, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', '', '', '', '', '', '', 0, '', '', '1', 'Yes', 0, '0', 0, '', '', 'b_bg_pattern_abstra ct2', 'EVERYONE', '', '', '', '', '', '', 0, '', '', '1', '0', 0, 0, '0', 0, 0, 0, 0, '', 'Ninguna', '0', '0', '0', '100,100,100', 0, 0, '', '100,100,100', 0, '1', '1', '1', 0, 0, '0', '0', '0', 0, NULL, 0, '', '', '0', 0, '1', 0, '', '1', 0, 0, 0, 'citizenship', '0', 0, '2014-09-04 14:28:23', 9, 0, '0', '0');

/*!40101 SET CHARACTER_SET_CLIEN T=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESUL TS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTIO N=@OLD_COLLATION_CONNECTION */;
4° Execute e seja feliz!
______
Créditos:
Settings [PPF] | Postar aqui na ppf
alberto37 [KM] | Postar no km (fórum espanhol)
______
bjs


Não funcionou

Membro

Dá para resper meu tópico lá? To presand dejuda, aaff.

Mensagem - Página 2 de 2

Ir à página : Anterior  1, 2

Tópicos similares

Permissão deste fórum:
Você não pode responder aos tópicos neste fórum