Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 12-22-2007, 04:52 AM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Reply With Quote
  #2  
Old 12-22-2007, 03:01 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<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>
Reply With Quote
  #3  
Old 12-26-2007, 07:17 AM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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




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
Reply With Quote
  #4  
Old 12-26-2007, 08:43 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 12-26-2007, 11:33 AM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #6  
Old 12-27-2007, 09:13 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Edit and save any of your BB-codes in the AdminCP, that should resolve this error.
Reply With Quote
  #7  
Old 12-28-2007, 01:21 PM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks Sir Problem Sloved In Very Shot Period

Thanks a lot again
Reply With Quote
  #8  
Old 01-02-2008, 09:13 PM
paulvev's Avatar
paulvev paulvev is offline
 
Join Date: Mar 2007
Posts: 73
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #9  
Old 01-03-2008, 08:50 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Contact your host for the correct MySQL config info.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:01 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05198 seconds
  • Memory Usage 2,247KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete