Ik verwijder ze even, en zet ze opnieuw neer.
Code: Selecteer alles
-- NOTE: Replace phpbb_ with your table prefix
CREATE TABLE `phpbb_fc_codes` (
`codeid` int(6) NOT NULL auto_increment,
`systemid` tinyint(2) NOT NULL default '0',
`gameid` smallint(3) NOT NULL default '0',
`userid` mediumint(8) NOT NULL default '0',
`gamehandle` varchar(20) NOT NULL default '',
`friendcode` varchar(20) NOT NULL default '',
PRIMARY KEY (`codeid`)
);
CREATE TABLE `phpbb_fc_games` (
`gameid` smallint(3) NOT NULL auto_increment,
`systemid` tinyint(2) NOT NULL default '0',
`gamename` varchar(128) NOT NULL default '',
PRIMARY KEY (`gameid`)
);
CREATE TABLE `phpbb_fc_systems` (
`systemid` tinyint(2) NOT NULL auto_increment,
`systemname` varchar(64) NOT NULL default '',
PRIMARY KEY (`systemid`)
);
Dat zijn ze (ik doe ze allemaal tegelijk, wat werkt, want ik krijg 3 tabellen). En weer dezelfde error:
Code: Selecteer alles
Algemene fout
SQL ERROR [ mysqli ]
Column 'gameid' cannot be null [1048]
SQL
INSERT INTO phpbb_fc_codes (systemid, gameid, userid, gamehandle, friendcode) VALUES ('1', NULL, '2', 'Mario kart DS', '1234-5644-5453')
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()
FILE: includes/ucp/ucp_fc.php
LINE: 90
CALL: dbal_mysqli->sql_query()
FILE: includes/functions_module.php
LINE: 471
CALL: ucp_fc->main()
FILE: ucp.php
LINE: 310
CALL: p_master->load_active()
