PDA

View Full Version : Please Help about vbdatabase error


chennairam
12-22-2007, 04:52 AM
Hi vbulletin Members

please help me last 2day i am always Getting database Error in My Forum


So kindly Help me

i dont understand To Still Problem From Server or vbulletin


So pls help me Here the log

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts, post_thanks_thanked_times
FROM user
ORDER BY post_thanks_thanked_times DESC LIMIT 0, 10;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Friday, December 21st 2007 @ 04:02:20 PM
Script : http://XXXXXXXXX/forums/
Referrer :
IP Address : 122.164.157.221
Username : chennairam
Classname : vB_Database


Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT * FROM cpsession
WHERE userid = 2
AND hash = '27a0775378d164639109e925a5384614'
AND dateline > 1198297382;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Saturday, December 22nd 2007 @ 05:23:11 AM
Script : http://XXXXXXXXX/forums/admincp/index.php?loc=plugin.php%3Fdo%3Dproduct
Referrer :
IP Address : 122.164.175.247
Username : chennairam
Classname : vB_Database



Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT * FROM user FORCE INDEX (lastpost)
WHERE lastpost > 1198261800 ORDER BY username;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Saturday, December 22nd 2007 @ 06:41:10 AM
Script : http://XXXXXXXXX/forums/index.php
Referrer : http://XXXXXXXXXXXXXXXXXX.org/forums/showthread.php?p=17469#post17469
IP Address : 122.164.175.247
Username : chennairam
Classname : vB_Database


Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'frontredirect'
AND varname = 'login' AND languageid IN (-1, 0, 1);

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Saturday, December 22nd 2007 @ 06:46:11 AM
Script : http://XXXXXXXXX.org/forums/login.php?do=login
Referrer : http://XXXXXXXXX.org/forums/admincp/index.php
IP Address : 122.164.175.247
Username : chennairam
Classname : vB_Database


Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT *
FROM adminmessage
WHERE status = 'undone'
ORDER BY dateline;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Saturday, December 22nd 2007 @ 06:48:15 AM
Script : http://XXXXXXXX/forums/admincp/index.php?do=home
Referrer : http://XXXXXXXXX/forums/admincp/index.php
IP Address : 122.164.175.247
Username : chennairam
Classname : vB_Database



Still i am Worry About my form


br.,
Ram

Lynne
12-22-2007, 03:01 PM
<a href="http://www.vbulletin.com/forum/showpost.php?p=284052&postcount=3" target="_blank">http://www.vbulletin.com/forum/showp...52&postcount=3</a>

chennairam
12-26-2007, 07:17 AM
Hi vbulletin Team

please help me

Problem :- I am Always Getting Database error

So i take a Database backup And Create a New Datbase And import Old Databese To database sucessfully

Version is 3.6.7

After i edit config.php With New Connection settings

After i try to login

Getting Some error


http://img171.imageshack.us/img171/3306/errorzq5.png

So after i download Load Latest 3.6.8 Pathc level 2

I upload all files To My Forum Root Except Install.php

After i done upgrade.php aslo

5 steps it will over

Every thing Sucessfully


But When I Try to Open Forum Its open Good With my User and password Every thing is okey

But I cant login In Adminpannel

When i Put User and password in admin pannel

Thanks For logging

After Again again ask user id and password


Still i cant Login admin pannel

pls Tell me Any thing About This issue


regards
Ram

Marco van Herwaarden
12-26-2007, 08:43 AM
Please upload tools.php from the 'do_not_upload' folder of your vBulletin distribution to your admincp directory. Now point your browser to admincp/tools.php.
Reset the cookie Domain and Path to the default values.
Once your problem is fixed please remove tools.php again from the server.

If this does not solve your problems, please clear your browser cookies and cache, restart your browser and try again.

chennairam
12-26-2007, 11:33 AM
Thanks Sir Now Everything Ok

Now i can login Admin pannel

But When I Try New post I am Getting This error

Warning: Invalid argument supplied for foreach() in /includes/functions_editor.php on line 610

Pls Help me about this also sir

regards
Ram

Marco van Herwaarden
12-27-2007, 09:13 AM
Edit and save any of your BB-codes in the AdminCP, that should resolve this error.

chennairam
12-28-2007, 01:21 PM
Thanks Sir Problem Sloved In Very Shot Period

Thanks a lot again

paulvev
01-02-2008, 09:13 PM
Can anybody help please?

I'm suddenly getting Database Errors on my forum and my emailed error is :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'mysql2.streamline.net' (2) /home/fhlinux210/t/xxxxxxxxxxxxxxx.co.uk/user/htdocs/includes/class_core.php on line 273

The forum still works (mostly) but it IS really annoying to have DB errors every few clicks. Any assistance would be appreciated although i have to point out i am a newbie when it comes to MySQL.

Marco van Herwaarden
01-03-2008, 08:50 AM
Contact your host for the correct MySQL config info.