cant upload more than 100 sub id's at a time

defelice

New member
Nov 23, 2009
1,225
28
0
texas
I used to be able to upload hundreds of sub-ids at a time with no issue. recently i havent been able to upload more than 100 or my prosper will 500 internal error. I have to update a few thousand sub-ids a day which ends up taking 1-2 hours per day at this rate... any ideas?
 


If you can't fix the Prosper issue just use Ubot. It would take probably 5 minutes to code up something that takes a .txt file of subids and manually enters them in 50 at a time.
 
If you can't fix the Prosper issue just use Ubot. It would take probably 5 minutes to code up something that takes a .txt file of subids and manually enters them in 50 at a time.

well its not even that.. each upload takes 50-100 sub id's at a time and takes 2-4 minutes each upload.

@iliketurtles, yeah, im switching to a dedi after my buy is completed... in the mean time i'm trying to find what the issue is, as its never been this slow.. memory/cpu levels arent being taxed.
 
oh.. and ill offer someone some pocket change to get in and help me 1 on 1 if possible... pretty desperate as im trying to optimize a buy among other things right now...
 
that sounds like a sever/sql setting issue from my non-educated/technical standpoint.

I've regularly banged in hundreds (dunno exact) subids and it's never taken a long time at all.

Are you into high 7 or 8 figures of subids on that account? Once I cross 7 figures shit gets bad real quickly.
 
I haven't used Prosper in a while, but can't you just go into the DB with phpmyadmin or something and import them manually? It even has a really easy import CSV feature, so you should be able to make a text file and import it there as long as you know what table the subids are in.

Other than that, turn on error reporting and see what the problem is. It might just be the script timing out, in which case increasing the PHP execution time in your server config would work great.
 
that sounds like a sever/sql setting issue from my non-educated/technical standpoint.

I've regularly banged in hundreds (dunno exact) subids and it's never taken a long time at all.

Are you into high 7 or 8 figures of subids on that account? Once I cross 7 figures shit gets bad real quickly.

im in the low 7 figures... maybe dump the database full of sub ids?

I haven't used Prosper in a while, but can't you just go into the DB with phpmyadmin or something and import them manually? It even has a really easy import CSV feature, so you should be able to make a text file and import it there as long as you know what table the subids are in.

Other than that, turn on error reporting and see what the problem is. It might just be the script timing out, in which case increasing the PHP execution time in your server config would work great.

nothing is logging in any error logs. would you happen to know if the 202_clicks table is where the sub-id's are stored? anyone else?

i cant install migrate to a new server or install on a new domain because i have a buy going... honestly open to paying someone to help me fix this
 
Dump the tables, that should put it back to normal.

I run into the same problem when I go over 1 mil clicks