vb.org Archive
Page 50 of 105 « First 404849 50 515260100 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/showthread.php?t=71992)

jonnerd154 01-01-2005 09:48 PM
I need a little help. I followed the install directions perfectly (I think, I may have made a mistake.) Everything LOOKS ok in the mod and admincp's and the warn [user] links are at the top of all posts, etc. When I click on the Ban [user] links I am directed to (EG) http://mahplace.com/forums/Warn.php?...28&post=769427 but the output of that page is just <html><body></body></html>

Any ideas why the page is not parsing?

EDIT: Note that I am using an installer package I downloaded yesterday.

mojo8850 01-01-2005 11:20 PM
Ok.. Here's Wat I've Done.. :ermm:

I Installed The Warning HACK 1.0 Then Upgraded To 1.5.
And Then Installed The AWS v3.0.2.!

Now When I Click On Warning Systems > View Ban User's I Get Database Error..!

Quote:
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT user.userid, user.username, user.usergroupid AS busergroupid,
userban.usergroupid AS ousergroupid, userban.reason AS reason,
IF(userban.displaygroupid = 0, userban.usergroupid, userban.displaygroupid) AS odisplaygroupid,
bandate, liftdate,
adminuser.userid AS adminid, adminuser.username AS adminname
FROM user AS user
LEFT JOIN userban AS userban ON(userban.userid = user.userid)
LEFT JOIN user AS adminuser ON(adminuser.userid = userban.adminid)
WHERE user.usergroupid IN(8)
ORDER BY userban.liftdate ASC, user.username

mysql error: Unknown column 'userban.reason' in 'field list'

mysql error number: 1054

Date: Sunday 02nd of January 2005 02:14:47 AM
Can Some One Help Me Please..! :tired: :tired: :tired:

Delphiprogrammi 01-02-2005 04:45 AM
hi ,

yeah we can help you there is a column missing in your userban database table goto PhpMyAdmin or whatever you use to run SQL queries and run
Code:
ALTER TABLE `".TABLE_PREFIX."userban` ADD COLUMN `reason` mediumtext
drop the TABELE_PRFIX part if MySQL complains about it (give your table name instead then)

sv1cec 01-02-2005 06:19 AM
Quote:
Originally Posted by jonnerd154
I need a little help. I followed the install directions perfectly (I think, I may have made a mistake.) Everything LOOKS ok in the mod and admincp's and the warn [user] links are at the top of all posts, etc. When I click on the Ban [user] links I am directed to (EG) http://mahplace.com/forums/Warn.php?...28&post=769427 but the output of that page is just <html><body></body></html>

Any ideas why the page is not parsing?

EDIT: Note that I am using an installer package I downloaded yesterday.
Ban User links??? There should be no "Ban User" links. Where are these links found?

sv1cec 01-02-2005 06:23 AM
Bahawolf,

Find the following code

HTML Code:
<if condition="$post[warning_level]>0">
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
Replace that with:

HTML Code:
<if condition="$post[warning_level]=='' OR $post[warning_level]=='0'">
<BR>Warning Level: 0
<else />
<font color="#ff0000">
<BR>Warnings Level: $post[warning_level]
<font color="#000000">
</if>
Careful that code exists twice in postbit. Replace both instances.

Rgds

Delphiprogrammi 01-02-2005 06:33 AM
hi sv1cec ,

i run into a little problem with the latest version installed.if you choose "view banned users" (and you don't have any) that page is redirected to a blank page after a while just a blank white browser window it must be in admin_warn.php but i'm to scared to screw up

jonnerd154 01-02-2005 07:46 AM
Quote:
Originally Posted by sv1cec
Ban User links??? There should be no "Ban User" links. Where are these links found?
Ack, sorry...I meant Warn User links.

bold 01-03-2005 05:07 AM
hey i'm getting a error when i try to send a pm.

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: select username from vb3_user where userid=
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 '' at line 1

mysql error number: 1064

Date: Monday 03rd of January 2005 01:06:50 AM
Script: http://www.xxxxx.com/forums/private.php
Referer: http://www.xxxxx.com/forums/private.php?do=newpm&u=122
Username: bold
IP Address: 172.137.2.235
any ideas?

sv1cec 01-03-2005 05:51 AM
Quote:
Originally Posted by Delphiprogrammi
hi sv1cec ,

i run into a little problem with the latest version installed.if you choose "view banned users" (and you don't have any) that page is redirected to a blank page after a while just a blank white browser window it must be in admin_warn.php but i'm to scared to screw up
This issue has been dealt with. Please download the latest zip and upload admin_warn.php to your server.

Rgds

sv1cec 01-03-2005 05:52 AM
Quote:
Originally Posted by bold
hey i'm getting a error when i try to send a pm.

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: select username from vb3_user where userid=
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 '' at line 1

mysql error number: 1064

Date: Monday 03rd of January 2005 01:06:50 AM
Script: http://www.xxxxx.com/forums/private.php
Referer: http://www.xxxxx.com/forums/private.php?do=newpm&u=122
Username: bold
IP Address: 172.137.2.235
any ideas?
Check your modifications in private.php, you must have missed something.

Rgds


All times are GMT. The time now is 04:59 PM.
Page 50 of 105 « First 404849 50 515260100 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.01635 seconds
  • Memory Usage 1,753KB
  • 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
  • (2)bbcode_html_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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