Error Message MySql - Please help

[sovereign6]

Table 'touchof_automall1blue.re2_agents' doesn't exist

I am reasonably new to MySql dbases.

I have uploaded a php website template to my host server.

Created a mySql dbase in Cpanel.

But still getting an error message that says:

Table 'touchof_automall1blue.re2_agents' doesn't exist.

Any help would be most grateful.

Will let you have my Cpanel details, if anybody can take a look.

Thanks

Cheers

[Mrblogs]

IT is saying that a Table named "re2_agents" does not exist in the database "touchof_automaill1blue"

[sovereign6]

Hi MrBlogs

Thanks for your reply.

Still don't understand as I did not create a Table named "re2_agents...

If I give you the Cpanel log in info.

Would you be able to have a look?

Thanks for your advice.

Cheers

[Mrblogs]

Where are you getting that error message?

[minbak]

I think I know what the problem.

You need to restore the backup file from the original database into your new database.

Then, change the login details in conn.php

[littleFella]

When you create a table as admin or a user with admin rights then it may be necessary to grant rights to other users to allow them read access (and/or other rights) to that table.

[FGTH]

I don't think the single quotes are necessay unless you've got dashes in your database name or table name... if you do use single quotes, make sure you're using ` and not '

[Immo]

touchof_automall1blue.re2_agents

Remove the fullstop and replace with an underscore, if its cpanel then re2_agents should be your username.


If that doesnt work goto the mysql page in Cpanel and look under the database, it should show you a connection string that you can copy and paste wherever you need it.