Home > Archive > Microsoft SQL Server forum > February 2006 > unknown column 'state' in field list









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author unknown column 'state' in field list
Nospam

2006-02-25, 9:45 am

I installed a script that is suppose to accept paypal, however on trying to
test a payment, I get this error msg:

Error
Database access error


and I get this error msg emailed to me:


Unknown column 'State' in 'field list'
Query: 'INSERT INTO `TransactionsMembers
hip` (ID, Sum, State ) VALUES

what could be swrong, importantly how do I fix it?


Toby Inkster

2006-02-25, 9:45 am

Nospam wrote:

> Unknown column 'State' in 'field list'
> Query: 'INSERT INTO `TransactionsMembers
hip` (ID, Sum, State ) VALUES


At a guess, the database table " TransactionsMembersh
ip" doesn't have a
column called "State".

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact

Jerry Stuckle

2006-02-25, 9:45 am

Nospam wrote:
> I installed a script that is suppose to accept paypal, however on trying to
> test a payment, I get this error msg:
>
> Error
> Database access error
>
>
> and I get this error msg emailed to me:
>
>
> Unknown column 'State' in 'field list'
> Query: 'INSERT INTO `TransactionsMembers
hip` (ID, Sum, State ) VALUES
>
> what could be swrong, importantly how do I fix it?
>
>


Maybe ask whomever you got the script from?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com