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

CMX_CMGSCCC 03-11-2006 03:11 PM
MySQL Version 3.23.58

I wonder if I'm creating a field in there that in incompatible with 3.23, I'll look into this.

EDIT: No, it looks valid.. try running this query and see if it gives u an error..

Code:
        CREATE TABLE IF NOT EXISTS (tableprefix)vbp_ribbon
        (
                ribbonid INT UNSIGNED NOT NULL auto_increment,
                visible INT UNSIGNED NOT NULL DEFAULT '1',
                ribbonname VARCHAR(100) NOT NULL DEFAULT '',
                touserid INT UNSIGNED NOT NULL DEFAULT '0',
                tousername VARCHAR(100) NOT NULL DEFAULT '',
                fromuserid INT UNSIGNED NOT NULL DEFAULT '0',
                fromusername VARCHAR(100) NOT NULL DEFAULT '',
                cause VARCHAR(250) NOT NULL DEFAULT '',
                message VARCHAR(250) NOT NULL DEFAULT '',
                PRIMARY KEY  (ribbonid)
        ) TYPE=MyISAM;
Change (tableprefix) to your table prefix or remove it if u do not have one.

-CMX

GamerzWorld 03-11-2006 03:32 PM
Your SQL query has been executed successfully (Query took 0.0009 sec)
Its there now..hmm. Still not got any other of the DB's, can you paste a list of commands to do it manuallyplease

CMX_CMGSCCC 03-11-2006 08:58 PM
Just take it from inside the product-vbbuxplaza.xml

If you do not have it installed, u really need to reimport the product again..

Edit the previous vbPlaza plugin and set the version number to like 1.4.9

Then save the change it should say 1.4.9 in Manage Products, then import the product-vbbuxplaza.xml file with allow overwrite set to yes and it should install all of the tables, if its not, u r doing something wrong.

The reason I believe this is because the query worked u said, so there is definitely not a conflicting MySQL version problem.

-CMX

GamerzWorld 03-11-2006 09:25 PM
Quote:
Originally Posted by CMX_CMGSCCC
Just take it from inside the product-vbbuxplaza.xml

If you do not have it installed, u really need to reimport the product again..

Edit the previous vbPlaza plugin and set the version number to like 1.4.9

Then save the change it should say 1.4.9 in Manage Products, then import the product-vbbuxplaza.xml file with allow overwrite set to yes and it should install all of the tables, if its not, u r doing something wrong.

The reason I believe this is because the query worked u said, so there is definitely not a conflicting MySQL version problem.

-CMX
I have reimported it around 10 times and no luck so it must be the installer conflicting with something

CMX_CMGSCCC 03-11-2006 09:28 PM
If u give me admin access to ur forums and ftp access to verify the files uploaded, I could install it for u and figure out exactly what the problem is.

If u will agree to that, send me the details via PM.

-CMX

GamerzWorld 03-11-2006 10:12 PM
Sent :)

Tryed adding more manually, got the following error

"#1064 - You have an error in your SQL syntax near '" . TABLE_PREFIX . "vbp_gift
(
giftid INT UNSIGNED NOT NULL auto_increment,' at line 1"

CMX_CMGSCCC 03-12-2006 10:22 AM
You will have to replace " . TABLE_PREFIX . " with your real table prefix or delete it if u do not have one.

-CMX


All times are GMT. The time now is 05:52 PM.

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.01730 seconds
  • Memory Usage 1,757KB
  • 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
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (17)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