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

Reply
 
Thread Tools Display Modes
  #1  
Old 11-07-2010, 06:45 PM
NLPLegacy NLPLegacy is offline
 
Join Date: Aug 2010
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Error with my products

Code:
Database error in vBulletin 3.8.6:

Invalid SQL:
SELECT t.* FROM credits_transaction AS t LEFT JOIN credits_event AS e ON (t.eventid = e.eventid) WHERE t.userid = 1 AND t.status = 0 AND t.timestamp <= (1289162502 - IF(ISNULL(e.eventid), 0, e.delay)) ORDER BY t.transactionid ASC LIMIT 1;

MySQL Error   : Table '*****_***.credits_transaction' doesn't exist
Error Number  : 1146
Request Date  : Sunday, November 7th 2010 @ 01:41:42 PM
Error Date    : Sunday, November 7th 2010 @ 01:41:42 PM
Script        : http://*********.com/forums/index.php
Referrer      : http://*********.com/forums/******/index.php?do=head
IP Address    : **********
Username      : Legacy
Classname     : vB_Database
MySQL Version : 5.0.91-community

I have no idea what's wrong and I don't know how to fix this. I've also tried another cash system and the same thing happens
Reply With Quote
  #2  
Old 11-07-2010, 08:15 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Disable the product and then post in the modification thread for help. Help for modifications isn't provided out here in the main forums.
Reply With Quote
  #3  
Old 11-08-2010, 01:41 AM
NLPLegacy NLPLegacy is offline
 
Join Date: Aug 2010
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lynne View Post
Disable the product and then post in the modification thread for help. Help for modifications isn't provided out here in the main forums.
I've already done that. This db error comes with other mods as well so it's just not one mod
Reply With Quote
  #4  
Old 11-08-2010, 02:07 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It might come on other pages and such, but it's not a default vbulletin table (there is no credits_transaction table in default vbulletin) so it's from a modification and you need to seek help in the modification thread.
Reply With Quote
  #5  
Old 11-08-2010, 03:48 AM
Michael.A's Avatar
Michael.A Michael.A is offline
 
Join Date: Dec 2008
Location: L.A
Posts: 449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you can just add a Table in you DB with that same title but dont try it unless you backup first..
Reply With Quote
  #6  
Old 11-08-2010, 07:05 AM
FreshFroot's Avatar
FreshFroot FreshFroot is offline
 
Join Date: Jul 2005
Posts: 770
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You need to provide more information.

What product are you using, which uses credits? There are a few and one of them didn't install or uninstall properly.

I can help if you provide more details or pop me a PM if you want.
Reply With Quote
  #7  
Old 11-08-2010, 06:37 PM
NLPLegacy NLPLegacy is offline
 
Join Date: Aug 2010
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by FreshFroot View Post
You need to provide more information.

What product are you using, which uses credits? There are a few and one of them didn't install or uninstall properly.

I can help if you provide more details or pop me a PM if you want.
I'm using vBCredits with vBShop. I've also tried vbPlaza

EDIT: Nevermind guys. I fixed it. I just added all files again and re-installed product
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 01:24 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.03936 seconds
  • Memory Usage 2,215KB
  • 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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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_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