Welcome Visitor, Please Login or Register Now Thursday, March 28, 2024 08:37 AM 
Forums Index > Mewsoft Products > Auctionawy > Add Credit/ Debit : SQL error
New Topic   New Reply
Search for:
Author Message
newbie newbie's personal page
Registered Member
Posts: 63 Display member's posts
Joined: 03-28-24 08:37 AM
Member Offline
View Member's Profile Visit member's website http:// Send private message
 
Back to top
Add Credit/ Debit : SQL error Edit Delete Reply with quote Quote
First Post Posted on: 04-24-08 06:34 AM next post first post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-28-24 08:37 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Add Credit/ Debit : SQL error Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 04-24-08 07:44 AM last post previous post
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

Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print