synchronization cache and database

You should never delete or add images from or to, or otherwise directly interact with, your g2data folder.

Now that you have done this, your options are:

1. The easy way is to ask your host to restore that folder from their backup archives and then delete the album from within G2.
2. A more difficult way is to find out which images were in that album, recreate them and then delete the album from within G2. The creation can be a small jpg file of anything which you then duplicate and rename to match the original file names. You can use something like www.waybackmachine.org to go back to see what the album contained site was like before the deletion.
3. The hard way is to get a dump of all current Item IDs and then go through your database and manually delete any record that isn't in that list.

To get a dump of the items ids, take the code below and put it into your theme.tpl near the bottom just before the {g->debug}. It should list all the item ids of items within each album. Type them into excel, sort the list and delete duplicates. (IMPORTANT: Add item id '0' to your list ... i.e. do not delete item id '0')

{if $theme.pageType == 'album'}
	{if count($theme.children)}
		{foreach from=$theme.children item=child}
			<div>{$child.id}</div>
		{/foreach}
	{/if}
{/if}

Remove the code once you are done ... also remove whatever malware it is that Google says your site is distributing (http://google.com/safebrowsing/diagnostic?tpl=safari&site=twilightersitalia.com&hl=en-us)

If you can't navigate the site at all, then options 1 or 2 are about all I can think of that you can do.

--
dakanji.com

Nice one.

This assumes the user knows the Item ids of the missing items so will need to be combined with Option 3 above.

I suppose it could be expanded to recurse through the albums get the current ids, compare this with a list of those in the db and delete the extras.

OP will have to do this or hire someone to write this up for him. Hopefully he will post the resulting script here for possible pushing into the lib/support scripts.
--
dakanji.com

Cool.

Taking a quick look at it though, I think you may need to amend it a bit so that the HTML runs first and the user can input the path to G2.

At the moment, it is referencing global gallery and the configs in config.php as well as embed.php but can't know where these are located.

Structure probably should be a form asking for the path to G2 and then run "init(path_to_g2);" so that you can "require once path_to_g2 . embed.php;"

Also not sure where user will input specific id.

Well done all the same.

--
dakanji.com

Ha, I see ... Wasn't aware.
Great work

--
dakanji.com

I also tried to put the code of Dayo in theme.tpl, but when I go to the gallery it shows only a blank page with Error...

and so the problem is: why the gallery is down?? we've already done the restore of the backup in the database...

Restoring the database has no relevance to your issue which is that you manually deleted a folder. This is why your gallery is down.

If you go back and read through this thread, you will see that no one recommended restoring the database as a solution.

Run the script to fix the problem.
--
dakanji.com

I've never run it on a site that is down.
You'll need to fix the STORAGE_FAILURE first.
It is a database error.

I'm wondering if changing line 39 of missingObjectFix.php to:
$ret = GalleryEmbed::init(array('fullInit'=>false));
would help.

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

oh my god, I didn't understand anything @.@

the script with the change doesn't work at all.

I'm searching in waybackmachine but there isn't the the last day with the folder that we deleted, it was the 21th June, but the waybackmachine stops at 30th April ç_ç

I think your problem goes beyond simply deleting that folder. As a last throw of the dice, recreate an empty version of the folder directly in location in g2data it was before and try running the script.

If this doesn't work then you probably have to get a new installation.

• Create a new folder and copy all your old g2 files into it
• Download a new copy of G2 to your webspace
• Install the new G2 and create all your albums in G2 except the one you deleted since you don't want it anymore. You can look at the structure in g2data/albums.
• use the add from server feature to repopulate them from your old g2data folder (again this has to be done in G2 ... remember you should not directly add or remove folders from g2data - the option above is an exception to fix a problem.

--
dakanji.com

The folder you deleted. Try to recreate it (empty) in the same location it was before deletion and then rerun the script.

If this doesn't work, and it is only a slim chance, try to rebuild the gallery with a new installation as described.

--
dakanji.com

my latest version v.0.6 skips the loading of any template info, so should connect to your gallery.
simply edit line 13 with your password and upload to your gallery root directory...

I just deleted an album directory on my test gallery and the script fixed it no problem.

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

Sorry, that's the same database error as before.
Do you have a database backup from this morning, before your host did your restore? Does your host have one from earlier today?

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

I think you should restore the most recent backup.
Your gallery was accessible before your host restored for you correct?

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

kiucci
Put back that last backup of your database (03 August) and do not change or restore the database again.
Run the script after and see.

Wayne
I believe there is probably something else beyond the album deletion going on with his gallery.
The way to absolutely solve this would probably be to use customised version of G2 functions with error trapping.
I.E., an attempt to init gallery which traps ids that generate storage failure errors without stopping. These ids can then be deleted from the db.

--
dakanji.com

run the upgrader
twilightersitalia.com/gallery/upgrade

specifically step 2 system checks

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

Do you have access to server error logs?
If not, ask your host for clues in the logs pertaining to your gallery.

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

I can see just the most recent error logs and about the gallery there is only this typw of error:

[Mon Aug 09 16:44:02 2010] [error] [client 207.46.204.177] ModSecurity: Warning. Pattern match "msn(?:bot|ptc)" at REQUEST_HEADERS:User-Agent. [file "/etc/apache/modsecurity/modsecurity_crs_55_marketing.conf"] [line "17"] [id "910008"] [msg "MSN robot activity"] [severity "NOTICE"] [hostname "www.twilightersitalia.com"]

not too many? XD just 24560 photos ç_ç

you think I can insert the record??

You can try:

DROP TABLE IF EXISTS `g2_User`;
CREATE TABLE IF NOT EXISTS `g2_User` (
  `g_id` int(11) NOT NULL,
  `g_userName` varchar(32) NOT NULL,
  `g_fullName` varchar(128) default NULL,
  `g_hashedPassword` varchar(128) default NULL,
  `g_email` varchar(255) default NULL,
  `g_language` varchar(128) default NULL,
  `g_locked` int(1) default '0',
  PRIMARY KEY  (`g_id`),
  UNIQUE KEY `g_userName` (`g_userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `g2_User` (`g_id`, `g_userName`, `g_fullName`, `g_hashedPassword`, `g_email`, `g_language`, `g_locked`) VALUES (5, 'guest', 'Guest', 'U7T4b19b16ff9d1f6e1e22b686394e8d4c42', NULL, NULL, 0),
(6, 'Admin', 'Gallery Administrator', 'A3gs01c022fdf6d2e82d99866eea3ce1064d', 'youremail@youremail.com', NULL, 0);

Adjust the email address in the above insert. Then you'll have to use the password recovery if we get your gallery backup.

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

If he does this, he will lose all his user records
--
dakanji.com

You need to find a backup of your db from working g2 installation on your site and load the missing tables. If not available, You can try running suprsidr's sql and then adding blank versions of the others. Most likely, you will need to reinstall.

Filezilla has sftp (secure ftp). Your host may not permit you access this way though ... you need to ask.

BTW. If you or your staff have spyware that is broadcasting your ftp password to some hacker in Siberia, they already have your new one already.

Change it again today and tomorrow and the day after .... until each machine has been throughly scanned. After that, change it every week or at least frequently. Your guys probably log in at home sometimes and God only knows what they have on their home computers.

--
dakanji.com

ok I found a working backup and restored it, and now the gallery and your script work (I just want to say that Aruba said he had restored the same backup that I restored today -.- ), but only for the admin; for the users it shows "Closed for working"...

I run the script for the album where was the folder that we have deleted, but nothing changed...