Help me please!!!

[Guest]

Call me stupid or stuck in a really bad blonde moment! LOL! I am new, very new to oscommerce and I am having a lot of trouble!

 

I installed a Account Balance_V3 contrib so I could give my customers credit and they could use that to purchase with. I installed everything and followed all directions but I keep getting an error at checkout. When you go to finish the check out it says,

 

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

 

select customers_account_balance from customers where customers_id = '3'

 

[TEP STOP]

 

If I go under the admin to update a customer it says,

 

1054 - Unknown column 'c.customers_account_balance' in 'field list'

 

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_account_balance, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by c.customers_lastname, c.customers_firstname limit 0, 20

 

[TEP STOP]

 

I went back and checked the install instructions. The only thing I did not do is mess with the tables. I am supposed to alter the add customers table, then drop and create customer balance history table. Problem is I don't know where to do this at!

 

I just had wisdom teeth pulled and am very medicated right now so I am having trouble with thinking and concentrating. LOL! But I can't wait to get this all fixed, I have customers emailing me wanting to know why they can't make their purchases. Will someone please help me?? I am begging!

[♥bruyndoncx]

Call me stupid or stuck in a really bad blonde moment!  LOL! I am new, very new to oscommerce and I am having a lot of trouble!

 

I installed a Account Balance_V3 contrib so I could give my customers credit and they could use that to purchase with. I installed everything and followed all directions but I keep getting an error at checkout. When you go to finish the check out it says,

If I go under the admin to update a customer it says,

I went back and checked the install instructions. The only thing I did not do is mess with the tables. I am supposed to alter the add customers table, then drop and create customer balance history table. Problem is I don't know where to do this at!

 

I just had wisdom teeth pulled and am very medicated right now so I am having trouble with thinking and concentrating. LOL! But I can't wait to get this all fixed, I have customers emailing me wanting to know why they can't make their purchases. Will someone please help me?? I am begging!

<{POST_SNAPBACK}>

You know what the solution is ... follow the instructions and alter the customers table and add the customer balance history table.

If you don't do that you site remains broken !

 

How to do this ?

 

Make sure to backup your database before you do this so you can restore things when needed. (you can create a backup via the oscommerce / Admin / tools section

 

Then, using phpmyadmin (ask your host if you can't see it in your hosts control panel) run the sql provided to alter customers table.

After openin phpmyadmin, activate the sql tab, and just copy & paste the sql code and press 'go'.

[♥toyicebear]

In your phpmyadmin, if you dont know where you have that one i suggest you ask your hosting company.

 

 

Also read this for future reference: Read on.....

[Guest]

Okay I did all that and I get this error.

 

SQL-query:

 

INSERT INTO `customers` ( customers_balance_history ) orders_id int( 11 ) NOT NULL ,

customers_id int( 11 ) NOT NULL default '0',

customers_firstname char( 20 ) default NULL ,

customers_lastname char( 20 ) default NULL ,

date_customers_balance datetime NOT NULL ,

amount_customer_balance decimal( 15, 4 ) default '0',

type_customer_balance char( 20 ) default NULL ,

desc_customer_balance char( 64 ) default NULL

TYPE =

MYISAM

MySQL said: 

 

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'orders_id int(11) NOT NULL,

  customers_id int(11) NOT NULL de

 

What am I doing wrong?

[Guest]

are you trying to insert info into a table or create one? reread the instructions for the instruction again, make sure you have copied the sql query exactly

[Guest]

I am trying to create a table

[Guest]

I altered the customers table and added the new customer balace table. I copied and pasted everything over to make sure it was right. Now when I go under my admin section for customers I get this error.

 

1054 - Unknown column 'orders_id' in 'order clause'

 

select * from customers_balance_history order by orders_id DESC limit -20, 20

 

[TEP STOP]

[241]

is there an orders_id field in the customers_balance_history table

Edited May 29, 2005 by 241

[Guest]

Yes here is what is there.

 

orders_id  int(11)  No  0               

  customers_id  int(11)  No  0               

  customers_firstname  char(20)  Yes  NULL               

  customers_lastname  char(20)  Yes  NULL               

  date_customers_balance  datetime  No  0000-00-00 00:00:00               

  amount_customer_balance  decimal(15,4)  No  0.0000               

  type_customer_balance  char(20)  Yes  NULL               

  desc_customer_balance  char(64)  Yes  NULL   

[241]

just installed it and it works fine no errors, you must have made an error in installing.

 

Are you installing to a clean version of osCommerce or a modified version.

Did you manually alter the files or did you just use a straight replacement of the files with those from the contribution

[Guest]

clean version of oscommerce. I used straight replacement of files. My cart and check out are working now. It is just under my admin customer balance section that won't work.