vb.org Archive
Page 31 of 105 « First 212930 31 32334181 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)

SamirDarji 12-14-2004 06:57 PM
Quote:
Originally Posted by sv1cec
My friend, if you had no warnings in ZT's hack, delete everything and start from scratch. Why bother?
I guess I misunderstood the uinstaller the first time I read it. I thought I'd have to redo all the template mods. That would be a pain.

Quote:
Originally Posted by sv1cec
The query above is the one which modifies ZT's table to mine, but it is an older version, it does not have the 'version' column, download the last zip and get it from the upgrade_warn.php file.
Will do. I'll try run the query first, but if that doesn't work, I'll uninstall and install from scratch.

sv1cec 12-14-2004 07:32 PM
Quote:
Originally Posted by SamirDarji
I guess I misunderstood the uinstaller the first time I read it. I thought I'd have to redo all the template mods. That would be a pain.


Will do. I'll try run the query first, but if that doesn't work, I'll uninstall and install from scratch.
I double-checked (sometimes, you never know what YOU have done), and the uninstaller removes only the templates that the hack adds. Not the ones, which existed and you modified. And of course, it does not change the php files you changed.

Rgds

SamirDarji 12-14-2004 07:54 PM
Well, here's what I got back from the SQL Query:
Code:
Database forum - Table warning_options running on hsvtest.ods.org
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 527
STR: "
SQL: alter table warning_options
add `hierarchical` char(3),
add `automatic` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(0),
add `restore_groupid` smallint(5) unsigned,
add `incr_ban_days` char(3),
add `max_no_bans` int(5),
add `viewoption` char(3),
add `multiple_per_post` char(3),
add `send_pm_warning` char(3),
add `send_em_warning` char(3),
add `historical` char(3),
add `allowoffpost` char(3),
add `warnings_per_page` int(3)";

SQL-query : 

alter table warning_options add `hierarchical` char(3), add `automatic` char(3), add `automatic_warner` int(10) unsigned, add `warner` int(15), add `troll_usergroup_id` varchar(10), add `aprotected_usergroups` varchar(0), add `restore_groupid` smallint(5) unsigned, add `incr_ban_days` char(3), add `max_no_bans` int(5), add `viewoption` char(3), add `multiple_per_post` char(3), add `send_pm_warning` char(3), add `send_em_warning` char(3), add `historical` char(3), add `allowoffpost` char(3), add `warnings_per_page` int(3)";

MySQL said:


Too big column length for column 'aprotected_usergroups' (max = 255). Use BLOB instead
I ran it in both phpmyadmin and through admincp. Anything else left to try before I just uninstall and reinstall?

sv1cec 12-14-2004 08:42 PM
Quote:
Originally Posted by SamirDarji
Well, here's what I got back from the SQL Query:
Code:
Database forum - Table warning_options running on hsvtest.ods.org
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 527
STR: "
SQL: alter table warning_options
add `hierarchical` char(3),
add `automatic` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(0),
add `restore_groupid` smallint(5) unsigned,
add `incr_ban_days` char(3),
add `max_no_bans` int(5),
add `viewoption` char(3),
add `multiple_per_post` char(3),
add `send_pm_warning` char(3),
add `send_em_warning` char(3),
add `historical` char(3),
add `allowoffpost` char(3),
add `warnings_per_page` int(3)";

SQL-query : 

alter table warning_options add `hierarchical` char(3), add `automatic` char(3), add `automatic_warner` int(10) unsigned, add `warner` int(15), add `troll_usergroup_id` varchar(10), add `aprotected_usergroups` varchar(0), add `restore_groupid` smallint(5) unsigned, add `incr_ban_days` char(3), add `max_no_bans` int(5), add `viewoption` char(3), add `multiple_per_post` char(3), add `send_pm_warning` char(3), add `send_em_warning` char(3), add `historical` char(3), add `allowoffpost` char(3), add `warnings_per_page` int(3)";

MySQL said:


Too big column length for column 'aprotected_usergroups' (max = 255). Use BLOB instead
I ran it in both phpmyadmin and through admincp. Anything else left to try before I just uninstall and reinstall?
The query is NOT the one you should be running. I told you to download the zip file again and extract the upgrade_warn.php from the zip and look in that file for the query. The query you are running does not include the column 'version' and it has a mistake in the column `aprotected_usergroups', which has a length of 0.

You said you have no TABLE_PREFIX, so run this query here:

alter table warning_options
add `version` char(10),
add `hierarchical` char(3),
add `automatic` char(3),
add `automaticpm` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(10),
add `restore_groupid` smallint(5) unsigned,
add `incr_ban_days` char(3),
add `max_no_bans` int(5),
add `viewoption` char(3),
add `multiple_per_post` char(3),
add `send_pm_warning` char(3),
add `send_em_warning` char(3),
add `historical` char(3),
add `allowoffpost` char(3),
add `warnings_per_page` int(3)

Rgds

SamirDarji 12-14-2004 09:08 PM
Quote:
Originally Posted by sv1cec
The query is NOT the one you should be running. I told you to download the zip file again and extract the upgrade_warn.php from the zip and look in that file for the query. The query you are running does not include the column 'version' and it has a mistake in the column `aprotected_usergroups', which has a length of 0.

