Jump to content
Sava

Hub Transfer Request v1.0

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...