Table [username].categories not found

I'm trying to install the Build a Niche Script on my GoDaddy host, I followed all the instructions provided yet when I load the page I get that in the title:

crystak.categories not found

And crystak is my username and name of the database!

I don't know much about MySQL databases but I've tried looking for information about this on the internet but there is none.

My website is www.myemohairstyles.com and you can see this happening there.

In the config.php file I have this::

<?php 
$hostname = "server name";
$database = "crystak";
$username = "crystak";
$password = "pass";
?>

PHP:

and this corresponds to the information on the godaddy database.

I have no experience about this whatsoever so if you think you need any more info to help, please let me know!

Hope someone can help me fix this .

 

I imagine 'crystak.categories not found' means that the application failed to install, when installing it couldn't create the necessary tables but it finished the installation anyway. You'll need to delete and reupload the script, delete and recreate the database, and then run the installer again.

 

you posted enough information for hackers to hack your site, remove those asap.

 

Maybe 'password' is fake.

 

Yes, password was fake - is it still at risk ? :S

I've already done this 3 times and same thing happens . I'll try again and see how it goes.

Just re-tried it and same page appears. Thing is that the word in front of .categories changes to whatever the database name/username is.

I'm wondering whether the code contained in that config.php file is not too little for this as browsing godaddy I saw they recommend this code for connecting to my Linux server:

<?php
//Sample Database Connection Syntax for PHP and MySQL.

//Connect To Database
$hostname="mysql.secureserver.net";
$username="your_dbusername";
$password="your_dbpassword";
$dbname="your_dbusername";
$usertable="your_tablename";
$yourfield = "your_field";
$connection = mysql_connect("$hostname", "$username", "$password");
mysql_select_db("$databasename", $con);

# Check If Record Exists

$query = "SELECT * FROM $usertable";

$result = mysql_query($query);

if($result)
{
while($row = mysql_fetch_array($result))
{
$name = $row["$yourfield"];
echo "Name: ".$name."
";
}
}
?>

PHP:

But if I copy and paste that I don't know the values of the other variables such as tablename and field .

Also, it's MySQL 5.0 - don't know if that makes a difference.

 

Nah, they would have a different file for the connection. They would just be including the config to grab the login details.

So did you run through an install file? Maybe you have to run a file such as www.domain.com/install/ or www.domain.com/install.php

You oculd also look for a readme.txt.

 

There is a readme.pdf but I followed the instructions precisely... I created this database on GoDaddy, fetched my info from there, added it in the config.php file that came with the BANS package, uploaded the rest of the website through Cute FTP, set the right CHMOD properties as instructed and that was all.

 

If you made no errors with the connection details or anything else then it must be a problem with the script (or a combination of the web hosting and the script). Contact whoever made the script, hopefully they can help.

 

Ah I feel so stupid now, finally got it to work. I spent about 3 hours trying and soon after posting this it works.

I uploaded the database manually through my mysql admin panel provided by GoDaddy rather than uploading it in the root folder of the website. You'd think it's a very important step to miss in the damn instructions!

 

Haha, yes. A database won't work by simply being uploaded. It needs to be executed by MySQL (PHPMyAdmin).