Days and Days of work then bamn - errors all over - I shared cache for two installs

claidig

Joined: 2009-02-22
Posts: 2
Posted: Thu, 2012-10-04 09:38

I am really crossing my fingers on someone being able to help me with my own stupidity :(
Short Version:
Created a site with gallery2
Copied entire site to another domain/directory but didn't change the cache folder location

Had both sites up and was editing them both at same time...started getting weird errors.

I really want to keep all files, URLS, plugins and galleries but there is no users or comments etc. to worry about.

I would like to empty databse if possible but not sure what's stored there or how to do it.

Started to try and fix it...stopped and though I better get help.

Thank you very much.

--------------------------------
Full More Detailed Version
--------------------------------

I tend to make long posts so I bolded the cliff notes...I can un do that if it bothers anyone.

I created a site with Wordpress and Gallery 2 a few years ago with all the bells and whistles I wanted...I am talking days of work (only because I suck..lol) and now I am afraid I made a critical error.

After I got my site A the way I wanted I went ahead and copied over it to another domain, site B...
I changed the DB settings in the config for site B, ran the installer and all was good (so it seemed).

Last night I had to make a bunch of changes on BOTH sites and didn't know the cache directory was still being shared (saw that just now in config file)....so data would go in it for one site then when I would go fiddle with the other site and I would be pulling mixed random data from the shared cache directory (I am pretty sure this is what has happened).

Now I am getting errors...session data lost...all sorts of weird things on both sites. Looks like enity ID's can either anything so sometime I try to pull an image when it says it's a user ID, that sort of thing.

About the sites:
Site A has galleries that I would like to keep...Site B has no galleries.
But Both sites have many modified templates...all over the place from plugins, functions, styles, .tpl files etc.

What I have done so far after finding out about my idiocy...
I have just now changed the cache path on the two config files and made their own folders.
I put the same data in each of them (a copy of what was in the shared cache) and ran the updater on the site with the galleries.
It ran and the galleries I want are there but I am sure it's still messed up in the DB or cache.

I tried running installer for Site B and looks like it's not working.
Warning: in_array() [function.in-array]: Wrong datatype for second argument in /home/claidig/domain.com/gallery2/modules/core/classes/Gallery.class on line 651

My main question(s)
!. Can I somehow keep all my modified files and clean up the DB, maybe start all the rows back to empty.


2. If I do this can I pull the galleries first so I can import them after I clean it up...including titles, URLS, etc. since I just got search engines hitting it.

My System Info (should be the same on both installs):
Gallery URL = http://www.domain.com/gallery2/main.php
Gallery version = 2.3.1 core 1.3.0.1
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.17 cgi-fcgi
Webserver = Apache
Database = mysqli 5.1.39-log, lock.system=database
Toolkits = ArchiveUpload, Ffmpeg, Getid3, ImageMagick, jpegtran, LinkItemToolkit, NetPBM, Thumbnail, Gd, SquareThumb
Acceleration = none/900, none/900
Operating system = Linux nashira 2.6.32.36-hardened #9 SMP Tue Mar 29 09:29:20 PDT 2011 x86_64
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)
Rows in GalleryAccessMap table = 8
Rows in GalleryAccessSubscriberMap table = 696
Rows in GalleryUser table = 4
Rows in GalleryItem table = 689
Rows in GalleryAlbumItem table = 46
Rows in GalleryCacheMap table = 0

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2012-10-04 11:40

1st stop using site B
2nd head to site A.com/gallery2/lib/support and clear all the caches
3rd create a new g2data directory for site B and re-install directing to its own DB and g2data
4th check site A for errors

-s
________________________________
All New jQuery Minislideshow for G2/G3