로그인

Home > >
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.00024초 [set names utf8]
실행시간:0.00026초 [SELECT bid FROM `spb3_list_equipment_join` WHERE `uid`='' LIMIT 1]
실행시간:0.00025초 [select * from spb3_logon where uid = '']
실행시간:0.00045초 [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,638,028,038.01198초 []
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] => 2021-11-28 )
$dbinfo = array(19개)
$_FILES = array(0개)
$_SERVER = array(28개)
$SITE = array(15개)
$_SESSION = array(0개)
$db_arraysql = array(4개)
$mlist = array(1개)
$sol2lun = array(4개)
$href = array(4개)
$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 = '2021';
$NowThisMonth = '11';
$NowThisDay = '28';
$intThisTimestamp = 1638025200;
$intThisYear = '2021';
$intThisMonth = '11';
$intThisDay = '28';
$intThisWeekday = '0';
$varThisWeekday = '일';
$intPrevYear = '2021';
$intPrevMonth = 10;
$intNextYear = '2021';
$intNextMonth = 12;
$intLastDay = 30;
$intPrevLastDay = 31;
$intNextLastDay = 31;
$intFirstWeekday = '1';
$thisFullDate = '2021년 11월 28일 일요일';
$searchDateFrom = '2021-11-01';
$searchDateTo = '2021-11-30';