Lyhne1
Lurker
Joined: 05 Jul 2008
Posts: 232
Location: In your Mom
|
 Posted: Dec 16, 2009 10:11am Post subject: MySQL error |
 |
|
Hello overone,
Getting a error  Well any who I was mod out the country flags from .png to .gif Nicer looking flags ect....I used my editor to make the changes (replace all ) option...save file and reuploaded it and get this error any help would be great.
Thanks!
| Code: | 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 */;
--
-- Database: `XXXXXXXXXXX`
--
-- --------------------------------------------------------
--
-- Table structure for table `xbtit_countries`
--
CREATE TABLE `xbtit_countries` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`flagpic` varchar(50) default NULL,
`domain` char(3) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=245 ;
--
-- Dumping data for table `xbtit_countries`
--
INSERT INTO `xbtit_countries` (`Rows`, `flagpic`) VALUES
(1, 'ad.gif'),
(1, 'ae.gif'),
(1, 'af.gif'),
(1, 'ag.gif'),
(1, 'ai.gif'),
(1, 'al.gif'),
(1, 'am.gif'),
(1, 'an.gif'),
(1, 'ao.gif'),
(1, 'aq.gif'),
(1, 'ar.gif'),
(1, 'as.gif'),
(1, 'at.gif'),
(1, 'au.gif'),
(1, 'aw.gif'),
(1, 'ax.gif'),
(1, 'az.gif'),
(1, 'ba.gif'),
(1, 'bb.gif'),
(1, 'bd.gif'),
(1, 'be.gif'),
(1, 'bf.gif'),
(1, 'bg.gif'),
(1, 'bh.gif'),
(1, 'bi.gif'),
(1, 'bj.gif'),
(1, 'bm.gif'),
(1, 'bn.gif'),
(1, 'bo.gif'),
(1, 'br.gif'),
(1, 'bs.gif'),
(1, 'bt.gif'),
(1, 'bv.gif'),
(1, 'bw.gif'),
(1, 'by.gif'),
(1, 'bz.gif'),
(1, 'ca.gif'),
(1, 'cc.gif'),
(1, 'cd.gif'),
(1, 'cf.gif'),
(1, 'cg.gif'),
(1, 'ch.gif'),
(1, 'ci.gif'),
(1, 'ck.gif'),
(1, 'cl.gif'),
(1, 'cm.gif'),
(1, 'cn.gif'),
(1, 'co.gif'),
(1, 'cr.gif'),
(1, 'cs.gif'),
(1, 'cu.gif'),
(1, 'cv.gif'),
(1, 'cx.gif'),
(1, 'cy.gif'),
(1, 'cz.gif'),
(1, 'de.gif'),
(1, 'dj.gif'),
(1, 'dk.gif'),
(1, 'dm.gif'),
(1, 'do.gif'),
(1, 'dz.gif'),
(1, 'ec.gif'),
(1, 'ee.gif'),
(1, 'eg.gif'),
(1, 'eh.gif'),
(1, 'er.gif'),
(1, 'es.gif'),
(1, 'et.gif'),
(1, 'fi.gif'),
(1, 'fj.gif'),
(1, 'fk.gif'),
(1, 'fm.gif'),
(1, 'fo.gif'),
(1, 'fr.gif'),
(1, 'ga.gif'),
(1, 'gb.gif'),
(1, 'gd.gif'),
(1, 'ge.gif'),
(1, 'gf.gif'),
(1, 'gg.gif'),
(1, 'gh.gif'),
(1, 'gi.gif'),
(1, 'gl.gif'),
(1, 'gm.gif'),
(1, 'gn.gif'),
(1, 'gp.gif'),
(1, 'gq.gif'),
(1, 'gr.gif'),
(1, 'gs.gif'),
(1, 'gt.gif'),
(1, 'gu.gif'),
(1, 'gw.gif'),
(1, 'gy.gif'),
(1, 'hk.gif'),
(1, 'hm.gif'),
(1, 'hn.gif'),
(1, 'hr.gif'),
(1, 'ht.gif'),
(1, 'hu.gif'),
(1, 'id.gif'),
(1, 'ie.gif'),
(1, 'il.gif'),
(1, 'im.gif'),
(1, 'in.gif'),
(1, 'io.gif'),
(1, 'iq.gif'),
(1, 'ir.gif'),
(1, 'is.gif'),
(1, 'it.gif'),
(1, 'je.gif'),
(1, 'jm.gif'),
(1, 'jo.gif'),
(1, 'jp.gif'),
(1, 'ke.gif'),
(1, 'kg.gif'),
(1, 'kh.gif'),
(1, 'ki.gif'),
(1, 'km.gif'),
(1, 'kn.gif'),
(1, 'kp.gif'),
(1, 'kr.gif'),
(1, 'kw.gif'),
(1, 'ky.gif'),
(1, 'kz.gif'),
(1, 'la.gif'),
(1, 'lb.gif'),
(1, 'lc.gif'),
(1, 'li.gif'),
(1, 'lk.gif'),
(1, 'lr.gif'),
(1, 'ls.gif'),
(1, 'lt.gif'),
(1, 'lu.gif'),
(1, 'lv.gif'),
(1, 'ly.gif'),
(1, 'ma.gif'),
(1, 'mc.gif'),
(1, 'md.gif'),
(1, 'mg.gif'),
(1, 'mh.gif'),
(1, 'mk.gif'),
(1, 'ml.gif'),
(1, 'mm.gif'),
(1, 'mn.gif'),
(1, 'mo.gif'),
(1, 'mp.gif'),
(1, 'mq.gif'),
(1, 'mr.gif'),
(1, 'ms.gif'),
(1, 'mt.gif'),
(1, 'mu.gif'),
(1, 'mv.gif'),
(1, 'mw.gif'),
(1, 'mx.gif'),
(1, 'my.gif'),
(1, 'mz.gif'),
(1, 'na.gif'),
(1, 'nc.gif'),
(1, 'ne.gif'),
(1, 'nf.gif'),
(1, 'ng.gif'),
(1, 'ni.gif'),
(1, 'nl.gif'),
(1, 'no.gif'),
(1, 'np.gif'),
(1, 'nr.gif'),
(1, 'nu.gif'),
(1, 'nz.gif'),
(1, 'om.gif'),
(1, 'org.gif'),
(1, 'pa.gif'),
(1, 'pe.gif'),
(1, 'pf.gif'),
(1, 'pg.gif'),
(1, 'ph.gif'),
(1, 'pk.gif'),
(1, 'pl.gif'),
(1, 'pm.gif'),
(1, 'pn.gif'),
(1, 'pr.gif'),
(1, 'ps.gif'),
(1, 'pt.gif'),
(1, 'pw.gif'),
(1, 'py.gif'),
(1, 'qa.gif'),
(1, 're.gif'),
(1, 'ro.gif'),
(1, 'ru.gif'),
(1, 'rw.gif'),
(1, 'sa.gif'),
(1, 'sb.gif'),
(1, 'sc.gif'),
(1, 'sd.gif'),
(1, 'se.gif'),
(1, 'sg.gif'),
(1, 'sh.gif'),
(1, 'si.gif'),
(1, 'sj.gif'),
(1, 'sk.gif'),
(1, 'sl.gif'),
(1, 'sm.gif'),
(1, 'sn.gif'),
(1, 'so.gif'),
(1, 'sr.gif'),
(1, 'st.gif'),
(1, 'sv.gif'),
(1, 'sy.gif'),
(1, 'sz.gif'),
(1, 'tc.gif'),
(1, 'td.gif'),
(1, 'tf.gif'),
(1, 'tg.gif'),
(1, 'th.gif'),
(1, 'tj.gif'),
(1, 'tk.gif'),
(1, 'tl.gif'),
(1, 'tm.gif'),
(1, 'tn.gif'),
(1, 'to.gif'),
(1, 'tr.gif'),
(1, 'tt.gif'),
(1, 'tv.gif'),
(1, 'tw.gif'),
(1, 'tz.gif'),
(1, 'ua.gif'),
(1, 'ug.gif'),
(1, 'um.gif'),
(1, 'unknown.gif'),
(1, 'us.gif'),
(1, 'uy.gif'),
(1, 'uz.gif'),
(1, 'va.gif'),
(1, 'vc.gif'),
(1, 've.gif'),
(1, 'vg.gif'),
(1, 'vn.gif'),
(1, 'vu.gif'),
(1, 'wf.gif'),
(1, 'ws.gif'),
(1, 'ye.gif'),
(1, 'yt.gif'),
(1, 'za.gif'),
(1, 'zm.gif'),
(1, 'zw.gif'); |
Error
SQL query:
-- -- Dumping data for table `xbtit_countries` -- INSERT INTO `xbtit_countries` (`Rows`, `flagpic`) VALUES (1, 'ad.gif'), (1, 'ae.gif'), (1, 'af.gif'), (1, 'ag.gif'), (1, 'ai.gif'), (1, 'al.gif'), (1, 'am.gif'), (1, 'an.gif'), (1, 'ao.gif'), (1, 'aq.gif'), (1, 'ar.gif'), (1, 'as.gif'), (1, 'at.gif'), (1, 'au.gif'), (1, 'aw.gif'), (1, 'ax.gif'), (1, 'az.gif'), (1, 'ba.gif'), (1, 'bb.gif'), (1, 'bd.gif'), (1, 'be.gif'), (1, 'bf.gif'), (1, 'bg.gif'), (1, 'bh.gif'), (1, 'bi.gif'), (1, 'bj.gif'), (1, 'bm.gif'), (1, 'bn.gif'), (1, 'bo.gif'), (1, 'br.gif'), (1, 'bs.gif'), (1, 'bt.gif'), (1, 'bv.gif'), (1, 'bw.gif'), (1, 'by.gif'), (1, 'bz.gif'), (1, 'ca.gif'), (1, 'cc.gif'), (1, 'cd.gif'), (1, 'cf.gif'), (1, 'cg.gif'), (1, 'ch.gif'), (1, 'ci.gif'), (1, 'ck.gif'), (1, 'cl.gif'), (1, 'cm.gif'), (1, 'cn.gif'), (1, 'co.gif'), (1, 'cr.gif'), (1, 'cs.gif'), (1, 'cu.gif'), (1, 'cv.gif'), (1, 'cx.gif'), (1, 'cy.gif'), (1, 'cz.gif'), (1, 'de.gif'), (1, 'dj.gif'), (1, 'dk.gif'), (1, 'dm.gif'), (1, '[...]
MySQL said: Documentation
#1054 - Unknown column 'Rows' in 'field list' |
|
Register
Log in
