Edit albums on external page
|
roulandf
Joined: 2009-05-04
Posts: 7 |
Posted: Mon, 2009-05-04 09:40
|
|
Hello, I'm currently developing a page on an external server which includes some files out of main.php (e.g. bootstrap.inc, init.inc, GalleryCoreApi.inc and so on). With these lines of code I'm able to modify the "Title", "Description" and "Summary" of an album.
require_once("../bootstrap.inc");
require_once("../modules/core/classes/GalleryCoreApi.class");
require_once("../init.inc");
GalleryInitFirstPass();
GalleryInitSecondPass();
global $gallery;
$session =& $gallery->getSession();
$session->start();
list($ret, $user) = GalleryCoreApi::fetchUserByUsername("admin");
$gallery->setActiveUser($user);
//get GalleryItem by itemId
list ($ret, $item) = GalleryCoreApi::loadEntitiesById(2011, 'GalleryItem'); //2011 points to a photoitem
list ($ret, $lockId) = GalleryCoreApi::acquireWriteLock($item->getId());
$values = array("title"=>"Titel", "summary"=>"Summary", "keywords"=>"Keywords", "description"=>"Description");
$item->setTitle($values['title']);
$item->setSummary($values['summary']);
$item->setKeywords($values['keywords']);
$item->setDescription($values['description']);
$item->setSerialNumber($item->getSerialNumber());
$ret = $item->save();
$ret = GalleryCoreApi::releaseLocks($lockId);
If I change to the "Edit photoitem" view on Gallery2 Interface, I can see the changes made by this external script. But it seems, that these changes are not stored in DB but only in current session. If I change e.g. the title on the edit photoitem view, it will throw the following exception:
Error Detail -
Error (ERROR_OBSOLETE_DATA) : UPDATE g2_Entity SET g_modificationTimestamp=?,g_serialNumber=? WHERE g_id=? AND g_serialNumber=? (1241428222|8|2011|7)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 362 (GalleryCoreApi::error)
* in modules/core/classes/GalleryStorage.class at line 324 (GalleryStorageExtras::saveEntity)
* in modules/core/classes/GalleryEntity.class at line 294 (GalleryStorage::saveEntity)
* in modules/core/classes/GalleryItem.class at line 414 (GalleryEntity::save)
* in modules/core/ItemEditItem.inc at line 253 (GalleryItem::save)
* in modules/core/ItemEdit.inc at line 84 (ItemEditItem::handleRequest)
* in main.php at line 250 (ItemEditController::handleRequest)
* in main.php at line 104
* in main.php at line 88
Changing a value in array $values from e.g. key "title" gets the value "title of the photoalbum" throws this exception (if i run the script then again with the old value for key "title" what was "Title" there will no error occur:
object(GalleryStatus)#19 (4) {
["_stack"]=>
NULL
["_errorCode"]=>
int(513)
["_errorMessage"]=>
string(119) "UPDATE g2_Entity SET g_modificationTimestamp=?,g_serialNumber=? WHERE g_id=? AND g_serialNumber=? (1241428205|8|2011|7)"
["_stackTrace"]=>
array(5) {
[0]=>
array(7) {
["file"]=>
string(80) "/var/www/gallery2/modules/core/classes/GalleryStorage/GalleryStorageExtras.class"
["line"]=>
int(362)
["function"]=>
string(5) "error"
["class"]=>
string(14) "GalleryCoreApi"
["object"]=>
object(GalleryStorageExtras)#9 (1) {
["_gs"]=>
object(MySqlStorage)#6 (16) {
["_db"]=>
object(ADODB_mysqli)#7 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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(1)
["fetchMode"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#8 (0) {
}
["_errorMsg"]=>
bool(false)
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_nonTransactionalDb"]=>
object(ADODB_mysqli)#13 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#14 (0) {
}
["_errorMsg"]=>
string(60) "Duplicate entry 'f19a7678608b4a68319e89c897af138d' for key 1"
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_extras"]=>
object(GalleryStorageExtras)#9 (1) {
["_gs"]=>
object(MySqlStorage)#6 (16) {
["_db"]=>
object(ADODB_mysqli)#7 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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(1)
["fetchMode"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#8 (0) {
}
["_errorMsg"]=>
bool(false)
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_nonTransactionalDb"]=>
object(ADODB_mysqli)#13 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#14 (0) {
}
["_errorMsg"]=>
string(60) "Duplicate entry 'f19a7678608b4a68319e89c897af138d' for key 1"
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_extras"]=>
*RECURSION*
["_type"]=>
string(6) "mysqli"
["_username"]=>
string(4) "root"
["_password"]=>
string(0) ""
["_database"]=>
string(8) "gallery2"
["_hostname"]=>
string(9) "localhost"
["_isTransactional"]=>
bool(true)
["_schema"]=>
string(0) ""
["_tablePrefix"]=>
string(3) "g2_"
["_columnPrefix"]=>
string(2) "g_"
["_entityInfoCache"]=>
array(0) {
}
["_usePersistentConnections"]=>
bool(false)
["_isEmptyAllowedForNotNullColumn"]=>
bool(true)
["_serverInfo"]=>
string(10) "5.0.51a-24"
}
}
["_type"]=>
string(6) "mysqli"
["_username"]=>
string(4) "root"
["_password"]=>
string(0) ""
["_database"]=>
string(8) "gallery2"
["_hostname"]=>
string(9) "localhost"
["_isTransactional"]=>
bool(true)
["_schema"]=>
string(0) ""
["_tablePrefix"]=>
string(3) "g2_"
["_columnPrefix"]=>
string(2) "g_"
["_entityInfoCache"]=>
array(0) {
}
["_usePersistentConnections"]=>
bool(false)
["_isEmptyAllowedForNotNullColumn"]=>
bool(true)
["_serverInfo"]=>
string(10) "5.0.51a-24"
}
}
["type"]=>
string(2) "->"
["args"]=>
array(4) {
[0]=>
int(512)
[1]=>
string(80) "/var/www/gallery2/modules/core/classes/GalleryStorage/GalleryStorageExtras.class"
[2]=>
int(361)
[3]=>
string(119) "UPDATE g2_Entity SET g_modificationTimestamp=?,g_serialNumber=? WHERE g_id=? AND g_serialNumber=? (1241428205|8|2011|7)"
}
}
[1]=>
array(7) {
["file"]=>
string(59) "/var/www/gallery2/modules/core/classes/GalleryStorage.class"
["line"]=>
int(324)
["function"]=>
string(10) "saveEntity"
["class"]=>
string(20) "GalleryStorageExtras"
["object"]=>
object(GalleryStorageExtras)#9 (1) {
["_gs"]=>
object(MySqlStorage)#6 (16) {
["_db"]=>
object(ADODB_mysqli)#7 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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(1)
["fetchMode"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#8 (0) {
}
["_errorMsg"]=>
bool(false)
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_nonTransactionalDb"]=>
object(ADODB_mysqli)#13 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#14 (0) {
}
["_errorMsg"]=>
string(60) "Duplicate entry 'f19a7678608b4a68319e89c897af138d' for key 1"
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_extras"]=>
object(GalleryStorageExtras)#9 (1) {
["_gs"]=>
object(MySqlStorage)#6 (16) {
["_db"]=>
object(ADODB_mysqli)#7 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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(1)
["fetchMode"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#8 (0) {
}
["_errorMsg"]=>
bool(false)
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_nonTransactionalDb"]=>
object(ADODB_mysqli)#13 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#14 (0) {
}
["_errorMsg"]=>
string(60) "Duplicate entry 'f19a7678608b4a68319e89c897af138d' for key 1"
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_extras"]=>
*RECURSION*
["_type"]=>
string(6) "mysqli"
["_username"]=>
string(4) "root"
["_password"]=>
string(0) ""
["_database"]=>
string(8) "gallery2"
["_hostname"]=>
string(9) "localhost"
["_isTransactional"]=>
bool(true)
["_schema"]=>
string(0) ""
["_tablePrefix"]=>
string(3) "g2_"
["_columnPrefix"]=>
string(2) "g_"
["_entityInfoCache"]=>
array(0) {
}
["_usePersistentConnections"]=>
bool(false)
["_isEmptyAllowedForNotNullColumn"]=>
bool(true)
["_serverInfo"]=>
string(10) "5.0.51a-24"
}
}
["_type"]=>
string(6) "mysqli"
["_username"]=>
string(4) "root"
["_password"]=>
string(0) ""
["_database"]=>
string(8) "gallery2"
["_hostname"]=>
string(9) "localhost"
["_isTransactional"]=>
bool(true)
["_schema"]=>
string(0) ""
["_tablePrefix"]=>
string(3) "g2_"
["_columnPrefix"]=>
string(2) "g_"
["_entityInfoCache"]=>
array(0) {
}
["_usePersistentConnections"]=>
bool(false)
["_isEmptyAllowedForNotNullColumn"]=>
bool(true)
["_serverInfo"]=>
string(10) "5.0.51a-24"
}
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
&object(GalleryPhotoItem)#16 (25) {
["width"]=>
int(120)
["height"]=>
int(120)
["mimeType"]=>
string(10) "image/jpeg"
["size"]=>
int(5790)
["canContainChildren"]=>
int(0)
["description"]=>
string(24) "Descriptionss from query"
["keywords"]=>
string(19) "Keywords from query"
["ownerId"]=>
int(6)
["renderer"]=>
NULL
["summary"]=>
string(18) "Summary from query"
["title"]=>
string(16) "title from query"
["viewedSinceTimestamp"]=>
int(1241088796)
["originationTimestamp"]=>
int(1241088796)
["pathComponent"]=>
string(5) "3.jpg"
["parentId"]=>
int(1983)
["id"]=>
int(2011)
["creationTimestamp"]=>
int(1241088796)
["isLinkable"]=>
int(1)
["linkId"]=>
NULL
["linkedEntity"]=>
NULL
["modificationTimestamp"]=>
int(1241428205)
["serialNumber"]=>
int(8)
["entityType"]=>
string(16) "GalleryPhotoItem"
["onLoadHandlers"]=>
NULL
["_persistentStatus"]=>
array(2) {
["flags"]=>
int(0)
["originalValue"]=>
array(23) {
["width"]=>
int(120)
["height"]=>
int(120)
["mimeType"]=>
string(10) "image/jpeg"
["size"]=>
int(5790)
["canContainChildren"]=>
int(0)
["description"]=>
string(12) "Descriptions"
["keywords"]=>
string(8) "Keywords"
["ownerId"]=>
int(6)
["renderer"]=>
NULL
["summary"]=>
string(7) "Summary"
["title"]=>
string(6) "Titles"
["viewedSinceTimestamp"]=>
int(1241088796)
["originationTimestamp"]=>
int(1241088796)
["pathComponent"]=>
string(5) "3.jpg"
["parentId"]=>
int(1983)
["id"]=>
int(2011)
["creationTimestamp"]=>
int(1241088796)
["isLinkable"]=>
int(1)
["linkId"]=>
NULL
["modificationTimestamp"]=>
int(1241424004)
["serialNumber"]=>
int(7)
["entityType"]=>
string(16) "GalleryPhotoItem"
["onLoadHandlers"]=>
NULL
}
}
}
}
}
[2]=>
array(7) {
["file"]=>
string(58) "/var/www/gallery2/modules/core/classes/GalleryEntity.class"
["line"]=>
int(294)
["function"]=>
string(10) "saveEntity"
["class"]=>
string(14) "GalleryStorage"
["object"]=>
object(MySqlStorage)#6 (16) {
["_db"]=>
object(ADODB_mysqli)#7 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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(1)
["fetchMode"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#8 (0) {
}
["_errorMsg"]=>
bool(false)
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_nonTransactionalDb"]=>
object(ADODB_mysqli)#13 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#14 (0) {
}
["_errorMsg"]=>
string(60) "Duplicate entry 'f19a7678608b4a68319e89c897af138d' for key 1"
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_extras"]=>
object(GalleryStorageExtras)#9 (1) {
["_gs"]=>
object(MySqlStorage)#6 (16) {
["_db"]=>
object(ADODB_mysqli)#7 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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(1)
["fetchMode"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#8 (0) {
}
["_errorMsg"]=>
bool(false)
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_nonTransactionalDb"]=>
object(ADODB_mysqli)#13 (88) {
["databaseType"]=>
string(6) "mysqli"
["dataProvider"]=>
string(6) "native"
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["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(true)
["forceNewConnect"]=>
bool(true)
["poorAffectedRows"]=>
bool(true)
["clientFlags"]=>
int(0)
["substr"]=>
string(9) "substring"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["nameQuote"]=>
string(1) "`"
["optionFlags"]=>
array(1) {
[0]=>
array(2) {
[0]=>
int(5)
[1]=>
int(0)
}
}
["arrayClass"]=>
string(25) "ADORecordSet_array_mysqli"
["_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(8) "gallery2"
["host"]=>
string(9) "localhost"
["user"]=>
string(4) "root"
["password"]=>
string(0) ""
["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"]=>
string(24) "GalleryAdodbErrorHandler"
["cacheSecs"]=>
int(3600)
["memCache"]=>
bool(false)
["memCacheHost"]=>
NULL
["memCachePort"]=>
int(11211)
["memCacheCompress"]=>
bool(false)
["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"]=>
int(1)
["null2null"]=>
string(4) "null"
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
object(mysqli)#14 (0) {
}
["_errorMsg"]=>
string(60) "Duplicate entry 'f19a7678608b4a68319e89c897af138d' for key 1"
["_errorCode"]=>
bool(false)
["_queryID"]=>
bool(true)
["_isPersistentConnection"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["_transmode"]=>
string(0) ""
["databaseName"]=>
string(8) "gallery2"
}
["_extras"]=>
object(GalleryStorageExtras)#9 (1) {
["_gs"]=>
*RECURSION*
}
["_type"]=>
string(6) "mysqli"
["_username"]=>
string(4) "root"
["_password"]=>
string(0) ""
["_database"]=>
string(8) "gallery2"
["_hostname"]=>
string(9) "localhost"
["_isTransactional"]=>
bool(true)
["_schema"]=>
string(0) ""
["_tablePrefix"]=>
string(3) "g2_"
["_columnPrefix"]=>
string(2) "g_"
["_entityInfoCache"]=>
array(0) {
}
["_usePersistentConnections"]=>
bool(false)
["_isEmptyAllowedForNotNullColumn"]=>
bool(true)
["_serverInfo"]=>
string(10) "5.0.51a-24"
}
}
["_type"]=>
string(6) "mysqli"
["_username"]=>
string(4) "root"
["_password"]=>
string(0) ""
["_database"]=>
string(8) "gallery2"
["_hostname"]=>
string(9) "localhost"
["_isTransactional"]=>
bool(true)
["_schema"]=>
string(0) ""
["_tablePrefix"]=>
string(3) "g2_"
["_columnPrefix"]=>
string(2) "g_"
["_entityInfoCache"]=>
array(0) {
}
["_usePersistentConnections"]=>
bool(false)
["_isEmptyAllowedForNotNullColumn"]=>
bool(true)
["_serverInfo"]=>
string(10) "5.0.51a-24"
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
&object(GalleryPhotoItem)#16 (25) {
["width"]=>
int(120)
["height"]=>
int(120)
["mimeType"]=>
string(10) "image/jpeg"
["size"]=>
int(5790)
["canContainChildren"]=>
int(0)
["description"]=>
string(24) "Descriptionss from query"
["keywords"]=>
string(19) "Keywords from query"
["ownerId"]=>
int(6)
["renderer"]=>
NULL
["summary"]=>
string(18) "Summary from query"
["title"]=>
string(16) "title from query"
["viewedSinceTimestamp"]=>
int(1241088796)
["originationTimestamp"]=>
int(1241088796)
["pathComponent"]=>
string(5) "3.jpg"
["parentId"]=>
int(1983)
["id"]=>
int(2011)
["creationTimestamp"]=>
int(1241088796)
["isLinkable"]=>
int(1)
["linkId"]=>
NULL
["linkedEntity"]=>
NULL
["modificationTimestamp"]=>
int(1241428205)
["serialNumber"]=>
int(8)
["entityType"]=>
string(16) "GalleryPhotoItem"
["onLoadHandlers"]=>
NULL
["_persistentStatus"]=>
array(2) {
["flags"]=>
int(0)
["originalValue"]=>
array(23) {
["width"]=>
int(120)
["height"]=>
int(120)
["mimeType"]=>
string(10) "image/jpeg"
["size"]=>
int(5790)
["canContainChildren"]=>
int(0)
["description"]=>
string(12) "Descriptions"
["keywords"]=>
string(8) "Keywords"
["ownerId"]=>
int(6)
["renderer"]=>
NULL
["summary"]=>
string(7) "Summary"
["title"]=>
string(6) "Titles"
["viewedSinceTimestamp"]=>
int(1241088796)
["originationTimestamp"]=>
int(1241088796)
["pathComponent"]=>
string(5) "3.jpg"
["parentId"]=>
int(1983)
["id"]=>
int(2011)
["creationTimestamp"]=>
int(1241088796)
["isLinkable"]=>
int(1)
["linkId"]=>
NULL
["modificationTimestamp"]=>
int(1241424004)
["serialNumber"]=>
int(7)
["entityType"]=>
string(16) "GalleryPhotoItem"
["onLoadHandlers"]=>
NULL
}
}
}
}
}
[3]=>
array(7) {
["file"]=>
string(56) "/var/www/gallery2/modules/core/classes/GalleryItem.class"
["line"]=>
int(414)
["function"]=>
string(4) "save"
["class"]=>
string(13) "GalleryEntity"
["object"]=>
object(GalleryPhotoItem)#16 (25) {
["width"]=>
int(120)
["height"]=>
int(120)
["mimeType"]=>
string(10) "image/jpeg"
["size"]=>
int(5790)
["canContainChildren"]=>
int(0)
["description"]=>
string(24) "Descriptionss from query"
["keywords"]=>
string(19) "Keywords from query"
["ownerId"]=>
int(6)
["renderer"]=>
NULL
["summary"]=>
string(18) "Summary from query"
["title"]=>
string(16) "title from query"
["viewedSinceTimestamp"]=>
int(1241088796)
["originationTimestamp"]=>
int(1241088796)
["pathComponent"]=>
string(5) "3.jpg"
["parentId"]=>
int(1983)
["id"]=>
int(2011)
["creationTimestamp"]=>
int(1241088796)
["isLinkable"]=>
int(1)
["linkId"]=>
NULL
["linkedEntity"]=>
NULL
["modificationTimestamp"]=>
int(1241428205)
["serialNumber"]=>
int(8)
["entityType"]=>
string(16) "GalleryPhotoItem"
["onLoadHandlers"]=>
NULL
["_persistentStatus"]=>
array(2) {
["flags"]=>
int(0)
["originalValue"]=>
array(23) {
["width"]=>
int(120)
["height"]=>
int(120)
["mimeType"]=>
string(10) "image/jpeg"
["size"]=>
int(5790)
["canContainChildren"]=>
int(0)
["description"]=>
string(12) "Descriptions"
["keywords"]=>
string(8) "Keywords"
["ownerId"]=>
int(6)
["renderer"]=>
NULL
["summary"]=>
string(7) "Summary"
["title"]=>
string(6) "Titles"
["viewedSinceTimestamp"]=>
int(1241088796)
["originationTimestamp"]=>
int(1241088796)
["pathComponent"]=>
string(5) "3.jpg"
["parentId"]=>
int(1983)
["id"]=>
int(2011)
["creationTimestamp"]=>
int(1241088796)
["isLinkable"]=>
int(1)
["linkId"]=>
NULL
["modificationTimestamp"]=>
int(1241424004)
["serialNumber"]=>
int(7)
["entityType"]=>
string(16) "GalleryPhotoItem"
["onLoadHandlers"]=>
NULL
}
}
}
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
bool(true)
[1]=>
int(0)
}
}
[4]=>
array(7) {
["file"]=>
string(47) "/var/www/gallery2/gallery_edit/gallery_edit.php"
["line"]=>
int(326)
["function"]=>
string(4) "save"
["class"]=>
string(11) "GalleryItem"
["object"]=>
object(GalleryPhotoItem)#16 (25) {
["width"]=>
int(120)
["height"]=>
int(120)
["mimeType"]=>
string(10) "image/jpeg"
["size"]=>
int(5790)
["canContainChildren"]=>
int(0)
["description"]=>
string(24) "Descriptionss from query"
["keywords"]=>
string(19) "Keywords from query"
["ownerId"]=>
int(6)
["renderer"]=>
NULL
["summary"]=>
string(18) "Summary from query"
["title"]=>
string(16) "title from query"
["viewedSinceTimestamp"]=>
int(1241088796)
["originationTimestamp"]=>
int(1241088796)
["pathComponent"]=>
string(5) "3.jpg"
["parentId"]=>
int(1983)
["id"]=>
int(2011)
["creationTimestamp"]=>
int(1241088796)
["isLinkable"]=>
int(1)
["linkId"]=>
NULL
["linkedEntity"]=>
NULL
["modificationTimestamp"]=>
int(1241428205)
["serialNumber"]=>
int(8)
["entityType"]=>
string(16) "GalleryPhotoItem"
["onLoadHandlers"]=>
NULL
["_persistentStatus"]=>
array(2) {
["flags"]=>
int(0)
["originalValue"]=>
array(23) {
["width"]=>
int(120)
["height"]=>
int(120)
["mimeType"]=>
string(10) "image/jpeg"
["size"]=>
int(5790)
["canContainChildren"]=>
int(0)
["description"]=>
string(12) "Descriptions"
["keywords"]=>
string(8) "Keywords"
["ownerId"]=>
int(6)
["renderer"]=>
NULL
["summary"]=>
string(7) "Summary"
["title"]=>
string(6) "Titles"
["viewedSinceTimestamp"]=>
int(1241088796)
["originationTimestamp"]=>
int(1241088796)
["pathComponent"]=>
string(5) "3.jpg"
["parentId"]=>
int(1983)
["id"]=>
int(2011)
["creationTimestamp"]=>
int(1241088796)
["isLinkable"]=>
int(1)
["linkId"]=>
NULL
["modificationTimestamp"]=>
int(1241424004)
["serialNumber"]=>
int(7)
["entityType"]=>
string(16) "GalleryPhotoItem"
["onLoadHandlers"]=>
NULL
}
}
}
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
}
}
After the first occurance of an error there only helps cleaning the cache - if I wouldn't do that, i could not change any property on this photo. Thanks in advance, |
|
Posts: 7
After hard work debugging the script I have found an API called GalleryEmbed and after implementing it my script works. Check out the following script if you want to edit your galleries by an external application:
require_once('../embed.php'); //this file is part of each gallery2 installation and you'll find it in gallery2 root on filesystem /* * Initialize G2 (includes all necessary classes, * puts G2 into a state ready to process your calls) */ $ret = GalleryEmbed::init(array('fullInit' => true)); check($ret); /* Here go your G2 API calls */ list($ret, $user) = GalleryCoreApi::fetchUserByUsername("admin"); $gallery->setActiveUser($user); //get GalleryItem by itemId list ($ret, $item) = GalleryCoreApi::loadEntitiesById(2011, 'GalleryItem'); //2011 points to a photoitem list ($ret, $lockId) = GalleryCoreApi::acquireWriteLock($item->getId()); $values = array("title"=>"Titel", "summary"=>"Summary", "keywords"=>"Keywords", "description"=>"Description"); $item->setTitle($values['title']); $item->setSummary($values['summary']); $item->setKeywords($values['keywords']); $item->setDescription($values['description']); $ret = $item->save(); $ret = GalleryCoreApi::releaseLocks($lockId); /* //Here go your G2 API calls */ /* * At the end, commit the transaction by calling ::done() * or all changes made above will be rolled back automatically */ $ret = GalleryEmbed::done(); check($ret); function check($ret) { if ($ret) die($ret->getAsHtml()); }