로그인 및 회원 정보

로그인

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.00019초 [set names utf8]
실행시간:0.00019초 [SELECT bid FROM `spb3_list_equipment_join` WHERE `uid`='' LIMIT 1]
실행시간:0.00025초 [select * from spb3_logon where uid = '']
실행시간:0.00047초 [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,669,501,115.81898초 []
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-11-27
)

$dbinfo = array(19개) 

$_FILES = array(0개) 

$_SERVER = array(27개) 

$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 = '2022';
$NowThisMonth = '11';
$NowThisDay = '27';
$intThisTimestamp = 1669474800;
$intThisYear = '2022';
$intThisMonth = '11';
$intThisDay = '27';
$intThisWeekday = '0';
$varThisWeekday = '일';
$intPrevYear = '2022';
$intPrevMonth = 10;
$intNextYear = '2022';
$intNextMonth = 12;
$intLastDay = 30;
$intPrevLastDay = 31;
$intNextLastDay = 31;
$intFirstWeekday = '2';
$thisFullDate = '2022년 11월 27일 일요일';
$searchDateFrom = '2022-11-01';
$searchDateTo = '2022-11-30';