kbohme

I am using Version 2.1.934 I had the host dump the database and tried installing again. It mostly worked except I got these errors: Writing "phpvms_fieldvalues_ibfk_1` FOREIGN KEY (`fieldid`) REFERENCES `phpvms_customfields" table... failed - manually run this query: "ALTER TABLE `phpvms_fieldvalues` ADD CONSTRAINT `phpvms_fieldvalues_ibfk_1` FOREIGN KEY (`fieldid`) REFERENCES `phpvms_customfields` (`fieldid`) ON DELETE CASCADE, ADD CONSTRAINT `phpvms_fieldvalues_ibfk_2` FOREIGN KEY (`pilotid`) REFERENCES `phpvms_pilots` (`pilotid`) ON DELETE CASCADE;" Writing "phpvms_groupmembers_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `phpvms_groups" table... failed - manually run this query: "ALTER TABLE `phpvms_groupmembers` ADD CONSTRAINT `phpvms_groupmembers_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `phpvms_groups` (`groupid`) ON DELETE CASCADE, ADD CONSTRAINT `phpvms_groupmembers_ibfk_2` FOREIGN KEY (`pilotid`) REFERENCES `phpvms_pilots` (`pilotid`) ON DELETE CASCADE;" Writing "phpvms_pilots_ibfk_1` FOREIGN KEY (`code`) REFERENCES `phpvms_airlines" table... failed - manually run this query: "ALTER TABLE `phpvms_pilots` ADD CONSTRAINT `phpvms_pilots_ibfk_1` FOREIGN KEY (`code`) REFERENCES `phpvms_airlines` (`code`) ON UPDATE CASCADE;" Writing "phpvms_pirepcomments_ibfk_1` FOREIGN KEY (`pirepid`) REFERENCES `phpvms_pireps" table... failed - manually run this query: "ALTER TABLE `phpvms_pirepcomments` ADD CONSTRAINT `phpvms_pirepcomments_ibfk_1` FOREIGN KEY (`pirepid`) REFERENCES `phpvms_pireps` (`pirepid`) ON DELETE CASCADE ON UPDATE CASCADE;" Writing "phpvms_schedules_ibfk_1` FOREIGN KEY (`code`) REFERENCES `phpvms_airlines" table... failed - manually run this query: "ALTER TABLE `phpvms_schedules` ADD CONSTRAINT `phpvms_schedules_ibfk_1` FOREIGN KEY (`code`) REFERENCES `phpvms_airlines` (`code`) ON UPDATE C Now again I don't have access to the phpmyadmin to rerun anything on the database manually, so my two part question is: Is there anything on the server that needs to be changed to avoid these errors if i dump and do another fresh install ? AND If I just ignore them (or can't fix them) what effects will these missing things have on the VA ? I appreciate that it is quite the question, but at this point if I can make do with the install I have I will just continue with it.

I will check that out however it seems to only be happening on some of the pages now.... eg. on the pilot profile page...only 3 but on the schedules details page its back to 4..I have looked at all the (I think they are called assests?) and it seems to call that info from the same table. I am not however a php or sql guy so I may be wrong. I am on the road for the next couple of days, but if I understand you correctly it is a problem with the tables themselves (most likely) not the php. I will inventigate further on that premise. Thanks yet again for your help.

yep I have the latest. ok then I will call my server and have them delete everything and try again. cross your fingers

Thanks, I ran the check install and there are no errors I tried to reinstall using a different table prefix and got the same error when trying to install tables Fatal error: Cannot redeclare class ezDB_mysql in /home/.sites/70/site4/web/vms/core/classes/ezdb/ezdb_mysql.class.php on line 299. What i will try is to get the host to delete all the tables for me and start again. I will let you know (it generally takes a couple of days for the host to do stuff for me) Is there an additional code I can run just to get an admin user added so that I can access the admin panel and see if it works ? (or perhaps a built in admin login or backdoor ?)

Hey again. When I use the <?php echo $schedule->depicao ?> I only get the first 3 letters of the airport code. When I entered CYAM I only got CYA, So I changed all my airport entries to the last three letters, HOWEVER I am presently working on code that needs all four letters...CYAM I have looked through the local config and cant find anything Is their any place to make i four letters ? Thanks

well my host is not setup so that its users have access to the phpmyadmin He can set it up for me but it would have to be done through my ip address. I was trying to avoid that as presently my ip changes from time to time because of my internet provider. It would be a long and hellish process to setup a static permanent IP that could be used for the phpmyadmin. I was hoping that an upgrade would fix the problem but I guess not. I guess my last option is going to be to find an additional host just for my vms (something else I was trying to avoid)

Hello again, Sorry to be such a pain. My installation had errors and therefore did not procees to step two where I enter all off the details about the airline and most importantly setup the admin user. I cannot therefore get to the admin section. I am trying to re-install vms but keep getting this error: Fatal error: Cannot redeclare class ezDB_mysql in /home/.sites/70/site4/web/vms/core/classes/ezdb/ezdb_mysql.class.php on line 299 I do not have access to phpmyadmin and therefore cannot erase the tables and start again. Any suggestions would be much appreciated. Thanks.