You said you have no TABLE_PREFIX, so run this query here:

alter table warning_options
add `version` char(10),
add `hierarchical` char(3),
add `automatic` char(3),
add `automaticpm` char(3),
add `automatic_warner` int(10) unsigned,
add `warner` int(15),
add `troll_usergroup_id` varchar(10),
add `aprotected_usergroups` varchar(10),
add `restore_groupid` smallint(5) unsigned,
add `incr_ban_days` char(3),
add `max_no_bans` int(5),
add `viewoption` char(3),
add `multiple_per_post` char(3),
add `send_pm_warning` char(3),
add `send_em_warning` char(3),
add `historical` char(3),
add `allowoffpost` char(3),
add `warnings_per_page` int(3)

Rgds
Ooops!! I forgot to get the newest zip. It's been a crazy day. Trying to change headlights in my car and it was so cold that my frozen hands couldn't do anything for more than 15 mins. So I was going back and forth between this and the car.

SamirDarji 12-14-2004 09:11 PM
That worked. Should I go ahead and run the other query that put the default options in the tables or should I just go ahead and set the warning options through admincp?

nubian 12-15-2004 12:01 AM
can somebody please help me.
i cannot find this...

Code:
  $post[reputationdisplay]</if>
in my postbit.
the only thing that comes close to that is this:
Code:
  <div class="smallfont">
                                  <if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>
                                  <if condition="$post['field2']"><div>$vbphrase[location_perm]: $post[field2]</div></if>
                                  <if condition="$post['age']"><div>$vbphrase[age]: $post[age]</div></if>
                                        <div>
                                  $vbphrase[posts]: $post[posts]
                                        </div>
                                  <if condition="$show['reputation']"><if condition="$show['reppower']">$vbphrase[reppower]: $post[reppower] </if><div>$post[reputationdisplay]</div></if>
                                  <div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon]</div>
                                  </div>
do i just add it under this line of code?
Code:
<if condition="$show['reputation']"><if condition="$show['reppower']">$vbphrase[reppower]: $post[reppower] </if><div>$post[reputationdisplay]</div></if>
i have a virgin postbit template from v 3.0.3
i'm very new to coding
thanks in advance

nubian 12-15-2004 01:34 AM
with my post above i've used my best guess.
looked like some of the lines were in that exact letter case.

i have another problem.
everythign seems to be okay but when i try to enter threads it looks like the image below.
i've re-enter the lines of codes neccesary for showthread.php and functions_showthread.php

can any of you tell me why it's doing this.
please help
thanks in advance

SamirDarji 12-15-2004 02:12 AM
Quote:
Originally Posted by nubian
with my post above i've used my best guess.
looked like some of the lines were in that exact letter case.

i have another problem.
everythign seems to be okay but when i try to enter threads it looks like the image below.
i've re-enter the lines of codes neccesary for showthread.php and functions_showthread.php

can any of you tell me why it's doing this.
please help
thanks in advance
Sounds like a template issue to me rather than a php one. Check over your template changes and make sure they are correct too.

TRStealth 12-15-2004 03:15 AM
Quote:
Originally Posted by TRStealth
I'm getting a problem:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: update warning_options set
hierarchical='No',
automatic='No',
automaticpm='No',
warner='1',
automatic_warner='1',
banned_limit='5',
points_before_banned='10',
banned_usergroup_id='8',
troll_usergroup_id='8',
protected_usergroups='5|6|7|11|14|5|6|9|13|15|12|10',
aprotected_usergroups='11|14|5|6|9|13|15|12|10',
restore_groupid='',
incr_ban_days='Yes',
max_no_bans='2',
viewoption='Mgm',
multiple_per_post='No',
send_pm_warning='Yes',
send_em_warning='No',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='30'
 where oid='1'
mysql error: Unknown column 'automaticpm' in 'field list'

mysql error number: 1054

Date: Sunday 12th of December 2004 07:14:35 PM
Script: http://www.enclave1.net/forums/admincp/admin_warn.php
Referer: http://www.enclave1.net/forums/admincp/admin_warn.php?act=manageoptions
Username: Stealth
IP Address: xx.xx.xx.xx
Also, when I go to Warn.php?do=ViewMyWarnings , it just comes out as a blank page.
I fixed the view warnings thing, but can anyone tell me why I'm getting the SQL Error?


All times are GMT. The time now is 08:28 PM.
Page 31 of 105 « First 212930 31 32334181 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.03823 seconds
  • Memory Usage 1,784KB
  • 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
  • (6)bbcode_code_printable
  • (7)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