Eroor 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

 

[edmarriner]

in mysql have you just created a database?

 

[sovereign6]

Hi Edmariner,

Yes,

Do I have to create a table as well?

Cheers

 

[Noobie]

create a table and name it re2_agents
... before that ...
did your website come with a file with a .sql extension.

If so, before creating any tables, go to phpMyAdmin from cPanel - >MySQL databases and selected your database, then import, then browse the .sql file and click ok

 

[adam_uk]

sovereign6, like Noobie said in folder with the script you got there is probably a .sql file which you need to upload via phpMYadmin. Or there might even be an installer that will do it for you.

If you check with the people who made the script they might be able to direct you further.

 

[Kate]

Just in case it isn't clear:

'touchof_automall1blue.re2_agents'

=> touchof_automall1blue is the name of the database
=> re2_agents is the name of the table


Also I am wondering if the name of the DB is not too long...

 

[iNod]

No. You are not really limited to the size of the DB. Though I wouldn't recommand having it 100 characters long.

As for the problem I would go into PHPMyAdmin and just type a simple command in the touchof_automall1blue SQL area like

SELECT * FROM re2_agents LIMIT 1

If you get a result than there is no problem. Otherwise if you get an error I would confirm everything. Try deleteing the table and reuploading/creating aswell as doing a few other things like checking for correct spelling.

- Steve

 

[yeppers]

Just in case it isn't clear:

'touchof_automall1blue.re2_agents'

=> touchof_automall1blue is the name of the database
=> re2_agents is the name of the table


Also I am wondering if the name of the DB is not too long...

No. You are not really limited to the size of the DB.

I'm wondering the same thing sdsinc, usually I cannot have a db name longer than around 8 characters, CPanel renames it.

As everyone's been saying sovereign6, if you have a .sql file with your website, upload it via phpMyAdmin. If not, you'll need to create the tables yourself and enter in any old data, which for someone who may not be familiar with SQL and PHP may not be the easiest thing. You'll need to find that SQL file, or reinstall your websites script.

All the best,
Rhett.

 

[iNod]

As far as I know CPanel doesn't allow it to be more than 8 characters as Billy said. But if you use PHPMyAdmin directly you can create it any size. I believe the reason behind it is mainly security and the fact that it adds the suername to the front just makes it that much longer.

Please let us know if you find a way to do this, or figure it out.

- Steve

 

[sovereign6]

Cheers guys for all your help.

Got it sorted.