vb.org Archive - SQL Error

Page 2 of 2

Show 40 post(s) from this thread on one page

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)

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

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 01:42 AM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01005 seconds Memory Usage 1,730KB 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 (1)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 (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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: