I was able to get the query to run in PHPAdmin after changing to the correct table name. I was not able to get the corrected query to run in MySQL Workbench though.
Thanks, Paul Paul Dokken Software Developer SIL PNG Communication and Technology Services Ukarumpa EHP 444 | Papua New Guinea [email protected] +675-537-3544 x4404 {Telecom} +675-7081-8666 {Digicel} -----Original Message----- From: CTS-Programmer 3 (Paul Dokken) [mailto:[email protected]] Sent: Tuesday, 6 January 2015 2:27 PM To: [email protected] Subject: [Koha] Update a field using SQL Hi am running Koha 3.18. I want to run some SQL queries to update some fields. When I try and run a simple query like UPDATE item SET PRICE = 2.00 WHERE BARCODE = '37000001' it just says executing query until I stop it. I am using MySQL Workbench from the Koha host and running under root user. Anything special I have to do? Thanks, Paul Paul Dokken Software Developer SIL PNG Communication and Technology Services Ukarumpa EHP 444 | Papua New Guinea [email protected] +675-537-3544 x4404 {Telecom} +675-7081-8666 {Digicel} _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
