troubleshooting Question

MySQL error with missing column, but the column is already there.

Avatar of purplelettuce
purplelettuce asked on
MySQL Server
3 Comments1 Solution1114 ViewsLast Modified:
I'm having the following error trying to update oscommerce and protx to work with the new maestro cards. The main problem is a mysql statement that protx_process.php is trying to run, the error that comes up is the following:

1054 - Unknown column 'value' in 'field list'

insert into protx_direct (id, customer_id, order_id, vendortxcode, txtype, value, vpstxid, status, statusdetail, txauthno, securitykey, avscv2, address_result, postcode_result, CV2_result, 3DSecureStatus, CAVV, txtime) values ('', '14', '189', '189-07305597560146812969278769059518', 'PAYMENT', '544.28', '', '', '', '', '', '', '', '', '', '', '', '2007-07-23 16:07:35')


But there IS a column called value in the protx_direct table, below is a copy and paste of the specific table within phpMyAdmin:

         Field         Type        Collation        Attributes        Null        Default        Extra        Action
       id                        int(11)               UNSIGNED       Yes        NULL        auto_increment        
       customer_id        int(11)                       Yes        0                
       vendortxcode        varchar(40)       latin1_swedish_ci               Yes        NULL                
       txtype        varchar(16)       latin1_swedish_ci               Yes        NULL                
       value        decimal(15,4)                       Yes        NULL                
       vpstxid        varchar(50)       latin1_swedish_ci               Yes        NULL                
       status        varchar(10)       latin1_swedish_ci               Yes        NULL                
       statusdetail        varchar(100)       latin1_swedish_ci               Yes        NULL                
       txauthno        varchar(10)       latin1_swedish_ci               Yes        NULL                
       securitykey        varchar(10)       latin1_swedish_ci               Yes        NULL                
       avscv2        varchar(50)       latin1_swedish_ci               Yes        NULL                
       address_result        varchar(20)       latin1_swedish_ci               Yes        NULL                
       postcode_result        varchar(20)       latin1_swedish_ci               Yes        NULL                
       CV2_result        varchar(20)       latin1_swedish_ci               Yes        NULL                
       3DSecureStatus        varchar(12)       latin1_swedish_ci               Yes        NULL                
       CAVV        varchar(32)       latin1_swedish_ci               Yes        NULL                
       txtime        timestamp                       Yes        CURRENT_TIMESTAMP                

Can anyone please help with this as i've been at it all day and the site that was once working is currently broken...
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros