Database error-mysql error

[saini]

Hi friends,

From last few days i am continuously getting database error. I think this is because of welcome PM settings. Check this:

 Database error in vBulletin 3.8.4:

Invalid SQL:

    REPLACE INTO
      `warezcats_rcd_log_pm`
    SET
      `pmid`          =  397,
      `pmtextid`      =  268,
      `fromuserip`    = '***********',
      `fromuserid`    =  0,
      `fromusername`  = 'Unregistered',
      `fromuseremail` = '',
      `touserid`      =  109,
      `tousername`    = 'duernatte',
      `touseremail`   = '*****************',
      `title`         = 'Welcome to Warezcats',
      `message`       = 'Thanks for registering at Warezcats! We are  glad you have chosen to be a part of our community and we hope you enjoy  your stay.\r\n\r\nAll the best,\r\nWarezcats',
      `iconid`        =  ,
      `dateline`      =  1320728278,
      `showsignature` =  ,
      `allowsmilie`   =  1;

MySQL Error   : 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 '
      `dateline`      =  1320728278,
      `showsignature` =  ,
      `allow' at line 15
Error Number  : 1064
Request Date  : Tuesday, November 8th 2011 @ 05:57:58 AM
Error Date    : Tuesday, November 8th 2011 @ 05:57:58 AM
Script        : http://www.warezcats.com/register.php ***************
Referrer      : *******************
IP Address    : *****************
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Plz help me how to solve this error.....

saini Reviewed by saini on 8th Nov 2011. Database error-mysql error Hi friends, From last few days i am continuously getting database error. I think this is because of welcome PM settings. Check this: Database error in vBulletin 3.8.4: Invalid SQL: REPLACE INTO `warezcats_rcd_log_pm` Rating: 5

[mob_player]

Try to Optimize & repair your database

[saini]

mob, How to do that....?

[newuploader]

Upgrade or remove extraneous data from your database. looks like Mysql quota is full?

[vorazeal]

you can ask your host to do that, mine host did that for me.

[saini]

extraneous data ?? means...?

Will i ask the hosts...?

[mob_player]

mob, How to do that....?

Well, Go to your Vbulletin admincp, then Go to maintenance tools(you can find out through absolute left end), then Repair database , Select all the tables & Choose to optimize and repair it

[saini]

Have did that mob, let's see if i get this error again or not...

Have also notify the hosts...

[nba517]

raise a tk to the host provider