updating a house of tomorrow - Updating gallery2

----- (mysql): SHOW TABLES ----- realpath(/usr/home/alexus/alexus/alexus.org/gallery-2.0-current/modules/core/classes/../../..) Binding text domain: modules_core - /usr/home/alexus/alexus/alexus.org/gallery-2.0-current/modules/core/locale file_exists(/usr/home/alexus/alexus/alexus.org/gallery2/g2data/versions.dat) file(/usr/home/alexus/alexus/alexus.org/gallery2/g2data/versions.dat, ) is_writeable(/usr/home/alexus/alexus/alexus.org/gallery-2.0-current/config.php) file_exists(/usr/home/alexus/alexus/alexus.org/gallery-2.0-current/modules/core/classes/Gallery Storage/../../../../modules/core/classes/Gallery Storage/Database Storage/schema/platform/mysql) opendir(/usr/home/alexus/alexus/alexus.org/gallery-2.0-current/modules/core/classes/Gallery Storage/../../../../modules/core/classes/Gallery Storage/Database Storage/schema/platform/mysql) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) closedir(Resource id #51) ----- (mysql): SHOW TABLES ----- ----- (mysql): SELECT g_name, g_major, g_minor FROM g2_Schema ----- fopen(/usr/home/alexus/alexus/alexus.org/gallery-2.0-current/modules/core/classes/Gallery Storage/../../../../modules/core/classes/Gallery Storage/Database Storage/schema/platform/mysql/R_Gallery Item Properties Map_1_0.sql, r, 0) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fclose(Resource id #54) mysql error: [1051: Unknown table 'g2_Item Properties Map'] in EXECUTE("DROP TABLE g2_Item Properties Map") ----- (mysql): DROP TABLE g2_Item Properties Map ----- 1051: Unknown table 'g2_Item Properties Map' ADODB_mysql._Execute(DROP TABLE g2_Item Properties Map, false) % line 833, file: php ADODB_mysql. My setup before the upgrade attempt: Gallery version = 2.0-beta-3 core 0.9.28 PHP version = 4.3.11 isapi Webserver = Microsoft-IIS/5.1 Database = mysqlt 5.0.6-beta-nt Toolkits = Archive Upload, Ffmpeg, Exif, Thumbnail, Image Magick, Net PBM Operating system = Windowx XP (with all updates) Browser = Internet Explorer 6 with all updates.

Execute(DROP TABLE g2_Item Properties Map) % line 1809, file: Database Storage.class My Sql Database Storage._execute Sql File(/usr/home/alexus/alexus/alexus.org/gallery-2.0-current/modules/c...) % line 1540, file: Database Storage.class My Sql Database Storage.configure Store(core) % line 343, file: Gallery Storage.class Gallery Storage.configure Store(core) % line 133, file: Gallery Module.class realpath(/usr/home/alexus/alexus/alexus.org/gallery-2.0-current/modules/core/classes/../../../) ---- Gallery URL (optional): Gallery version: gallery2 cvs Webserver (with version): apache2.x (latest release) Datatabase (with version): mysql-4.1.x (latest release) PHP version (eg 4.2.1): php-5.x (latest release) phpinfo URL (optional): Toolkit(s): netpbm, imagemigic, dcraw (all latest releases) Operating system: freebsd-5.x (latest release) Web browser/version: IE6 (latest release) G1 version (for migration bugs): 0.9.29 upgrade. please use phpmyadmin or any other mean to access your database and take a view at the entries of g2_schema delete the row with Item Properties Map if there is such a row. Note that I get 1 missing file when updating from CVS, but it shouldn't effect me as I'm running my SQL and not Oracle: Error (ERROR_STORAGE_FAILURE) : Error trying to load c:\Inetpub\wwwroot\WEBDOMAIN\Gallery\modules\core\classes\Gallery Storage/../../../../modules/core/classes/Gallery Storage/Database Storage/schema/platform/mysql/R_Gallery Item Properties Map_1_0in c:\Inetpub\wwwroot\WEBDOMAIN\Gallery\modules\core\classes\Gallery Storage\Database Storage.class at line 1813 (My Sql Database Storage::error) in c:\Inetpub\wwwroot\WEBDOMAIN\Gallery\modules\core\classes\Gallery Storage\Database Storage.class at line 1540 (My Sql Database Storage::_execute Sql File) in c:\Inetpub\wwwroot\WEBDOMAIN\Gallery\modules\core\classes\Gallery Storage.class at line 343 (My Sql Database Storage::configure Store) in c:\Inetpub\wwwroot\WEBDOMAIN\Gallery\modules\core\classes\Gallery Module.class at line 133 (Gallery Storage::configure Store) in c:\Inetpub\wwwroot\WEBDOMAIN\Gallery\upgrade\steps\Upgrade Core Module Step.class at line 80 (Core Module::install Or Upgrade) in c:\Inetpub\wwwroot\WEBDOMAIN\Gallery\upgrade\at line 177 (Upgrade Core Module Step::process Request) file_exists(C:\Programs\G2Data\cache\module/core/0/0/0.inc) fopen(C:\Programs\G2Data\cache\module/core/0/0/0.inc, rb, 0) fread(Resource id #28, 4096) fclose(Resource id #28) [1120862405] can't guarantee 300 -- extending!

anonymous and devel cvs work for me, just tested for you. oh and still dont have problem connecting to other's cvs.. Backup: Permission denied cvs checkout: cannot rewrite CVS/Entries.

updating gallery2-11

My solution was to use My SQL to search through each album, find the oldest picture, and update the album’s origination date to match the oldest picture. Since we are experimenting on your gallery database, obviously you want to back it up first.

Using my favorite My SQL interface, I crafted the following SQL statement to examine the problem: SELECT g_id AS album Id, g_title, g_origination Timestamp, ( SELECT MIN(g_origination Timestamp) FROM g2_Item INNER JOIN g2_Item Attributes Map ON g2_Item.g_id = g2_Item Attributes Map.g_item Id WHERE g_parent Sequence LIKE CONCAT( '%/', album Id, '/' ) ) AS oldest Picture FROM g2_Item INNER JOIN g2_Item Attributes Map ON g2_Item.g_id = g2_Item Attributes Map.g_item Id WHERE g_can Contain Children > 0 As you can see, many of the albums had pictures much older than the timestamp on the folder. If I have to tell you that, you are in over your head. This forced me to create a temporary table to hold the intermediate results, and then use those results to update the desired table.

Backup: Permission denied cvs checkout: cannot rewrite CVS/Entries. Backup: Permission denied cvs checkout: Updating gallery2/layouts/classic/locale/sv_SE cvs checkout: Updating gallery2/layouts/classic/locale/sv_SE/LC_MESSAGES cvs checkout: gallery2/layouts/classic/locale/sv_SE/LC_MESSAGES/layouts_is no longer in the repository cvs [checkout aborted]: cannot open CVS/Entries.

Log: Permission denied [email protected]:/home/alexus/alexus/alexus.orgthat seems to be a local problem. so i'm getin different error i dont see how this can be a local issue, since i was using same line and up untill this day have not had any problems connecting to your cvs server..

i can provide you with any future info you'd need from me...

Currently installed 0.9.27 New version 0.9.29 Stack Trace: Error (ERROR_STORAGE_FAILURE) : Error trying to load /usr/home/alexus/alexus/alexus.org/gallery-2.0-current/modules/core/classes/Gallery Storage/../../../../modules/core/classes/Gallery Storage/Database Storage/schema/platform/mysql/R_Gallery Item Properties Map_1_0in modules/core/classes/Gallery Storage/Database Storage.class at line 1813 (My Sql Database Storage::error) in modules/core/classes/Gallery Storage/Database Storage.class at line 1540 (My Sql Database Storage::_execute Sql File) in modules/core/classes/Gallery Storage.class at line 343 (My Sql Database Storage::configure Store) in modules/core/classes/Gallery Module.class at line 133 (Gallery Storage::configure Store) in upgrade/steps/Upgrade Core Module Step.class at line 80 (Core Module::install Or Upgrade) in upgrade/at line 177 (Upgrade Core Module Step::process Request) DEBUG WINDOW: file_exists(/usr/home/alexus/alexus/alexus.org/gallery2/g2data/cache/module/core/0/0/0.inc) fopen(/usr/home/alexus/alexus/alexus.org/gallery2/g2data/cache/module/core/0/0/0.inc, rb, 0) fread(Resource id #29, 4096) fclose(Resource id #29) [1120859304] can't guarantee 300 -- extending!

UPDATE g2_Entity INNER JOIN new Album Times ON g2_Entity.g_id = new Album Times.album Id SET g_creation Timestamp=oldest Picture, g_modification Timestamp=oldest Picture WHERE oldest Picture AND oldest Picture < g_creation Time Stamp; We also have to update the creation time stamps, which is the date actually displayed and permitted to be edited for the album. Running the above 4 statements in order produces the desired affect.

Preferably, these should be executed as a single entry to avoid the temporary table disappearing.

-------------------------------------------------------------------------------- (mysqlt): SHOW TABLES -------------------------------------------------------------------------------- realpath(c:\Inetpub\wwwroot\WEBDOMAIN\Gallery\modules\core\classes/../../..) Binding text domain: modules_core - c:\Inetpub\wwwroot\WEBDOMAIN\Gallery/modules/core/locale file_exists(C:\Programs\G2Data\versions.dat) file(C:\Programs\G2Data\versions.dat, ) is_writeable(c:\Inetpub\wwwroot\WEBDOMAIN\Gallery/config.php) -------------------------------------------------------------------------------- (mysqlt): SET AUTOCOMMIT=0 -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- (mysqlt): BEGIN -------------------------------------------------------------------------------- file_exists(c:\Inetpub\wwwroot\WEBDOMAIN\Gallery\modules\core\classes\Gallery Storage/../../../../modules/core/classes/Gallery Storage/Database Storage/schema/platform/mysql) opendir(c:\Inetpub\wwwroot\WEBDOMAIN\Gallery\modules\core\classes\Gallery Storage/../../../../modules/core/classes/Gallery Storage/Database Storage/schema/platform/mysql) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) readdir(Resource id #51) closedir(Resource id #51) -------------------------------------------------------------------------------- (mysqlt): SHOW TABLES -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- (mysqlt): SELECT g_name, g_major, g_minor FROM g2_Schema -------------------------------------------------------------------------------- fopen(c:\Inetpub\wwwroot\WEBDOMAIN\Gallery\modules\core\classes\Gallery Storage/../../../../modules/core/classes/Gallery Storage/Database Storage/schema/platform/mysql/R_Gallery Item Properties Map_1_0.sql, r, 0) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fgets(Resource id #54, 4096) feof(Resource id #54) fclose(Resource id #54) mysqlt error: [1051: Unknown table 'g2_itempropertiesmap'] in EXECUTE("DROP TABLE g2_Item Properties Map") -------------------------------------------------------------------------------- (mysqlt): DROP TABLE g2_Item Properties Map -------------------------------------------------------------------------------- 1051: Unknown table 'g2_itempropertiesmap' ADODB_mysqlt._Execute(DROP TABLE g2_Item Properties Map, false) % line 833, file: php ADODB_mysqlt.

7 Comments

  1. Instead of transferring the exemption without regard to payment of child support on time, some custodial parents agree to a transfer of the dependency exemption only if the other parent is current on child support payments by December 31 of each year. The cost of some private colleges and universities would bankrupt the average parent.

  2. If literally the only reason you are interested in me is because I'm fat, you might want to take a step back and get to know a bit about me first. When you tell me I'm not, what you are really saying is that despite my body size, I'm not all those horrible things you tend to associate with fatness.

  3. A couple of months ago, I was sitting at a bar minding my own business when the woman next to me did something strange.

  4. From the standpoint of anthropology and sociology, dating is linked with other institutions such as marriage and the family which have also been changing rapidly and which have been subject to many forces, including advances in technology and medicine.

Comments are closed.