[INPUT NEEDED] mass csv embed

ptsguy · 2012-08-22 15:26:24

only importing one at a time before quitting...can you please post a fix for this? I am trying to import some embed dumps today..bangbros,oyeachicks and have tried those two and several others and none going past one.

ptsguy · 2012-08-22 16:07:04

your $counter is not getting incremented for whatever reason...
I do not think that whole block is being executed...going to investigate further, but count is 0...never got incremented

if ($ignore === 1) {
                                        if (!isset($list[$count]['flv']) OR empty($list[$count]['flv']) OR
                                                !isset($list[$count]['title']) OR empty($list[$count]['title'])) {
                                                continue;
                                        }
                                }

                                        if (($method == 'flv' OR $method == 'hotlink') AND !isset($list[$count]['flv'])) {
                                                $error = 'Import method set to FLV Source (or FLV Hotlink) and flv source url not present in the CSV file!';
                                        }

                                        if ($thumb_method == 'generate' && !isset($list[$count]['flv'])) {
                                                $error = 'Thumb method set to Generate and FLV Source URL not present in the CSV file!';
                                        }

                                        if ($method == 'embed' && !isset($list[$count]['embed'])) {
                                                $error = 'Import method set to Embed and embed code not found in the CSV file!';
                                        }

                                        ++$count;
                                }
                        echo $count;
                                if ($error) {
                                $errors[] = $error;
                        }

ptsguy · 2012-08-22 16:23:44

for whatever reason your count is never incremented so the counter is stuck on 0 and only taking the 0 element of the $row array... for a temp fix I am incrementing count right after you call VArray::combine($ordering,row) and stick that inside of $list[$count]...

I've never been one to debug php code with an actual debugger so I wouldn't know where to start.. i can pick a syntax error from the cli or a 500 error from the apache logs...outside of that, this is a logic error and I'd need a debugger to step through it... I can't see it in putty, i've spent a little time this morning walking through the code and putting echos in.. also I added a check for tags that are seperated with ; instead of , to the get_tags function

 private function get_tags($title, $tags='')
        {
                if ($tags != '') {
                        if(strstr($tags,";"))
                                $tags = str_replace(";",",",$tags);
                        return prepare_tags($tags);
                }

                $title  = preg_replace('/[^A-Za-z0-9 ]+/', ' ', trim($title));
                $title  = preg_replace('/\s\s+/', ' ', $title);
                $tags   = array();
                $array  = explode(' ', $title);
                foreach ($array as $string) {
                        if (strlen($string) >= 4) {
                                $tags[] = $string;
                        }
                }

                return implode(',', $tags);
        }

have fun...its the counter though..

ptsguy · 2012-08-22 16:42:46

Query: INSERT INTO video_csv_imported SET unique_id = '194bcd426d5b86ef81b01297daad13b7', video_id = 31973
Error Message: Duplicate entry '31973' for key 'video_id'
Error Number: 1062

this gets tossed on dupes...

symtab · 2012-08-23 07:05:42

I will also debug this.

ptsguy · 2012-08-23 11:32:47

Lemme know if ya get it fixed, could really use a patch for this...

ptsguy · 2012-08-23 15:52:59

I got rid of that error, probably did it the wrong way, but I truncated the video_csv_imported table... I am bound to have some dupes now I am guessing.

RawrPorn · 2012-08-27 13:30:40

change:

Query: INSERT INTO video_csv_imported SET unique_id = '194bcd426d5b86ef81b01297daad13b7', video_id = 31973

to

Query: INSERT IGNORE INTO video_csv_imported SET unique_id = '194bcd426d5b86ef81b01297daad13b7', video_id = 31973

itll skip duplicate entries without error. used to use insert ignore when filtering large email lists.

symtab · 2012-09-14 05:31:41

The video_id should never be a duplicate (its generated for every video when its added, and its auto incrementing, so i dont know how you got to have a duplicate). Please email the CSV so i can also test.

mmpo · 2014-04-02 15:54:20

I have the same problem in 1.0.8 version how i can fix that?

symtab · 2014-04-03 05:14:46

Use the IGNORE for the mysql query. There shouldnt be any duplicates (for some reason its adding 2 entries for a video, which should never happen). I was not able to reproduce this. If you want you can me the CSV and i can test.

Adult Script Pro Community Forums

#1 2012-08-22 15:26:24

[INPUT NEEDED] mass csv embed

#2 2012-08-22 16:07:04

Re: [INPUT NEEDED] mass csv embed

#3 2012-08-22 16:23:44

Re: [INPUT NEEDED] mass csv embed

#4 2012-08-22 16:42:46

Re: [INPUT NEEDED] mass csv embed

#5 2012-08-23 07:05:42

Re: [INPUT NEEDED] mass csv embed

#6 2012-08-23 11:32:47

Re: [INPUT NEEDED] mass csv embed

#7 2012-08-23 15:52:59

Re: [INPUT NEEDED] mass csv embed

#8 2012-08-27 13:30:40

Re: [INPUT NEEDED] mass csv embed

#9 2012-09-14 05:31:41

Re: [INPUT NEEDED] mass csv embed

#10 2014-04-02 15:54:20

Re: [INPUT NEEDED] mass csv embed

#11 2014-04-03 05:14:46

Re: [INPUT NEEDED] mass csv embed

Board footer