vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vbBux / vbPlaza (https://vborg.vbsupport.ru/forumdisplay.php?f=171)
-   -   SQL Error (https://vborg.vbsupport.ru/showthread.php?t=109936)

GamerzWorld 03-09-2006 03:51 PM

SQL Error
 
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 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 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 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 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 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 03-10-2006 12:27 PM

did you run fix all gifts postbit???

GamerzWorld 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 :confused:

Guess im going to have to disable for now :(

CMX_CMGSCCC 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 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


All times are GMT. The time now is 03:08 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.01001 seconds
  • Memory Usage 1,737KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete