alguem sabe como eu posso remover esse errO?

[waldineywsp]

eu to com problema no meu web site do nada, nao ta dando mais pra resetar no site e ta me dando esse erro na hora de tentar resetar.

CTM-Error #2: Erro ao executar Query : "UPDATE MuOnline.dbo.Character SET

 

 

cLevel=1,Experience=0,Resets=Resets+1,resetsDay=resetsDay+1,resetsWeek=resetsWeek+1,resetsMonth=resetsMonth+1,Money=Money-

 

 

 

 

0,MapNumber=0,MapPosX=125,MapPosY=125 WHERE Name='PointDL' and AccountID='ponto'"

Por favor, Entrar ou Registrar para ver o conteúdo das URLs!

 

[iFreeHP]

Abra seu SQL Manager, na tabela Character

Verifique se existe todas essas colunas:

cLevel

Experience

Resets

resetsDay

resetsWeek

resetsMonth

e Money.

deve estar faltando alguma.. ou alguma delas com o nome diferente.. poste resultados ai.. xD

Abrass

 

[CronusMakerchanel]

algumas nao presisa por serem padrão todas são int 4 defalt value 0

Resets

resetsDay

resetsWeek

resetsMonth

 

[waldineywsp]

ainda  nao consegui resolver alguem tem mais alguma ideia?

 

[abuzado]

cara roda essa query . rode na muonline !

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

/*
//##############################################//
// -> Effect Web                                //
// -> Powered by Erick-Master                   //
// -> CTM TEAM Softwares                        //
// -> www.ctmts.com.br                          //
//##############################################//
*/

USE [MuOnline]
GO

------------- Table: MEMB_INFO -------------
ALTER TABLE dbo.MEMB_INFO ADD Gold int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.MEMB_INFO ADD Cash int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.MEMB_INFO ADD Points int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.MEMB_INFO ADD CTM_Date varchar(50) NULL
GO

ALTER TABLE dbo.MEMB_INFO ADD CTM_Birth varchar(50) NULL
GO

ALTER TABLE dbo.MEMB_INFO ADD CTM_Sex varchar(50) NULL
GO

ALTER TABLE dbo.MEMB_INFO ADD vip int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.MEMB_INFO ADD VIP_Time int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.MEMB_INFO ADD VIP_Begin int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.MEMB_INFO ADD VIP_Integer int NOT NULL DEFAULT 0
GO

------------- Table: Character -------------
ALTER TABLE dbo.Character ADD CTM_Image varchar(50) NULL
GO

ALTER TABLE dbo.Character ADD Resets int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.Character ADD resetsDay int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.Character ADD resetsWeek int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.Character ADD resetsMonth int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.Character ADD MResets int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.Character ADD PkCountWeb int NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.Character ADD HeroCountWeb int NOT NULL DEFAULT 0
GO