vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Please Help about vbdatabase error (https://vborg.vbsupport.ru/showthread.php?t=165837)

chennairam 12-22-2007 04:52 AM

Please Help about vbdatabase error
 
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
Quote:

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
Quote:

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/inde...3Fdo%3Dproduct
Referrer :
IP Address : 122.164.175.247
Username : chennairam
Classname : vB_Database

Quote:

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...7469#post17469
IP Address : 122.164.175.247
Username : chennairam
Classname : vB_Database
Quote:

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.


All times are GMT. The time now is 06:19 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01051 seconds
  • Memory Usage 1,738KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete