Table 'suvoocom_wl.beta' doesn't exist

[adamjones]

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!

[Pikachu2000]

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?

[adamjones]

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?

[adamjones]

Fixed it, for some reason it was this;

 

$forumid = strip_slashes($_GET['id']);

 

Don't know why :S