Latest Announcemnent
New thread

Vbulleting database error

Status
Not open for further replies.
R

RDB

Active Member
1,109
2011
88
40
Himates,

facing database errors on posting new threads...:

Code: 
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        : [URL]http://www.warezcats.com/newthread.php?do=postthread&f=24[/URL]
Referrer      :
IP Address    : 77.28.129.98
Username      : stefan-te
Classname     : vB_Database
MySQL Version :

Any idea how to solve it....
 
21 comments
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
 
now i am getting following errors:

Code: 
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        : [URL]http://www.warezcats.com/post_thanks.php?do=findthanks_user_gave&u=455[/URL]
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.....
 
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.
 
hi, plz help me i am getting this error now:

Code: 
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        : [URL]http://www.warezcats.com/[/URL]
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....
 
saini said:
hi, plz help me i am getting this error now:

Code: 
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        : [URL]http://www.warezcats.com/[/URL]
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....
Click to expand...

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:
Code: 
chown -R mysql:mysql foldername

Or the actual database file is missing.
 
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....?
 
i have kloxo panel.....how to solve this error....

---------- Post added at 04:16 PM ---------- Previous post was at 01:57 PM ----------

plz someone help, how to run that query from kloxo panel...?

---------- Post added at 04:26 PM ---------- Previous post was at 04:16 PM ----------

Oh so now its working after running this query.....thanks vapor host...

My site is up now....:)
 
Sorry i never got back to you i was gone for a few days.

Glad to see it was resolved.

saini said:
i have kloxo panel.....how to solve this error....

---------- Post added at 04:16 PM ---------- Previous post was at 01:57 PM ----------

plz someone help, how to run that query from kloxo panel...?

---------- Post added at 04:26 PM ---------- Previous post was at 04:16 PM ----------

Oh so now its working after running this query.....thanks vapor host...

My site is up now....:)
Click to expand...
 
While installing a fresh vbulletin i am getting this error:
90odxc.jpg


how to solve this error...?
 
That just means the user warezcat_wcats was not allowed access to the database specified.

Make sure you have added the correct user and privileges to the mysql database.
 
You need to add the database details in the config file and create the same on the server i.e cpanel and then also add the username and password that has full privelages on the hosting cheers
if you still can't fix drop me a pm will do it for you
cheers
 
ok problem solved..:)

---------- Post added at 10:42 PM ---------- Previous post was at 10:03 PM ----------

here is more error:

i am getting 500 internal server error while access admincp......
forum and mod cp working fine but admincp giving 500 internal server error....

there is no vbseo installed too...

any way to solve it...?
 
another database error:

Code: 
Database error in vBulletin 3.8.6:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `glowhostspamomatic_log`(
                                    `date` DATETIME NOT NULL,
                                    `ip` VARCHAR(15) NOT NULL,
                                    `email` VARCHAR(255) NOT NULL,
                                    `username` VARCHAR(255) NOT NULL,
                                    `message` VARCHAR(255) NOT NULL,
                                    `is_blocked` TINYINT NOT NULL DEFAULT "0",
                                    `user_hash` VARCHAR(50) NOT NULL,
                                    `user_id` INT NOT NULL
                                 ) TYPE=MyISAM;;

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 'TYPE=MyISAM' at line 10
Error Number  : 1064
Request Date  : Wednesday, April 11th 2012 @ 02:51:47 AM
Error Date    : Wednesday, April 11th 2012 @ 02:51:48 AM
Script        : http://www.whangout.com/admincp/plugin.php?do=productimport
Referrer      : http://www.whangout.com/admincp/plugin.php?do=productadd
IP Address    : 117.203.143.42
Username      : WHangout
Classname     : vB_Database
MySQL Version : 5.5.21-cll
 
Status
Not open for further replies.
Back
Top