The Arcive of Official vBulletin Modifications Site.

Meet Our Staff · **Released**: 07-05-2008

MEET OUR STAFF GOLD by

This Product brought to you by
Www.vBulletin-TR.Com

Description: Meet Our Staff Solution Better than vB.Org's

Note 1: I've finally decided to publish Pro version of this product to all of you.
Note 2: Paid version will come soon for vBulletin version 4.x.x. Series.

Go to for vBulletin Version 3.8.x Series of this product.. (please, click here..)

Comments, suggestions, translations, bugs, etc... are very welcome!
Support is only given to people who have clicked Mark as Installed.

Mark as Installed - Nominate for MOTM

Online Demo: www.vbulletin-tr.com/forum/staff.php?langid=1

http://img691.imageshack.us/img691/2...urstaffpro.jpg

Comments, suggestions, translations, bugs, etc... are very welcome!
Support is only given to people who have clicked Mark as Installed.

Saint_ago · #**402** 02-26-2009, 04:06 PM

Database error in vBulletin 3.8.1:

Invalid SQL:

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

MySQL Error : Unknown column 'usergroup.isstaff' in 'where clause'
Error Number : 1054
Request Date : Thursday, February 26th 2009 @ 03:03:58 PM
Error Date : Thursday, February 26th 2009 @ 03:03:58 PM
Script : http://bfcentral.oi.com.br/forum/staff.php
Referrer : http://bfcentral.oi.com.br/forum/
IP Address : 32.104.18.240
Username : S.Templar
Classname : vB_Database
MySQL Version : 5.0.45-log

Using 3.2 on a 3.8.1 board

Chadi · #**403** 02-26-2009, 07:46 PM

Once again, database errors:

Code:

Database error in vBulletin

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

MySQL Error   : Duplicate column name 'isstaff'
Error Number  : 1060
Request Date  : Thursday, February 26th 2009 @ 03:45:36 PM
Error Date    : Thursday, February 26th 2009 @ 03:45:36 PM
Script        : http://www.talkjesus.com/xxxxx/plugin.php?do=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 · #**404** 02-26-2009, 07:52 PM

delete isstaff field from usergroup table in database than re-install product again.

Chadi · #**405** 02-26-2009, 08:12 PM

Thank you. That worked

inciarco · #**406** 02-26-2009, 08:40 PM

Quote:

Originally Posted by Hasann

delete isstaff field from usergroup table in database than re-install product again.

When Deleting the Field and Trying to Uninstall the Product it Causes an DataBase Error, so the Uninstall Code don't Take in Consideration to Ignore if the Field don't Exist.

I Also Tried Deleting the Field and Re-Installing and Overwriting the Product and DataBase Error Persists.

