SQL DB

[Guest]

I was altering my db to add the hear about mod and somehow I move

CubeCart_customer to another db on MySQL. Can anyone help me

resolve this and get my table back in the right place. I did export my

db before messing with it but it will not import back in.

I now have the table back in but it is not working correctly. I get this

error when clicking on view customer in admin:

MySQL Error Occured

1054: Unknown column 'type' in 'where clause'

QUERY = SELECT * FROM CubeCart_customer WHERE type = 1 ORDER BY regTime DESC

I get this error when I click on orders in admin:

MySQL Error Occured

1146: Table 'slip_ccrt1.CubeCart_order_sum' doesn't exist

QUERY = SELECT CubeCart_customer.customer_id, status, cart_order_id, time, title, firstName, lastName, ip, prod_total, CubeCart_customer.email FROM CubeCart_order_sum INNER JOIN CubeCart_customer ON CubeCart_order_sum.customer_id = CubeCart_customer.customer_id ORDER BY time DESC

When trying to log in on the cc site I get:

MySQL Error Occured

1054: Unknown column 'password' in 'where clause'

QUERY = SELECT customer_id FROM CubeCart_customer WHERE email='[email protected]' AND password = '6f481d2e10991be6d771cad420c9fc7f' AND type>0

When trying to add a new customer in cc I get this error:

MySQL Error Occured

1054: Unknown column 'type' in 'field list'

QUERY = SELECT customer_id, type FROM CubeCart_customer WHERE email='[email protected]'

Looks like I need some real help here.

Rich

[email protected]