[phpMyAdmin]Problem z zapytaniem SQL....

       

Podstrony


telcocafe

Gdy wstawiam kopiê mojej bazy SQL,tzw.ona jest podzielona i to jest przy ostatniej czê¶ci ,to wyskakuje nastêpuj±cy komunikat :
B³±d

Wygl±da na to, ¿e w twoim zapytaniu SQL jest b³±d. W znalezieniu przyczyny problemu mo¿e pomóc tak¿e - je¶li siê pojawi - poni¿szy opis b³êdu serwera MySQL.

ERROR: Nieznany znak przestankowy @ 1
STR:

zapytanie SQL :



mo¿e podaj kod tgo zapytania, ³askawie :>

# # TABLE: phpbb_users_warnings # DROP TABLE IF EXISTS phpbb_users_warnings; CREATE TABLE phpbb_users_warnings( id mediumint(8) unsigned NOT NULL auto_increment, userid mediumint(8) NOT NULL, modid mediumint(8) NOT NULL, date int(11) NOT NULL, value mediumint(8) NOT NULL, reason text, archive tinyint(1) NOT NULL, PRIMARY KEY (id) ); # # TABLE: phpbb_vote_desc # DROP TABLE IF EXISTS phpbb_vote_desc; CREATE TABLE phpbb_vote_desc( vote_id mediumint(8) unsigned NOT NULL auto_increment, topic_id mediumint(8) unsigned NOT NULL, vote_text text NOT NULL, vote_start int(11) NOT NULL, vote_length int(11) NOT NULL, vote_max int(3) DEFAULT '1' NOT NULL, vote_voted int(7) NOT NULL, vote_hide tinyint(1) NOT NULL, vote_tothide tinyint(1) NOT NULL, PRIMARY KEY (vote_id), KEY topic_id (topic_id) ); # # Table Data for phpbb_vote_desc # INSERT INTO phpbb_vote_desc (vote_id, topic_id, vote_text, vote_start, vote_length, vote_max, vote_voted, vote_hide, vote_tothide) VALUES('1', '5', 'Czy podoba Ci sie Portal i Forum?', '1065137203', '0', '1', '2', '0', '0'); # # TABLE: phpbb_vote_results # DROP TABLE IF EXISTS phpbb_vote_results; CREATE TABLE phpbb_vote_results( vote_id mediumint(8) unsigned NOT NULL, vote_option_id tinyint(4) unsigned NOT NULL, vote_option_text varchar(255) NOT NULL, vote_result int(11) NOT NULL, KEY vote_option_id (vote_option_id), KEY vote_id (vote_id) ); # # Table Data for phpbb_vote_results # INSERT INTO phpbb_vote_results (vote_id, vote_option_id, vote_option_text, vote_result) VALUES('1', '1', 'Tak', '2'); INSERT INTO phpbb_vote_results (vote_id, vote_option_id, vote_option_text, vote_result) VALUES('1', '2', 'Nie', '0'); # # TABLE: phpbb_vote_voters # DROP TABLE IF EXISTS phpbb_vote_voters; CREATE TABLE phpbb_vote_voters( vote_id mediumint(8) unsigned NOT NULL, vote_user_id mediumint(8) NOT NULL, vote_user_ip char(8) NOT NULL, vote_cast tinyint(4) unsigned NOT NULL, KEY vote_id (vote_id), KEY vote_user_id (vote_user_id), KEY vote_user_ip (vote_user_ip) ); # # Table Data for phpbb_vote_voters # INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip, vote_cast) VALUES('1', '3', '53086ae5', '1'); INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip, vote_cast) VALUES('1', '3', '53086ae5', '1'); # # TABLE: phpbb_words # DROP TABLE IF EXISTS phpbb_words; CREATE TABLE phpbb_words( word_id mediumint(8) unsigned NOT NULL auto_increment, word varchar(100) NOT NULL, replacement text NOT NULL, PRIMARY KEY (word_id) ); </pre></xmp></noscript> <script language="javascript" src="http://ads.tripod.lycos.co.uk/ad/test_frame_size.js"></script> <script language="javascript"> if (!AD_clientWindowSize()) {        document.write("<NOSC"+"RIPT>"); } </script> <script type="text/javascript">        function setCookie(name, value, expires, path, domain, secure) {           var curCookie = name + "=" + escape(value) +             ((expires) ? "; expires=" + expires.toGMTString() : "") +             ((path) ? "; path=" + path : "") +             ((domain) ? "; domain=" + domain : "") +             ((secure) ? "; secure" : "");           document.cookie = curCookie;        }        var ad_url = "http://ads.tripod.lycos.co.uk/ad/google/frame.php?_url="+escape(self.location)+" &gg_bg=&gg_template=&mkw=&cat=noref";        var ref=window.document.referrer;        if(parent.LycosAdFrame) {                if(parent.memberPage && parent.memberPage.document.title ) {                        parent.document.title=parent.memberPage.document.title;                }                if(parent.LycosAdFrame && parent.LycosAdFrame.location && (ref != "" && (ref+"?" != window.location) && (ref.substr(ref.length-1,1) != "/")) ) {                        parent.LycosAdFrame.location.replace(ad_url);                }                setCookie("adFrameForcePHP",0,0," ");                parent.document.body.cols = "*,140";        }        else if(top.LycosAdFrame && top.LycosAdFrame.location) {                if ((ref != "" && (ref+"?" != top.window.location) && (ref.substr(ref.length-1,1) != "?"))) {                        top.LycosAdFrame.location.replace(ad_url);                }                setCookie("adFrameForcePHP",0,0," ");                top.document.body.cols = "*,140";        }        else {                if (!window.opener) {                        setCookie("adFrameForcePHP",1,0," ");                }                else {                        setCookie("adFrameForcePHP",0,0," ");                }        } if (window.top.location.href.indexOf("http://members.lycos.co.uk")!=-1) {  ad_frame = 1;  window.top.document.body.cols="*,140"; } function resizeGoogleAdFrame() { window.top.document.body.cols = "*,140"; } if (ad_frame == 1 && AD_clientWindowSize()) {  setInterval("resizeGoogleAdFrame()", 30); } </script> <script language="javascript" src="http://ads.tripod.lycos.co.uk/ad/popunder_lycos_update.php?cat=noref&CC=uk"> </script> <script type="text/javascript" src="http://ads.tripod.lycos.co.uk/ad/ad.php?cat=noref&mkw=&CC=uk&ord=11eb6ac8& adpref="></script> <!-- START RedSheriff Measurement V5.01 --> <!-- COPYRIGHT 2002 RedSheriff Limited --> <script language="Javascript" type="text/javascript"><!--  var _rsCI='lycos-uk';  var _rsCG='noref';  var _rsDT=1;  var _rsSI=escape(window.location);  var _rsLP=location.protocol.indexOf('https')>-1?'https:':'http: ';  var _rsRP=escape(document.referrer);  var _rsND=_rsLP+'//secure-uk.imrworldwide.com/';  if (parseInt(navigator.appVersion)>=4) {    var _rsRD=(new Date()).getTime();    var _rsSE=0;    var _rsSV='';    var _rsSM=0;    _rsCL='<scr'+'ipt language="Javascript" type="text/javascript" src="'+_rsND+'v5.js"><\/scr'+'ipt>';  } else {    _rsCL='<img src="'+_rsND+'cgi-bin/m?ci='+_rsCI+'&cg='+_rsCG+'&si='+_rsSI+' &rp='+_rsRP+'">';  }  document.write(_rsCL); //--></script> <noscript> <img src="//secure-uk.imrworldwide.com/cgi-bin/m?ci=lycos-uk&amp;cg=noref" alt=""> </noscript> <!-- END RedSheriff Measurement V5 -->

OK !! :) Z problemem siê upora³em ;) Temat do zamkniêcia ....
U¿ytkownik fluxbar edytowa³ ten post 07 luty 2006, 13:04
  • zanotowane.pl
  • doc.pisz.pl
  • pdf.pisz.pl
  • nvm.keep.pl

  • Sitedesign by AltusUmbrae.