problem encountered in 3.12

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

problem encountered in 3.12

ExsonQu
Administrator
Dear all,
   
      After filled the PO, I encountered the problem as following:


Database Error : The purchase order header record could not be inserted into the database because
Unknown column 'tel' in 'field list'
Database SQL Failure : The SQL statement used to insert the purchase order header record and failed was
INSERT INTO purchorders ( orderno, supplierno, comments, orddate, rate, initiator, requisitionno, intostocklocation, deladd1, deladd2, deladd3, deladd4, deladd5, deladd6, tel, suppdeladdress1, suppdeladdress2, suppdeladdress3, suppdeladdress4, suppdeladdress5, suppdeladdress6, suppliercontact, supptel, contact, version, revised, deliveryby, status, stat_comment, deliverydate, paymentterms) VALUES(10, 'JCGS', '', '2010-03-25', '1', 'admin', '', 'MEL', '1234 Collins Street', 'Melbourne', 'Victoria 2345', '', '', 'Australia', '+61 3 56789012', '太平洋数码电脑城十七层1709-1715室', '海淀区海淀路52号,', '北京,中国', '', '', '', '简明', '', 'Jack Roberts', '1', '2010/03/25', '1', 'Pending', '25/03/2010 - Order Created by [hidden email] -
', '2010/03/25', '20' )

Best regards!

Exson Qu

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
web-ERP-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-users
Reply | Threaded
Open this post in threaded view
|

Re: problem encountered in 3.12

TimSchofield5
This post was updated on .
Hi, Did you run all the database updates in sql/mysql/upgrade3.11.1-3.12.sql :

Thanks
tim


2010/3/25 exson qu <hexinfans@gmail.com>:
> Dear all,
>
>       After filled the PO, I encountered the problem as following:
>
>
> Database Error : The purchase order header record could not be inserted into
> the database because
> Unknown column 'tel' in 'field list'
> Database SQL Failure : The SQL statement used to insert the purchase order
> header record and failed was
> INSERT INTO purchorders ( orderno, supplierno, comments, orddate, rate,
> initiator, requisitionno, intostocklocation, deladd1, deladd2, deladd3,
> deladd4, deladd5, deladd6, tel, suppdeladdress1, suppdeladdress2,
> suppdeladdress3, suppdeladdress4, suppdeladdress5, suppdeladdress6,
> suppliercontact, supptel, contact, version, revised, deliveryby, status,
> stat_comment, deliverydate, paymentterms) VALUES(10, 'JCGS', '',
> '2010-03-25', '1', 'admin', '', 'MEL', '1234 Collins Street', 'Melbourne',
> 'Victoria 2345', '', '', 'Australia', '+61 3 56789012',
> '太平洋数码电脑城十七层1709-1715室', '海淀区海淀路52号,', '北京,中国', '', '', '', '简明', '', 'Jack
> Roberts', '1', '2010/03/25', '1', 'Pending', '25/03/2010 - Order Created by
> admin -
> ', '2010/03/25', '20' )
>
> Best regards!
>
> Exson Qu
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>



--
Course View Towers,
Plot 21 Yusuf Lule Road,
Kampala
T   +256 (0) 312 314 418
M +256 (0) 752 963 325
www.weberpafrica.com
@TimSchofield2
Blog: http://weberpafrica.blogspot.co.uk/

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
web-ERP-users mailing list
web-ERP-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/web-erp-users
For those wondering about the constant nastiness and abuse that Phil Daintree fires at me, the facts can be found here at http://weberpafrica.blogspot.co.uk/