Databases
StackOverflow2013
Postsdbo
POPHP and MySQL Session
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP and MySQL Session
    text
    copied!<p>we moved our website to a new server that came with a new IP address. What puzzles me; the website login sessions do not work on the new server but when I change the database IP to the old server they are working. </p> <p><strong>MySQL Version :</strong> </p> <ol> <li>Old server = 5.1.58- Community </li> <li>New server = 5.1.68 - Community</li> </ol> <p>At first I thought it was a PHP error but I now believe it's not and suspect its MySQL related. Anyone who knows what might have caused this conflict?</p> <p><strong>Debugging Error :</strong> </p> <blockquote> <p>Notice: A session had already been started - ignoring session_start() in C:\inetpub\wwwroot\gtest\libs\products.php on line 2 Notice: Undefined index: uUserTypeID in C:\inetpub\wwwroot\gtest\admin\index.php on line 50 Notice: Undefined offset: 0 in C:\inetpub\wwwroot\gtest\admin\index.php on line 52 Notice: Undefined offset: 0 in C:\inetpub\wwwroot\gtest\admin\index.php on line 52 </p> </blockquote> <p><strong>Line 50 :</strong></p> <pre><code>GetUserType($_SESSION['uUserTypeID'], $UserTypeID, $UserTypeDescr, $Active_Tag); </code></pre> <p><strong>Line 52 :</strong></p> <pre><code>if (($UserTypeDescr[0] == 'Admin') || ($UserTypeDescr[0] == 'Report')) </code></pre> <p><strong>Code overview :</strong></p> <pre><code>&lt;?php error_reporting(E_ALL); ini_set('display_errors', True); session_start(); require '../libs/database.php'; require '../libs/users.php'; require '../libs/products.php'; require '../libs/quotes.php'; require '../libs/common.php'; require 'functions.admin.php'; if (!($_SESSION['uAUID']) &gt; 0) { DisplayLoginForm(); } else { **GetUserType($_SESSION['uUserTypeID'], $UserTypeID, $UserTypeDescr, $Active_Tag);** **if (($UserTypeDescr[0] == 'Admin') || ($UserTypeDescr[0] == 'Report'))** { if (isset($_POST['eProdID']) &amp;&amp; isset($_POST['eProdGroupID'])) { $_SESSION['page'] = 'edit_product'; $_SESSION['page_header'] = 'Edit Product'; } else if (isset($_POST['eProdGroupID'])) { $_SESSION['page'] = 'edit_product_group'; $_SESSION['page_header'] = 'Edit Product Group'; } else if (isset($_POST['eAUID'])) { $_SESSION['page'] = 'edit_user'; $_SESSION['page_header'] = 'Edit User'; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload