Sava Posted August 15, 2012 Author Report Share Posted August 15, 2012 Hey. I am not really sure what is causing the error as I haven't experienced this during my testing and it is the first time being reported. The lines that are being reported are: { $sql = "DELETE FROM loa WHERE pilotid='$id'"; $query = mysql_query($sql); return mysql_affected_rows(); } There isn't much to it. It is a simple query to delete the request for that pilot (pilot id). Can you make sure that everything imported to the DB successfully. Go to phpmyadmin and manually delete everything from the loa table and than submit a new request from the front end and see if you can delete it then. Quote Link to comment Share on other sites More sharing options...
Stealthbird97 Posted August 15, 2012 Report Share Posted August 15, 2012 Hey. I am not really sure what is causing the error as I haven't experienced this during my testing and it is the first time being reported. The lines that are being reported are: { $sql = "DELETE FROM loa WHERE pilotid='$id'"; $query = mysql_query($sql); return mysql_affected_rows(); } There isn't much to it. It is a simple query to delete the request for that pilot (pilot id). Can you make sure that everything imported to the DB successfully. Go to phpmyadmin and manually delete everything from the loa table and than submit a new request from the front end and see if you can delete it then. I checked it, i cleared the LOA table and it just doesn't like doing something. Oh well I'm just going to have to do LoA and Hub Transfers through my Support centre. Quote Link to comment Share on other sites More sharing options...
Sava Posted August 15, 2012 Author Report Share Posted August 15, 2012 I am really not sure on what is causing the error. If anyone else can help, please do. Quote Link to comment Share on other sites More sharing options...
Stealthbird97 Posted October 31, 2012 Report Share Posted October 31, 2012 Anyone Explain this. Warning: mysql_query() [function.mysql-query]: Access denied for user 'julianac'@'localhost' (using password: NO) in/home/julianac/public_html/core/common/LoAData.class.php on line 23 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in/home/julianac/public_html/core/common/LoAData.class.php on line 23 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in/home/julianac/public_html/core/common/LoAData.class.php on line 24 Quote Link to comment Share on other sites More sharing options...
Sava Posted October 31, 2012 Author Report Share Posted October 31, 2012 As the error says, a connection to the mysql server could not been established. I am not sure what causes that.. Quote Link to comment Share on other sites More sharing options...
Sava Posted October 31, 2012 Author Report Share Posted October 31, 2012 Also, this should go in the LoA topic, not this one. Quote Link to comment Share on other sites More sharing options...
Stealthbird97 Posted November 1, 2012 Report Share Posted November 1, 2012 I get roughly the same problem for both of your addons Sava. Quote Link to comment Share on other sites More sharing options...
Sava Posted November 1, 2012 Author Report Share Posted November 1, 2012 It is a problem on your end. Not sure which one, but it is on your end. Quote Link to comment Share on other sites More sharing options...
Stealthbird97 Posted November 1, 2012 Report Share Posted November 1, 2012 Quote Link to comment Share on other sites More sharing options...
Sava Posted November 2, 2012 Author Report Share Posted November 2, 2012 If anyone has any ideas, they are welcome. You can also try and contact your host. Maybe its them. Quote Link to comment Share on other sites More sharing options...
Stealthbird97 Posted November 6, 2012 Report Share Posted November 6, 2012 Fixed it. There was something, i don't know what mucked up with something. I got the Chairman to reinstall phpVMS so we couldn start over.That was delete everything right down to the databases. Its all working now. Quote Link to comment Share on other sites More sharing options...
Sava Posted November 7, 2012 Author Report Share Posted November 7, 2012 Quote Link to comment Share on other sites More sharing options...
Fernando Posted August 10, 2013 Report Share Posted August 10, 2013 Sava, Please!!! When you accept the approval, it sends an automatic email, When status denied, is not sent. Is it normal or a bug? Quote Link to comment Share on other sites More sharing options...
Taran Posted December 10, 2013 Report Share Posted December 10, 2013 I submitted a transfer request but it did not show up in the admin panel. Any fix? Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted December 11, 2013 Moderators Report Share Posted December 11, 2013 same error here after installing it Quote Link to comment Share on other sites More sharing options...
Taran Posted December 12, 2013 Report Share Posted December 12, 2013 Has anybody found a fix? Quote Link to comment Share on other sites More sharing options...
Taran Posted December 14, 2013 Report Share Posted December 14, 2013 I submitted a transfer request but it did not show up in the admin panel. Any fix? anyone? Quote Link to comment Share on other sites More sharing options...
MC1028 Posted December 15, 2013 Report Share Posted December 15, 2013 I have the same issue Sava. Quote Link to comment Share on other sites More sharing options...
Taran Posted December 31, 2013 Report Share Posted December 31, 2013 still no fix? Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted January 7, 2014 Moderators Report Share Posted January 7, 2014 to all with the error try the following in your commen change the husstransfer class the part for the get all requests to the following $sql = "SELECT h.pilotid, p.firstname, p.lastname, p.email, p.hub, h.hub_initial, h.hub_req, h.date_submitted, h.reason, h.status FROM ".TABLE_PREFIX."hubtransfer h LEFT JOIN ".TABLE_PREFIX."pilots p ON p.pilotid = h.pilotid"; $ret = DB::get_results($sql); return $ret; this fixzd mine thanks to the help of manuel from crazy creatives Quote Link to comment Share on other sites More sharing options...
Taran Posted January 8, 2014 Report Share Posted January 8, 2014 That worked! Thanks Quote Link to comment Share on other sites More sharing options...
CFVA Posted August 20, 2014 Report Share Posted August 20, 2014 Can someone explain the above a bit clearer! Which file needs editing? Quote Link to comment Share on other sites More sharing options...
rambo Posted December 19, 2014 Report Share Posted December 19, 2014 Hi after have installed the module, have send a Test Request.... In the admin area, I see only: there are no active requests. Pls help Regards Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted December 19, 2014 Moderators Report Share Posted December 19, 2014 The solution has been already published. Check a few answers above. Quote Link to comment Share on other sites More sharing options...
kenny Posted March 27, 2015 Report Share Posted March 27, 2015 to all with the error try the following in your commen change the husstransfer class the part for the get all requests to the following $sql = "SELECT h.pilotid, p.firstname, p.lastname, p.email, p.hub, h.hub_initial, h.hub_req, h.date_submitted, h.reason, h.status FROM ".TABLE_PREFIX."hubtransfer h LEFT JOIN ".TABLE_PREFIX."pilots p ON p.pilotid = h.pilotid"; $ret = DB::get_results($sql); return $ret; this fixzd mine thanks to the help of manuel from crazy creatives can you copy your code in "HubTransfertData.class.php" from line 51 to exd of modify? Thanks Quote Link to comment Share on other sites More sharing options...
kenny Posted April 5, 2015 Report Share Posted April 5, 2015 i don't see any request in admin section... What can i do? Thanks Quote Link to comment Share on other sites More sharing options...
Iraklis Posted October 4, 2015 Report Share Posted October 4, 2015 An Error Was Encountered The module "LOA" doesn't exist! any help??? Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted October 4, 2015 Moderators Report Share Posted October 4, 2015 Where are you getting this error? Quote Link to comment Share on other sites More sharing options...
Iraklis Posted October 4, 2015 Report Share Posted October 4, 2015 http://www.gralexand...btransfer_index http://www.gralexandair.net/index.php/loa Quote Link to comment Share on other sites More sharing options...
Iraklis Posted October 7, 2015 Report Share Posted October 7, 2015 any help please.... 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.