Member Avatar for IAuchmoody27

Warning: require_once(../../GrBx/cw3/admin/application.php) [function.require-once]: failed to open stream: No such file or directory in C:\xampp\htdocs\GrBx\cw3\admin\ProductForm.php on line 2

Fatal error: require_once() [function.require]: Failed opening required '../../GrBx/cw3/admin/application.php' (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\GrBx\cw3\admin\ProductForm.php on line 2

Can someone please explain this error message? I am using Cartweaver and I'm trying to change it in a way that I can add more fields to the product database. I've been working with cartweaver support to get as far as I've gotten. I'm just getting a fatal error as I try to open the productform in the admin section.

  • 4 Contributors
  • 57 Replies
  • 396 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Cartweaver

Recommended Answers

All 57 Replies

Member Avatar for CFROG

Make sure that this is the correct path to the application.php file and that the file actually exists in that location. ../../GrBx/cw3/admin/application.php <---------

It's looking for the the application.php file and it's not finding it. Some common reasons for this error are the filename is misspelled, the path to file is incorrect, or the file does not exist in that location.

commented: CFROG is very active in trying to help me. +1
Member Avatar for Viletung

Your code is looking for a file, but it (application.php) doesn't exists at the position it is looking for.

EDIT: Got beaten by CFROG.

Edited by Viletung because: n/a
Member Avatar for IAuchmoody27

Yeah, I was able to figure that it has something to do with that but application.php is and always has been the same and usually functions fine. It is still there and the path is right. What doesn't make sense is that those scripts have always worked fine and application.php is unrelated (as far as I can tell) to any of the changes I've made.

Member Avatar for CFROG

In some cases, especially with DreamWeaver saving your file to a different folder will update your links unless you tell it not to.

Try using this as your path: ../GrBx/cw3/admin/application.php

Member Avatar for IAuchmoody27

found my problem, my page is full of broken links...

Member Avatar for CFROG

Don't you just hate when that happens? 8-)

Edited by CFROG because: n/a
Member Avatar for IAuchmoody27

I fixed most of them, but I don't know how to fix this one...

<a href="../../GrBx/cw3/admin/ProductImageUpload.php?type=<?php echo($row_rsCWGetImageTypes["imgType_ID"]);?>&nextpage=3" title="Upload/Manage Images" onclick="showUpload(this); return false;">


if I do..

<a href="ProductImageUpload.php?type=<?php echo($row_rsCWGetImageTypes["imgType_ID"]);?>&nextpage=3" title="Upload/Manage Images" onclick="showUpload(this); return false;">

It still isn't working

Member Avatar for IAuchmoody27

<a href="ProductImageUpload.php?type=<?php echo($row_rsCWGetImageTypes["imgType_ID"]);?>&nextpage=3" title="Upload/Manage Images" onclick="showUpload(this); return false;"><img src="assets/images/folder.gif" width="16" height="16" border="0" /></a><img src="assets/images/delete.gif" alt="Remove image from product" onclick="document.getElementById('<?php echo($imageFieldName);?>').value=''">

Is there an extra <a> tag in here?

Member Avatar for CFROG

There doesn't seem to be. My best guess would be that it has something to with your onclick function.

Member Avatar for IAuchmoody27

Okay, everything in the broken links department is fixed.

Now, I have error reporting on, but it won't show me any errors. I still get stuck when trying to add a product, though.

When I try to add one, the screen goes white and there's a fatal error (that it fails to report) and when I try to update a product, as soon as I click update the page just refreshes with the old data. :(

Member Avatar for CFROG

Without seeing the code I don't know what to tell you about that one.

Member Avatar for IAuchmoody27

Here are the two .php files in question. Feel free to inspect.

<?php
error_reporting (E_ALL);
/* 
================================================================
Application Info: 
Cartweaver 2002 - 2007, All Rights Reserved.
Developer Info: 
	Application Dynamics Inc.
	1560 NE 10th
	East Wenatchee, WA 98802
	Support Info: http://www.cartweaver.com/go/phphelp

Cartweaver Version: 3.0.4  -  Date: 5/21/2007

================================================================
Name: CWProductAction.php
Description: All actions for the Product Form page are handled here.
================================================================
*/
$_GET["nextpage"] = (isset($_GET["nextpage"])) ? $_GET["nextpage"] : 1;
$_POST["nextpage"] = (isset($_POST["nextpage"])) ? $_POST["nextpage"] : $_GET["nextpage"];

/* =====  ADD PRODUCT and / or SKU  ===== */
/* [ START ] Add new Product */
if(isset($_POST["action"]) && $_POST["action"] == "AddProduct") {
	$addProductError = array();

	$query_rsCWCheckProductID = "SELECT product_MerchantProductID 
	FROM tbl_products 
	WHERE product_MerchantProductID = '" . $_POST["product_MerchantProductID"] . "'";
	$rsCWCheckProductID = $cartweaver->db->executeQuery($query_rsCWCheckProductID, "rsCWCheckProductID");
	$rsCWCheckProductID_recordCount = $cartweaver->db->recordCount;
	$row_rsCWCheckProductID = $cartweaver->db->db_fetch_assoc($rsCWCheckProductID);
	if($rsCWCheckProductID_recordCount != 0) {
		array_push($addProductError,"Product already exists, please enter a new Product ID");
	}else{
		/* Set Default Values for form fields for insert */
		$_POST["product_MerchantProductID"] = isset($_POST["product_MerchantProductID"]) ? $_POST["product_MerchantProductID"] : "NULL";
		$_POST["product_Name"] = isset($_POST["product_Name"]) ? $_POST["product_Name"] : "NULL";
		$_POST["product_Description"] = isset($_POST["product_Description"]) ? $_POST["product_Description"] : "NULL";
		$_POST["product_ShortDescription"] = isset($_POST["product_ShortDescription"]) ? $_POST["product_ShortDescription"] : "NULL";
		$_POST["product_Sort"] = isset($_POST["product_Sort"]) ? $_POST["product_Sort"] : "0";
		$_POST["product_OnWeb"] = isset($_POST["product_OnWeb"]) ? $_POST["product_OnWeb"] : "NULL";
		$_POST["product_Archive"] = isset($_POST["product_Archive"]) ? $_POST["product_Archive"] : "0";
		$_POST["product_shipchrg"] = isset($_POST["product_shipchrg"]) ? $_POST["product_shipchrg"] : "1";
		$_POST["product_style"] = isset($_POST["product_style"]) ? $_POST["product_style"] : "NULL";
		$_POST["product_l"] = isset($_POST["product_l"]) ? $_POST["product_l"] : "NULL";
		$_POST["product_w"] = isset($_POST["product_w"]) ? $_POST["product_w"] : "NULL";
		$_POST["product_d"] = isset($_POST["product_d"]) ? $_POST["product_d"] : "NULL";
		$_POST["product_board"] = isset($_POST["product_board"]) ? $_POST["product_board"] : "NULL";
		$_POST["product_grade"] = isset($_POST["product_grade"]) ? $_POST["product_grade"] : "NULL";
		$_POST["product_print"] = isset($_POST["product_print"]) ? $_POST["product_print"] : "NULL";
		$_POST["product_used"] = isset($_POST["product_used"]) ? $_POST["product_used"] : "NULL";
		
		$query_rsCW = sprintf("INSERT INTO tbl_products 
				(product_MerchantProductID, 
				product_Name, 
				product_Description, 
				product_ShortDescription,
				product_Sort, 
				product_OnWeb, 
				product_Archive, 
				product_shipchrg,
				product_taxgroupid,
				product_style
				product_l
				product_w
				product_d
				product_board
				product_grade
				product_print
				product_used)
		VALUES ('%s','%s','%s','%s',%d,%d,%d,'%s',%d,'%s','%s','%s','%s','%s','%s','%s','%s'
			)",$_POST["product_MerchantProductID"]
			,$_POST["product_Name"]
			,$_POST["product_Description"]
			,$_POST["product_ShortDescription"]
			,$_POST["product_Sort"]
			,$_POST["product_OnWeb"]
			,$_POST["product_Archive"]
			,$_POST["product_shipchrg"]
			,$_POST["product_taxgroupid"]
			,$_POST["product_style"]
			,$_POST["product_l"]
			,$_POST["product_w"]
			,$_POST["product_d"]
			,$_POST["product_board"]
			,$_POST["product_grade"]
			,$_POST["product_print"]
			,$_POST["product_used"]);
		$rsCW = $cartweaver->db->executeQuery($query_rsCW, "rsCW");
		
		/* Get our new autonumber ID for further inserts */
		$query_rsCWGetNewProdId = "SELECT product_ID 
		FROM tbl_products 
		WHERE product_MerchantProductID = '" . $_POST["product_MerchantProductID"] . "'";
		$rsCWGetNewProdId = $cartweaver->db->executeQuery($query_rsCWGetNewProdId, "rsCWGetNewProdId");
		$rsCWGetNewProdId_recordCount = $cartweaver->db->recordCount;
		$row_rsCWGetNewProdId = $cartweaver->db->db_fetch_assoc($rsCWGetNewProdId);

		/* Add Category */
		if(isset($_POST["product_Category_ID"])){		
			for($i=0; $i < count($_POST["product_Category_ID"]); $i++) {
				$query_updtCats = sprintf("INSERT INTO tbl_prdtcat_rel 
				(prdt_cat_rel_Product_ID, prdt_cat_rel_Cat_ID)
				VALUES (%d, %d)",$row_rsCWGetNewProdId["product_ID"],$_POST["product_Category_ID"][$i]);
				$updtCats = $cartweaver->db->executeQuery($query_updtCats, "updtCats");
			}
		}
	
			/* Add Secondary Category */
		if(isset($_POST["scndctgry_ID"])){		
			for($i=0; $i < count($_POST["scndctgry_ID"]); $i++) {
				$query_updtScndCats = sprintf("INSERT INTO tbl_prdtscndcat_rel
						(prdt_scnd_rel_Product_ID, prdt_scnd_rel_ScndCat_ID )
						VALUES (%d, %d)",$row_rsCWGetNewProdId["product_ID"],$_POST["scndctgry_ID"][$i]);
				$updtScndCats = $cartweaver->db->executeQuery($query_updtScndCats, "updtScndCats");
			}
		}

			/* Add Selected Product Options */
		if(isset($_POST["product_options"])){		
			for($i=0; $i < count($_POST["product_options"]); $i++) {
				$query_updtProductOptions = sprintf("INSERT INTO tbl_prdtoption_rel
					(optn_rel_Prod_ID, optn_rel_OptionType_ID)
					VALUES (%d, %d)",$row_rsCWGetNewProdId["product_ID"],$_POST["product_options"][$i]);
				$updtProductOptions = $cartweaver->db->executeQuery($query_updtProductOptions, "updtProductOptions");
			}
		}

		/* Add Image URLs */
		for($i=1; $i<=$_POST["imageCount"]; $i++) {
			if ($_POST["image$i"] != "") {
				$query_rs = sprintf("INSERT INTO tbl_prdtimages (
					prdctImage_ProductID,
					prdctImage_ImgTypeID,
					prdctImage_FileName,
					prdctImage_SortOrder
				) VALUES (%d, %d, '%s', 1)",
				$row_rsCWGetNewProdId["product_ID"]
				,$_POST["imageType$i"]
				,$_POST["image$i"]);
				$rs = $cartweaver->db->executeQuery($query_rs, "rs");
			} /* END if ($_POST["Image$i"]) != "") */
		}
		header("Location: " . $cartweaver->thisLocation . "?product_ID=" . $row_rsCWGetNewProdId["product_ID"] . "&nextpage=4&addsku=ADD#addsku"); 
		exit();
 	}/* END if(rsCheckProductID_recordCount != 0) { */
}/* END if(isset($_POST["AddProduct"])) { */
 
/* [ START ] Add new SKU  */
if (isset($_POST["addsku"])){
	/* Check to make sure the SKU_ID is unique */

	$query_rsCWCheckUniqueSKU = "SELECT SKU_MerchSKUID 
	FROM tbl_skus 
	WHERE SKU_MerchSKUID = '" . $_POST["SKU_MerchSKUID"] . "'";
	$rsCWCheckUniqueSKU = $cartweaver->db->executeQuery($query_rsCWCheckUniqueSKU, "rsCWCheckUniqueSKU");
	$rsCWCheckUniqueSKU_recordCount = $cartweaver->db->recordCount;
	$row_rsCWCheckUniqueSKU = $cartweaver->db->db_fetch_assoc($rsCWCheckUniqueSKU);

	if ($rsCWCheckUniqueSKU_recordCount != 0) {
		array_push($addSKUError,"SKU ID already exists. Please choose a different SKU ID.");
	}else{
		/* Set Default Form Values */
		$_POST["SKU_MerchSKUID"] = isset($_POST["SKU_MerchSKUID"]) ? $_POST["SKU_MerchSKUID"] : "NULL";
		$_POST["product_ID"] = isset($_POST["product_ID"]) ? $_POST["product_ID"] : "NULL";
		$_POST["SKU_Price"] = isset($_POST["SKU_Price"]) ? $_POST["SKU_Price"] : "NULL";
		$_POST["SKU_Weight"] = isset($_POST["SKU_Weight"]) ? $_POST["SKU_Weight"] : "0";
		$_POST["SKU_Stock"] = isset($_POST["SKU_Stock"]) ? $_POST["SKU_Stock"] : "0";
		$_POST["SKU_ShowWeb"] = isset($_POST["SKU_ShowWeb"]) ? $_POST["SKU_ShowWeb"] : "NULL";
		$_POST["SKU_Sort"] = isset($_POST["SKU_Sort"]) ? $_POST["SKU_Sort"] : "0";

		$query_rsCW = sprintf("INSERT INTO tbl_skus (SKU_MerchSKUID, SKU_ProductID, SKU_Price, SKU_Weight, SKU_Stock,
			SKU_ShowWeb, SKU_Sort) VALUES (
				'%s','%s','%s','%s','%s',%d,%d)",$_POST["SKU_MerchSKUID"],
				$_POST["product_ID"],
				$_POST["SKU_Price"],
				$_POST["SKU_Weight"],
				$_POST["SKU_Stock"],
				$_POST["SKU_ShowWeb"],
				$_POST["SKU_Sort"]);
		$rsCW = $cartweaver->db->executeQuery($query_rsCW, "rsCW");
		
		/* Get the autonumber to use for all further inserts */

		$query_rsCWNewSKUID = "SELECT SKU_ID 
		FROM tbl_skus 
		WHERE SKU_MerchSKUID = '" . $_POST["SKU_MerchSKUID"] . "'";
		$rsCWNewSKUID = $cartweaver->db->executeQuery($query_rsCWNewSKUID, "rsCWNewSKUID");
		$rsCWNewSKUID_recordCount = $cartweaver->db->recordCount;
		$row_rsCWNewSKUID = $cartweaver->db->db_fetch_assoc($rsCWNewSKUID);
	
		$newSKUID = $row_rsCWNewSKUID["SKU_ID"];
		/* Add SKU Options */
		/* Loop through the form collection and grab all of the chosen options */
		while (list($key,$val) = each($_POST)){
			if (substr($key, 0, 9) == "selOption" && $val != "choose"){
				$query_updtProductOptions = "INSERT INTO tbl_skuoption_rel
				(optn_rel_sku_id, optn_rel_Option_ID)
				VALUES ($newSKUID, $val)";
				$updtProductOptions = $cartweaver->db->executeQuery($query_updtProductOptions, "updtProductOptions");
			}
		}
		header("Location: " . $cartweaver->thisLocation . "?product_ID=" . $_GET["product_ID"] . "&addsku=ADD#addsku"); 
		exit();
	}/* END if ($rsCWCheckUniqueSKU_recordCount != 0) */
}/* END if (isset($_POST["addsku"])){ */
/* [ END ] Add new SKU  */

/* =====  DELETE PRODUCT and associated SKUs ===== */
 
/* [ START ] Delete PRODUCT */

if (isset($_POST["DeleteProduct"])){	
	/* Get any product SKUs */	
	$query_getSKUs = "SELECT SKU_ID
		FROM tbl_skus
		WHERE SKU_ProductID = " . $_POST["product_ID"];
	$getSKUs = $cartweaver->db->executeQuery($query_getSKUs, "getSKUs");
	$getSKUs_recordCount = $cartweaver->db->recordCount;
	$row_getSKUs = $cartweaver->db->db_fetch_assoc($getSKUs);

	/* If we have skus, delete them */
	if($getSKUs_recordCount != 0) {
		$skuL
<?php
require_once("application.php");
error_reporting (E_ALL);
/* 
================================================================
Application Info: 
Cartweaver 2002 - 2007, All Rights Reserved.
Developer Info: 
	Application Dynamics Inc.
	1560 NE 10th
	East Wenatchee, WA 98802
	Support Info: http://www.cartweaver.com/go/phphelp

Cartweaver Version: 3.0.8  -  Date: 4/12/2008

================================================================
Name: Product$_POST["php"]
Description: Displays details and administers SKUs for the selected product.
================================================================
*/
/* Set location for highlighting in Nav Menu */
$strSelectNav = "Products";
$displayUpSell = $_SESSION["showupsell"];

$_GET["nextpage"] = (isset($_GET["nextpage"])) ? $_GET["nextpage"] : 1;
$_POST["nextpage"] = (isset($_POST["nextpage"])) ? $_POST["nextpage"] : $_GET["nextpage"];

/* ===[ START ]====  Product Action  ========================= */
/*  
  Include contains all the action queries for Adding, Updating, 
  and Deleteing Product and SKU records
*/
if(!isset($addProductError)) {$addProductError = array();}
if(!isset($addSKUError)) {$addSKUError = array();}

require_once("CWValidateProduct.php");
if(count($addProductError) == 0 && count($addSKUError) == 0) {
	require("CWProductAction.php");
}
/* ===[ END ]=====  Product Action  ========================== */
/* Set Product_ID parameters */
if(!isset($_GET["product_ID"])) {$_GET["product_ID"] = 0;}
/* ===== ARCHIVE PRODUCT ===== */
/* [ START ] Archive Product */

if(isset($_GET["ArchiveProduct"])){
	$query_archiveProduct = "UPDATE tbl_products
			SET product_Archive = '1'
			WHERE product_ID=" . $_GET["product_ID"];
	$archiveProduct = $cartweaver->db->executeQuery($query_archiveProduct, "archiveProduct");
	header("Location: ProductActive.php?status=1"); 
	exit();
}

/* Set default params for the entire page */
$skuList = 0;
$hasOrders = 0;
$productHasOrders = 0;
$disabledText = "";
$formFocus = "'productform','product_Name'";

if($_GET["product_ID"] == 0) {
	$formFocus = "'productform','product_MerchantProductID'";
}elseif(isset($_GET["addsku"])) {
	$formFocus = "'addSKU','SKU_MerchSKUID'";
}
/* Reactivate Product */
if(isset($_POST["ReactivateProduct"]) && isset($_GET["product_ID"])){
	$query_rsCWArchiveProduct = sprintf("UPDATE tbl_products
	  SET product_Archive = '0'
	  WHERE product_ID = %d",$_GET["product_ID"]);
	$rsCWArchiveProduct = $cartweaver->db->executeQuery($query_rsCWArchiveProduct, "rsCWArchiveProduct");
	header("Location: ProductForm.php?product_ID=" . $_GET["product_ID"]);
	exit();
}

/* Get Product Data */
$query_rsCWGetProduct = sprintf("SELECT product_ID, product_MerchantProductID, 
product_Name, product_Description, 
product_ShortDescription, product_Sort, 
product_OnWeb, product_Archive, product_shipchrg, product_taxgroupid, product_style, product_l, product_w, product_d, product_board, product_grade, product_print, product_used
FROM tbl_products WHERE product_ID = %d",$_GET["product_ID"]);
$rsCWGetProduct = $cartweaver->db->executeQuery($query_rsCWGetProduct, "rsCWGetProduct");
$rsCWGetProduct_recordCount = $cartweaver->db->recordCount;
$row_rsCWGetProduct = $cartweaver->db->db_fetch_assoc($rsCWGetProduct);

/* Is this an archived product? */
$archived = $row_rsCWGetProduct["product_Archive"] == 1;

/* All Available Options */
$query_rsCWAllAvailOptions = "SELECT o.optiontype_ID, o.optiontype_Name, s.option_Name, s.option_Sort, s.option_ID 
FROM tbl_list_optiontypes o
INNER JOIN tbl_skuoptions s
ON o.optiontype_ID = s.option_Type_ID 
WHERE o.optiontype_Archive = 0 
AND s.option_Archive = 0 
ORDER BY o.optiontype_Name, s.option_ID";
$rsCWAllAvailOptions = $cartweaver->db->executeQuery($query_rsCWAllAvailOptions, "rsCWAllAvailOptions");
$rsCWAllAvailOptions_recordCount = $cartweaver->db->recordCount;
$row_rsCWAllAvailOptions = $cartweaver->db->db_fetch_assoc($rsCWAllAvailOptions);

/* Get Distinct Product Options */
$query_rsCWProductOptions = "SELECT DISTINCT optiontype_ID, optiontype_Name 
FROM tbl_list_optiontypes 
WHERE optiontype_Archive <> 1 
ORDER BY optiontype_Name";
$rsCWProductOptions = $cartweaver->db->executeQuery($query_rsCWProductOptions, "rsCWProductOptions");
$rsCWProductOptions_recordCount = $cartweaver->db->recordCount;
$row_rsCWProductOptions = $cartweaver->db->db_fetch_assoc($rsCWProductOptions);

/* Get Selected Product Options */
$query_rsCWRelProductOptions = sprintf("SELECT DISTINCT 
	o.optiontype_ID, 
	o.optiontype_Name, 
	s.option_ID, 
	s.option_Name, 
	s.option_Sort
FROM tbl_products p
	INNER JOIN tbl_prdtoption_rel r 
		ON p.product_ID = r.optn_rel_Prod_ID 
	INNER JOIN tbl_list_optiontypes o
		ON o.optiontype_ID = r.optn_rel_OptionType_ID
	INNER JOIN tbl_skuoptions s 	
		ON o.optiontype_ID = s.option_Type_ID	
WHERE p.product_ID= %s
ORDER BY 
	o.optiontype_Name, 
	s.option_Sort",$_GET["product_ID"]);
$rsCWRelProductOptions = $cartweaver->db->executeQuery($query_rsCWRelProductOptions, "rsCWRelProductOptions");
$rsCWRelProductOptions_recordCount = $cartweaver->db->recordCount;
$row_rsCWRelProductOptions = $cartweaver->db->db_fetch_assoc($rsCWRelProductOptions);

/* Get SKU Data */
$query_rsCWGetSKUs = sprintf("SELECT SKU_ID, SKU_MerchSKUID, 
SKU_ProductID, SKU_Price, SKU_Weight, 
SKU_Stock, SKU_ShowWeb, SKU_Sort
FROM tbl_skus 
WHERE SKU_ProductID = %s 
ORDER BY SKU_Sort",$_GET["product_ID"]);
$rsCWGetSKUs = $cartweaver->db->executeQuery($query_rsCWGetSKUs, "rsCWGetSKUs");
$rsCWGetSKUs_recordCount = $cartweaver->db->recordCount;
$row_rsCWGetSKUs = $cartweaver->db->db_fetch_assoc($rsCWGetSKUs);

/* Get Categories */
$query_rsCWCategories = "SELECT category_ID, 
category_Name, 
category_sortorder, 
category_archive 
FROM tbl_prdtcategories
ORDER BY category_sortorder, category_Name";
$rsCWCategories = $cartweaver->db->executeQuery($query_rsCWCategories, "rsCWCategories");
$rsCWCategories_recordCount = $cartweaver->db->recordCount;
$row_rsCWCategories = $cartweaver->db->db_fetch_assoc($rsCWCategories);

/* Get Secondary Categories */
$query_rsCWScndCategories = "SELECT scndctgry_ID, 
scndctgry_Name, 
scndctgry_Sort, 
scndctgry_Archive
FROM tbl_prdtscndcats
ORDER BY scndctgry_Sort, scndctgry_Name";
$rsCWScndCategories = $cartweaver->db->executeQuery($query_rsCWScndCategories, "rsCWScndCategories");
$rsCWScndCategories_recordCount = $cartweaver->db->recordCount;
$row_rsCWScndCategories = $cartweaver->db->db_fetch_assoc($rsCWScndCategories);

/* Get Related Categories */
$query_rsCWRelCategories = sprintf("SELECT prdt_cat_rel_Cat_ID 
FROM tbl_prdtcat_rel 
WHERE prdt_cat_rel_Product_ID = %d",$_GET["product_ID"]);
$rsCWRelCategories = $cartweaver->db->executeQuery($query_rsCWRelCategories, "rsCWRelCategories");
$rsCWRelCategories_recordCount = $cartweaver->db->recordCount;
$row_rsCWRelCategories = $cartweaver->db->db_fetch_assoc($rsCWRelCategories);

/* Get Related Secondary Categories */
$query_rsCWRelScndCategories = sprintf("SELECT prdt_scnd_rel_ScndCat_ID
FROM tbl_prdtscndcat_rel
WHERE prdt_scnd_rel_Product_ID = %d",$_GET["product_ID"]);
$rsCWRelScndCategories = $cartweaver->db->executeQuery($query_rsCWRelScndCategories, "rsCWRelScndCategories");
$rsCWRelScndCategories_recordCount = $cartweaver->db->recordCount;
$row_rsCWRelScndCategories = $cartweaver->db->db_fetch_assoc($rsCWRelScndCategories);


/* Variable for checking if a sku or product has previous orders */
if($rsCWGetSKUs_recordCount != 0) {
	$skuList = $cartweaver->db->valueList($rsCWGetSKUs, "SKU_ID");
}

$query_checkForOrders = "SELECT Count(ordersku_id) as AreThereSkus 
FROM tbl_orderskus WHERE orderSKU_SKU IN($skuList)";
$checkForOrders = $cartweaver->db->executeQuery($query_checkForOrders, "checkForOrders");
$checkForOrders_recordCount = $cartweaver->db->recordCount;
$row_checkForOrders = $cartweaver->db->db_fetch_assoc($checkForOrders);
if($row_checkForOrders["AreThereSkus"] != 0) {
	$productHasOrders = 1;
	$disabledText = ' disabled="disabled"';
}
		
/* Get Image Types */
$query_rsCWGetImageTypes = "SELECT * FROM tbl_list_imagetypes
ORDER BY imgType_SortOrder, imgType_Name";
$rsCWGetImageTypes = $cartweaver->db->executeQuery($query_rsCWGetImageTypes, "rsCWGetImageTypes");
$rsCWGetImageTypes_recordCount = $cartweaver->db->recordCount;
$row_rsCWGetImageTypes = $cartweaver->db->db_fetch_assoc($rsCWGetImageTypes);


/* Get Cross Sell List */
$query_rsCWGetUpsell = sprintf("SELECT p.product_ID, 
p.product_MerchantProductID, 
p.product_Name, 
u.upsell_ID
FROM tbl_products p
INNER JOIN tbl_prdtupsell u
ON p.product_ID = u.upsell_RelProdID
WHERE u.upsell_ProdID = %d
ORDER BY p.product_Name, p.product_MerchantProductID",$_GET["product_ID"]);
$rsCWGetUpsell = $cartweaver->db->executeQuery($query_rsCWGetUpsell, "rsCWGetUpsell");
$rsCWGetUpsell_recordCount = $cartweaver->db->recordCount;
$row_rsCWGetUpsell = $cartweaver->db->db_fetch_assoc($rsCWGetUpsell);

/* Get Tax Groups */
$query_rsCWTaxgroups = "SELECT *
FROM tbl_taxgroups
ORDER BY taxgroup_name ASC";
$rsCWTaxgroups = $cartweaver->db->executeQuery($query_rsCWTaxgroups, "rsCWTaxgroups");
$rsCWTaxgroups_recordCount = $cartweaver->db->recordCount;
$row_rsCWTaxgroups = $cartweaver->db->db_fetch_assoc($rsCWTaxgroups);


/* Set default form values */
if(!isset($_POST["product_MerchantProductID"])) {$_POST["product_MerchantProductID"] = '';}
if(!isset($_POST["product_Name"])) {$_POST["product_Name"] = $row_rsCWGetProduct["product_Name"];}
if(!isset($_POST["product_Sort"])) {$_POST["product_Sort"] = $row_rsCWGetProduct["product_Sort"];}
if(!isset($_POST["product_OnWeb"])) {$_POST["product_OnWeb"] = $row_rsCWGetProduct["product_OnWeb"];}
if(!isset($_POST["product_shipchrg"])) {$_POST["product_shipchrg"] = $row_rsCWGetProduct["product_shipchrg"];}
if(!isset($_POST["product_style"])) {$_POST["product_style"] = $row_rsCWGetProduct["product_style"];}
if(!isset($_POST["product_l"])) {$_POST["product_l"] = $row_rsCWGetProduct["product_l"];}
if(!isset($_POST["product_w"])) {$_POST["product_w"] = $row_rsCWGetProduc
Member Avatar for IAuchmoody27

yeah that's what I meant, so where would I look to find why it isn't there?

Member Avatar for IAuchmoody27

<a href="ProductForm.php?product_ID=<?php echo($row_rsCWProductsSearch["product_ID"]);?>" title="Edit <?php echo($row_rsCWProductsSearch["product_Name"]);?>"><?php echo($row_rsCWProductsSearch["product_Name"]);?></a>

is line 73 on ProductActive.php, for updating existing products.

<div id="lnSubProducts" class="lnSubMenu" style="display: none;">
<a href="ProductForm.php">–Add New</a>
<a href="ProductActive.php?status=0">–Active Products</a>
<a href="ProductActive.php?status=1">–Archived Products</a>
</div>

is line 25 in CWIncNav.php which is a submenu in AdminHome.php

attaching these 3 pages as well

<?php
require_once("application.php");
/*
================================================================
Application Info: 
Cartweaver 2002 - 2007, All Rights Reserved.
Developer Info: 
	Application Dynamics Inc.
	1560 NE 10th
	East Wenatchee, WA 98802
	Support Info: http://www.cartweaver.com/go/phphelp

Cartweaver Version: 3.0.0  -  Date: 4/21/2007

================================================================
Name: AdminHome.php
Description: Admin home page and dispalys basics sales reports.
================================================================
*/

$query_rsCWNewOrders = "SELECT o.order_Date
, o.order_ID
, o.order_Total 
FROM tbl_orders o
WHERE o.order_Date
BETWEEN '" . $_SESSION["LastLogin"] . "' AND '" . date("Y-m-d H:i:s") . "'
ORDER BY o.order_Date";
$rsCWNewOrders = $cartweaver->db->executeQuery($query_rsCWNewOrders, "rsCWNewOrders");
$rsCWNewOrders_recordCount = $cartweaver->db->recordCount;
$row_rsCWNewOrders = $cartweaver->db->db_fetch_assoc($rsCWNewOrders);

$query_rsCWToVerify = "SELECT o.order_Date, o.order_ID, o.order_Total 
FROM tbl_orders o
WHERE o.order_Status = 1
ORDER BY o.order_Date";
$rsCWToVerify = $cartweaver->db->executeQuery($query_rsCWToVerify, "rsCWToVerify");
$rsCWToVerify_recordCount = $cartweaver->db->recordCount;
$row_rsCWToVerify = $cartweaver->db->db_fetch_assoc($rsCWToVerify);

$query_rsCWToShip = "SELECT o.order_ID, o.order_Date, o.order_Total, s.shipmeth_Name
FROM tbl_shipmethod s INNER JOIN tbl_orders o ON s.shipmeth_ID = o.order_ShipMeth_ID
WHERE o.order_Status = 2
ORDER BY o.order_Date";
$rsCWToShip = $cartweaver->db->executeQuery($query_rsCWToShip, "rsCWToShip");
$rsCWToShip_recordCount = $cartweaver->db->recordCount;
$row_rsCWToShip = $cartweaver->db->db_fetch_assoc($rsCWToShip);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>CW Admin: Home</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="assets/admin.css" rel="stylesheet" type="text/css">
</head>
<body>
<?php include("CWIncNav.php");?>
<div id="divMainContent">
  <h1>Admin Home</h1>
  <h2>Order Status</h2>
  <h3>New Orders</h3>
<?php 
if($rsCWNewOrders_recordCount == 0) {
	echo("<p>No new orders");
}else{
	echo($rsCWNewOrders_recordCount . " new " . ($rsCWNewOrders_recordCount < 1) ? "orders" : "order");
}
echo(" since " . cwDateFormat($_SESSION["LastLogin"]) . "</p>");		
if($rsCWNewOrders_recordCount > 0){ ?>
  <table>
    <col />
    <col style="text-align: right;" />
    <col style="text-align: center;" />
    <tr>
      <th>Order Date</th>
      <th>Total</th>
      <th>View</th>
    </tr>
<?php 
	$recCounter = 0;
	do {
		?>
    <tr class="<?php cwAltRow($recCounter++);?>">
      <td><?php echo(date("Y-m-d H:i:s",strtotime($row_rsCWNewOrders["order_Date"])));?></td>
      <td><?php echo(cartweaverMoney($row_rsCWNewOrders["order_Total"]));?></td>
      <td><a href="OrderDetails.php?order_ID=<?php echo($row_rsCWNewOrders["order_ID"]);?>"><img src="assets/images/viewdetails.gif" alt="View Order" width="15" height="15" border="0"></a></td>
    </tr>
<?php  	
	}  while ($row_rsCWNewOrders = $cartweaver->db->db_fetch_assoc($rsCWNewOrders)); ?>
  </table>
<?php 
} ?>
  <h3>Unverified Orders</h3>
  <p><?php echo($rsCWToVerify_recordCount);
	echo ($rsCWToVerify_recordCount != 1) ? " orders" : " order";?></p>
<?php
if($rsCWToVerify_recordCount > 0) { ?>
  <table>
    <col />
    <col style="text-align: right;" />
    <col style="text-align: center;" />
    <tr>
      <th>Order Date</th>
      <th>Total</th>
      <th>View</th>
    </tr>
<?php 
	$recCounter = 0;
	do {
		?>
    <tr class="<?php cwAltRow($recCounter++);?>">
      <td><?php echo(cwDateFormat($row_rsCWToVerify["order_Date"]));?></td>
      <td><?php echo(cartweaverMoney($row_rsCWToVerify["order_Total"]));?></td>
      <td><a href="OrderDetails.php?order_ID=<?php echo($row_rsCWToVerify["order_ID"]);?>"><img src="assets/images/viewdetails.gif" alt="View Order" width="15" height="15" border="0"></a></td>
    </tr>
<?php 
	}  while ($row_rsCWToVerify = $cartweaver->db->db_fetch_assoc($rsCWToVerify)); ?>
  </table>
<?php 
} ?>
  <h3>Orders to ship</h3>
  <p><?php echo($rsCWToShip_recordCount . (($rsCWToShip_recordCount != 1) ? " orders" : " order"));?></p>
<?php
if($rsCWToShip_recordCount > 0) { ?>
  <table>
    <col />
    <col style="text-align: right;" />
    <col />
    <col style="text-align: center;" />
    <tr>
      <th>Order Date</th>
      <th>Total</th>
      <th>Ship Method</th>
      <th>View</th>
    </tr>
<?php 
	$recCounter = 0;
	do {
	?>
    <tr class="<?php cwAltRow($recCounter++);?>">
      <td><?php echo(cwDateFormat($row_rsCWToShip["order_Date"]));?></td>
      <td><?php echo(cartweaverMoney($row_rsCWToShip["order_Total"]));?></td>
      <td><?php echo($row_rsCWToShip["shipmeth_Name"]);?></td>
      <td><a href="OrderDetails.php?order_ID=<?php echo($row_rsCWToShip["order_ID"]);?>"><img src="assets/images/viewdetails.gif" alt="View Order" width="15" height="15" border="0"></a></td>
    </tr>
<?php  	
	}  while ($row_rsCWToShip = $cartweaver->db->db_fetch_assoc($rsCWToShip)); ?>
  </table>
<?php 
} ?>
</div>
</body>
</html>
<?php
cwDebugger($cartweaver);
?>
<script language="JavaScript" type="text/javascript" src="assets/global.js"></script>
<?php
function debugLinks(){
	global $cartweaver;
	$cartlinksDebugger = "<a href=\"" . $cartweaver->thisPageName;
	$debuggerQS = "";
	foreach($_GET as $key=>$val) {
		if($key != "debug") {
			if($debuggerQS != "") $debuggerQS .= "&amp;";
			$debuggerQS .= $key . "=" . $val;
		}
	}
	$cartlinksDebugger .= ($debuggerQS == "") ? "?" : "?$debuggerQS&";
	$cartlinksDebugger .= "debug=" . $_SESSION["StorePassword"];
	$cartlinksDebugger .= "\">&#8211;Debugger " . $cartweaver->debugger  . "</a>";
	return $cartlinksDebugger;
}
?>
<div id="divHelp" style="float: right; margin-right: 10px;">
	<a href="helpfiles/AdminHelp.php?helpFileName=<?php echo($cartweaver->thisPageName);?>" target="_blank"> <img src="assets/images/cwContextHelp.gif" alt="Get Help" width="16" height="16" align="absmiddle"></a>
</div>
<div id="leftNav">
<div id="divLogo"><a href="AdminHome.php"><img src="assets/images/logo.gif" alt="Cartweaver Logo" width="168" height="87" border="0" id="imgLogo" /></a></div>
	<a href="javascript:;" id="lnProducts" onclick="dwfaq_ToggleOMaticClass(this,'lnProducts','leftNavOpen');dwfaq_ToggleOMaticDisplay(this,'lnSubProducts');return document.MM_returnValue" class="leftNav">Products</a>
	<div id="lnSubProducts" class="lnSubMenu" style="display: none;">
		<a href="ProductForm.php">&#8211;Add New</a>
		<a href="ProductActive.php?status=0">&#8211;Active Products</a>
		<a href="ProductActive.php?status=1">&#8211;Archived Products</a>
	</div>
	
	<a href="javascript:;" class="leftNav" id="lnOrders" onclick="dwfaq_ToggleOMaticClass(this,'lnOrders','leftNavOpen');dwfaq_ToggleOMaticDisplay(this,'lnSubOrders');return document.MM_returnValue">Orders</a>
	<div id="lnSubOrders" class="lnSubMenu" style="display: none;">
		<a href="Orders.php">&#8211;Search By Date</a>
		<?php echo($_SESSION["ShipStatusMenu"]);?>
	</div>
	
	<a href="javascript:;" class="leftNav" id="lnCustomers" onclick="dwfaq_ToggleOMaticClass(this,'lnCustomers','leftNavOpen');dwfaq_ToggleOMaticDisplay(this,'lnSubCustomers');return document.MM_returnValue">Customers</a>
 	<div id="lnSubCustomers" class="lnSubMenu" style="display: none;">
		<a href="Customers.php">&#8211;Customer Search</a>
	</div>
	
		<a href="javascript:;" class="leftNav" id="lnCategories" onclick="dwfaq_ToggleOMaticClass(this,'lnCategories','leftNavOpen');dwfaq_ToggleOMaticDisplay(this,'lnSubCategories');return document.MM_returnValue">Categories</a>
 	<div id="lnSubCategories" class="lnSubMenu" style="display: none;">
		<a href="ListCategories.php">&#8211;Main</a>
		<a href="ListScndCategories.php">&#8211;Secondary</a>
	</div>
	
	<a href="javascript:;" class="leftNav" id="lnOptions" onclick="dwfaq_ToggleOMaticClass(this,'lnOptions','leftNavOpen');dwfaq_ToggleOMaticDisplay(this,'lnSubOptions');return document.MM_returnValue">Options</a>
	<div id="lnSubOptions" class="lnSubMenu" style="display: none;">
		<a href="Options.php">&#8211;Add New</a>
		<?php echo($_SESSION["OptionsMenu"]);?>
	</div>

	<a href="javascript:;" class="leftNav" id="lnDiscounts" onclick="dwfaq_ToggleOMaticClass(this,'lnDiscounts','leftNavOpen');dwfaq_ToggleOMaticDisplay(this,'lnSubDiscounts');return document.MM_returnValue">Discounts</a>
 	<div id="lnSubDiscounts" class="lnSubMenu" style="display: none;">
		<a href="DiscountDetails.php">&#8211;Add Discount</a>
		<a href="ListDiscounts.php?DiscountView=1">&#8211;Active Discounts</a>
		<a href="ListDiscounts.php?DiscountView=0">&#8211;Archived Discounts</a>
	</div>
	<a href="javascript:;" class="leftNav" id="lnShippingTax" onclick="dwfaq_ToggleOMaticClass(this,'lnShippingTax','leftNavOpen');dwfaq_ToggleOMaticDisplay(this,'lnSubShippingTax');return document.MM_returnValue">Shipping/Tax</a>
	<div id="lnSubShippingTax" class="lnSubMenu" style="display: none;">
		<a href="ShipMethods.php">&#8211;Shipping Methods</a>
		<a href="ShipRange.php">&#8211;Shipping Range</a>
		<?php if($_SESSION["TaxSystem"] != "Groups") {
			echo('<a href="ShipStateProv.php">&#8211;Tax/Ship Extension</a>');
		}else{ ?>
		<a href="ShipStateProv.php">&#8211;Tax/Ship Extension</a>
		<a href="ListTaxGroups.php">&#8211;Tax Groups</a>
		<a href="ListTaxRegions.php">&#8211;Tax Regions</a>
		<?php } /* END if($_SESSION["TaxSystem"] != "Groups") */ ?>
	</div>
	
	<a href="javascript:;" class="leftNav" id="lnSettings" onclick="dwfaq_ToggleOMaticClass(this,'lnSettings','leftNavOpen');dwfaq_ToggleOMaticDisplay(this,'lnSubSettings');return document.MM_returnValue">Store Settings</a>
	<div id="lnSubSettings" class="lnSubMenu" style="display: none;">
		<a href="ListAdminUsers.php">&#8211;Admin Users</a>
		<a href="ListCountry.php">&#8211;Countries</a>
		<a href="ListCreditCard.php">&#8211;Credit Cards</a>
		<a href="ListShipStatus.php">&#8211;Ship/Order Status</a>
		<?php if(isset($_SESSION["AccessLevel"]) && $_SESSION["AccessLevel"] == 'superadmin') {
			/* Show the config list page */
			echo('<a href="ListConfigGroups.php">&#8211;Config Groups</a>');
		}
		$query_rsCWNavConfigGroups = "SELECT configgroup_name, configgroup_id 
		FROM tbl_configgroup";
		if(!isset($_SESSION["AccessLevel"]) || $_SESSION["AccessLevel"] != 'superadmin') {
			$query_rsCWNavConfigGroups .= " WHERE configgroup_showmerchant = 1";
		}
		$query_rsCWNavConfigGroups .= " ORDER BY configgroup_sort, configgroup_name";
		$rsCWNavConfigGroups = $cartweaver->db->executeQuery($query_rsCWNavConfigGroups, "rsCWNavConfigGroups");
		$rsCWNavConfigGroups_recordCount = $cartweaver->db->recordCount;
		$row_rsCWNavConfigGroups = $cartweaver->db->db_fetch_assoc($rsCWNavConfigGroups);

		$recCounter = 0;
		do {
			echo('<a href="ConfigSettings.php?id=' . $row_rsCWNavConfigGroups["configgroup_id"] . '">&#8211;' . $row_rsCWNavConfigGroups["configgroup_name"] . '</a>');
		} while ($row_rsCWNavConfigGroups = $cartweaver->db->db_fetch_assoc($rsCWNavConfigGroups)); 
		// Show debug link to super admin
		if(isset($_SESSION["AccessLevel"]) && $_SESSION["AccessLevel"] == 'superadmin') {
			echo(debugLinks());
		}
		 ?>
	</div>
	
	<?php if($_SESSION["CompanyEmail"] == "support@cartweaver.com") {?>
	<p class="smallprint"><strong>Please change your <a href="ConfigSettings.php?id=3">company email</a>. It is currently set to the Cartweaver default value.</strong></p>
	<?php } /* END if($_SESSION["CompanyEmail"] == "support@cartweaver.com") */ 
	
	$siteRoot = $cartweaver->thisLocation;
	$siteRoot = str_replace("cw3/admin/". $cartweaver->thisPageName,"",$siteRoot);
?>
	<p class="smallprint"><a href="<?php echo($siteRoot);?>">Back to store</a></p>
<div id="logOut">
<form name="theFrom" method="post" action="<?php echo($cartweaver->thisLocation . "?logout=true");?>">
  <input type="submit" name="Submit" value="Log Out" class="formButton">
</form>
</div>
</div>
<?php if(isset($strSelectNav)) { 
	echo("<script type=\"text/javascript\">\n");
	echo("<!--\n");
	echo("dwfaq_ToggleOMaticClass(this,'ln$strSelectNav','leftNavOpen');\n");
	echo("dwfaq_ToggleOMaticDisplay(this,'lnSub$strSelectNav');\n");
	echo("-->\n");
	echo("</script>\n");
}
?>
<?php
require_once("application.php");
if(isset($_GET["status"])) {
	$archived = $_GET["status"] == "1";
}else{
	$archived = false;
}
/* 
================================================================
Application Info: 
Cartweaver 2002 - 2007, All Rights Reserved.
Developer Info: 
	Application Dynamics Inc.
	1560 NE 10th
	East Wenatchee, WA 98802
	Support Info: http://www.cartweaver.com/go/phphelp

Cartweaver Version: 3.0.0  -  Date: 4/21/2007

================================================================
Name: ProductActive.php
Description: Display a list of Active Products
================================================================
*/

/* Set location for highlighting in Nav Menu */
$strSelectNav = "Products";

/* Reactivate Product */
if(isset($_GET["ReactivateProduct_ID"])){
	$query_rsCWArchiveProduct = "UPDATE tbl_products
	  SET product_Archive = '0'
	  WHERE product_ID = " . $_GET["ReactivateProduct_ID"];
	$rsCWArchiveProduct = $cartweaver->db->executeQuery($query_rsCWArchiveProduct, "rsCWArchiveProduct");
	header("Location: ProductForm.php?product_ID=" . $_GET["ReactivateProduct_ID"]);
	exit();
}
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>CW Admin: Product List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="assets/admin.css" rel="stylesheet" type="text/css">
</head>
<body>

<?php include("CWIncNav.php");?>

<div id="divMainContent">
 <?php 
require("CWProductSearch.php");

if($rsCWProductsSearch_recordCount != 0){ 
	echo($pagingLinks);?>
    <h1>Product List <?php if($archived) {echo("* Archived products *");}?></h1>
    <table>
      <tr>
        <th>Product ID</th>
        <th>Name</th>
        <th>Photo</th>
        <th>On Web</th>
        <th>Edit</th>
      </tr>
<?php
	$recCounter = 0;
	do {
		$imageSRC = cwGetImage($row_rsCWProductsSearch["product_ID"], 1);
    	?>
        <tr class="<?php cwAltRow($recCounter++);?>">
          <td align="center"><?php echo($row_rsCWProductsSearch["product_MerchantProductID"]);?></td>
          <td><a href="ProductForm.php?product_ID=<?php echo($row_rsCWProductsSearch["product_ID"]);?>" title="Edit <?php echo($row_rsCWProductsSearch["product_Name"]);?>"><?php echo($row_rsCWProductsSearch["product_Name"]);?></a></td>
          <td align="center"><a href="ProductForm.php?product_ID=<?php echo($row_rsCWProductsSearch["product_ID"]);?>"><?php echo(cwDisplayImage($row_rsCWProductsSearch["product_ID"], 1, $row_rsCWProductsSearch["product_Name"]));?></a></td>
		  <td align="center"><input name="checkbox" type="checkbox" class="formCheckbox" value="checkbox" disabled<?php if($row_rsCWProductsSearch["product_OnWeb"] == 1){echo(" checked");}?>></td>
          <td align="center"><?php if($archived) {
		  echo('[<a href="' . $cartweaver->thisPage . "?ReactivateProduct_ID=" . $row_rsCWProductsSearch["product_ID"] . '">Reactivate</a>]');
		  }else{
		  ?><a href="ProductForm.php?product_ID=<?php echo($row_rsCWProductsSearch["product_ID"]);?>"><img src="assets/images/edit.gif" alt="Edit <?php echo($row_rsCWProductsSearch["product_Name"]);?>" width="15" height="15" border="0"></a>
		  <?php } // END if($archived) ?></td>
        </tr>
      <?php } while ($row_rsCWProductsSearch = $cartweaver->db->db_fetch_assoc($rsCWProductsSearch)); ?>
    </table>
<?php echo($pagingLinks);
  }else{
 	echo("<p><strong>No Matches Found</strong></p>");
 }?>
</div>
</body>
</html>
<?php
cwDebugger($cartweaver);
?>
Member Avatar for IAuchmoody27

$imageFolder = "../../"

is this my issue? line 553 in productform.php

Member Avatar for CFROG

Try changing it to ../

Member Avatar for IAuchmoody27

By the way, thanks for responding so much, I appreciate it.

Member Avatar for CFROG

I was assuming that have a folder specified for your images. Just in case you don't you will have to tell it where to look. ../../some_folder

Member Avatar for IAuchmoody27

I don't think that's my issue, I think the problem lies in ProductAction.php

Member Avatar for CFROG

This needs to stay the way that is now that I look at it $imageFolder = "../../" I'm having a hard time following what is supposed to be doing what in the code. There is a lot there. So the problem is that you are getting a blank page, what should be happening on that page if it was working?

Member Avatar for IAuchmoody27

in productform.php you see that there are 5 pages or tables. 1: general, 2: descriptions, 3: pictures, 4: SKU, 5: Upsells. The first three pages are filled out together and then it updates the product. The blank page happens when making a new product, (I think it actually adds it to the database after page 3, and then it would move on to the SKUs) the page goes white instead of moving to page 4.

Alternatively, if I try to UPDATE an existing product (it uses the same page: productform.php) then no matter which page I use or which element I try to change, as soon as I click update it just refreshes the page with the old info.

Member Avatar for CFROG

Looks like the reason for the issue with page 4 is because the product is not actually making it into the database. Page 4 is conditional.

<?php if($rsCWGetProduct_recordCount != 0) { ?>
	<div id="page4">

The record count is obviously zero, now to figure out why it's not adding the product to the db.

Edited by CFROG because: n/a
Member Avatar for IAuchmoody27

Indeed! :)

thanks for sheding light on that, I'll keep looking into it, any other help would be appreciated

thanks!

Member Avatar for CFROG

On the CWProductAction page change line 90 to this and try again to add a product.

Line 90 : Change to

,$_POST["product_used"])or die(mysql_error());

This will give us a heads up of what is going on with the INSERT query, if anything.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.