List of forum errors -- what happened?

[tsis_k]

After running find and repair any errors from forum maintenance in Admin panel, I got these errors

The following errors are fouling up your forum:
Member #8009 has received one or more personal messages, but does not exist.
The subject of topic #165943 is currently not stored in the subject cache.
Cached word 'dear' is linked to a non-existent topic.
Cached word 'husband' is linked to a non-existent topic.
Cached word 'my' is linked to a non-existent topic.
Cached word 're' is linked to a non-existent topic.
Cached word 'version' is linked to a non-existent topic.

Would you like to fix these errors?
Yes - No

I then proceed to click "yes" but unlike it has done in the past, this is what I got.

Database Error
Duplicate entry '2494512-1' for key 3
File: /home/xxxxxx/public_html/forum/Sources/RepairBoards.php
Line: 190

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.3. The above error might possibly go away if you execute the latest version of upgrade.php.

I'm at a lost at how to solve this problem. Please help

[Kill Em All]

Please run the upgrade.php from the large upgrade package. You can simply just upload the sql files and the upgrade.php then run the upgrade.php.  Tell us if you get the same error.

[Oldiesmann]

The "duplicate key" error is a bug in SMF which has been fixed for SMF 2.0. See Bug #2725: "Find and Repair Errors" can cause "duplicate key" errors... for more info.

Try running these queries in phpMyAdmin before trying to repair the errors:

Code Select Expand

UPDATE smf_topics SET ID_FIRST_MSG = 0 WHERE ID_FIRST_MSG = 2494512;
UPDATE smf_topics SET ID_LAST_MSG = 0 WHERE ID_LAST_MSG = 2494512;

That should prevent the repair process from creating a duplicate key error.

The odd thing is, the thing it's trying to repair there isn't one of the problems listed (stranded post - SMF found a post linked to a non-existent topic).

[tsis_k]

The "duplicate key" error is a bug in SMF which has been fixed for SMF 2.0. See Bug #2725: "Find and Repair Errors" can cause "duplicate key" errors... for more info.

Try running these queries in phpMyAdmin before trying to repair the errors:

Code Select Expand

UPDATE smf_topics SET ID_FIRST_MSG = 0 WHERE ID_FIRST_MSG = 2494512;
UPDATE smf_topics SET ID_LAST_MSG = 0 WHERE ID_LAST_MSG = 2494512;

That should prevent the repair process from creating a duplicate key error.

The odd thing is, the thing it's trying to repair there isn't one of the problems listed (stranded post - SMF found a post linked to a non-existent topic).

Thank you.

After running the queries above, find and repair any errors maintenance was complete without any problem.

[ModelBoatMayhem]

Could someone help me with this please?
( I'm not technical but do have access to all sorts of magical things in my VPS CPannel, including phpMyAdmin but I don't really know what I'm doing... ) 

Database Error

Duplicate entry '270296-84' for key 3
File: /home/xxxxxxxx/public_html/forum/Sources/RepairBoards.php
Line: 190

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.12, while your database is at version 1.1 RC3. The above error might possibly go away if you execute the latest version of upgrade.php. 

[Paul_Pauline]

Hi.

In phpMyAdmin, click on the link to the database you want, then at the top click on query, this will open up an input field to enter queries, enter the queries shown in the earlier post and run them, when you have done that run the upgrade.

[ModelBoatMayhem]

Thanks Paul,I get the error message:

SQL query:
UPDATE smf_topics SET ID_FIRST_MSG =0 WHERE ID_FIRST_MSG =270296 -84;


MySQL said:
  #1146 - Table 'mbmayhem_forum.smf_topics' doesn't exist

[Paul_Pauline]

Hi.

Do you tables have a different prefix than smf

If they do replace the smf with the prefix you are using.

[ModelBoatMayhem]

That's fixed it! Thanks..... how do I run upgrade.php on it's own? ( It says the forum is up to date.)

[Paul_Pauline]

Grab a 1.1.12 large upgrade pack, unzip it and find the three files "upgrade" "upgrade_1-0.sql" "upgrade_1-1.sql", place these in the root of your forum and run the upgrade.

Browse to  http://yoursitesname.com/upgrade.php

[ModelBoatMayhem]

That's brilliant Paul, no errors now.
Thanks for explaining so simply.

Can you help me with another problem? When i try to do a backup (via Forum Maintenance panel ), it's now only producing a 0 byte file? ( normally, up till last week it was over 67Mb.)

What areas should i be look at to fix this, please?

[Illori]

check this out How do I backup my database?

[Paul_Pauline]

I personally wouldn't rely on the backup function in your admin panel, I make my own database backups through my hosts control panel.

I backup my SMF files by dragging them over to my desktop via ftp.

[ModelBoatMayhem]

Thanks everyone, got my errors sorted out and downloading my entire site now via CPannel..... 8.3Gig!!!

[Kill Em All]

I am going to mark the topic solved, please feel free to unmark it solved if you have further questions.

[ModelBoatMayhem]

Can I ask one more question please?

I've got the 8.6Gig backup file sitting on my server but so far I've not found a way of downloading it.
I tried FTP and it only downloads 2.6Gig,  same with download from file manager in Cpanel. The session says it complete but obviously it's not.

What am I doing wrong?

[Illori]

how did you produce the backup? where in your file manager/ftp do you see this archive file?

[ModelBoatMayhem]

I used Cpanel's - "Backup Wizard".It's produced a xxxx.tar.gz  8.6 Gb file on the root of my host server.....

[Illori]

you could go into the file manager browse to your smf folder, have it check all files [check box] and compress the files that are checked then download that zip.

[ModelBoatMayhem]

That also produces a huge file of over 4Gb....