vb.org Archive - Error with my products

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Error with my products (https://vborg.vbsupport.ru/showthread.php?t=253316)

NLPLegacy

11-07-2010 06:45 PM

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

Lynne

11-07-2010 08:15 PM

Disable the product and then post in the modification thread for help. Help for modifications isn't provided out here in the main forums.

NLPLegacy

11-08-2010 01:41 AM

Quote:

Originally Posted by Lynne (Post 2119205)

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

Lynne

11-08-2010 02:07 AM

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.

Michael.A

11-08-2010 03:48 AM

you can just add a Table in you DB with that same title but dont try it unless you backup first..

FreshFroot

11-08-2010 07:05 AM

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.

NLPLegacy

11-08-2010 06:37 PM

Quote:

Originally Posted by FreshFroot (Post 2119384)

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

All times are GMT. The time now is 09:14 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01183 seconds Memory Usage 1,725KB 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 (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)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
Messages: