$query = "SELECT icao FROM " . TABLE_PREFIX . "airports WHERE hub='1' AND icao!= '$pilot_hub'";
I think that this is going to work.
1 Like
Yes, servetas that could be the issue. I didn’t notice it when I updated the git from the iPad in the afternoon.
I updated the core/common/HubTrasnferData.class.php file once more and hope that solves it. Download it and tell me if it helps.
I couldn’t check if it works as I don’t have access to my phpvms test site at the moment from the iPad.
Sorry for the trouble.
Very good!
Yep, that did it! Thanks guys!
Glad it worked out!
Nice addon!
Thanks
When trying to delete the default LoA in the form.
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 60
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 60
Warning : mysql_affected_rows() [function.mysql-affected-rows]: Access denied for user ‘julianac’@‘localhost’ (using password: NO) in /home/julianac/public_html/core/common/LoAData.class.php on line 61
Warning : mysql_affected_rows() [function.mysql-affected-rows]: A link to the server could not be established in /home/julianac/public_html/core/common/LoAData.class.php on line 61
Warning : mysql_affected_rows() [function.mysql-affected-rows]: Access denied for user ‘julianac’@‘localhost’ (using password: NO) in /home/julianac/public_html/admin/modules/LoA/LoA.php on line 63
Warning : mysql_affected_rows() [function.mysql-affected-rows]: A link to the server could not be established in /home/julianac/public_html/admin/modules/LoA/LoA.php on line 63
it seems it has to do with you mysql not being setup correctly.
it is late here, i will check in the morning but i believe it’s something on your side.
I am such an idiot this is the wrong topic. this was meant to be in your LoA module. Please excuse my post. but if you have a solution it would be most helpful.
Edit***
I’ve tried your Hub Transfer Request Module now and receive an error quite similar. I’m going to look and see if I can find a problem somewhere in your code as the main site works. its just your modules that don’t
Edit** Again**
It seems that the both modules are assuming that my MySQL database has no password. or at least it isn’t getting the MySQL data correctly from the local.config.php file.
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.
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.
I am really not sure on what is causing the error. If anyone else can help, please do.
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
As the error says, a connection to the mysql server could not been established. I am not sure what causes that..
Also, this should go in the LoA topic, not this one.
I get roughly the same problem for both of your addons Sava.
It is a problem on your end. Not sure which one, but it is on your end.
If anyone has any ideas, they are welcome. You can also try and contact your host. Maybe its them.