Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › eCart Checkout Wizard Step 1 of 2: Database connection

eCart Checkout Wizard Step 1 of 2: Database connection

Thread began 1/29/2012 10:28 pm by mail393820 | Last modified 1/31/2012 8:25 am by Jason Byrnes | 1068 views | 3 replies |

1/29/2012 10:28 pm | #1 mail393820

eCart Checkout Wizard Step 1 of 2: Database connection

I have reached step 1 of 2: Store order summary in database. I have ticked the checkbox to create using preset: default. It has automatically selected my Connection: connSW but below says "This user does not have the necessary permissions to add/remove tables from the selected database. Update your database connection to specify a new user with edit privileges." Please help as I don't know how to proceed. Thanks in advance.

1/30/2012 11:02 am | #2 Jason ByrnesWebAssist

connect to the database directly using PHPMyAdmin or another MySQL GUI tool and execute the following SQL commands to create the tables:

CREATE TABLE `orders` (
  `OrderID` int(11) NOT NULL AUTO_INCREMENT,
  `OrderAmount` float DEFAULT NULL,
  `OrderShipName` varchar(100) DEFAULT NULL,
  `OrderShipAddress` varchar(100) DEFAULT NULL,
  `OrderShipAddress2` varchar(100) DEFAULT NULL,
  `OrderCity` varchar(50) DEFAULT NULL,
  `OrderState` varchar(50) DEFAULT NULL,
  `OrderZip` varchar(20) DEFAULT NULL,
  `OrderCountry` varchar(50) DEFAULT NULL,
  `OrderPhone` varchar(20) DEFAULT NULL,
  `OrderFax` varchar(20) DEFAULT NULL,
  `OrderShipping` float DEFAULT NULL,
  `OrderTax` float DEFAULT NULL,
  `OrderEmail` varchar(100) DEFAULT NULL,
  `OrderDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`OrderID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `orderdetails` (
  `DetailID` int(11) NOT NULL AUTO_INCREMENT,
  `DetailOrderID` int(11) DEFAULT NULL,
  `DetailProductID` int(11) DEFAULT NULL,
  `DetailName` varchar(250) DEFAULT NULL,
  `DetailPrice` float DEFAULT NULL,
  `DetailQuantity` int(11) DEFAULT NULL,
  PRIMARY KEY (`DetailID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

1/30/2012 9:42 pm | #3 mail393820

Thank you very much Jason. That worked a treat! Best wishes.

1/31/2012 8:25 am | #4 Jason ByrnesWebAssist

you're welcome, glad to hear it is working.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.