Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do I make a sql table?


Tsuri Japan

Recommended Posts

I'm trying to add a better version of the customer admin layout but in the contrib it says just add customer_notes field to your SQL database in the customer table.

 

I know how to get there and all but I'm not able to write a table.... :blush:

 

Can someone help me out a bit?

http://www.oscommerce.com/community/contri...h,customer+list

 

Thanks,

 

Nigelman :thumbsup:

Link to comment
Share on other sites

hey thanks for the help I really appreciate it..........but um she ain't working very well:

 

Error

SQL query:

 

ALTER TABLE `customer` ADD `customers_notes` INT( 128 ) DEFAULT NULL

 

MySQL said:

 

#1146 - Table 'tsuriXXXX_osc2.customer' doesn't exist

 

but it does???

 

thanks,

 

Nigelman

Link to comment
Share on other sites

Use this

 

ALTER TABLE `customers` ADD `customers_notes` INT( 128 ) DEFAULT NULL;

Installed Contributions: CCGV, Close Popup, Dynamic Meta Tags, Easy Populate, Froogle Data Feeder, Google Position, Infobox Header Entire Row, Live Support for OSC, PayPal Seal with CC images, Report_m Sales, Shop by Price Revised, SQL Updater, Who's Online Enhancement, Footer, GNA EP Assistant and still going.

Link to comment
Share on other sites

Thanks man!!!!!!!

 

got it and now the contrib is working smooth as......funny thing though. After adding that SQL code I got this message:

 

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_meta_style.inc.php:27) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 1154

 

but the contrib is working great, go figure?

 

Nigelman :thumbsup:

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...