SQL/DB Error -- [Unknown column 'wc3_web_skill.skill_type' i

Post by **Geesu** » Mon Jun 02, 2008 11:28 am

post database dump pls

Post by **Geesu** » Tue Jun 03, 2008 8:18 am

delete the table that is messed up (wc3_web_skill) - then change the map - it should be created correctly

Post by **Geesu** » Wed Jun 04, 2008 10:04 am

your data tables aren't populated- SQL dump again pls

Post by **Geesu** » Thu Jun 12, 2008 8:49 am

Delete this table:

--
-- Tabellenstruktur für Tabelle `wc3_web_skill`
--

CREATE TABLE `wc3_web_skill` (
`skill_id` tinyint(4) unsigned NOT NULL default '0',
`skill_lang` char(2) NOT NULL default '',
`skill_name` varchar(100) default NULL,
`skill_description` text NOT NULL,
`skill_type` tinyint(4) unsigned NOT NULL default '0',
`skill_owner` tinyint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`skill_id`,`skill_lang`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `wc3_web_skill`
--

Then start up war3ft - post what errors it throws

Post by **Geesu** » Thu Jun 12, 2008 12:22 pm

no map change - kill server - start server

what is userinfos

Post by **Geesu** » Fri Jun 13, 2008 2:04 pm

and any errors in the wc3 error log file? post it

Post by **Geesu** » Mon Jun 16, 2008 8:38 am

Yes they're auto pulled from the lang file...

So I just realized why - delete the wc3_config table too

along with the web skills - then start it up

Post by **Geesu** » Tue Jun 17, 2008 3:04 pm

heh np - sorry it took me so long - sometimes i forget how I made things haha