adamjones Posted August 16, 2010 Share Posted August 16, 2010 Hi, No matter what I seem to change in my code, I sill get the same error! "Table 'suvoocom_wl.beta' doesn't exist" This is my 'core.php' file; <?php session_start(); @include ('config.php'); @include ('connect.php'); // ######################################################################### // Check if Writing Lounge is under maintenance, and avoid, if possible $qry="SELECT * FROM fuse_rights WHERE username='".$_SESSION['username']."'"; $result=mysql_query($qry); if($result) { if(mysql_num_rows($result) == 1) { $checks = mysql_fetch_assoc($result); $am = $checks['avoid_maintenance']; } } if(isset($_SESSION['username']) && $am == 0) { $result = mysql_query("SELECT * FROM break") or die(mysql_error()); while($row = mysql_fetch_assoc($result)) { if($row['on'] == 1) { header('location:../maintenance'); exit(); } } } if(isset($_SESSION['username']) && $am == 1) { } else { $result = mysql_query("SELECT * FROM break") or die(mysql_error()); while($row = mysql_fetch_assoc($result)) { if($row['on'] == 1) { header('location:../maintenance'); exit(); } } } // ######################################################################### // Check if Writing Lounge has BETA activated if(!session_is_registered(betaaccess)){ $result = mysql_query("SELECT * FROM beta") or die(mysql_error()); while($row = mysql_fetch_assoc($result)) { if($row['on'] == 1) { header('location:../BETA'); exit(); } } } // ######################################################################### // Check if the user logged in is banned $result = mysql_query("SELECT username FROM bans WHERE username = '".$_SESSION['username']."'") or die(mysql_error()); if (mysql_num_rows($result) > 0) { header('location:../banned'); exit(); } // ######################################################################### // Define the variables Writing Lounge will use later on $remote_ip = $_SERVER[REMOTE_ADDR]; $H = date('H'); $i = date('i'); $s = date('s'); $m = date('m'); $d = date('d'); $Y = date('Y'); $j = date('j'); $n = date('n'); $today = $d; $month = $m; $year = $Y; $date_normal = date('d-m-Y',mktime($m,$d,$Y)); $date_reversed = date('Y-m-d', mktime($m,$d,$y)); $date_full = date('d-m-Y H:i:s',mktime($H,$i,$s,$m,$d,$Y)); $date_time = date('H:i:s',mktime($H,$i,$s)); $date_hc = "".$j."-".$n."-".$Y.""; $regdate = $date_normal; $forumid = strip_slashes($_GET['id']); ?> It's basically the backbone to my website. This is my 'config.php' file; <?php $sqlhostname = "localhost"; $sqlusername = "suvoocom_wl"; $sqlpassword = "*****"; $sqldb = "suvoocom_wl"; ?> And this is my 'connect.php' file; <?php mysql_connect("$sqlhostname", "$sqlusername", "$sqlpassword")or die("Unable to connect."); mysql_select_db("$sqldb")or die("Unable to select the database you provided. Either I do not have premission to connect to that database, or the database doesn't exist."); ?> Does anyone have any ideas? :S Thanks! Link to comment https://forums.phpfreaks.com/topic/210865-table-suvoocom_wlbeta-doesnt-exist/ Share on other sites More sharing options...
Pikachu2000 Posted August 16, 2010 Share Posted August 16, 2010 Is all of the spelling and capitalization identical between the script and the table? What happens if you copy/paste the query string into phpMyAdmin? Link to comment https://forums.phpfreaks.com/topic/210865-table-suvoocom_wlbeta-doesnt-exist/#findComment-1099865 Share on other sites More sharing options...
adamjones Posted August 16, 2010 Author Share Posted August 16, 2010 Is all of the spelling and capitalization identical between the script and the table? What happens if you copy/paste the query string into phpMyAdmin? Thankyou! In my table, beta was capitalised, however, now I'm just been given a blank page? Link to comment https://forums.phpfreaks.com/topic/210865-table-suvoocom_wlbeta-doesnt-exist/#findComment-1099872 Share on other sites More sharing options...
adamjones Posted August 16, 2010 Author Share Posted August 16, 2010 Fixed it, for some reason it was this; $forumid = strip_slashes($_GET['id']); Don't know why :S Link to comment https://forums.phpfreaks.com/topic/210865-table-suvoocom_wlbeta-doesnt-exist/#findComment-1099873 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.