PhatZilla Posted December 30, 2008 Report Share Posted December 30, 2008 So I uploaded a clean install of phpvms to the live server and was just running through the install, and after putting in my DB info it gave some php error about it needing to be a string. I tinkered with it a bit, hit the 'test connection' button and it gave me an error saying accessis denied for me. Problem is that my DB username and DB name have an underscore in them. The error message truncated the underscore and everything after it. I'm going to try upping my (already installed) local copy, and altering the local.config by hand. wish me luck. I get this now Fatal error: Function name must be a string in /edited/edited/public_html/phatzilla/phpvms/core/classes/MySQL.class.php on line 134 Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted December 30, 2008 Administrators Report Share Posted December 30, 2008 I've corrected that, it's just an error with the error logger which reports the error (phew) But what it would tell you is that it can't connect to the database. Underscores shouldn't matter (I have 2 underscores in one of my test db's). Check the username/password/db name Quote Link to comment Share on other sites More sharing options...
PhatZilla Posted December 30, 2008 Author Report Share Posted December 30, 2008 Yeah, I just realized my sql username and or pass and or db access is messed up. Ill have my buddy fix it, he hosts it professionally Quote Link to comment Share on other sites More sharing options...
PhatZilla Posted December 31, 2008 Author Report Share Posted December 31, 2008 Ok. I got tired of waiting for my buddy. I moved to a paid host. I srtarted doing a new install, then quickly realized I didn't need to. I put my skins folder on the live site and my updated local.config. It seems to work fine, except there is now no fleet, or pilots. I can';t even log in as admin. Should I try a fresh install and actually run the install script? Quote Link to comment Share on other sites More sharing options...
PhatZilla Posted December 31, 2008 Author Report Share Posted December 31, 2008 Error SQL query: -- -- Dumping data for table `phpvms_acarsdata` -- INSERT INTO `phpvms_acarsdata` ( `id` , `pilotid` , `flightnum` , `pilotname` , `aircraft` , `lat` , `lng` , `heading` , `alt` , `gs` , `depicao` , `depapt` , `arricao` , `arrapt` , `deptime` , `timeremaining` , `arrtime` , `distremain` , `phasedetail` , `online` , `messagelog` , `lastupdate` ) VALUES ( 1, 'WAR0001', 'WAR0001', '', 'NKSEA1', '48.649139', '-123.424438', 0, '65', 177, 'KSEA', 'SEATTLE TACOMA INTL', 'CYYJ', 'VICTORIA INTL', '00:00:00', '00:00', '00:00:00', '0', 'Cruise', '', '', '2008-12-29 01:27:07' ) ; MySQL said: #1062 - Duplicate entry '1' for key 1 Quote Link to comment Share on other sites More sharing options...
PhatZilla Posted December 31, 2008 Author Report Share Posted December 31, 2008 als, i just deleted a third pilot type i had addied, there wa admnistrators, active and i added a third.. meant to delet it, but since i cant access admin features, I just did it from the db. The url is www.westairregional.org its horrible looking right now. Haha. I'm focused on the function at the moment. Disregard. It's fixed. I'm just sql retarded Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted December 31, 2008 Administrators Report Share Posted December 31, 2008 Yep, just change the id value with NULL. phpVMS has paid hosting too Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.