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 :
A oto dane zapytanie SQL,które chciałem wstawić .... :
Kod: Zaznacz cały
#
# 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 -->
Trzeba było dodać tak jak napisałeś 