vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Add-On Releases - vbuserbar for 3.6.x (https://vborg.vbsupport.ru/showthread.php?t=132629)

imported_predatorkill 11-28-2006 07:24 PM

The update was done in less than a minute...Great job stony,again!!:cool: :cool:

Roxie 11-28-2006 09:02 PM

I get this error even using the newest version:

Quote:


Invalid SQL:

CREATE TABLE vb3_`vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT( 10 ) NOT NULL ,
`usergroupid` INT( 10 ) NOT NULL ,
`name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`path` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`createdate` INT( 10 ) NOT NULL ,
`modifieddate` INT( 10 ) NOT NULL ,
`groupid` INT( 10 ) NOT NULL ,
INDEX ( `userid` , `usergroupid`, `name`)
) TYPE = MYISAM;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT' at line 1
Error Number : 1064
Date : Tuesday, November 28th 2006 @ 05:59:50 PM
Script : http://.......com/admincp/plugin.php?do=productimport
Referrer : http://....../admincp/plugin.php?do=productadd
IP Address : ....
Username : ....
Classname : vb_database

sduckie2k5 11-28-2006 09:45 PM

Same thing here, new version, first time install. Heres mine....

Invalid SQL:

CREATE TABLE vb_`vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT( 10 ) NOT NULL ,
`usergroupid` INT( 10 ) NOT NULL ,
`name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`path` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`createdate` INT( 10 ) NOT NULL ,
`modifieddate` INT( 10 ) NOT NULL ,
`groupid` INT( 10 ) NOT NULL ,
INDEX ( `userid` , `usergroupid`, `name`)
) TYPE = MYISAM;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT' at line 1
Error Number : 1064
Date : Tuesday, November 28th 2006 @ 06:46:32 PM
Script : ..........plugin.php?do=productimport
Referrer :
IP Address : .......
Username : .......
Classname : vb_database

Would love to know what is wrong, or what Im doing wrong so I can get it to work. Yes I have GD2. Thanks

JD45 11-29-2006 06:38 AM

Quote:

Originally Posted by sduckie2k5 (Post 1127601)
Same thing here, new version, first time install. Heres mine....




Invalid SQL:

CREATE TABLE vb_`vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT( 10 ) NOT NULL ,
`usergroupid` INT( 10 ) NOT NULL ,
`name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`path` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`createdate` INT( 10 ) NOT NULL ,
`modifieddate` INT( 10 ) NOT NULL ,
`groupid` INT( 10 ) NOT NULL ,
INDEX ( `userid` , `usergroupid`, `name`)
) TYPE = MYISAM;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT' at line 1
Error Number : 1064
Date : Tuesday, November 28th 2006 @ 06:46:32 PM
Script : ..........plugin.php?do=productimport
Referrer :
IP Address : .......
Username : .......
Classname : vb_database


Would love to know what is wrong, or what Im doing wrong so I can get it to work. Yes I have GD2. Thanks

Thritto on the error...

stonyarc 11-29-2006 08:17 AM

Quote:

Originally Posted by Roxie (Post 1127576)
I get this error even using the newest version:

Sorry

It was the old SQL statement typo that got back in.

The version now online is correct and should handle prefix nicely

sduckie2k5 11-29-2006 12:14 PM

Quote:

Originally Posted by stonyarc (Post 1127916)
Sorry

It was the old SQL statement typo that got back in.

The version now online is correct and should handle prefix nicely


Thankyou, that worked, Great addition to my website! ~D

Roxie 11-29-2006 02:52 PM

Works beautifully. Great work Stonyarc. :)

JD45 11-29-2006 02:59 PM

Hmm...I'm still getting this:

Quote:

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT' at line 1

stonyarc 11-29-2006 03:15 PM

Quote:

Originally Posted by JD45 (Post 1128116)
Hmm...I'm still getting this:

JD did you download the latest version again?

The sequence you quoted is no longer in there.

JD45 11-29-2006 03:17 PM

Quote:

Originally Posted by stonyarc (Post 1128124)
JD did you download the latest version again?

The sequence you quoted is no longer in there.

I thought I did :surprised:

I did the sql by hand and everything installed fine, now I just need to test everything. I'll re-download it and make sure I have the updated version.


All times are GMT. The time now is 10:22 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.01127 seconds
  • Memory Usage 1,745KB
  • 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
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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