Exporting Users still unresolved (SOLVED)

THoTH · Beginner Joined: May 15, 2008 Posts: 13

Hi..

Looks like great software, so I installed it today. Spent most of the day working out why it stops exporting users at 3000 or thereabouts. Forum threads discussed possible solutions, none were applicable. Any ideas ?

I just tried again, and it prompted me that my version was out of date, so downloaded and extracted all the new files, uploaded them, now it won't store the relative and actual paths or the cookie details and user ID, it blanks those areas when I submit. They're valid though.

Not checked the database to see if they're being written, and I'm still getting reminded that I haven't updated?

Hi Smile

Sorry for the semi rant there, details are 7.6 security patched Raven etc.

Hope you can help Smile

AdBot

THoTH · Beginner Joined: May 15, 2008 Posts: 13

Just an update, the version check messages have now gone, and it is now storing the paths correctly in the database. But the user export stops on average around 3000 users. Sometimes it's 2800 sometimes 3300, but roughly 3000 is the most common figure it stops at without errors. I've about 6,300 users.

The standalone is working without hitch, I've imported some pics from coppermine etc without problem, although I did note if I selected too many albums the same thing happens as with the export, it just stops so far through, no error messages or anything.

I've the latest integration, and the latest gallery installed. Does anyone have a script that will move the user data over without this export script?

Ansolon · Beginner Joined: Apr 11, 2003 Posts: 7

it can be related with your php timeout limit in the server. I did successfully export more than 60 000 users before, howeever now I have some problems that it stops 62 000 while exporting. php timeout limit increasing didnt solve my problem, but it can solve yours.

Ansolon · Beginner Joined: Apr 11, 2003 Posts: 7

if it didnt help also make this

go to /html/modules/gallery/admin/export.php

find
$gallery->guaranteeTimeLimit(300);

change with

$gallery->guaranteeTimeLimit(900);

Ansolon · Beginner Joined: Apr 11, 2003 Posts: 7

my last message again solved my problem too I successfully export 85000 users.

THoTH · Beginner Joined: May 15, 2008 Posts: 13

I'll give those suggestions a try, thank you very much indeed. I only have about 6000 users and it sticks half way, so not sure it will be a php time setting, maybe its php's upload limit, which I brought down a while back.

Thanks again, if it works I'll let you know. Very Happy

dari

THoTH wrote: › I'll give those suggestions a try, thank you very much indeed. I only have about 6000 users and it sticks half way, so not sure it will be a php time setting, maybe its php's upload limit, which I brought down a while back.

Thanks again, if it works I'll let you know. Very Happy

the upload limit wouldn't matter here as you're not transferring files to the server. it's the timeout that matters. it could also be a database issue (ie, too many queries at once and it bogs down).
_________________

THoTH · Beginner Joined: May 15, 2008 Posts: 13

Thanks for the help guys, I turned safe mode off to begin with and it worked straight away ! Turned it back on again, and all works well. Sorry to take so long to get back to you, I've been busy with my new gallery. Laughing