(Also when Deleting the Field the Installed don't Create it Again)

Not Good Idea to Delete that Field.

(Be Careful With That).

(Also when trying to Use the Un-Installer it says about "staff" Field not Existant, so I had to Create the "staff" Field to be able to Un-Install the Hack. I'm Guessing that "staff" and "isstaff" are Both Fields of your Mod, because this Mod's Un-Installer Deletes Both Fields.)

Also Uninstalling and Re-Installing the Mod Causes DataBase Errors when Trying to Access the "staff.php" Page.

Quote:

MySQL Error : Unknown column '[ZZZ]usergroup.usergroupid' in 'field list'
Error Number : 1054

Hasann I Think You Should Upload the Latest Working Version of this Mod as an User Asked for a Few Posts Before, so that they can Use that Working Version (3.1).

My Best Regards.

Hasann · #**407** 02-26-2009, 08:44 PM

Quote:

Originally Posted by inciarco

When Deleting the Field and Trying to Uninstall the Product it Causes an DataBase Error, so the Uninstall Code don't Take in Consideration to Ignore if the Field don't Exist.

I Also Tried Deleting the Field and Re-Installing and Overwriting the Product and DataBase Error Persists.

(Also when Deleting the Field the Installed don't Create it Again)

Not Good Idea to Delete that Field.

(Be Careful With That).

Hasann I Think You Should Upload the Latest Working Version of this Mod as an User Asked for a Few Posts Before, so that they can Use that Working Version (3.1).

My Best Regards.

working fine for me v3.2 please remove the whole hack from your forum and re-import again.
I've not anymore that version 3.1 sorry I have only v3.2 and Pro version 1.0 installed on my site.

inciarco · #**408** 02-26-2009, 09:01 PM

Quote:

Originally Posted by Hasann

working fine for me v3.2 please remove the whole hack from your forum and re-import again.
I've not anymore that version 3.1 sorry I have only v3.2 and Pro version 1.0 installed on my site.

I Already Tried that and it didn't Worked (I Edited my Previous Post with Additional Info while you were Posting your Reply).

I Attach to this Post Version 3.1 so that You Can Upload it on the Thread.

My Best Regards.

My Last Post Edited:

Quote:

Originally Posted by inciarco

When Deleting the Field and Trying to Uninstall the Product it Causes an DataBase Error, so the Uninstall Code don't Take in Consideration to Ignore if the Field don't Exist.

I Also Tried Deleting the Field and Re-Installing and Overwriting the Product and DataBase Error Persists.

(Also when Deleting the Field the Installed don't Create it Again)

Not Good Idea to Delete that Field.

(Be Careful With That).

(Also when trying to Use the Un-Installer it says about "staff" Field not Existant, so I had to Create the "staff" Field to be able to Un-Install the Hack. I'm Guessing that "staff" and "isstaff" are Both Fields of your Mod, because this Mod's Un-Installer Deletes Both Fields.)

Also Uninstalling and Re-Installing the Mod Causes DataBase Errors when Trying to Access the "staff.php" Page.

Hasann I Think You Should Upload the Latest Working Version of this Mod as an User Asked for a Few Posts Before, so that they can Use that Working Version (3.1).

My Best Regards.

Martell · #**409** 02-27-2009, 01:33 AM

Database error in vBulletin 3.7.3:

Invalid SQL:

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

MySQL Error : Unknown table 'vB_usergroup' in field list
Error Number : 1109
Request Date : Friday, February 27th 2009 @ 06:31:38 AM
Error Date : Friday, February 27th 2009 @ 06:31:38 AM

mindfawk · #**410** 02-27-2009, 08:46 AM

Quote:

Originally Posted by inciarco

I Already Tried that and it didn't Worked (I Edited my Previous Post with Additional Info while you were Posting your Reply).

I Attach to this Post Version 3.1 so that You Can Upload it on the Thread.

My Best Regards.

My Last Post Edited:

Thank you!

I installed the newest 3.2, and I'm still getting the same database errors, I really appreciate you attached 3.1!

Saint_ago · #**411** 02-27-2009, 10:15 AM

Uninstalled everything, removed field isstaff, removed all files from /forum and sub folders, re-upped all files from 3.2, reinstalled 3.2 Ok, but:

1) Not showing options in ADMINCP to choose staff groups; the only settings that shows it's in attachment image;

2) When opening /forum/staff.php, still showing the following error:

Code:

Database error in vBulletin 3.8.1:

Invalid SQL:

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

MySQL Error   : Unknown column 'vb_usergroup.usergroupid' in 'field list'
Error Number  : 1054
Request Date  : Friday, February 27th 2009 @ 09:09:32 AM
Error Date    : Friday, February 27th 2009 @ 09:09:32 AM
Script        : http://bfcentral.oi.com.br/forum/staff.php
Referrer      : http://bfcentral.oi.com.br/forum/showgroups.php
IP Address    : 32.104.18.240
Username      : S.Templar
Classname     : vB_Database
MySQL Version : 5.0.45-log

Note that all values in field "isstaff" in DB is 0, because i can't choose any staff groups from hack settings.

UPDATE: Manually changed Administrator group isstaff field from 0 to 1, in my DB. But the DB error stills the same:

Code:

Database error in vBulletin 3.8.1:

Invalid SQL:

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

MySQL Error   : Unknown column 'vb_usergroup.usergroupid' in 'field list'
Error Number  : 1054
Request Date  : Friday, February 27th 2009 @ 09:16:21 AM
Error Date    : Friday, February 27th 2009 @ 09:16:21 AM
Script        : http://bfcentral.oi.com.br/forum/staff.php
Referrer      : 
IP Address    : 32.104.18.240
Username      : S.Templar
Classname     : vB_Database
MySQL Version : 5.0.45-log

Back to 3.1 working like a charm!

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06493 seconds Memory Usage 2,339KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_code (6)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!