smf_personal_messages' doesn't exist

[abhi]

Table '(my dbname) _ (dbname) _(my forum). smf_personal_messages' doesn't exist File: /home/vol9 /http://(Hostname)/htdocs/Sources/Subs-Post.php Line: 1149


what should i do?

Cant snt personal images!

[TheListener]

Can you explain what the cause of the error was.

Mods installed etc.

The more infornmation we have the better we can help.

[abhi]

smf_personal_messages'
table deleted

that table now not at my database!
I want that!

[abhi]

Any1 here?
For a simple support

[xenovanis]

Did you delete that table? Why? 

In phphMyAdmin, run this query:

Code Select Expand


CREATE TABLE smf_personal_messages (
  id_pm int(10) unsigned NOT NULL auto_increment,
  id_pm_head int(10) unsigned NOT NULL default '0',
  id_member_from mediumint(8) unsigned NOT NULL default '0',
  deleted_by_sender tinyint(3) unsigned NOT NULL default '0',
  from_name varchar(255) NOT NULL default '',
  msgtime int(10) unsigned NOT NULL default '0',
  subject varchar(255) NOT NULL default '',
  body text NOT NULL,
  PRIMARY KEY (id_pm),
  KEY id_member (id_member_from, deleted_by_sender),
  KEY msgtime (msgtime),
  KEY id_pm_head (id_pm_head)
) ENGINE=MyISAM;


What is phpMyAdmin?

[abhi]

Unfortunately dear , . .
During My database checking

[ɔɔɔɔɔɔuɥoɾ]

Did you delete that table? Why? 

In phphMyAdmin, run this query:

Code Select Expand


CREATE TABLE smf_personal_messages (
  id_pm int(10) unsigned NOT NULL auto_increment,
  id_pm_head int(10) unsigned NOT NULL default '0',
  id_member_from mediumint(8) unsigned NOT NULL default '0',
  deleted_by_sender tinyint(3) unsigned NOT NULL default '0',
  from_name varchar(255) NOT NULL default '',
  msgtime int(10) unsigned NOT NULL default '0',
  subject varchar(255) NOT NULL default '',
  body text NOT NULL,
  PRIMARY KEY (id_pm),
  KEY id_member (id_member_from, deleted_by_sender),
  KEY msgtime (msgtime),
  KEY id_pm_head (id_pm_head)
) ENGINE=MyISAM;


What is phpMyAdmin?

What if smf_ is not the prefix used lol

[xenovanis]

What if smf_ is not the prefix used lol

Well, I thought about that and then I read this

smf_personal_messages


in the subject of this topic and the first post. So, I assumed it was smf_ 

[abhi]

Hey, how to run query in phpmyadmin

give me the route

[ɔɔɔɔɔɔuɥoɾ]

What if smf_ is not the prefix used lol

Well, I thought about that and then I read this

smf_personal_messages


in the subject of this topic and the first post. So, I assumed it was smf_ 

True, true lol

[xenovanis]

Hey, how to run query in phpmyadmin

give me the route

Open phpMyAdmin, select your database for smf and click the "query" tab at the top of the page.

[abhi]

Yeah clicked . . Then check

feilds,sort,show, etc . .

What create?

[ɔɔɔɔɔɔuɥoɾ]

Run the query

....

Click Go lol

[abhi]

#1064 -  You have an error in your SQL syntax;  check the manual that corresponds to your  MySQL server version for the right syntax to use  near 'smf_personal_messages (   id_pm int(10) unsigned NOT NULL auto_increment,   i' at line 1

smf_personal_messages (     id_pm   INT (   10   )   UNSIGNED   NOT   NULL AUTO_INCREMENT   ,       id_pm_head   INT (   10   ) UNSIGNED   NOT   NULL   DEFAULT '0    id_member_from mediumint(   unsigned NOT NULL default ' 0     deleted_by_sender   TINYINT (   3   )   UNSIGNED

[xenovanis]

Did you just plain copy and paste the code I gave you?

[abhi]

Yes me pasted your code this

Code Select Expand

smf_personal_messages (   
id_pm int(10)  unsigned NOT
NULL auto_increment,   
id_pm_head int(10) 
unsigned NOT NULL default '0
  id_member_from
mediumint(8)  unsigned NOT
NULL default '0   deleted_by_
sender tinyint(3)  unsigned
NOT NULL default '0   
from_name varchar(255) 
NOT NULL default '',   
msgtime int(10)  unsigned
NOT NULL default '0   subject
varchar(255)  NOT NULL
default '',   body text NOT
NULL,   PRIMARY KEY
(id_pm),   KEY id_member
(id_member_from, deleted_
by_sender),   KEY msgtime
(msgtime),   KEY
id_pm_head (id_pm_head) )
ENGINE=MyISAM;

[xenovanis]

Code Select Expand


CREATE TABLE smf_personal_messages (
  id_pm int(10) unsigned NOT NULL auto_increment,
  id_pm_head int(10) unsigned NOT NULL default '0',
  id_member_from mediumint(8) unsigned NOT NULL default '0',
  deleted_by_sender tinyint(3) unsigned NOT NULL default '0',
  from_name varchar(255) NOT NULL default '',
  msgtime int(10) unsigned NOT NULL default '0',
  subject varchar(255) NOT NULL default '',
  body text NOT NULL,
  PRIMARY KEY (id_pm),
  KEY id_member (id_member_from, deleted_by_sender),
  KEY msgtime (msgtime),
  KEY id_pm_head (id_pm_head)
) ENGINE=MyISAM;


Copy again. A lot is missing.

[ɔɔɔɔɔɔuɥoɾ]

Tip, click the [select] button on the top to "select all"

[Kill Em All]

abhi, do you need any further help with this? Did xenovanis's SQL query help create a new PM table for you?