Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Urgent help needed


Guest

Recommended Posts

Would anyone be able to translate what this error messages means:

 

1054 - Unknown column 'customer_discount' in 'field list'

 

select customer_discount from customers where customers_id = '137'

 

[TEP STOP]

 

I have installed the credit class contribution and this is the only error and no one is reply to me in the contribution forum.

 

I am pretty sure it means that there is a column missing from my databases in the customer field. Below is the sql file that needed to be inserted and I cannot see any mention of this column in it:

 

# phpMyAdmin MySQL-Dump
# version 2.3.1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: May 02, 2003 at 03:49 AM
# Server version: 3.23.52
# PHP Version: 4.2.3
# Database : `new_cc_gv`


INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Welcome Gift Voucher Amount', 'NEW_SIGNUP_GIFT_VOUCHER_AMOUNT', '0', 'Welcome Gift Voucher Amount: If you do not wish to send a Gift Voucher in your create account email put 0 for no amount else if you do place the amount here i.e. 10.00 or 50.00 no currency signs', 1, 31, NULL, '2003-12-05 05:01:41', NULL, NULL);

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Welcome Discount Coupon Code', 'NEW_SIGNUP_DISCOUNT_COUPON', '', 'Welcome Discount Coupon Code: if you do not want to send a coupon in your create account email leave blank else place the coupon code you wish to use', 1, 32, NULL, '2003-12-05 05:01:41', NULL, NULL);



#
# Table structure for table `coupon_email_track`
#

CREATE TABLE coupon_email_track (
 unique_id int(11) NOT NULL auto_increment,
 coupon_id int(11) NOT NULL default '0',
 customer_id_sent int(11) NOT NULL default '0',
 sent_firstname varchar(32) default NULL,
 sent_lastname varchar(32) default NULL,
 emailed_to varchar(32) default NULL,
 date_sent datetime NOT NULL default '0000-00-00 00:00:00',
 PRIMARY KEY  (unique_id)
) TYPE=MyISAM;


#
# Table structure for table `coupon_gv_customer`
#

CREATE TABLE coupon_gv_customer (
 customer_id int(5) NOT NULL default '0',
 amount decimal(8,4) NOT NULL default '0.0000',
 PRIMARY KEY  (customer_id),
 KEY customer_id (customer_id)
) TYPE=MyISAM;


#
# Table structure for table `coupon_gv_queue`
#

CREATE TABLE coupon_gv_queue (
 unique_id int(5) NOT NULL auto_increment,
 customer_id int(5) NOT NULL default '0',
 order_id int(5) NOT NULL default '0',
 amount decimal(8,4) NOT NULL default '0.0000',
 date_created datetime NOT NULL default '0000-00-00 00:00:00',
 ipaddr varchar(32) NOT NULL default '',
 release_flag char(1) NOT NULL default 'N',
 PRIMARY KEY  (unique_id),
 KEY uid (unique_id,customer_id,order_id)
) TYPE=MyISAM;


#
# Table structure for table `coupon_redeem_track`
#

CREATE TABLE coupon_redeem_track (
 unique_id int(11) NOT NULL auto_increment,
 coupon_id int(11) NOT NULL default '0',
 customer_id int(11) NOT NULL default '0',
 redeem_date datetime NOT NULL default '0000-00-00 00:00:00',
 redeem_ip varchar(32) NOT NULL default '',
 order_id int(11) NOT NULL default '0',
 PRIMARY KEY  (unique_id)
) TYPE=MyISAM;


#
# Table structure for table `coupons`
#

CREATE TABLE coupons (
 coupon_id int(11) NOT NULL auto_increment,
 coupon_type char(1) NOT NULL default 'F',
 coupon_code varchar(32) NOT NULL default '',
 coupon_amount decimal(8,4) NOT NULL default '0.0000',
 coupon_minimum_order decimal(8,4) NOT NULL default '0.0000',
 coupon_start_date datetime NOT NULL default '0000-00-00 00:00:00',
 coupon_expire_date datetime NOT NULL default '0000-00-00 00:00:00',
 uses_per_coupon int(5) NOT NULL default '1',
 uses_per_user int(5) NOT NULL default '0',
 restrict_to_products varchar(255) default NULL,
 restrict_to_categories varchar(255) default NULL,
 restrict_to_customers text,
 coupon_active char(1) NOT NULL default 'Y',
 date_created datetime NOT NULL default '0000-00-00 00:00:00',
 date_modified datetime NOT NULL default '0000-00-00 00:00:00',
 PRIMARY KEY  (coupon_id)
) TYPE=MyISAM;


#
# Table structure for table `coupons_description`
#

CREATE TABLE coupons_description (
 coupon_id int(11) NOT NULL default '0',
 language_id int(11) NOT NULL default '0',
 coupon_name varchar(32) NOT NULL default '',
 coupon_description text,
 KEY coupon_id (coupon_id)
) TYPE=MyISAM;

 

From the size of thread on this contribution, there must be alot of you that have successfully installed this one. So please can someone point me in the right direction?

Link to comment
Share on other sites

yep!

first check custoemr table if u have that field or not. may be misspelled or so.

then...

if not.

this sql doesnt have any update for customer table...it means u have missed. re check with the contribution code. u might have missed a line. check with readme file. please let me know if it worked or not. in either cases.

thanks,

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...