vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Miscellaneous Hacks - Meet Our Staff (https://vborg.vbsupport.ru/showthread.php?t=184491)

Hornstar 02-25-2009 04:05 AM

I am getting a database error after upgrading as well :/

Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT user.*, usergroup.usergroupid, usergroup.isstaff, usergroup.title, user.options, usertextfield.*, userfield.*,
userfield.field2,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM vb3_user AS user
LEFT JOIN vb3_usergroup AS usergroup ON(vb3_usergroup.usergroupid = vb3_user.usergroupid)
LEFT JOIN vb3_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vb3_usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
WHERE vb3_usergroup.isstaff = '1'
AND (FIND_IN_SET('6', membergroupids) OR user.usergroupid = 6);

MySQL Error : Unknown column 'vb3_usergroup.isstaff' in 'where clause'
Error Number : 1054
Request Date : Wednesday, February 25th 2009 @ 01:03:07 AM
Error Date : Wednesday, February 25th 2009 @ 01:03:14 AM
Script : http://www..net/forums/staff.php?do=...oups&groupid=6
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community

Chadi 02-25-2009 04:09 AM

Error

Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:
ALTER TABLE usergroup ADD staff INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error : Duplicate column name 'staff'
Error Number : 1060
Request Date : Wednesday, February 25th 2009 @ 12:08:08 AM
Error Date : Wednesday, February 25th 2009 @ 12:08:08 AM
Script : http://www.talkjesus.com/xxxxx/plugi...=productimport
Referrer : http://www.talkjesus.com/xxxxx/plugin.php?do=productadd
IP Address : xxxxx
Username : Chad
Classname : vB_Database
MySQL Version : 5.0.67-community

Hasann 02-25-2009 07:07 AM

I thought they're now fixed. Please upload all files overwrite and re-import product.xml file again.

digicom 02-25-2009 07:46 AM

just upgraded from 3.1 to 3.2 and now when i click link in nav bar i get this any ideas Hasann? thanks
https://vborg.vbsupport.ru/

Hasann 02-25-2009 07:55 AM

Quote:

Originally Posted by digicom (Post 1754035)
just upgraded from 3.1 to 3.2 and now when i click link in nav bar i get this any ideas Hasann? thanks
http://img11.imageshack.us/img11/5139/meetstaff.png

have you been selected your staff groups?

https://vborg.vbsupport.ru/attachmen...9&d=1235447493

digicom 02-25-2009 08:04 AM

Much Apprciated Hasann All Working Now! Thankyou :up:

inciarco 02-25-2009 01:43 PM

I Uploaded Files and Overwrited Product but an Error is Happening when Trying to Access "staff.php":

ZZZ is Table Prefix.

Perhaps the Table Prefix is missing on "WHERE usergroup.isstaff = " ? :confused:
(I can see the Prefix on "SELECT ZZZusergroup.usergroupid, ZZZusergroup.isstaff")

Quote:

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT ZZZusergroup.usergroupid, ZZZusergroup.isstaff, ZZZusergroup.title,
COUNT(ZZZuser.userid) AS membercount
FROM ZZZusergroup
LEFT JOIN ZZZuser
ON ZZZuser.usergroupid=ZZZusergroup.usergroupid
OR FIND_IN_SET(ZZZusergroup.usergroupid, ZZZuser.membergroupids)
WHERE usergroup.isstaff = '1'
GROUP BY ZZZusergroup.usergroupid
ORDER BY ZZZusergroup.title ASC;

MySQL Error : Unknown column 'usergroup.isstaff' in 'where clause'
Error Number : 1054
Request Date : Wednesday, February 25th 2009 @ 10:39:29 AM
Error Date : Wednesday, February 25th 2009 @ 10:39:30 AM
Script : http://ZZZ/staff.php
Referrer : http://ZZZ/
IP Address : ZZZ
Username : ZZZ
Classname : ZZZDatabase
MySQL Version : 5.0.51a-community
:)

Chadi 02-25-2009 06:35 PM

Still getting same database error

This time a different table

MySQL Error : Duplicate column name 'isstaff'

Martell 02-25-2009 09:27 PM

Database error :confused:

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT user.*, usergroup.usergroupid, usergroup.isstaff, usergroup.title, user.options, usertextfield.*, userfield.*,
userfield.field2,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM vB_user AS user
LEFT JOIN vB_usergroup AS usergroup ON(vB_usergroup.usergroupid = vB_user.usergroupid)
LEFT JOIN vB_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vB_usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
WHERE vB_usergroup.isstaff = '1';

MySQL Error : Unknown table 'vB_usergroup' in where clause
Error Number : 1109
Request Date : Thursday, February 26th 2009 @ 02:23:54 AM
Error Date : Thursday, February 26th 2009 @ 02:23:54 AM
Script : http://xxx/staff.php
Referrer :
IP Address : 91.207.170.131
Username : Martell
Classname : vb_database
MySQL Version : 4.1.22

mindfawk 02-25-2009 09:38 PM

Can you put the ZIP file back up for the 3.1 version? I didn't have any issues with it, this new version gives me the same data base issues as the others above.


All times are GMT. The time now is 09:30 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.01680 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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