The Arcive of Official vBulletin Modifications Site.

SQL Error · **Released**: 03-09-2006

Hello,

When im attemtping to view members profiles I am getting the following error

Quote:

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT * FROM vbp_ribbon
WHERE touserid = '695'
ORDER BY ribbonid DESC;

MySQL Error : Table 'Mirzone.vbp_ribbon' doesn't exist
Error Number : 1146
Date : Thursday, March 9th 2006 @ 09:48:27 AM
Script : http://www.rpg-centre.com/forum/member.php?u=695
Referrer : http://www.rpg-centre.com/forum/index.php?styleid=11
Username : Merlin
Classname : vb_database

I really cant afford to shut it down for peoples p3tz yet obviously I need this facility asap.. Thanks for any help

p.s. im running latest version, upgraded it from ebux

X-Files · #2 03-09-2006, 04:26 PM

Quote:

Originally Posted by GamerzWorld

Hello,

When im attemtping to view members profiles I am getting the following error

I really cant afford to shut it down for peoples p3tz yet obviously I need this facility asap.. Thanks for any help

p.s. im running latest version, upgraded it from ebux

Have you run the rebuild for the ribbon system.

CMX_CMGSCCC · #3 03-09-2006, 05:24 PM

The install did not work properly if that table does not exist.

You could try to fix the install by editing the product for vbPlaza, and setting its version number to 1.4.9

Then try to reimport the product XML file with allow overwrite set to Yes and it should fix it.

-CMX

GamerzWorld · #4 03-10-2006, 09:26 AM

Sigh, I did what you said yet still the database isnt right

"MySQL Error : Table 'Mirzone.vbp_option' doesn't exist"

Rickie3 · #5 03-10-2006, 10:18 AM

Quote:

Originally Posted by GamerzWorld

Sigh, I did what you said yet still the database isnt right

"MySQL Error : Table 'Mirzone.vbp_option' doesn't exist"

i had the exact same error,once i uninstalled the old estore/ebux plugin all was good

GamerzWorld · #6 03-10-2006, 12:23 PM

Quote:

Originally Posted by Rickie3

i had the exact same error,once i uninstalled the old estore/ebux plugin all was good

I followed instructions, just double checked it was deffinatly uninstalled :tired:

Rickie3 · #7 03-10-2006, 12:27 PM

did you run fix all gifts postbit???

GamerzWorld · #8 03-10-2006, 01:45 PM

Quote:

Originally Posted by Rickie3

did you run fix all gifts postbit???

No but my users could not and did not buy gifts, I only used it for points

Guess im going to have to disable for now

CMX_CMGSCCC · #9 03-11-2006, 12:48 PM

For some reason the vbp_ribbon table did not get created properly, what version MySQL are u using?

Also can u paste the table definition for vbp_ribbon if it does indeed exist.

-CMX

GamerzWorld · #10 03-11-2006, 02:07 PM

Quote:

Originally Posted by CMX_CMGSCCC

For some reason the vbp_ribbon table did not get created properly, what version MySQL are u using?

Also can u paste the table definition for vbp_ribbon if it does indeed exist.

-CMX

It doesnt even create. Tryed uninsalling and reinstaling and although it says its making it while I uplload it, it does not appear :tired:

http://www.mirzone.net/phpinfo.php

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06102 seconds Memory Usage 2,288KB Queries Executed 23 (?)
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 (6)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)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 pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!