Forums Index > Mewsoft Products > Auctionawy > Add Credit/ Debit : SQL error
newbie First Post Posted on: 04-24-08 06:34 AM
Add Credit/ Debit : SQL error
If I try to add any type of credit ( promotion, refund etc) to user account . I get the following error:

Credit Error

SQL Error: Column count doesn't match value count at row 1
Query:
INSERT INTO Deposits VALUES('tester', 100, 1097969635, 'credit_reason_8')
Line 849, File /home/..../public_html/cgi-bin/auction/sqldriver.pm.

Debit Error

SQL Error: Column count doesn't match value count at row 1
Query:
INSERT INTO Deposits VALUES('tester', -1, 1097970207, 'debit_reason_1')
Line 849, File /home/..../public_html/cgi-bin/auction/sqldriver.pm.


Can you please assist . Hope I did'nt mess up anything

regards
newbie cry
mewsoft Reply #: 1 Posted on: 04-24-08 07:44 AM
Re: Add Credit/ Debit : SQL error
May be your sql table Deposits did not create in full or your mysql database coruppted or else. Try to delete this table "Deposits" and create the sql tables again. You can first try to register as a user and it should auto ads a credit for the user account.

Mewsoft Support
www.mewsoft.com