database problem

[talkingfootball]

Hi All

I'm having a problem with missing database files.

My old webhost moved the sites on their server ... then the problems begun.

We then moved webhosts and they have told me to post here for advice.

site is www.talkingfootball.net/forums

Regards

Looking forward to your reply

[Lynne]

Perhaps restore the site from a backup? Without you posting more specifics (like the actual errors), then we really aren't going to be able to help you much.

[talkingfootball]

Hi Lynne

Here is the exact error I'm getting. Thanks for your help so far.


Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
VALUES
(1, 1, 'TalkingFootball', 1, 'Test', 'Testing small problem', 0, 1, 1204423248, '58.168.210.49', 0, 1958);

MySQL Error : Duplicate entry '20982' for key 1
Error Number : 1062
Date : Saturday, March 1st 2008 @ 09:00:48 PM
Script : http://www.talkingfootball.net/forums/newthread.php?do=postthread&f=33
Referrer : http://www.talkingfootball.net/forums/newthread.php?do=newthread&f=33
IP Address : 58.168.210.49
Username : TalkingFootball
Classname : vB_Database

[Marco van Herwaarden]

See: Duplicate entry 'XXX' (http://www.vbulletin.com/docs/html/main/mysql_duplicatekey)

[talkingfootball]

Thanks Marco

However as a newbie what does it mean by .....

"Please run these queries to create the proper indexes in vBulletin"

[Phaedrus]

How do you access your database in your IP Control Panel?

It will make a difference in how to run queries.

If you are using phpMyAdmin... after logging into phpMyAdmin

1. Select the database from the left.
2. Click on the SQL tab at the top.
3. Run the queries in the box provided...

[Blazin Trav]

I don't see any errors @ OP. Are you still having issues?

[talkingfootball]

I don't see any errors @ OP. Are you still having issues?

Hi Trav

Yip people cant post on the forum!!!

[Opserty]

<a href="http://www.vbulletin.com/docs/html/maintenance_query" target="_blank">How to run queries</a>