65k images, 400 albums to import

mombos

Joined: 2005-01-04
Posts: 49

Posted: Wed, 2006-09-20 21:56

Hello all

i always seem to set myself the hard tasks, i have 65k images and 400 albums to import into G2 from 1.5.1

when i start the import of one of the albums which has 1048 photo's in it, it gets to about 350 and gives me the following error
1226 User 'XXXX' has exceeded the 'max_updates' resource (current value: 20000)
(i have inputted XXXX for my mysql db name for this post)

i am using the import module which comes with gallery2.

i am using version 2.0.2 because its the only version which works 100% with zen-cart.

i have looked at the upload from local server option, but i am unsure if this makes a copy of my G1 albums or moves it from the original directory, can anyone answer me this?

i need to get all these albums imported keeping the directory structure, can anyone give me some hints/tips on how i am going to get it done.

Thanks

G2 URL (optional): www.a-w-p.com/gallery
G2 version: 2.0.2
G1 URL (optional): wwww.a-w-p.com/gallery2
G1 version: 1.5.1
G1 character set:
PHP memory limit:
upload_max_filesize 10M
post_max_size 8M
--
Gallery version = 2.0.2 core 1.0.0.2
PHP version = 4.3.11 apache
Webserver = Servage.net Cluster (Enhanced Apache)
Database = mysql 4.0.26-standard
Toolkits = ArchiveUpload, ImageMagick, SquareThumb, Gd
Operating system = Linux node1.c2 2.4.20-28.8smp #1 SMP Thu Dec 18 12:25:21 EST 2003 i686
Browser = Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)

---

PHP version (e.g. 4.3.11):
PHPInfo Link (see FAQ):
Webserver (e.g. Apache 1.3.33):
Database (e.g. MySql 4.0.11):
Activated toolkits (e.g. NetPbm, GD):
Operating system (e.g. Linux):
Browser (e.g. Firefox 1.0):

mindless

Joined: 2004-01-04
Posts: 8601

Posted: Wed, 2006-09-20 23:11

maybe your webhost has set some limit on how much DB activity can occur in a single request.. i haven't seen a message like that before. if that's the case, not much you can do but import in smaller chunks.. if you hit this with a single album, then.. ?

g2-zencart has a G2.1 release.. http://codex.gallery2.org/index.php/Gallery2:Modules:zencart

add from server does copy the images.. but you get just the images, no other data from G1 like captions.

mombos

Joined: 2005-01-04
Posts: 49

Posted: Wed, 2006-09-20 23:16

i am not too bothered about captions as the guy who's site it is doesnt use them at all, just uploads and people buy the images,

so if i use the upload file from server it will not move them just make a copy? and leave the original as it was?

just need to keep the old site running until i get this 100% working.

I wonder if i transfer my database to another server where i can control the limits if that will make any difference, ill give that a go in the morning.

i may look into that i didnt realise there was a 2.1 mod now, - spent alot of time on 2.0.2 already so ill have to see how much better 2.1 is than 2.0.2

Thanks

Rob

mombos Joined: 2005-01-04 Posts: 49	Posted: Wed, 2006-09-20 21:56
	Hello all i always seem to set myself the hard tasks, i have 65k images and 400 albums to import into G2 from 1.5.1 when i start the import of one of the albums which has 1048 photo's in it, it gets to about 350 and gives me the following error 1226 User 'XXXX' has exceeded the 'max_updates' resource (current value: 20000) (i have inputted XXXX for my mysql db name for this post) i am using the import module which comes with gallery2. i am using version 2.0.2 because its the only version which works 100% with zen-cart. i have looked at the upload from local server option, but i am unsure if this makes a copy of my G1 albums or moves it from the original directory, can anyone answer me this? i need to get all these albums imported keeping the directory structure, can anyone give me some hints/tips on how i am going to get it done. Thanks G2 URL (optional): www.a-w-p.com/gallery G2 version: 2.0.2 G1 URL (optional): wwww.a-w-p.com/gallery2 G1 version: 1.5.1 G1 character set: PHP memory limit: upload_max_filesize 10M post_max_size 8M -- Gallery version = 2.0.2 core 1.0.0.2 PHP version = 4.3.11 apache Webserver = Servage.net Cluster (Enhanced Apache) Database = mysql 4.0.26-standard Toolkits = ArchiveUpload, ImageMagick, SquareThumb, Gd Operating system = Linux node1.c2 2.4.20-28.8smp #1 SMP Thu Dec 18 12:25:21 EST 2003 i686 Browser = Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) --- PHP version (e.g. 4.3.11): PHPInfo Link (see FAQ): Webserver (e.g. Apache 1.3.33): Database (e.g. MySql 4.0.11): Activated toolkits (e.g. NetPbm, GD): Operating system (e.g. Linux): Browser (e.g. Firefox 1.0):
	XUser login Username: * Password: * Create new account Request new password
mindless Joined: 2004-01-04 Posts: 8601	Posted: Wed, 2006-09-20 23:11
	maybe your webhost has set some limit on how much DB activity can occur in a single request.. i haven't seen a message like that before. if that's the case, not much you can do but import in smaller chunks.. if you hit this with a single album, then.. ? g2-zencart has a G2.1 release.. http://codex.gallery2.org/index.php/Gallery2:Modules:zencart add from server does copy the images.. but you get just the images, no other data from G1 like captions.

mombos Joined: 2005-01-04 Posts: 49	Posted: Wed, 2006-09-20 23:16
	i am not too bothered about captions as the guy who's site it is doesnt use them at all, just uploads and people buy the images, so if i use the upload file from server it will not move them just make a copy? and leave the original as it was? just need to keep the old site running until i get this 100% working. I wonder if i transfer my database to another server where i can control the limits if that will make any difference, ill give that a go in the morning. i may look into that i didnt realise there was a 2.1 mod now, - spent alot of time on 2.0.2 already so ill have to see how much better 2.1 is than 2.0.2 Thanks Rob

65k images, 400 albums to import

XUser login