Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problem wtih Print Statements
08-10-2016, 01:18 AM
Post: #1
Problem wtih Print Statements
Am using WebERP 4.13 locally on xampp
when I go to print a customer statement
I get the following error

Database Error 1054 :
Unknown column 'statement' in 'where clause'
Database SQL Failure : The SQL that failed was
SELECT email FROM custcontacts WHERE statement=1 AND debtorno='000001'

I also tried the demo at http://www.weberp.org/weberp/index.php
and tried to print a statement and got the same error

any ideas ?

thanks in advance

R2-g
Find all posts by this user
Quote this message in a reply
08-10-2016, 03:57 AM
Post: #2
RE: Problem wtih Print Statements
The sql/mysql/upgrade4.12.3-4.13.sql file does include a statement to add this column:

ALTER table custcontacts ADD statement tinyint(4) NOT NULL DEFAULT 0;

However it doesn't appear to have been put into the demo.sql or default.sql files so won't be in any fresh installs. You need to execute the above sql statement. Not sure whether there are any other of the statements in the upgrade file that weren't included.

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
08-10-2016, 09:24 AM
Post: #3
RE: Problem wtih Print Statements
Bum! ... thanks guys will add this in.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
08-11-2016, 12:19 AM
Post: #4
RE: Problem wtih Print Statements
(08-10-2016 09:24 AM)phil Wrote:  Bum! ... thanks guys will add this in.

How do I add this line to mysql. I can get to the mysql prompt. I just dont know how to add this command.
Find all posts by this user
Quote this message in a reply
08-11-2016, 12:50 AM
Post: #5
RE: Problem wtih Print Statements
If you ate at the prompt you first need the statement :

use xxxxxxx;

Where xxxxxxx is the name if your database. Then just copy and paste the sql I posted earlier.
Visit this user's website Find all posts by this user
Quote this message in a reply
08-11-2016, 06:05 AM (This post was last modified: 08-11-2016 06:07 AM by phil.)
Post: #6
RE: Problem wtih Print Statements
Or if you have phpMyAdmin on your web-host you can run it from there having selected you webERP database

Code:
SELECT email FROM custcontacts WHERE statement=1 AND debtorno='000001'

see

https://www.siteground.com/tutorials/php..._query.htm

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
08-12-2016, 03:24 PM
Post: #7
RE: Problem wtih Print Statements
(08-11-2016 06:05 AM)phil Wrote:  Or if you have phpMyAdmin on your web-host you can run it from there having selected you webERP database

Code:
ALTER table custcontacts ADD statement tinyint(4) NOT NULL DEFAULT 0;

see

https://www.siteground.com/tutorials/php..._query.htm
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)