Hub Transfer Request v1.0

[Sava]

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.

[Stealthbird97]

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.

[Sava]

I am really not sure on what is causing the error. If anyone else can help, please do.

[Stealthbird97]

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

[Sava]

As the error says, a connection to the mysql server could not been established. I am not sure what causes that..

[Sava]

Also, this should go in the LoA topic, not this one.

[Stealthbird97]

I get roughly the same problem for both of your addons Sava.

[Sava]

It is a problem on your end. Not sure which one, but it is on your end.

[Stealthbird97]

[Sava]

If anyone has any ideas, they are welcome. You can also try and contact your host. Maybe its them.

[Stealthbird97]

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.

[Sava]

[Fernando]

Sava,

Please!!!

When you accept the approval, it sends an automatic email,

When status denied, is not sent.

Is it normal or a bug?

[Taran]

I submitted a transfer request but it did not show up in the admin panel. Any fix?

[joeri]

same error here after installing it

[Taran]

Has anybody found a fix?

[Taran]

I submitted a transfer request but it did not show up in the admin panel. Any fix? anyone?

[MC1028]

I have the same issue Sava.

[Taran]

still no fix?

[joeri]

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

[Taran]

That worked! Thanks

[CFVA]

Can someone explain the above a bit clearer! Which file needs editing?

[rambo]

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

[servetas]

The solution has been already published. Check a few answers above.

[kenny]

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

[kenny]

i don't see any request in admin section...

What can i do?

Thanks

[Iraklis]

An Error Was Encountered

The module "LOA" doesn't exist!

any help???

[servetas]

Where are you getting this error?

[Iraklis]

http://www.gralexand...btransfer_index

http://www.gralexandair.net/index.php/loa

[Iraklis]

any help please....