Vbulleting database error

[saini]

Himates,

facing database errors on posting new threads...:

Database error in vBulletin :

Invalid SQL:
INSERT INTO warezcats_thread
        (prefixid, postusername, postuserid, title, iconid, visible,  forumid, dateline, open, attach, lastpost, lastposter, replycount,  hiddencount, deletedcount)
VALUES
        ('', 'stefan-te', 283, 'Spartacus S02E08 480p HDTV XviD  AC3-MeRCuRY', 0, 1, 24, 1332223947, 1, 0, 1332223947, 'stefan-te', 0, 0,  0);

MySQL Error   : Duplicate entry '54398' for key 'PRIMARY'
Error Number  : 1062
Request Date  : Tuesday, March 20th 2012 @ 07:12:27 AM
Error Date    : Tuesday, March 20th 2012 @ 07:12:27 AM
Script        : http://www.warezcats.com/newthread.p...ostthread&f=24
Referrer      :
IP Address    : 77.28.129.98
Username      : stefan-te
Classname     : vB_Database
MySQL Version :

Any idea how to solve it....

saini Reviewed by saini on 20th Mar 2012. Vbulleting database error Himates, facing database errors on posting new threads...: Database error in vBulletin : Invalid SQL: INSERT INTO warezcats_thread (prefixid, postusername, postuserid, title, iconid, visible, forumid, dateline, open, attach, lastpost, lastposter, replycount, hiddencount, deletedcount) VALUES Rating: 5

[JamesVaporH]

Go into the admin panel and do a optimize and repair on all databases.
If not then try it from phpmyadmin and if that still does not work try to clean all posts and threads using the clean up tools

[saini]

thanks james, Its working after repairing the database...

[saini]

now i am getting following errors:

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
/home/warezcat/public_html/includes/class_core.php on line 311

MySQL Error   :
Error Number  :
Request Date  : Friday, March 23rd 2012 @ 12:44:27 PM
Error Date    : Friday, March 23rd 2012 @ 12:44:27 PM
Script        : http://www.warezcats.com/post_thanks...ser_gave&u=455
Referrer      :
IP Address    : 208.86.198.82
Username      :
Classname     : vB_Database
MySQL Version :

..
how to fix it....?

---------- Post added at 05:25 PM ---------- Previous post was at 05:18 PM ----------

sorry its a problem from host as mysql server is down.....

[Exel]

Indeed, it's in the error, just got to look closer.

'Can't connect to local MySQL server through socket'
Usually happens on shared hosts.

[saini]

hi, plz help me i am getting this error now:

Database error in vBulletin :

Invalid SQL:

                        SELECT *
                        FROM warezcats_datastore
                        WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');

MySQL Error   : Can't find file: './warezcat_wcats/warezcats_datastore.frm' (errno: 13)
Error Number  : 1017
Request Date  : Saturday, April 7th 2012 @ 12:54:13 AM
Error Date    : Saturday, April 7th 2012 @ 12:54:14 AM
Script        : http://www.warezcats.com/
Referrer      :
IP Address    : 117.212.56.136
Username      :
Classname     : vB_Database
MySQL Version :

how to fix it...everything is fine including config.php but still this error is coming....

[maverick79]

try to repair and optimize the database from phpmyadmin

[Exel]

Can't find file: './warezcat_wcats/warezcats_datastore.frm

Repairing the db should do the trick.

[JamesVaporH]

hi, plz help me i am getting this error now:

Database error in vBulletin :

Invalid SQL:

                        SELECT *
                        FROM warezcats_datastore
                        WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');

MySQL Error   : Can't find file: './warezcat_wcats/warezcats_datastore.frm' (errno: 13)
Error Number  : 1017
Request Date  : Saturday, April 7th 2012 @ 12:54:13 AM
Error Date    : Saturday, April 7th 2012 @ 12:54:14 AM
Script        : http://www.warezcats.com/
Referrer      :
IP Address    : 117.212.56.136
Username      :
Classname     : vB_Database
MySQL Version :

how to fix it...everything is fine including config.php but still this error is coming....

Either host has not permission-ed the mysql data folder correctly (usually caused when the datastore folder of the mysql database is transferred over)

fix only root can fix:

chown -R mysql:mysql foldername

Or the actual database file is missing.

[saini]

the files are still there i have checked.....let me ask the host again...

---------- Post added at 01:48 PM ---------- Previous post was at 01:46 PM ----------

and how to repair the database in kloxo cpanel....?