db error install // failure to update

[Guest]

Tried running the upgrade.php script, and rec'd this error message:

"MySQL Error Occured

1060: Duplicate column name 'stockUpdated'

QUERY = ALTER TABLE `CubeCart_order_inv` ADD `stockUpdated` INT DEFAULT '0' NOT NULL"

This is the upgrade.php script, and if I comment out the $db->misc line, then it says updated, but still same problem persists, not carrying over the inventory description or price to the shopping cart for check out.

<?php

if(isset($_GET['upgrade'])){

include_once("includes/global.inc.php");

include_once("includes/functions.inc.php");

include_once("admin/includes/functions.inc.php");

include_once("classes/db.inc.php");

$db = new db();

#$db->misc("ALTER TABLE `".$glob['dbprefix']."CubeCart_order_inv` ADD `stockUpdated` INT DEFAULT '0' NOT NULL ;");

?>

Thank you. Your store has been updated. Please now delete this upgrade script.

<?php

} else {

?>

<p>Devellion Ltd provide this upgrade script without any warranty of any kind and by proceeding you are doing so entirely at your own risk. PLEASE TAKE A FULL BACK UP OF THE STORE AND ITS DATABASE BEFORE THIS IS DONE!</p>

<p align="center">&gt;&gt; <a href="?upgrade=1"><strong>UPGRADE NOW</strong></a> &lt;&lt; </p>

<?php

}

?>

Then, I removed the table from mysql data files, and install says it was successful. Having previous problelm in that inventory items and description are not being loaded into shopping cart, but the quantity (only the quantity is).

Have 3.0.1 still running for different site, different db, but same machine, and no problem there.

This was an upgrade from 3.0.1 to 3.0.2, and now shopping cart not working. Think maybe it is a permissions issue.

In Products portion of Admin, can only "Edit" first six items, then all other return message of "Failed to Update Category".

Any suggestions greatly appreciated.

Marc