lỗi web NBB 3.0

[Learning]

Lỗi Query: INSERT INTO VI_CURR_INFO (ends_days,chek_code,used_time,memb___id,memb_name ,memb_guid,sno__numb,Bill_Section,Bill_value,Bill_ Hour,Surplus_Point,Surplus_Minute,Increase_Days ) VALUES ('2007','1',1234,'proanlon','',1,'7','6','3','6',' 6','2007-2-27 10:36:00','0' )

ai biết giúp cái

[Domino9990]

chưa chạy query rồi..................

[Learning]

bạn cho mình querty được không...

[Domino9990]

bạn cho mình querty được không...

mình không có quêry nbb 3.0..........

[Learning]

ai biết giúp mình cái .

[sontran901]

Data + Query NBB 3.0
Bạn tải tại đây: [Only registered and activated users can see links. ]
Sau khi Add DB vào bạn chạy Query sau:

CREATE TABLE [CardPhone] (
    [stt] [int] IDENTITY (1, 1) NOT NULL ,
    [acc] [varchar] (20) NULL ,
    [Name] [varchar] (10) NULL ,
    [menhgia] [int] NULL ,
    [card_type] [varchar] (20) NULL ,
    [card_num] [varchar] (20) NULL ,
    [card_serial] [varchar] (20) NULL ,
    [ngay] [smalldatetime] NULL ,
    [status] [tinyint] NULL ,
    [addvpoint] [varchar] (20) NULL ,
    [timenap] [int] NULL,
    [timeduyet] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [DoanhThu] (
    [id] [int] IDENTITY (1, 1) NOT NULL ,
    [year] [int] NOT NULL DEFAULT (2008),
    [month] [int] NOT NULL DEFAULT (1),
    [money] [int] NOT NULL DEFAULT (0),
    [card_type] [varchar] (20) NULL
) ON [PRIMARY]
GO


CREATE TABLE [TopMonth] (
    [id] [int] IDENTITY (1, 1) NOT NULL ,
    [stt] [int] NOT NULL DEFAULT (0) ,
    [acc] [varchar] (20) NULL ,
    [Name] [varchar] (10) NULL ,
    [resets] [int] NOT NULL DEFAULT (0),
    [Month] [int] NOT NULL DEFAULT (0) ,
    [Year] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [Check_Action] (
    [id] [int] IDENTITY (1, 1) NOT NULL ,
    [action] [varchar] (20) NULL ,
    [time] [int] NOT NULL DEFAULT (0),
    [status] [tinyint] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO
INSERT INTO Check_Action (action) VALUES ('ResetInDay')
INSERT INTO Check_Action (action) VALUES ('ResetInMonth')
INSERT INTO Check_Action (action) VALUES ('Top10RS')

CREATE TABLE [SMS] (
    [acc] [varchar] (20) NOT NULL ,
    [KeyXuLy] [varchar] (20) NOT NULL ,
    [time] [int] NOT NULL DEFAULT (0) ,
    [status] [tinyint] NOT NULL DEFAULT (0),
    [Code] [int] NOT NULL DEFAULT (0),
    [dulieu1] [varchar] (50) NULL ,
) ON [PRIMARY]
GO

CREATE TABLE [PassRan] (
    [acc] [varchar] (10) NULL ,
    [pass] [varchar] (10) NULL,
    [pass_md5] [varchar] (50) NULL
) ON [PRIMARY]
GO

alter table MEMB_INFO add bank bigint NOT NULL default 0;
alter table MEMB_INFO add vpoint bigint NOT NULL default 0
alter table MEMB_INFO add gcoin bigint NOT NULL default 0
alter table MEMB_INFO add memb__pwd2 char(10)
alter table MEMB_INFO add memb__pwdmd5 char(50)
alter table MEMB_INFO add pass2 char(10)
alter table MEMB_INFO add jewel_chao int not null default 0
alter table MEMB_INFO add jewel_cre int not null default 0
alter table MEMB_INFO add jewel_blue int not null default 0
alter table MEMB_INFO add passran tinyint not null default 0
alter table MEMB_INFO add checklogin varchar(50) null
alter table MEMB_INFO add time_checksms int not null default 0
alter table MEMB_INFO add checksms_status tinyint not null default 0
alter table MEMB_INFO add admin_block tinyint not null default 0

alter table Character add Resets int not null default 0
alter table Character add ResetVIP int not null default 0
alter table Character add Resets_Time int not null default 0
alter table Character add NoResetInDay int not null default 0
alter table Character add NoResetInMonth int not null default 0
alter table Character add Relifes int not null default 0
alter table Character add khoado tinyint not null default 0
alter table Character add makhoado varchar(50)
alter table Character add pointdutru int not null default 0 

Chúc bạn thành công!

[Learning]

chạy sao nó lỗi này vậy bạn

CREATE TABLE [CardPhone] (
[stt] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[Name] [varchar] (10) NULL ,
[menhgia] [int] NULL ,
[card_type] [varchar] (20) NULL ,
[card_num] [varchar] (20) NULL ,
[card_serial] [varchar] (20) NULL ,
[ngay] [smalldatetime] NULL ,
[status] [tinyint] NULL ,
[addvpoint] [varchar] (20) NULL ,
[timenap] [int] NULL,
[timeduyet] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [DoanhThu] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[year] [int] NOT NULL DEFAULT (2008),
[month] [int] NOT NULL DEFAULT (1),
[money] [int] NOT NULL DEFAULT (0),
[card_type] [varchar] (20) NULL
) ON [PRIMARY]
GO


CREATE TABLE [TopMonth] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[stt] [int] NOT NULL DEFAULT (0) ,
[acc] [varchar] (20) NULL ,
[Name] [varchar] (10) NULL ,
[resets] [int] NOT NULL DEFAULT (0),
[Month] [int] NOT NULL DEFAULT (0) ,
[Year] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [Check_Action] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[action] [varchar] (20) NULL ,
[time] [int] NOT NULL DEFAULT (0),
[status] [tinyint] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO
INSERT INTO Check_Action (action) VALUES ('ResetInDay')
INSERT INTO Check_Action (action) VALUES ('ResetInMonth')
INSERT INTO Check_Action (action) VALUES ('Top10RS')

CREATE TABLE [SMS] (
[acc] [varchar] (20) NOT NULL ,
[KeyXuLy] [varchar] (20) NOT NULL ,
[time] [int] NOT NULL DEFAULT (0) ,
[status] [tinyint] NOT NULL DEFAULT (0),
[Code] [int] NOT NULL DEFAULT (0),
[dulieu1] [varchar] (50) NULL ,
) ON [PRIMARY]
GO

CREATE TABLE [PassRan] (
[acc] [varchar] (10) NULL ,
[pass] [varchar] (10) NULL,
[pass_md5] [varchar] (50) NULL
) ON [PRIMARY]
GO

alter table MEMB_INFO add bank bigint NOT NULL default 0;
alter table MEMB_INFO add vpoint bigint NOT NULL default 0
alter table MEMB_INFO add gcoin bigint NOT NULL default 0
alter table MEMB_INFO add memb__pwd2 char(10)
alter table MEMB_INFO add memb__pwdmd5 char(50)
alter table MEMB_INFO add pass2 char(10)
alter table MEMB_INFO add jewel_chao int not null default 0
alter table MEMB_INFO add jewel_cre int not null default 0
alter table MEMB_INFO add jewel_blue int not null default 0
alter table MEMB_INFO add passran tinyint not null default 0
alter table MEMB_INFO add checklogin varchar(50) null
alter table MEMB_INFO add time_checksms int not null default 0
alter table MEMB_INFO add checksms_status tinyint not null default 0
alter table MEMB_INFO add admin_block tinyint not null default 0

alter table Character add Resets int not null default 0
alter table Character add ResetVIP int not null default 0
alter table Character add Resets_Time int not null default 0
alter table Character add NoResetInDay int not null default 0
alter table Character add NoResetInMonth int not null default 0
alter table Character add Relifes int not null default 0
alter table Character add khoado tinyint not null default 0
alter table Character add makhoado varchar(50)
alter table Character add pointdutru int not null default 0

[Domino9990]

bạn chạy từng cái query xem............

[sontran901]

nếu vẫn ko đc pm YM: [Only registered and activated users can see links. ]
mình sẽ giúp