fusion_messages
Asked Modified Viewed 1,993 times
asked
hello, has anyone ever faced a problem like that :
if yes, it would be very nice to share your information with me ;)
thank you
Code Download source
Table 'fusion_messages' is marked as crashed and should be repairedif yes, it would be very nice to share your information with me ;)
thank you
answered
Use whatever tool you have to run sql queries (phpmyadmin?)
run the following:
CHECK TABLE fusion_messages
then
REPAIR TABLE fusion_messages
And check the output.
** I Would backup your database before running the REPAIR TABLE function as it can cause data loss**
Good luck!!
Dave
run the following:
CHECK TABLE fusion_messages
then
REPAIR TABLE fusion_messages
And check the output.
** I Would backup your database before running the REPAIR TABLE function as it can cause data loss**
Good luck!!
Dave
answered
guys, i dont understand anything about mysql databases... :| maybe there is some kind of script to run ?
answered
Quote
chankarwing wrote:
try what bman suggested if that doesn't help then ermmmm....drop the table and remake the table (NOT THE DATABASE).
Im guessing misuse of the PM system is to blame for this ;)
i' ve droped a table fusion_messages , and now i got an error :
Code Download source
Table 'muzika_1.fusion_messages' doesn't exist Falk
Falk 131
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct
(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
- Super Admin, joined since
- Contributed 6,201 posts on the community forums.
- Started 639 threads in the forums
- Answered 11 questions
Go to admin => custom pges, preview this:
//Moderator: fixed misplaced [ / code] tag
Code Download source
<?php
$result = dbquery("CREATE TABLE ".$db_prefix."messages (
message_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
message_to MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
message_from MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
message_subject VARCHAR(100) NOT NULL DEFAULT '',
message_message TEXT NOT NULL,
message_smileys CHAR(1) NOT NULL DEFAULT '',
message_read TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
message_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
message_folder TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (message_id)
) TYPE=MyISAM;");
echo "Messages table restored";
?>//Moderator: fixed misplaced [ / code] tag
Edited by Sveinungs on 06-08-2007 18:37,
answered
thanks everybody for your help, i have reinstaled my fusion, and everything went good ;)
Category Forum
Official Core Support - 6Labels
None yet
Statistics
- Views 0 views
- Posts 5 posts
- Votes 0 votes
- Topic users 3 members
0 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions