Podstrony
|
telcocafeGdy 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&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 |
|||
Sitedesign by AltusUmbrae. |