5SA CEO Posted February 19, 2011 Report Share Posted February 19, 2011 Hi guys, I have made a school boy error today. I wanted to change my callsign to match with the one I would normally use, i.e. from 5SA0001 (admin) to 5SA389 (which I use) however I saw that I could it on the admin page and just didit with thinking then, I cannot get back into the admin pages, where can I change the settings to accept my new callsign as the admin for the site? Thanks Deano 5SA389 5 STAR VIRTUAL AVIATION CEO http://5starvirtualaviation.com/ Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 19, 2011 Moderators Report Share Posted February 19, 2011 Hey, go inside your phpVMS database and go to the pilots, and go to edit one of your profiles and change the ID to 1 and you should be back in. Quote Link to comment Share on other sites More sharing options...
5SA CEO Posted February 19, 2011 Author Report Share Posted February 19, 2011 Hi Vansers Thanks for that, but I must be missing it but I cannot seem to find it any where in the database, I have looked inside 'admin' & 'core' but nothing. I will keep looking Quote Link to comment Share on other sites More sharing options...
James142 Posted February 19, 2011 Report Share Posted February 19, 2011 Hi Vansers Thanks for that, but I must be missing it but I cannot seem to find it any where in the database, I have looked inside 'admin' & 'core' but nothing. I will keep looking You need to look in your mySQL database Quote Link to comment Share on other sites More sharing options...
5SA CEO Posted February 19, 2011 Author Report Share Posted February 19, 2011 thanks James, I dont know a thing about all this so must do some reading soon. I found the file in mysql but when I changed it to 1 I get the following SQL query: UPDATE`fivstar6_phpvms`.`phpvms_pilots`SET`pilotid`='1' WHERE`phpvms_pilots`.`pilotid`=389 MySQL said: #1451 - Cannot delete or update a parent row: a foreign key constraint fails (`fivstar6_phpvms`.`phpvms_groupmembers`, CONSTRAINT `phpvms_groupmembers_ibfk_2` FOREIGN KEY (`pilotid`) REFERENCES `phpvms_pilots` (`pilotid`) ON DELETE CASCADE) so what next? Now I went to look at the site and all I am getting is a blank page, I think I may have to re-install and start again, at least I saved the schedules, eh!! thanks for the support guys Quote Link to comment Share on other sites More sharing options...
5SA CEO Posted February 19, 2011 Author Report Share Posted February 19, 2011 going to watch utd play Crawley 2nd half now but will be back Quote Link to comment Share on other sites More sharing options...
James142 Posted February 19, 2011 Report Share Posted February 19, 2011 going to watch utd play Crawley 2nd half now but will be back Im not great with mySQL so I cant help from here, sorry but im sure there will be someone else to help you soon Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 19, 2011 Moderators Report Share Posted February 19, 2011 hi, run this in your SQL ALTER TABLE phpvms_pilots AUTO_INCREMENT = 1 and you might able to change your ID. Quote Link to comment Share on other sites More sharing options...
5SA CEO Posted February 20, 2011 Author Report Share Posted February 20, 2011 Sorted it out today, had to do a fresh install and all works. thanks 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.