osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

Purchase Without Account install??

This is a discussion on Purchase Without Account install?? within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; The install instructions say: STEP 3:Go into your server's backend and use a SQL tool such as PHPMYADMIN to run ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > osCommerce 2.2 Modification Help

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 06-25-2004, 04:32 PM
New Member
 
Join Date: May 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
dragon5
Default Purchase Without Account install??

The install instructions say:

STEP 3:Go into your server's backend and use a SQL tool such as PHPMYADMIN to run the following SQL scripts. Make sure you have backed up your database first:

ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id;
ALTER TABLE customers ADD INDEX (purchased_without_account);
INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1);
INSERT INTO configuration VALUES ('', 'Purchase Without Account', 'PWA_ON','true','Allow Customers to purchase without an account', 40, 1, '2003-04-08 13:07:44', '2003-04-08 12:10:51', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL;


Where exactly does this need to be installed to?? Root?
Database *****_osc4 running on localhost??
Never had the need for phpmyadmin until now. I don't have a clue!
Thanks
d5
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 06-25-2004, 06:33 PM
New Member
 
Join Date: Feb 2004
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
bleu
Default

Open PHPMYADMIN in your browser, if you have access to it. Click on the database you have installed for your store to select it.

Click on the SQL link. A text field form will be available. Paste the code in the box and click the GO button.

This will install and/or alter the tables in the proper location.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 06-25-2004, 06:42 PM
New Member
 
Join Date: Feb 2004
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
bleu
Default

If you are asking where to install PHPMYADMIN, here is a basic tutorial that will walk you throught the steps.

http://www.ubbcentral.com/resources/PhPMyAdmin.html
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #4  
Old 06-25-2004, 08:41 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 11,058
Thanks: 80
Thanked 348 Times in 327 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default

Or you can execute the above mysql commands from an SSH session on your server (if you have access).

From the command prompt, type: mysql and hit enter.

Then type : use *****_osc4 and hit enter (*****_osc4 is the name of your database)

Then type each of the above commands, one to a line and hit enter after each one.

__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates designed for osCMax 2. Loyalty discounts up to 30% off!
    Each purchase supports the osCMax project with much needed funds!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. Default multi server configuration for exceptional performance!

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #5  
Old 07-21-2004, 09:45 PM
red_fraggle's Avatar
Active Member
 
Join Date: Feb 2004
Location: wilmington, NC
Posts: 319
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 0
red_fraggle
Default

If you are running PLESK on your host, login to plesk, click the domain the database is on, click "databases", click the database in question from the list, click "DBwebadmin", this starts PHPMyadmin, once it loads, click the database name on the left navigation panel, click "SQL", click "browse" and select the SQL file your trying to insert. Make sure to backup your DB first.
__________________
Clifton Murphy CEO/CTO
Hyperactive Inc.
osCommerce hosting, OSCMAX hosting, osCommerce modification, and OSCMAX modification specialists!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
2 Problems-New Install: Broken Images/Purchase wo Account puggybelle osCMax v2 Installation issues 2 10-25-2005 03:22 PM
Purchase without account teddybear90 osCMax v1.7 General Mods Discussion 0 07-12-2005 04:25 AM
Purchase without an account not available? Sam_Iam osCMax v1.7 Discussion 3 12-06-2004 07:16 PM
purchase without account please jloyzaga osCMax v1.7 Discussion 1 11-12-2003 06:16 AM
purchase without account jloyzaga osCMax v1.7 Discussion 5 09-21-2003 09:47 AM


All times are GMT -8. The time now is 08:31 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax