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

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2011, 09:49 PM
milad-sasha milad-sasha is offline
 
Join Date: Dec 2010
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default what is this erore -mysql error

i when loging my user name then can not see my index page of my forum and this eror of database will be appers...i just can not see my index page of my forum and i can see diffrnt link of my forum...this problem just my user when i loging...plz help me...

Code:
Database error in vBulletin 4.1.3:

Invalid SQL:

			SELECT userid, usergroupid, displaygroupid, username, credits
			FROM user AS user
			WHERE credits > 0 
			ORDER BY credits DESC
			LIMIT 0, 15;

MySQL Error   : Unknown column 'credits' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, May 4th 2011 @ 06:15:11 PM
Error Date    : Wednesday, May 4th 2011 @ 06:15:11 PM
Script        : http://www.rossoneri.ir/index.php
Referrer      : 
IP Address    : 89.144.150.157
Username      : Milad Sasha
Classname     : vB_Database
MySQL Version : 5.0.92-community
Reply With Quote
  #2  
Old 05-04-2011, 11:18 PM
merk_aus merk_aus is offline
 
Join Date: Feb 2008
Location: Australia
Posts: 582
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

it says that you have a credits system that either isn't installed properly or has been removed and the column hasn't been removed.
Reply With Quote
  #3  
Old 05-05-2011, 05:23 AM
milad-sasha milad-sasha is offline
 
Join Date: Dec 2010
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

what is the credits system?!! and i must what do to resolve this problem..plz help me

i im amature

tnx

--------------- Added [DATE]1304587319[/DATE] at [TIME]1304587319[/TIME] ---------------

plz somebody help me..i need help men
Reply With Quote
  #4  
Old 05-05-2011, 01:00 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You might go to the admin comtrol panel and click on "Plugins & Products" and then "Manage Products" and see if there is a product with "credit" in the name name, and if you find one, unintall it.

If that doesn't work, maybe the product or plugin didn't have "credit" in the name, in which case you could disable each product one at a time until the problem goes away, then uninstall that product.
Reply With Quote
  #5  
Old 05-05-2011, 01:23 PM
milad-sasha milad-sasha is offline
 
Join Date: Dec 2010
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

tnx man..my problem is resolve..my problem is this mod : [AJAX]Advanced Forum Statistics
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 02:53 AM.


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.07102 seconds
  • Memory Usage 2,197KB
  • 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
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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