2007-10-07 16:53:53 UTC
Hi all ... Hope all is going good for everyone.. I'm still running the Old myCMMS and have been for a while now. I'm using it for several Company's for over 2 yrs now.. WORKS GREAT!! even added some code so it can Keep up with all the equipment in 1442 Restrants. I'm the Head Tech for Pizza Hut,Long John Silvers and Several other francises. My original Server is a RedHat 6.2 running Apache2,PHP5 + MySQL 4.x something.... All has been going well till I got a brain fart and decided to build another server to seperate all the restrants from each other.
I have built a FreeBSD 6.0 server running Apache2,PHP5 compiled with all the goodies and mySQL. I tar'd up the entire site and made 3 new sites from the tarball.. 1 for Long John, Pizza Hut and Duncan Donuts. All using seperate databases. Heres's my Problems.
1) Submitting a new work order starts at number 30.
2) Purchases I never had time to finish or get working, tracking jobs + equipment was good enough.
3) the damn thing keeps wanting to look inside the pizzahut databse for equipment. I'v changed the class_DB.php database to look at LJS database everywhere in that document and did a search for all other database info through out the entire site.
4) No WO numbers are showing up in the Work Request page, When I aprove the Job heres the error I'm getting.
Error in the DB in LJS (LJS): Invalid QUERY: SELECT * FROM WO LEFT JOIN WOEQLIST ON WO.WONUM=WOEQLIST.WONUM WHERE WO.WONUM= AND EQNUM='Food Warmer'
error mySQL :
error number mySQL :
Date : 07.10.2007 @ 12:40
Page : /LJS/wr-approve.php?id1=&id2=Food%20Warmer
Referer :
USER IP : 192.168.1.6
There is no requisition #
Where do I reset my WO to 1 and Items(spares) to start at 1?
Thanks for Your Time
Snoops
