Gossamer Forum
Home : Products : Gossamer Links : Discussions :

LSQL 2.2 Payment error

Quote Reply
LSQL 2.2 Payment error
Hi All-

Getting errors when trying to make link payment.
Insert failed (No payment was charged): Failed to execute query: 'INSERT INTO lsql_Payments (payments_start,payments_last,payments_type,payments_id,payments_status,payments_term,payments_linkid,payments_amount,payments_method,Payment_ID) VALUES (?,?,?,?,?,?,?,?,?,NULL)' Reason: Unknown column 'payments_start' in 'field list' at Links::Payment::form line 137.


Please enable debugging in setup for more details.



Thanks!
M

Last edited by:

SSmeredith: Jun 23, 2004, 8:04 AM
Quote Reply
Re: [SSmeredith] LSQL 2.2 Payment error In reply to
Have you modified the Payments table? payments_start is a required column for payment handling. It seems that somehow the column has been dropped - assuming MySQL, the following query in the SQL Monitor should add it back:

ALTER TABLE lsqldev_Payments ADD COLUMN payments_start INT NOT NULL

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] LSQL 2.2 Payment error In reply to
i think it's getting checked out by you guys already - but the answer is no, i didn't modify anthing.

thanks!!