vb.org Archive
Page 11 of 14 « First 910 11 1213 Last »
Show 40 post(s) from this thread on one page

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)

Saint_ago 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 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 02-26-2009 07:52 PM
delete isstaff field from usergroup table in database than re-install product again.

Chadi 02-26-2009 08:12 PM
Thank you. That worked

inciarco 02-26-2009 08:40 PM
Quote:
Originally Posted by Hasann (Post 1755472)
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. :confused:

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

(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 02-26-2009 08:44 PM
Quote:
Originally Posted by inciarco (Post 1755494)
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. :confused:

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

(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 02-26-2009 09:01 PM
Quote:
Originally Posted by Hasann (Post 1755498)
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 (Post 1755494)
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. :confused:

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

(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 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 02-27-2009 08:46 AM
Quote:
Originally Posted by inciarco (Post 1755514)
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 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!

Hasann 02-28-2009 05:25 AM
this is the last version that I post here will never be any fixed or updated light version
sorry guys I must working on Meet Our Staff PRO v1.0

Martell 02-28-2009 07:13 AM
When opening /forum/staff.php, the following error: :confused:

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff
COUNT(user.userid) AS membercount
FROM vB_usergroup AS usergroup
LEFT JOIN vB_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 vB_usergroup AS usergroup
LEFT JOIN vB_' at line 2
Error Number : 1064
Request Date : Saturday, February 28th 2009 @ 11:58:27 AM
Error Date : Saturday, February 28th 2009 @ 11:58:28 AM
Script : http://xxx/staff.php
Referrer : http://xxx/index.php
IP Address : 91.207.170.131
Username : Martell
Classname : vb_database
MySQL Version : 4.1.22

veenuisthebest 02-28-2009 07:25 AM
Quote:
Originally Posted by Hasann (Post 1756698)
this is the last version that I post here will never be any fixed or updated light version
sorry guys I must working on Meet Our Staff PRO v1.0
I was thinking about installing this. But it seems everybody is having db errors in this version. Won't you be releasing a fix for this or atleast provide 3.2 again before leaving this mod.

Thanks!

Hasann 02-28-2009 07:43 AM
Quote:
Originally Posted by veenuisthebest (Post 1756721)
I was thinking about installing this. But it seems everybody is having db errors in this version. Won't you be releasing a fix for this or atleast provide 3.2 again before leaving this mod.

Thanks!
OKAY
please try this version

mindfawk 02-28-2009 02:05 PM
Where can we purchase the pro version?

Hornstar 02-28-2009 09:05 PM
not sure why people will want to buy the pro version if you cant even get the lite version working for all. I am still getting the database error after installing the new version today.

Code:
Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff
COUNT(user.userid) AS membercount
FROM vb3_usergroup AS usergroup
LEFT JOIN vb3_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 vb3_usergroup AS usergroup
LEFT JOIN vb' at line 2
Error Number  : 1064
Request Date  : Saturday, February 28th 2009 @ 06:04:30 PM
Error Date    : Saturday, February 28th 2009 @ 06:04:30 PM
Script        : http://www..net/forums/staff.php
Referrer      :
IP Address    :
Username      :
Classname    : vB_Database
MySQL Version : 5.0.67-community

inciarco 02-28-2009 09:18 PM
Quote:
Originally Posted by hornstar1337 (Post 1757177)
not sure why people will want to buy the pro version if you cant even get the lite version working for all. I am still getting the database error after installing the new version today.

Code:
Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff
COUNT(user.userid) AS membercount
FROM vb3_usergroup AS usergroup
LEFT JOIN vb3_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 vb3_usergroup AS usergroup
LEFT JOIN vb' at line 2
Error Number  : 1064
Request Date  : Saturday, February 28th 2009 @ 06:04:30 PM
Error Date    : Saturday, February 28th 2009 @ 06:04:30 PM
Script        : http://www..net/forums/staff.php
Referrer      :
IP Address    :
Username      :
Classname    : vB_Database
MySQL Version : 5.0.67-community
I Got that Same Error Too. :(

I thin is Important for Hasann to Get this Last Version 3.2 Working to Successfully Lauch His Pro Version; this is the FrontPage for Users to Motivate to Acquire the Pro One. ;)

My Best Regards.

:)

hobbybox 02-28-2009 11:24 PM
So I was going to give this a try - I uploaded staff.php and imported the file however I have looked EVERYWHERE in the admin area and cannot locate any link to set this application up. Does anyone have an idea where I find the link to set it up?

hobbybox 02-28-2009 11:45 PM
just figured out - there were no admin files in the zip files to upload - that makes a lot of sense

DragonMasterNYC 03-02-2009 10:02 PM
Ok so I updated it and now it looks like something is wrong with the phrases for the menu in the Admin CP, and also when I go to the meet our staff settings nothing comes up except the setting group drop down and save and reset buttons.

Please get back to me as soon as you get a chance.

Thanks ahead of time.

ShawneyJ 03-12-2009 12:44 PM
hi, silly question, vBulletin Options im looking to edit, but not there at all, had a hard look.
theres nothing in there that says Meet_Our_Staff at all.
thanks, maybe this is a 3.8 error?

sgrisole 03-13-2009 01:23 AM
I don't see the options either... I run vBulletin 3.7.4 Patch Level 1 here.

tipoboy 03-13-2009 02:20 PM
there is no vbulletin options here, you have to manually edit the templates if you want to change from default.

works fine for me on 3.8.1 and uninstalled fine, i made my own staff page up, and used a few points from this mod therefor

** clicks install

Lynne 03-13-2009 02:44 PM
The options are under vBulletin Options > vBulletin Options > Meet Our Staff Settings.

sgrisole 03-13-2009 07:20 PM
@Lynne
I can't find the options under vBulletin options after installing the product. If I browse to staff.php the page shows up though.

tipoboy 03-13-2009 08:30 PM
Quote:
Originally Posted by Lynne (Post 1767234)
The options are under vBulletin Options > vBulletin Options > Meet Our Staff Settings.
lynne there is no setting in the admincp -> vbulletin options

thats why i said you have to manually edit the new templates to your desired look

Lynne 03-13-2009 08:39 PM
Quote:
Originally Posted by tipoboy (Post 1767442)
lynne there is no setting in the admincp -> vbulletin options

thats why i said you have to manually edit the new templates to your desired look
I have the options in my admin cp (running 3.8.0). They look exactly like the image in the first post.

(You guys did upload all the files you were supposed to upload also, right?)

tipoboy 03-13-2009 08:50 PM
i've just installed it and the only thing in the uploads folder is "staff.php" and the product import. This could be the problem that people might be having :)

Lynne 03-13-2009 09:40 PM
Ah, I didn't notice it was updated. It looks like he didn't include the two files to be included in includes/xml . My guess is he'll come check this thread and then correct it.

Hasann 03-13-2009 10:21 PM
v2.0 does not have any vbulletin options but v2.0 yes
I've uploaded fixed version 3.2 of this mod

sgrisole 03-14-2009 03:01 PM
I installed version 3.2 and now I get the following error when visiting staff.php

Code:
Database error in vBulletin 3.7.4:

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 A' at line 2
Error Number  : 1064
Request Date  : Saturday, March 14th 2009 @ 11:43:48 AM
Error Date    : Saturday, March 14th 2009 @ 11:43:48 AM
Classname    : vB_Database
MySQL Version : 5.0.67-community
I tried to uninstall / reinstall the product several times but it didn't fix the problem...
BTW is the PRO version available somewhere?

tidefans 03-14-2009 06:13 PM
I am getting this same error


Quote:
Originally Posted by sgrisole (Post 1767919)
I installed version 3.2 and now I get the following error when visiting staff.php

Code:
Database error in vBulletin 3.7.4:

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 A' at line 2
Error Number  : 1064
Request Date  : Saturday, March 14th 2009 @ 11:43:48 AM
Error Date    : Saturday, March 14th 2009 @ 11:43:48 AM
Classname    : vB_Database
MySQL Version : 5.0.67-community
I tried to uninstall / reinstall the product several times but it didn't fix the problem...
BTW is the PRO version available somewhere?

cookiepants 03-14-2009 07:48 PM
Database error here too. I'd like to try it before paying for one. I've tried all versions here and will remove until the DB issue is resolved. Thanks!

Lynne 03-14-2009 08:10 PM
It looks like it's just missing a comma before the COUNT part of the select statement. Did someone try just addig in the comma and seeing if the error goes away?

sgrisole 03-14-2009 09:46 PM
Thanks Lynne, that made the page work, but now for some reason the moderators aren't listed when I click on the "moderators" link in staff.php. Only the admins are shown. Yes, I already added the "moderators" group to the staff usergroups in the options.
Any idea?

edit: I found out what was causing the problem and fixed it: the "moderators" group was not set as the primary group for moderators, so they didn't show up in the staff.php page. Now I have one more thing to adjust... Is there any way to have both the admins and moderators displayed on the same page? There are only two admins and 3 moderators in my board, so it would be nice to have them displayed on the same page.

Switch02 03-15-2009 12:13 PM
This version work on vb 3.8.1?

Thanks

sheppardzwc 03-15-2009 01:20 PM
Quote:
Originally Posted by Switch02 (Post 1768618)
This version work on vb 3.8.1?

Thanks
I don't know if it does or not, currently fixing an SQL error that Lynne supplied the answer to, and will post back later.

EDIT: Working perfectly for me.

http://www.toontownhall.com/forums/showgroups.php

Just remember to add a comma after the usergroup.istaff comment in the SQL query. (in staff.php by default)

Quote:
SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff,
COUNT(user.userid) AS membercount

cynthetiq 03-15-2009 05:15 PM
I did the update from 2.0 to 3.2 with the , for the SQL query. I get nothing on the staff.php page, not even a single name. if I use the 3.1 staff.php, I get names, broken up groups, but no title for the group, and no avatars for the individuals.

cynthetiq 03-15-2009 06:47 PM
some of it is my fault. I didn't declare the groups....

now that I di dthat. here's a screen cap

https://vborg.vbsupport.ru/external/2009/03/17.png

KSMatic 03-16-2009 04:21 AM
here is the staff.php file that needed to be fixed with "," for those who are getting database issues.

Copy this in to your forums/ directory file and bam, it works :)


All times are GMT. The time now is 05:58 PM.
Page 11 of 14 « First 910 11 1213 Last »
Show 40 post(s) from this thread on one page

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.01576 seconds
  • Memory Usage 1,863KB
  • 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_code_printable
  • (14)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
  • (40)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