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 04-17-2009 12:23 AM

your not the only one. Which is a shame, this mod has 31 pages so it obviously had some interest, but most of the replies in this mod have been about it not working.

Skyrider 04-17-2009 06:14 AM

Indeed, getting the same SQL error as above, uninstalled.

tipoboy 04-17-2009 06:25 AM

Quote:

Originally Posted by FF|Skyrider (Post 1793073)
Indeed, getting the same SQL error as above, uninstalled.

please see this post:
https://vborg.vbsupport.ru/showpost....&postcount=407

zefyx 04-24-2009 07:30 AM

For those with SQL errors, go into phpMyAdmin & delete the table that say's it is du.plicating.

Hasaan, when upgrading from 3.0 to 3.2 on vBulletin 3.8.2 I get 0 results in the Meet Our Staff page & a Page not found in admincp's Usergroup settings, even though the file is obviously present.

Skyrider 04-24-2009 07:03 PM

Why do I get:
Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:

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

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 'COUNT(user.userid) AS membercount
FROM usergroup AS usergroup
LEFT JOIN user AS ' at line 2
Error Number : 1064
Request Date : Friday, April 24th 2009 @ 10:02:41 PM
Error Date : Friday, April 24th 2009 @ 10:02:41 PM
?

Heck, can't even uninstall this:
Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:
ALTER TABLE usergroup DROP staff;

MySQL Error : Can't DROP 'staff'; check that column/key exists

TAIFUN_T 04-25-2009 02:04 AM

Russian Version

FF|Skyrider, upload staff.php

Rickeo 04-25-2009 11:43 AM

Can we get an updated version of this useful mod please?

flipstyle 04-26-2009 06:05 PM

Quote:

Originally Posted by Rickeo (Post 1798699)
Can we get an updated version of this useful mod please?

Yes please a update would be nice I had to revert back to the older version. The latest one has a db error.

SAReefer 04-27-2009 09:39 PM

will this work on 3.8?

tipoboy 04-27-2009 09:50 PM

Quote:

Originally Posted by SAReefer (Post 1800199)
will this work on 3.8?

yes but please read the posts as there is problems regarding the latest version, and people have posted fixes regarding the problem


All times are GMT. The time now is 01:05 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.01498 seconds
  • Memory Usage 1,739KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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