MySQL Error : 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 'AND (dtype = 'hour' OR dtype = 'day')
ORDER BY uid ASC,startdat' at line 3
Last SQL Query : SELECT * FROM spb3_list_equipment_join
WHERE 1 AND retimes=0 and bid =
AND (dtype = 'hour' OR dtype = 'day')
ORDER BY uid ASC,startdate, starthour 변수Array
(
[0] => set names utf8
[1] => SELECT bid FROM `spb3_list_equipment_join` WHERE `uid`='' LIMIT 1
[2] => select * from spb3_logon where uid = ''
[3] => SELECT * FROM spb3_list_equipment_join
WHERE 1 AND retimes=0 and bid =
AND (dtype = 'hour' OR dtype = 'day')
ORDER BY uid ASC,startdate, starthour
)
SitePHPbasic 디버그 모드
사용자 에러 [256]
내용: db_error()함수 호출
Line : 591 (file:/wecan/nmakerspace/nmakerspace.sdong.kr/spb3/sinc/lib/function_mysql3.php), PHP 5.4.45 (Linux)
디버그 추적(debug_backtrace)
#0 spb_error_handler() 함수사용, line(),
#1 trigger_error() 함수사용, line(591), /wecan/nmakerspace/nmakerspace.sdong.kr/spb3/sinc/lib/function_mysql3.php
#2 db_error() 함수사용, line(117), /wecan/nmakerspace/nmakerspace.sdong.kr/spb3/sinc/lib/function_mysql3.php
#3 db_query() 함수사용, line(31), /wecan/nmakerspace/nmakerspace.sdong.kr/equipmentjoin/pdball/inc_month.php
#4 include() 함수사용, line(179), /wecan/nmakerspace/nmakerspace.sdong.kr/equipmentjoin/pdball/index.php
사용변수들 ...
SitePHPbasic FULL Debug Mode [ sadmin] [ myadmin]
실행시간:0.00019초 [set names utf8] 실행시간:0.00021초 [SELECT bid FROM `spb3_list_equipment_join` WHERE `uid`='' LIMIT 1] 실행시간:0.00029초 [select * from spb3_logon where uid = ''] 실행시간:0.00046초 [SELECT * FROM spb3_list_equipment_join
WHERE 1 AND retimes=0 and bid =
AND (dtype = 'hour' OR dtype = 'day')
ORDER BY uid ASC,startdate, starthour] 실행시간:1,656,528,525.28376초 [] include file : /equipmentjoin/pdball/index.php 2020.04.22 12:00:16 include file : /spb3/sinc/header.php 2020.09.09 11:19:00 include file : /spb3/sinc/config.php 2020.02.28 13:20:43 include file : /spb3/sinc/lib/function_default.php 2020.03.03 11:41:15 include file : /spb3/sinc/ipconfig.php 2010.08.24 17:28:50 include file : /spb3/sinc/lib/class_spb_checktime.php 2010.08.24 17:28:50 include file : /spb3/sinc/lib/function_error.php 2019.11.15 11:32:38 include file : /spb3/sinc/lib/function_mysql3.php 2019.11.19 16:45:13 include file : /spb3/sinc/lib/function_app.php 2010.08.24 17:28:50 include file : /spb3/sinc/skin/skin.php 2010.08.24 17:28:50 include file : /spb3/sinc/skin/index_login.php 2020.04.07 11:22:02 include file : /spb3/sinc/skin/header.php 2021.07.19 13:30:49 include file : /spb3/sinc/skin/tail.php 2020.07.03 13:26:49 include file : /equipmentjoin/pdball/userfuntions.php 2020.03.20 19:19:55 include file : /equipmentjoin/pdball/function_lunartosol.php 2020.03.20 19:20:16 include file : /equipmentjoin/pdball/config.php 2020.03.24 18:47:00 include file : /equipmentjoin/pdball/inc_month.php 2020.04.02 13:29:33 $_GET = Array
(
[mode] => month
[date] => 2022-06-30
)
$dbinfo = array(19개)
$dbinfo = array (
'title' => '일정관리',
'thisUrl' => './',
'table' => 'spb3_list_equipment_join',
'pdb' => 'spb3_board3_equipment',
'skin' => 'basic',
'html_type' => 'ht',
'html_skin' => 'login',
'html_head' => '',
'html_tail' => '',
'enable_getinfo' => 'Y',
'bid' => 1,
'gid' => 0,
'priv_list' => '',
'priv_write' => '회원,운영자',
'priv_read' => '회원,운영자',
'priv_modify' => '회원,운영자',
'priv_delete' => '회원,운영자',
'cut_length' => '0',
'cut_content' => '',
); $_FILES = array(0개)
$_SERVER = array(26개)
$_SERVER = array (
'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
'HTTP_ACCEPT_ENCODING' => 'br,gzip',
'HTTP_HOST' => 'raic.kr',
'HTTP_CONNECTION' => 'Keep-Alive',
'PATH' => '/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin',
'SERVER_SIGNATURE' => '<address>Apache/2.2.15 (CentOS) Server at raic.kr Port 80</address>
',
'SERVER_SOFTWARE' => 'Apache/2.2.15 (CentOS)',
'SERVER_NAME' => 'raic.kr',
'SERVER_ADDR' => '61.14.208.180',
'SERVER_PORT' => '80',
'REMOTE_ADDR' => '44.201.96.43',
'DOCUMENT_ROOT' => '/wecan/nmakerspace/nmakerspace.sdong.kr',
'SERVER_ADMIN' => 'webmaster@staredong.com',
'SCRIPT_FILENAME' => '/wecan/nmakerspace/nmakerspace.sdong.kr/equipmentjoin/pdball/index.php',
'REMOTE_PORT' => '60680',
'GATEWAY_INTERFACE' => 'CGI/1.1',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'REQUEST_METHOD' => 'GET',
'QUERY_STRING' => '',
'REQUEST_URI' => '/equipmentjoin/pdball/index.php',
'SCRIPT_NAME' => '/equipmentjoin/pdball/index.php',
'PHP_SELF' => '/equipmentjoin/pdball/index.php',
'REQUEST_TIME_FLOAT' => 1656528525.269999980926513671875,
'REQUEST_TIME' => 1656528525,
); $SITE = array(15개)
$SITE = array (
'database' => 'user_nmakerspace',
'th' => 'spb3_',
'uh' => '/spb3/',
'home' => '/spb3/',
'name' => 'sitePHPbasic',
'company' => '뉴21커뮤니티(주)',
'webmaster' => 'spb@sdong.kr',
'hp' => '16449501',
'version' => '3.2.0',
'debug' => 2,
'home_path' => '/wecan/nmakerspace/nmakerspace.sdong.kr/',
'spb3_path' => '/wecan/nmakerspace/nmakerspace.sdong.kr/spb3/',
'html_path' => '/wecan/nmakerspace/nmakerspace.sdong.kr/spb3/sinc/skin/',
'lib_path' => '/wecan/nmakerspace/nmakerspace.sdong.kr/spb3/sinc/lib/',
'tail' => '
<!--//BODY-->
</div>
</div>
</div>
</div>
<footer id="footer" class="footer">
<div class="footer-main" style="background: #273648;">
<div class="wrapper ft-st-layer" style="margin-bottom: 11px;">
<div class="fnb">
<div><a href="/spb3/sjoin/license.php">이용약관</a></div>
<div><a href="/spb3/sjoin/privacy.php">개인정보방침</a></div>
<div><a href="/sub2/sub2_1.php">소개</a></div>
<div><a href="/sub1/sub1_4.php">찾아오시는 길</a></div>
</div>
</div>
<div class="wrapper">
<div class="info">
<div class="info-left">
<div class="info-title">남악메이커스페이스</div>
<div class="info-tell"> <i class="fas fa-phone" style="margin: 0 10px;"></i>061-285-9665 </div>
</div>
<div class="info-right">
<div class="info-site">SITE : https://raic.kr</div>
<div class="info-mail">E-MAIL : nms00@mokpo.ac.kr</div>
<div class="info-address">ADDRESS : 전남 무안군 삼향읍 남악3로 40 남악복합주민센터 3층 남악메이커스페이스</div>
<div class="info-work">운영시간 : AM 09:00 ~ PM 20:00(월~금) / AM 09:00 ~ PM 18:00(토) / 일요일,공휴일 휴무 / 10월31일 기관자체휴무</div>
<div class="info-copy">2020. All Rights Reserved.</div>
</div>
</div>
<div class="banner" style="margin-top: 8px">
<div class="white-logo" style="justify-content: flex-start;display: flex;">
<div>
<div class="sup-title">전문기관</div>
<div id="sup_img1"></div>
<div id="sup_img2"></div>
</div>
<div>
<div class="sup-title">참여기관</div>
<div id="sup_img5"></div>
<div id="sup_img6"></div>
</div>
</div>
<div class="white-logo">
<div>
<div class="sup-title">주관기관</div>
<div id="sup_img3"></div>
<div id="sup_img4"></div>
</div>
</div>
<style>
#sup_img1{width : 160px ;background-image:url("/images/중소벤처기업부white.png")}
#sup_img2{width : 110px ;background-image:url("/images/창업진흥원white.png")}
#sup_img3{width : 260px ;background-image:url("/images/산학협력단white.png"); }
#sup_img4{width : 350px ;background-image:url("/images/로봇인공지능융합센터white.png");margin-left: 13px;}
#sup_img5{width : 100px ;background-image:url("/images/무안군로고white.png")}
#sup_img6{width : 100px ;background-image:url("/images/전라남도white.png")}
.white-logo div div{height: 35px;justify-content: center;align-items: center;background-size: contain; background-repeat: no-repeat;background-position: center; line-height: 35px;}
.white-logo>div {display: flex; flex-direction: row;}
.sup-title{margin-right: 10px;}
@media (max-width: 1104px) {
}
</style>
</div>
</div>
<style>
.wrapper>div>span{font-size: 13px; padding-right: 10px;border-right: 1px solid #FFF;}
.wrapper>div>span:last-child{border-right: none;}
</style>
</div>
<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.18/jquery-ui.min.js"></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
<style>
#footer-menu-container{width: 30%;}
#footer-menu-container, #footer-menu-container * {box-sizing: border-box;}
#footer-menu-container .footer-menu>.item{padding:10px 0;cursor: pointer;}
.fnb{height: 100%;width: 40%;display: flex;align-items: center;}
.fnb>div{padding: 0 5px; border-right: 1px solid #FFF; line-height: 16px;}
.fnb>div:last-child{border-right: none;}
.footer-menu {margin: 0;padding: 0;overflow: hidden;display: flex;flex-direction: row;width: 100%;}
.footer-menu .item{width: 33.33332%; text-align: center;}
.footer-menu .item a {display: inline-block;color: #000;text-align: center;text-decoration: none;padding: 14px 16px;font-size: 17px;transition:0.3s;}
.footer-menu .current{border-top: 2px solid #1D7DBB;border-left: 2px solid #1D7DBB;border-right: 2px solid #1D7DBB;border-bottom: none;color: #222;}
.footer-menu .un-current{border-bottom: 2px solid #1D7DBB;}
.footer-menu-item {display: none; height: 30px;width: 1105px; margin: 0 auto;}
.footer-menu-item.current {display: block;}
.current>a{color: #1D7DBB; font-weight: 600;}
.ft-st-layer{display: flex; flex-direction: row;justify-content: space-between;}
</style>
<script>
$(function() {
$(".footer-menu>.item").click(function(){
var indexNum = $(this).index();
$(this).addClass("current").removeClass("un-current").siblings().removeClass("current").addClass("un-current");
$(".footer-menu-content>.footer-menu-item").eq(indexNum).show().siblings().hide();
})
});
</script>
</footer>
</div>
</body></html>',
); $_SESSION = array(0개)
$db_arraysql = array(4개)
$db_arraysql = array (
0 => 'set names utf8',
1 => 'SELECT bid FROM `spb3_list_equipment_join` WHERE `uid`=\'\' LIMIT 1',
2 => 'select * from spb3_logon where uid = \'\'',
3 => 'SELECT * FROM spb3_list_equipment_join
WHERE 1 AND retimes=0 and bid =
AND (dtype = \'hour\' OR dtype = \'day\')
ORDER BY uid ASC,startdate, starthour',
); $mlist = array(1개)
$mlist = array (
'birth_date' => NULL,
); $sol2lun = array(4개)
$sol2lun = array (
0 => '2022',
1 => '6',
2 => '2',
3 => '임인년|호랑이띠',
); $href = array(4개)
$href = array (
'today' => '/equipmentjoin/pdball/index.php?mode=day&date=2022-06-30',
'day' => '/equipmentjoin/pdball/index.php?mode=day&date=2022-06-30',
'week' => '/equipmentjoin/pdball/index.php?mode=week&date=2022-06-30',
'month' => '/equipmentjoin/pdball/index.php?mode=month&date=2022-06-30',
);
$db_lastsql = 'SELECT * FROM spb3_list_equipment_join
WHERE 1 AND retimes=0 and bid =
AND (dtype = \'hour\' OR dtype = \'day\')
ORDER BY uid ASC,startdate, starthour';
$db_conn = NULL;
$thisPath = '/wecan/nmakerspace/nmakerspace.sdong.kr/equipmentjoin/pdball/';
$thisUrl = '/equipmentjoin';
$qs_basic = 'db=';
$sql_where_cal = ' 1 ';
$bid = false;
$sql = 'SELECT * FROM spb3_list_equipment_join
WHERE 1 AND retimes=0 and bid =
AND (dtype = \'hour\' OR dtype = \'day\')
ORDER BY uid ASC,startdate, starthour';
$NowThisYear = '2022';
$NowThisMonth = '06';
$NowThisDay = '30';
$intThisTimestamp = 1656514800;
$intThisYear = '2022';
$intThisMonth = '06';
$intThisDay = '30';
$intThisWeekday = '4';
$varThisWeekday = '목';
$intPrevYear = '2022';
$intPrevMonth = 5;
$intNextYear = '2022';
$intNextMonth = 7;
$intLastDay = 30;
$intPrevLastDay = 31;
$intNextLastDay = 31;
$intFirstWeekday = '3';
$thisFullDate = '2022년 6월 30일 목요일';
$searchDateFrom = '2022-06-01';
$searchDateTo = '2022-06-30';
|