webERP Forum
Getting an error Database Error 1054 : - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: Getting an error Database Error 1054 : (/showthread.php?tid=2830)



Getting an error Database Error 1054 : - rabtech12 - 08-10-2016



The exact error is

Database Error 1054 :
Unknown column 'statement' in 'field list'
Database SQL Failure : The SQL that failed was
SELECT contid, debtorno, contactname, role, phoneno, statement, notes, email FROM custcontacts WHERE debtorno='00382' ORDER BY conoid


It happens when I try to add a contact for a customer account....

I logged into the weberp demo site and tried it and received the same error.

What do I need to do to fix this?

Thanks in advance for the help. I have tried searching and I cant find anything that would help....




RE: Getting an error Database Error 1054 : - TimSchofield - 08-10-2016

It is the same issue, and solution as in this thread:

http://www.weberp.org/forum/showthread.php?tid=2827

Tim


RE: Getting an error Database Error 1054 : - rabtech12 - 08-11-2016

yes, that is the error. I found this but wasnt sure how to implement the fix. Im not at all familiar with mysql. It took me a while just to get the Ubuntu server running and get all the required packages installed. I used a guide I found on the web to make the database. I am lost as to how to use this ALTER command. I can get logged back into the mysql prompt but i dont know how to alter the webep database.


If there is an extra command to add or somehow change to that database then execute this command I just dont know what it is?

And thanks for helping. I know i am new here and hopefully once it is installed and running I wont have to bother people with these questions..

The company that I am installing this for would love to pay a consultant to help them. They are in Alabama.... I told them I would get the software installed and they could look thru it and see if they liked it... So far they love it...

If there is a place on here that has consultants that help with this software they would love tho pay for someone to help get it all setup..




RE: Getting an error Database Error 1054 : - TimSchofield - 08-11-2016

Hi, if you can get to the mysql command line then enter the following statement:

use XXXXXXX;

where XXXXXXX is the name of the database. Then just copy and paste the ALTER command and it should work. If not let me know.

Tim


RE: Getting an error Database Error 1054 : - rabtech12 - 08-12-2016

(08-11-2016, 01:24 AM)falkoner Wrote: Hi, if you can get to the mysql command line then enter the following statement:

use XXXXXXX;

where XXXXXXX is the name of the database. Then just copy and paste the ALTER command and it should work. If not let me know.

Tim

worked flawlessly.... thanks for the help