Страницы:
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 ') ORDER BY ordernum,id LIMIT 0,10' at line 1An error occured in a database query!
array(5) {
[0]=>
array(7) {
["file"]=>
string(46) "/usr/home/www/shop.acapod.ru/lib/tikidblib.php"
["line"]=>
int(81)
["function"]=>
string(9) "sql_error"
["class"]=>
string(6) "TikiDB"
["object"]=>
object(UsersLib)#2 (12) {
["db"]=>
object(ADODB_mysql)#1 (88) {
["databaseType"]=>
string(5) "mysql"
["dataProvider"]=>
string(5) "mysql"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(129) "SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=SCHEMA()"
["metaColumnsSQL"]=>
string(22) "SHOW COLUMNS FROM `%s`"
["fmtTimeStamp"]=>
string(13) "'Y-m-d H:i:s'"
["hasLimit"]=>
bool(true)
["hasMoveFirst"]=>
bool(true)
["hasGenID"]=>
bool(true)
["isoDates"]=>
bool(true)
["sysDate"]=>
string(9) "CURDATE()"
["sysTimeStamp"]=>
string(5) "NOW()"
["hasTransactions"]=>
bool(false)
["forceNewConnect"]=>
bool(false)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["nameQuote"]=>
string(1) "`"
["compat323"]=>
bool(false)
["_genIDSQL"]=>
string(38) "update %s set id=LAST_INSERT_ID(id+1);"
["_genSeqSQL"]=>
string(33) "create table %s (id int not null)"
["_genSeqCountSQL"]=>
string(23) "select count(*) from %s"
["_genSeq2SQL"]=>
string(26) "insert into %s values (%s)"
["_dropSeqSQL"]=>
string(13) "drop table %s"
["database"]=>
string(5) "shop2"
["host"]=>
string(16) ":/tmp/mysql.sock"
["user"]=>
string(4) "gift"
["password"]=>
string(10) "not stored"
["debug"]=>
bool(false)
["maxblobsize"]=>
int(262144)
["concat_operator"]=>
string(1) "+"
["length"]=>
string(6) "length"
["random"]=>
string(6) "rand()"
["upperCase"]=>
string(5) "upper"
["fmtDate"]=>
string(7) "'Y-m-d'"
["true"]=>
string(1) "1"
["false"]=>
string(1) "0"
["replaceQuote"]=>
string(2) "\'"
["charSet"]=>
bool(false)
["metaDatabasesSQL"]=>
string(0) ""
["uniqueOrderBy"]=>
bool(false)
["emptyDate"]=>
string(6) " "
["emptyTimeStamp"]=>
string(6) " "
["lastInsID"]=>
bool(false)
["hasTop"]=>
bool(false)
["readOnly"]=>
bool(false)
["genID"]=>
int(0)
["raiseErrorFn"]=>
bool(false)
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["sysUTimeStamp"]=>
bool(false)
["arrayClass"]=>
string(18) "ADORecordSet_array"
["noNullStrings"]=>
bool(false)
["numCacheHits"]=>
int(0)
["numCacheMisses"]=>
int(0)
["pageExecuteCountRows"]=>
bool(true)
["uniqueSort"]=>
bool(false)
["leftOuter"]=>
bool(false)
["rightOuter"]=>
bool(false)
["ansiOuter"]=>
bool(false)
["autoRollback"]=>
bool(false)
["fnExecute"]=>
bool(false)
["fnCacheExecute"]=>
bool(false)
["blobEncodeType"]=>
bool(false)
["rsPrefix"]=>
string(13) "ADORecordSet_"
["autoCommit"]=>
bool(true)
["transOff"]=>
int(0)
["transCnt"]=>
int(0)
["fetchMode"]=>
bool(false)
["null2null"]=>
string(4) "null"
["bulkBind"]=>
bool(false)
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
resource(11) of type (mysql link)
["_errorMsg"]=>
string(179) "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 ') ORDER BY ordernum,id LIMIT 0,10' at line 1"
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(false)
["_isPersistentConnection"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(5) "shop2"
}
["site_id"]=>
string(1) "2"
["sitename"]=>
string(14) "shop.acapod.ru"
["preferences"]=>
array(25) {
["regok_page"]=>
string(14) "/im_regok.html"
["session_name"]=>
string(13) "sess_giftguru"
["regerror_page"]=>
string(17) "/im_regerror.html"
["img_cache"]=>
string(35) "/usr/home/www/shop.acapod.ru/cache/"
["start_point"]=>
string(1) "1"
["shop_proto"]=>
string(1) "2"
["goods_on_page"]=>
string(2) "10"
["good_order_page"]=>
string(35) "http://shop.acapod.ru/order_ok.html"
["bad_order_page"]=>
string(38) "http://shop.acapod.ru/order_error.html"
["mailFrom"]=>
string(18) "mailform@acapod.ru"
["card_img"]=>
string(21) "src="/img/zakaz6.gif""
["notify_emails"]=>
string(12) "yuri@rus.net"
["admin_email"]=>
string(19) "comission@acapod.ru"
["validateReg"]=>
string(20) "/im_regvalidate.html"
["userPage"]=>
string(13) "/im_user.html"
["site_dbc_user"]=>
string(4) "gift"
["site_dbc_pass"]=>
string(4) "GIFT"
["site_dbc_db"]=>
string(5) "shop2"
["image_url"]=>
string(22) "http://shop.acapod.ru/"
["page_dir"]=>
string(41) "/usr/home/www/shop.acapod.ru/cache/pages/"
["fragment_dir"]=>
string(45) "/usr/home/www/shop.acapod.ru/cache/fragments/"
["func_dir"]=>
string(37) "/usr/home/www/shop.acapod.ru/lib/func"
["catalog_page"]=>
string(34) "http://shop.acapod.ru/catalog.html"
["perm_denied_proto"]=>
string(36) "http://shop.acapod.ru/im-denied.html"
["card_img2"]=>
string(0) ""
}
["rememberme"]=>
string(3) "all"
["remembertime"]=>
string(8) "26280000"
["siteTitle"]=>
string(8) "giftguru"
["regGroup"]=>
string(10) "Registered"
["debug"]=>
bool(false)
["usergroups_cache"]=>
array(1) {
[""]=>
array(0) {
}
}
["groupperm_cache"]=>
array(1) {
[0]=>
array(0) {
}
}
["indexPage"]=>
string(10) "index.html"
}
["type"]=>
string(2) "->"
["args"]=>
array(3) {
[0]=>
&string(170) "select `id`,`name`,`heading`,`l_heading`,`art`,`quote`,`short_text`,`is_group`,`price`,`image2_w`,`image2_h` from `shop` where `is_active`="Y" and () ORDER BY ordernum,id"
[1]=>
&array(0) {
}
[2]=>
&bool(false)
}
}
[1]=>
array(7) {
["file"]=>
string(48) "/usr/home/www/shop.acapod.ru/lib/shopmainlib.php"
["line"]=>
int(965)
["function"]=>
string(5) "query"
["class"]=>
string(6) "TikiDB"
["object"]=>
object(UsersLib)#2 (12) {
["db"]=>
object(ADODB_mysql)#1 (88) {
["databaseType"]=>
string(5) "mysql"
["dataProvider"]=>
string(5) "mysql"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(129) "SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=SCHEMA()"
["metaColumnsSQL"]=>
string(22) "SHOW COLUMNS FROM `%s`"
["fmtTimeStamp"]=>
string(13) "'Y-m-d H:i:s'"
["hasLimit"]=>
bool(true)
["hasMoveFirst"]=>
bool(true)
["hasGenID"]=>
bool(true)
["isoDates"]=>
bool(true)
["sysDate"]=>
string(9) "CURDATE()"
["sysTimeStamp"]=>
string(5) "NOW()"
["hasTransactions"]=>
bool(false)
["forceNewConnect"]=>
bool(false)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["nameQuote"]=>
string(1) "`"
["compat323"]=>
bool(false)
["_genIDSQL"]=>
string(38) "update %s set id=LAST_INSERT_ID(id+1);"
["_genSeqSQL"]=>
string(33) "create table %s (id int not null)"
["_genSeqCountSQL"]=>
string(23) "select count(*) from %s"
["_genSeq2SQL"]=>
string(26) "insert into %s values (%s)"
["_dropSeqSQL"]=>
string(13) "drop table %s"
["database"]=>
string(5) "shop2"
["host"]=>
string(16) ":/tmp/mysql.sock"
["user"]=>
string(4) "gift"
["password"]=>
string(10) "not stored"
["debug"]=>
bool(false)
["maxblobsize"]=>
int(262144)
["concat_operator"]=>
string(1) "+"
["length"]=>
string(6) "length"
["random"]=>
string(6) "rand()"
["upperCase"]=>
string(5) "upper"
["fmtDate"]=>
string(7) "'Y-m-d'"
["true"]=>
string(1) "1"
["false"]=>
string(1) "0"
["replaceQuote"]=>
string(2) "\'"
["charSet"]=>
bool(false)
["metaDatabasesSQL"]=>
string(0) ""
["uniqueOrderBy"]=>
bool(false)
["emptyDate"]=>
string(6) " "
["emptyTimeStamp"]=>
string(6) " "
["lastInsID"]=>
bool(false)
["hasTop"]=>
bool(false)
["readOnly"]=>
bool(false)
["genID"]=>
int(0)
["raiseErrorFn"]=>
bool(false)
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["sysUTimeStamp"]=>
bool(false)
["arrayClass"]=>
string(18) "ADORecordSet_array"
["noNullStrings"]=>
bool(false)
["numCacheHits"]=>
int(0)
["numCacheMisses"]=>
int(0)
["pageExecuteCountRows"]=>
bool(true)
["uniqueSort"]=>
bool(false)
["leftOuter"]=>
bool(false)
["rightOuter"]=>
bool(false)
["ansiOuter"]=>
bool(false)
["autoRollback"]=>
bool(false)
["fnExecute"]=>
bool(false)
["fnCacheExecute"]=>
bool(false)
["blobEncodeType"]=>
bool(false)
["rsPrefix"]=>
string(13) "ADORecordSet_"
["autoCommit"]=>
bool(true)
["transOff"]=>
int(0)
["transCnt"]=>
int(0)
["fetchMode"]=>
bool(false)
["null2null"]=>
string(4) "null"
["bulkBind"]=>
bool(false)
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
resource(11) of type (mysql link)
["_errorMsg"]=>
string(179) "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 ') ORDER BY ordernum,id LIMIT 0,10' at line 1"
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(false)
["_isPersistentConnection"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(5) "shop2"
}
["site_id"]=>
string(1) "2"
["sitename"]=>
string(14) "shop.acapod.ru"
["preferences"]=>
array(25) {
["regok_page"]=>
string(14) "/im_regok.html"
["session_name"]=>
string(13) "sess_giftguru"
["regerror_page"]=>
string(17) "/im_regerror.html"
["img_cache"]=>
string(35) "/usr/home/www/shop.acapod.ru/cache/"
["start_point"]=>
string(1) "1"
["shop_proto"]=>
string(1) "2"
["goods_on_page"]=>
string(2) "10"
["good_order_page"]=>
string(35) "http://shop.acapod.ru/order_ok.html"
["bad_order_page"]=>
string(38) "http://shop.acapod.ru/order_error.html"
["mailFrom"]=>
string(18) "mailform@acapod.ru"
["card_img"]=>
string(21) "src="/img/zakaz6.gif""
["notify_emails"]=>
string(12) "yuri@rus.net"
["admin_email"]=>
string(19) "comission@acapod.ru"
["validateReg"]=>
string(20) "/im_regvalidate.html"
["userPage"]=>
string(13) "/im_user.html"
["site_dbc_user"]=>
string(4) "gift"
["site_dbc_pass"]=>
string(4) "GIFT"
["site_dbc_db"]=>
string(5) "shop2"
["image_url"]=>
string(22) "http://shop.acapod.ru/"
["page_dir"]=>
string(41) "/usr/home/www/shop.acapod.ru/cache/pages/"
["fragment_dir"]=>
string(45) "/usr/home/www/shop.acapod.ru/cache/fragments/"
["func_dir"]=>
string(37) "/usr/home/www/shop.acapod.ru/lib/func"
["catalog_page"]=>
string(34) "http://shop.acapod.ru/catalog.html"
["perm_denied_proto"]=>
string(36) "http://shop.acapod.ru/im-denied.html"
["card_img2"]=>
string(0) ""
}
["rememberme"]=>
string(3) "all"
["remembertime"]=>
string(8) "26280000"
["siteTitle"]=>
string(8) "giftguru"
["regGroup"]=>
string(10) "Registered"
["debug"]=>
bool(false)
["usergroups_cache"]=>
array(1) {
[""]=>
array(0) {
}
}
["groupperm_cache"]=>
array(1) {
[0]=>
array(0) {
}
}
["indexPage"]=>
string(10) "index.html"
}
["type"]=>
string(2) "->"
["args"]=>
array(4) {
[0]=>
&string(170) "select `id`,`name`,`heading`,`l_heading`,`art`,`quote`,`short_text`,`is_group`,`price`,`image2_w`,`image2_h` from `shop` where `is_active`="Y" and () ORDER BY ordernum,id"
[1]=>
&array(0) {
}
[2]=>
&string(2) "10"
[3]=>
&int(0)
}
}
[2]=>
array(2) {
["function"]=>
string(7) "Catalog"
["args"]=>
array(1) {
[0]=>
&string(3) "psc"
}
}
[3]=>
array(4) {
["file"]=>
string(44) "/usr/home/www/shop.acapod.ru/lib/mainlib.php"
["line"]=>
int(988)
["function"]=>
string(20) "call_user_func_array"
["args"]=>
array(2) {
[0]=>
&string(7) "Catalog"
[1]=>
&array(1) {
[0]=>
string(3) "psc"
}
}
}
[4]=>
array(4) {
["file"]=>
string(37) "/usr/home/www/shop.acapod.ru/shop.php"
["line"]=>
int(172)
["function"]=>
string(12) "ProcessLines"
["args"]=>
array(1) {
[0]=>
&array(29) {
[0]=>
string(22) "#!InsertFragment(35);
"
[1]=>
string(1) "
"
[2]=>
string(1) "
"
[3]=>
string(5) "
"
[4]=>
string(20) "#!CatalogHeader(h);
"
[5]=>
string(6) "
"
[6]=>
string(1) "
"
[7]=>
string(13) "
"
[8]=>
string(30) "
"
[9]=>
string(4) "
"
[10]=>
string(20) "#!CatalogHeader(c);
"
[11]=>
string(12) "
"
[12]=>
string(14) "
"
[13]=>
string(32) "
"
[14]=>
string(22) "Страницы:
"
[15]=>
string(17) "#!CatalogPage();
"
[16]=>
string(5) "
"
[17]=>
string(5) "
"
[18]=>
string(1) "
"
[19]=>
string(16) "#!Catalog(psc);
"
[20]=>
string(1) "
"
[21]=>
string(32) "
"
[22]=>
string(22) "Страницы:
"
[23]=>
string(17) "#!CatalogPage();
"
[24]=>
string(5) "
"
[25]=>
string(5) "
"
[26]=>
string(1) "
"
[27]=>
string(1) "
"
[28]=>
string(21) "#!InsertFragment(23);"
}
}
}
}
|