easy populate - error

[jloyzaga]

just downloaded the file and did a test upload and got this message - Any Ideas?
Warning: move_uploaded_file(/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog//temp/EP2003Sep18-2210.txt): failed to open stream: Permission denied in /home/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog/admin/easypopulate_functions.php on line 32

Warning: move_uploaded_file(): Unable to move '/var/tmp/phpXqHJkR' to '/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog//temp/EP2003Sep18-2210.txt' in /home/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog/admin/easypopulate_functions.php on line 32


File uploaded.
Temporary filename: /var/tmp/phpXqHJkR
User filename: EP2003Sep18-2210.txt
Size: 100219

Warning: file(/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog//temp/EP2003Sep18-2210.txt): failed to open stream: No such file or directory in /home/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog/admin/easypopulate.php on line 720

Warning: Invalid argument supplied for foreach() in /home/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog/admin/easypopulate.php on line 738

you have one two many slashes before //temp, you will have to edit your admin/easypopulate.php file. if your fail to solve it with editing this file just check your admin/includes/configure.php file has the correct values.

[jloyzaga]

Originally Posted by Anonymous

you have one two many slashes before //temp, you will have to edit your admin/easypopulate.php file. if your fail to solve it with editing this file just check your admin/includes/configure.php file has the correct values.

// **** Temp directory ****
// if you changed your directory structure from stock and do not have /catalog/temp/, then you'll need to change this accordingly.
//
$tempdir = "/temp/";
$tempdir2 = "temp/";

Is this where you think the //temp is wrong?

The config looks ok.

[jloyzaga]

Removed the "/" before temp for $tempdir, now I get

Warning: move_uploaded_file(/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog/temp/EP2003Sep18-2109.txt): failed to open stream: Permission denied in /home/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog/admin/easypopulate_functions.php on line 32

Warning: move_uploaded_file(): Unable to move '/var/tmp/phpMC1FFr' to '/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog/temp/EP2003Sep18-2109.txt' in /home/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog/admin/easypopulate_functions.php on line 32


File uploaded.
Temporary filename: /var/tmp/phpMC1FFr
User filename: EP2003Sep18-2109.txt
Size: 69286

Warning: file(/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog/temp/EP2003Sep18-2109.txt): failed to open stream: No such file or directory in /home/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog/admin/easypopulate.php on line 720

Warning: Invalid argument supplied for foreach() in /home/hsphere/local/home/arkmusic/arkmusic.com.au/arkms2/catalog/admin/easypopulate.php on line 738

I have stock MS2 no image mods. I installed EP commented out the extra images in ep.php Now I get this error

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE products SET products_price="5" ,products_im

UPDATE products SET products_price="5" ,products_image="" ,products_weight="0" ,products_tax_class_id="" ,products_date_available= "9/19/2003 9:45" ,products_date_added= "0000-00-00 00:00:00" ,products_last_modified=CURRENT_TIMESTAMP ,products_quantity="0" ,manufacturers_id=NULL , products_status=0 WHERE (products_id = "54")UPDATE products SET products_price="5" ,products_image="" ,products_weight="0" ,products_tax_class_id="" ,products_date_available= "9/19/2003 9:45" ,products_date_added= "0000-00-00 00:00:00" ,products_last_modified=CURRENT_TIMESTAMP ,products_quantity="0" ,manufacturers_id=NULL , products_status=0 WHERE (products_id = "54")


here is that section of code...any help would be very appreciated as I have been working on this for about 6 hours

$query = 'UPDATE products
SET
products_price="'.$v_products_price.
'" ,products_image="'.$v_products_image;

// unmcomment these lines if you are running the image mods

$query .= //. $v_products_mimage . '", "'
//. $v_products_bimage . '", "'
//. $v_products_subimage1 . '", "'
//. $v_products_bsubimage1 . '", "'
//. $v_products_subimage2 . '", "'
//. $v_products_bsubimage2 . '", "'
//. $v_products_subimage3 . '", "'
//. $v_products_bsubimage3 . '", "'


$query .= '" ,products_weight="'.$v_products_weight.
'" ,products_tax_class_id="'.$v_tax_class_id.
'" ,products_date_available= ' . $v_date_avail .
' ,products_date_added= ' . $v_date_added .
' ,products_last_modified=CURRENT_TIMESTAMP
,products_quantity="'.$v_products_quantity.
'" ,manufacturers_id='.$v_manufacturer_id.
' , products_status='.$v_db_status . '
WHERE
(products_id = "'. $v_products_id . '")';

$result = tep_db_query($query);
}

I solved the problem...

[michael_s]

Guest, It would be nice if you shared your solution... don't be selfish now...

[jloyzaga]

Could anyone explain my problem (excluding the obvious iq issue and the social habits etc).
What I did was downloaded the "complete" EP from a stock ms2 install and then tried to upload it again.
Is it something stupid like "you've already got these in there you fool" issue? I cannot see that in the errors, looks like real issues.

Could someone decipher what those messages mean?

Joe

I wish I could tell you....I have several different sites using different versions, I just kept switching until it worked. I have no idea what I did, all I know is it worked....

[michael_s]

Notes dammit! Keep Notes!

Oh well, I am glad you randomly fixed it!