이 에러 해결방법 부탁드립니다.
게시물 리스트에서 체크박스 선책후 삭제 누르면
select * from where wr_id = '11'
1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where wr_id = '11'' at line 1
error file : /gnuboard4/bbs/delete_all.php
이와 같은 에러가 나옵니다.
어떻게 해결 해야 되나요?
select * from where wr_id = '11'
1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where wr_id = '11'' at line 1
error file : /gnuboard4/bbs/delete_all.php
이와 같은 에러가 나옵니다.
어떻게 해결 해야 되나요?
|
댓글을 작성하시려면 로그인이 필요합니다.
로그인
댓글 6개
from 다음에 들어가는 변수를 체크해 보심이...
$write_table 변수가 들어 갈텐데 그 값이 넘어오지 않는거겠죠
첫 부분에서 $write_table 값을 출력해 보세요
제가 초짜라 감이 안잡혀요 ㅠㅠ
delete_all.php 20번 행에
echo "$write_table ////테스트행";
exit;
이렇게 넣어서 테이블명이 출력 되는지 보세요
안된다면 정말 이상한 문제이기도 한데...
////테스트행 이부분 지우고 등록하니 아무것도 안나옵니다 ㅠㅠ
$list.skin.php 에서부터 무언가 잘못된 것 같군요...무슨 잘못이 있는지는 귀신도 모릅니다
이번에는 3번행에 echo....저걸 넣어 보세요
////테스트행 이부분 지우고 등록하니 아무것도 안나옵니다 ㅠㅠ <--당연하지요 그 밑에 exit; 를 넣었으니
그 아래 부분은 없는 것과 같습니다
<?
if (!defined("_GNUBOARD_")) exit; // ?? ??? ?? ??
$img_width = "300";
$img_height = "80";
$img_quality = "95";
if (!function_exists("imagecopyresampled")) alert("GD 2.0.1 ?? ??? ???? ??? ??? ? ?? ??? ??? ???.");
$data_path = $g4[path]."/data/file/$bo_table";
$thumb_path = $data_path.'/thumb';
@mkdir($thumb_path, 0707);
@chmod($thumb_path, 0707);
if (!$skin_no) $skin_no = "01";
?>
<!-- ??? ?? ?? -->
<table width="<?=$width?>" align=center cellpadding=0 cellspacing=0><tr><td>
<!-- ?? ??? ??, ??? ??, ????? ?? -->
<table width="100%" cellspacing="0" cellpadding="0">
<tr height="25">
<? if ($is_category) { ?><form name="fcategory" method="get"><td width="50%"><select name=sca onchange="location='<?=$category_location?>'+this.value;"><option value=''>??</option><?=$category_option?></select></td></form><? } ?>
<td align="right">
??? <?=number_format($total_count)?>?
<? if ($rss_href) { ?><a href='<?=$rss_href?>'><img src='<?=$board_skin_path?>/img/btn_rss.gif' border=0 align=absmiddle></a><?}?>
<? if ($admin_href) { ?><a href="<?=$admin_href?>"><img src="<?=$board_skin_path?>/img/admin_button.gif" title="???" border="0" align="absmiddle"></a><?}?></td>
</tr>
<tr><td height=5></td></tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><td height=1></td></tr><tr><td bgcolor=#EBEBEB height=1></td></tr>
<tr><td height=5></td></tr>
</table>
<!-- ?? -->
<?
// ??? ???? ??? ??? ??? ??? ???? $list[$i][num]? ??? ??? ?????.
// if (!is_int($list[$i][num])) { $list[$i][num] = "<img src='$board_skin/img/arrow.gif'>"; }
?>
<? for ($i=0; $i<count($list); $i++) { ?>
<table width=100% border=0 cellpadding=0 cellspacing=0 align="center" onMouseOver="this.style.backgroundColor='#F8F8F8'" onMouseOut="this.style.backgroundColor=''">
<form name="fboardlist" method="post">
<tr align=center>
<td align=center>
<?
//??? ??
$thumfile = "";
$thumb = $thumb_path.'/'.$list[$i][wr_id];
// ??? ???? ???? ????
if (!file_exists($thumb)) {
$file = $list[$i][file][0][path] .'/'. $list[$i][file][0][file];
// ???? ??? ?????
if (preg_match("/\.(jp[e]?g|gif|png)$/i", $file) && file_exists($file)) {
$size = getimagesize($file);
if ($size[2] == 1)
$src = imagecreatefromgif($file);
else if ($size[2] == 2)
$src = imagecreatefromjpeg($file);
else if ($size[2] == 3)
$src = imagecreatefrompng($file);
else
break;
$rate = $img_width / $size[0];
$height = (int)($size[1] * $rate);
// ??? ??? ???? ??? ??? ???? ???? ???
if ($height < $img_height)
// ??? ??? ??? ??? ??? ??
$dst = imagecreatetruecolor($img_width, $height);
else
// ??? ??? ??? ??? ??? ??
$dst = imagecreatetruecolor($img_width, $img_height);
imagecopyresampled($dst, $src, 0, 0, 0, 0, $img_width, $height, $size[0], $size[1]);
imagejpeg($dst, $thumb_path.'/'.$list[$i][wr_id], $img_quality);
chmod($thumb_path.'/'.$list[$i][wr_id], 0606);
}
}
//???
if (file_exists($thumb))
$thumfile = "<img src='$thumb' border=0 align=absmiddle style='background:#e1e1e1; border:1px solid #646464;'>";
else
//???? ???
$thumfile="<div style=\"width: {$img_width}; height: {$img_height}; text-align:center; vertical-align:middle; margin-left: 1px; border: 1px solid #666666;\"><br /><br />No Image</div>";
//???? ???
if(preg_match("/\.(swf|wma|asf)$/i","$file") && file_exists($file))
{ $thumfile = "<script>doc_write(flash_movie('$file', 'flash$i', '$img_width', '$img_height', 'transparent'));</script>"; }
echo $thumfile;
?>
<a href='<?="./board.php?&bo_table=$bo_table&wr_id={$list[$i][wr_id]}"?>'></a>
</td>
<td align=left>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25">
<?//=$list[$i][reply]?>
<?//=$list[$i][icon_reply]?>
<a href='<?=$list[$i][href]?>'>
<? if ($list[$i][is_notice]) echo "<b>"; ?>
<span style="font-size:9pt;"><b>
<? if ($is_checkbox) { ?><input type=checkbox name=chk_wr_id[] value="<?=$list[$i][wr_id]?>"><? } ?><?=$list[$i][subject]?>
</b></span><? if ($is_category) { ?><span class=tt>[<?=$list[$i][ca_name]?>]</span>
<? } ?> <span style="font-size:8pt;"><font color="#999999"> | ?? : <?=$list[$i][datetime]?></font></span>
<? if ($list[$i][is_notice]) echo "</b>"; ?></a>
<? if ($list[$i][comment_cnt])
echo " <a href=\"{$list[$i][comment_href]}\"><span style='font-size:7pt;'>{$list[$i][comment_cnt]} </span></a>";?>
<?echo " " . $list[$i][icon_file];?> <?echo " " . $list[$i][icon_link];?>
<?=$list[$i][icon_new]?>
<?=$list[$i][icon_hot]?>
<?=$list[$i][icon_battle]?>
<?=$list[$i][icon_secret]?>
<br>
<font color=gray></td>
</tr>
<tr>
<td>
<?=cut_str(strip_tags($list[$i][wr_content]),300,"…")?>
</font> </td>
</tr>
</table></td>
<!--
<td align=left>
<img src=<?=$list[$i][file_image2]?> align="absmiddle" onError="this.style.visibility='hidden'" border=0 width=50 height=50>
</td>
-->
</tr>
<tr><td height=5></td></tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><td height=1></td></tr><tr><td bgcolor=#EBEBEB height=1></td></tr><tr><td height=6></td></tr></table>
<? } ?>
<? if (count($list) == 0) { echo "<tr><td colspan=6 align=center height=50 class='content contentbg'>??? ????.</td></tr>"; } ?>
</form>
<!-- ??? -->
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align="right" height=25 valign=bottom>
<? if ($prev_part_href) { echo "<a href='$prev_part_href'><img src='$board_skin_path/img/btn_search_prev.gif' width=50 height=20 border=0 align=absmiddle title='????'></a>"; } ?>
<?
// ???? ???? ???? ??? ?? ???? ????? ??? ? ????.
//echo $write_pages;
$write_pages = str_replace("??", "<img src='$board_skin_path/img/begin.gif' border='0' align='absmiddle' title='??'>", $write_pages);
$write_pages = str_replace("??", "<img src='$board_skin_path/img/prev.gif' border='0' align='absmiddle' title='??'>", $write_pages);
$write_pages = str_replace("??", "<img src='$board_skin_path/img/next.gif' border='0' align='absmiddle' title='??'>", $write_pages);
$write_pages = str_replace("??", "<img src='$board_skin_path/img/end.gif' border='0' align='absmiddle' title='??'>", $write_pages);
$write_pages = preg_replace("/<span>([0-9]*)<\/span>/", "<b><font style=\"font-family:??; font-size:8pt; color:#797979\">$1</font></b>", $write_pages);
$write_pages = preg_replace("/<b>([0-9]*)<\/b>/", "<b><font style=\"font-family:??; font-size:8pt; color:red;\">$1</font></b>", $write_pages);
?>
<?=$write_pages?>
<? if ($next_part_href) { echo "<a href='$next_part_href'><img src='$board_skin_path/img/btn_search_next.gif' width=50 height=20 border=0 align=absmiddle title='????'></a>"; } ?>
</td>
</tr>
</table>
<!-- ?? ?? -->
<form name=fsearch method=get style="margin:0px;">
<input type=hidden name=bo_table value="<?=$bo_table?>">
<input type=hidden name=sca value="<?=$sca?>">
<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td width="50%" height="40">
<? if ($list_href) { ?><a href="<?=$list_href?>"><img src="<?=$board_skin_path?>/img/btn_list.gif" border="0"></a><? } ?>
<? if ($write_href) { ?><a href="<?=$write_href?>"><img src="<?=$board_skin_path?>/img/btn_write.gif" border="0"></a><? } ?>
<? if ($is_checkbox) { ?>
<a href="javascript:select_delete();"><img src="<?=$board_skin_path?>/img/btn_select_delete.gif" border="0"></a>
<a href="javascript:select_copy('copy');"><img src="<?=$board_skin_path?>/img/btn_select_copy.gif" border="0"></a>
<a href="javascript:select_copy('move');"><img src="<?=$board_skin_path?>/img/btn_select_move.gif" border="0"></a>
<? } ?>
</td>
<td width="50%" align="right">
<select name=sfl>
<option value='wr_subject||wr_content'>??+??</option>
<option value='wr_subject'>??</option>
<option value='wr_content'>??</option>
<option value='mb_id'>?????</option>
<option value='wr_name'>??</option>
</select><input name=stx maxlength=15 size=10 itemname="???" required value="<?=$stx?>"><select name=sop>
<option value=and>and</option>
<option value=or>or</option>
</select>
<input type=image src="<?=$board_skin_path?>/img/search_btn.gif" border=0 align=absmiddle></td>
</tr>
</table>
</form>
</td></tr></table>
<script language="JavaScript">
if ("<?=$sca?>") document.fcategory.sca.value = "<?=$sca?>";
if ("<?=$stx?>") {
document.fsearch.sfl.value = "<?=$sfl?>";
document.fsearch.sop.value = "<?=$sop?>";
}
</script>
<? if ($is_checkbox) { ?>
<script language="JavaScript">
function all_checked(sw)
{
var f = document.fboardlist;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]")
f.elements[i].checked = sw;
}
}
function check_confirm(str)
{
var f = document.fboardlist;
var chk_count = 0;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]" && f.elements[i].checked)
chk_count++;
}
if (!chk_count) {
alert(str + "? ???? ?? ?? ?????.");
return false;
}
return true;
}
// ??? ??? ??
function select_delete()
{
var f = document.fboardlist;
str = "??";
if (!check_confirm(str))
return;
if (!confirm("??? ???? ?? "+str+" ???????\n\n?? "+str+"? ??? ??? ? ????"))
return;
f.action = "./delete_all.php";
f.submit();
}
// ??? ??? ?? ? ??
function select_copy(sw)
{
var f = document.fboardlist;
if (sw == "copy")
str = "??";
else
str = "??";
if (!check_confirm(str))
return;
var sub_win = window.open("", "move", "left=50, top=50, width=396, height=550, scrollbars=1");
f.sw.value = sw;
f.target = "move";
f.action = "./move.php";
f.submit();
}
</script>
<? } ?>
<!-- ??? ?? ? -->