vb.org Archive
Page 41 of 55 « First 313940 41 424351 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!


All times are GMT. The time now is 05:53 AM.
Page 41 of 55 « First 313940 41 424351 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.01796 seconds
  • Memory Usage 1,763KB
  • 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
  • (3)bbcode_code_printable
  • (6)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