Nevermind figured it out

UREKA !!! At long last it is all figure out and running. Xamp worked (thanks guys ) Much appreciation for all the help guys ! now how do I change it to solved ?

Ok my present server did not have the required versions of everything. I am not sure what changes from the last version to this one, but something did. So, I have tried it on a new server and SUCCESS ! I am still trying to get it to work on wamp, but I will download xamp and give it a go. I will keep you informed.

Well I just got the latest version as recommended. I tried the update first, and everything went belly up (perhaps a bad download). At that point I deleted all my files and databases so that I could start anew with a fresh install. Unfortunately the new version is too advanced for both of my online pay servers so I will have to wait or find something else to use for them, but more curious is that it wont install on my testing server (I run wamp on my home system). I just cant seem to get it to work... I just felt the need to explain the steps that I have taken so as to to sound too moronic

Thanks I will give that a go !

The local.config.php is being created but is empty. Can you perhaps tell me the info to put in there manually ?

Okay... I have created the database I have created a user for it with a password and full permissions (it is my server) I have run the checkinstall.php and everything is ok and I still get Fatal error: Uncaught <blockquote><font face=arial size=2 color=000099><b>Last Error --</b> [<font color=000000><b>Access denied for user 'SYSTEM'@'localhost' (using password: NO) (1045)</b></font>]<br />[<font color=000000><b></b></font>]</font><p> </blockquote><hr noshade color=dddddd size=1> thrown in C:\wamp\www\newphpvms\core\classes\ezdb\ezdb_mysql.class.php on line 99 I notice that it says user 'SYSTEM'@'localhost' that is not the username I put into the install info window nor can I find it for my database I even added SYSTEM as a user and still get the same error. I apologize if I am missing something obvious here...

Thanks, I thought as much. I will keep trying to get it to install...

I have been trying that, but I am doing a fresh install now, and there is not core/local.config.php Is there a file in the install directory that I need to change ? I have added users and used the default users (with passwords) and keep getting the same error

Here is the full error Fatal error: Uncaught <blockquote><font face=arial size=2 color=000099><b>Last Error --</b> [<font color=000000><b>Access denied for user 'SYSTEM'@'localhost' (using password: NO) (1045)</b></font>]<br />[<font color=000000><b></b></font>]</font><p> </blockquote><hr noshade color=dddddd size=1> thrown in C:\wamp\www\updated website\core\classes\ezdb\ezdb_mysql.class.php on line 99

I got the error: ezdb_mysql.class.php error on line 99 on one server and the install wont run on my other server (I think that is due to the server not having the required program) I downloaded and tried to install version 2.1.934 I think I have come to the conclusion that I can no longer run this on my server. Is there a download link to an earlier version that I can try ?

a paid site. I have talked to them and I seem to have all the rights and privileges needed. Php scripting enabled, etc.. I will go find a tutorial and double check what I need. I had a xoops website on it before and it worked and installed fine. I have emailed my host again and will double check the particulars. on my old host I tried it (where i had my old phpvms site) and get a ezdb_mysql.class.php error on line 99 can anyone shed some light on what that is ? It may help me get this going on my new host.

I usually test everything out on a separate home computer server. However the update didn't work on the server. I thought that it must be a problem with my home server setup so I uploaded it. I have moved now from an error to nothing at all. When I try to run the install.php I get nothing at all. No error, no nothing. I was thinking about redesigning my airline anyways. So I really dont mind loosing everything. I just want to get it installed so I can start designing !!! So far every update that I do has created days of tweaking work for me, although I am still a beginner when it comes to php. ( sorry about all the !!, been working on trying to install this for about 3 hours now, getting a bit frustrated. )

Yah I have had to delete the whole site and tried to start again. Now the new version won't install on either of my two servers. Keep getting a ezdb_mysql.class.php error on both. I really liked phpvms but everytime I try to upgrade its a royal pain. I'm getting a little frustrated. IF i get it running again I think I will stop upgrading.

I know this may be a silly question. I just updated to the newest version. (without a backup of course...DOH) Now I have nothing but problems again. Is there any way of going back to the old version ? Like an undo ? I know, probably not, but I have to ask

LOL Never mind, found it. You can delete this now.... sorry...

Hey all, I have just recovered from a hard drive crash ( I had the seagate 1TB drive and was unaware it needed a firmware upgrade ), ANYWAYS/... a while ago I read a post on the programs to use so that I could basically see changes on my system before uploading them. It was a server thing. I really want to load that again, but for the life of me I can't remember what it was called. I have searched the forums again but can't seem to find it. Any help would be greatly appreciated. Thanks.

Hey, What I am trying to do is add an accept link to the email that goes out after a pirep is submitted. I am trying to set it up so that when the email goes to my blackberry I can decide there and then if I want to accept it and simply hit the accept link. Presently I have to wait until I get to my computer, or surf to my admin page on the blackberry ( which is a pain in the *** ). Any suggestion would be much appreciated. Thanks Pakak Adventures www.pakakadventures.com