 I NEED SOME HELP WITH THE DOLPHIN 7.1.6 MYSQL DATABASE.
CERTAIN THINGS ARE DISAPPEARING CUASING THE WEBSITE TO BECOME NON FUNCTIONAL THIS HAPPENS MOSTLY WHEN DELETING SPAM ACCOUNTS.
1:FLASH APP MENU NON FUNCTIONAL 2:LANGUAGES DISAPPEARED 3:NOW MEMBERSHIP LEVELS HAVE DISAPPEARED.
CAN ANYONE TELL ME WHAT FIELDS TO LOOK FOR IN THE DATABASE FOR THESE?? SO I CAN FIX IT WITH AN OLD MYSQL DATABASE BACKUP.
PLEASE? HELP? |
once again. every midnight passes and i get this error
getMemberMembershipInfo() fatal error: Standard membership not found.
and i know its a mysql feild causing this as the user memberships are toast. non existant. please help |
Hello. you can use the following code to view your database. you'll have to plug in the top 4 variables from your headers file.
<?php $servername = "localhost"; $username = "your uaername"; $password = "yourDBpassword"; $dbname = "yourdbname"; // grab the above infor from your headers file // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }else echo "connected <br>";
mysql_select_db('alumclou_dolp481');
$sql = "SELECT * FROM Profiles"; $result = $conn->query($sql); while($row = $result->fetch_assoc()) {
print_r($row);
}
$conn->close(); mysql_close($db);
?> |
Sorry, that had errors. here you go...
<?php $servername = "localhost"; $username = "your uaername"; $password = "yourDBpassword"; $dbname = "yourdbname"; // grab the above infor from your headers file // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }else echo "connected <br>";
$sql = "SELECT * FROM Profiles"; $result = $conn->query($sql); while($row = $result->fetch_assoc()) {
print_r($row);
}
$conn->close();
?> |
you can stick any changes in the while statement. sounds like you need to change the id field? you won't know for sure until you take a look at your database. put this code in a new file, upload it to your server and open it in a browser to look at your database structure. My guess is that there is a faulty module doing this. Think about what has changed since the issue arose. in any case its easy to fix as long as it's not reoccurring. |
i will try that tomorrow. this error seems to be in the htdocs. if i restore htdocs (the code) it goes away. but ya, i think the database is also messed up as when i go to membership levels there is nothing there. all blank.
i might try reinstalling dolphin 7.1.6 and then copying over profiles and all the data in the databases exept for the sys_ etc fields. will let you know if this works tomorrow |
PROBLEM SOLVED. USED A DEFAULT DOLPHIN 7.1.6. COPIED OVER THE SYS_ACL ACCOUNT FIELDS AND THE LOCALIZATION FIELDS TO MY CURRENT SITE.
NOW I HAVE BACK ALL MEMBERSHIP ACCESS (YA NO MORE CRASHES) AND LANGUAGES WHICH ALSO WASN'T WORKING. PRETTY SIMPLE. AND EFFECTIVE. I HAD TO REPAIR THE DATABASE WHEN I TRANSFERED THE FIELDS TO MYSQL. |
