vb.org Archive
Page 54 of 105 « First 4445253 54 555664104 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)

Rhoads 01-05-2005 12:39 AM
Quote:
Originally Posted by Delphiprogrammi
hi,

drop the TABLE_PREFIX part and replace it with your "real" table name so if you have a database table name "vb_" the querry becomes

Code:
UPDATE vb_warning_options SET version='3.0.3' WHERE oid=1
seem you have a dutch MySQL ?

laat dat TABLE_PREFIX gedeelte weg en vervang het door je "tabel" naam dan gaat het werken
Thnx Delphiprogrammi, that was the problem, and now it's updated ;)

Torqued 01-05-2005 01:40 AM
John,

Getting an error after upgrading from 3.0 to 3.0.3

Quote:
Database error in vBulletin 3.0.3:

Invalid SQL: update vb3warning_options set
hierarchical='Yes',
automatic='No',
automaticpm='No',
autocomments='Yes',
warner='0',
automatic_warner='0',
collector='1',
banned_limit='3',
points_before_banned='10',
banned_usergroup_id='8',
troll_usergroup_id='8',
protected_usergroups='6|6',
aprotected_usergroups='6',
restore_groupid='0',
incr_ban_days='No',
max_no_bans='3',
bans_mature='0',
viewoption='All',
multiple_per_post='Yes',
send_pm_warning='Yes',
send_em_warning='No',
email_on_ban='Yes',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='15'
where oid='1'
mysql error: Unknown column 'collector' in 'field list'
Here is what is in my warning_options table:
Code:
          oid          int(15)                    No                      auto_increment
        version          varchar(10)                  Yes          NULL                   
        hierarchical          char(3)                  Yes          NULL                   
        automatic          char(3)                  Yes          NULL                   
        automaticpm          char(3)                  Yes          NULL                   
        autocomments          char(3)                  Yes          NULL                   
        automatic_warner          int(10)        UNSIGNED        Yes         
        warner          int(10)        UNSIGNED        Yes          NULL         
        collector          int(10)        UNSIGNED        Yes          NULL         
        banned_limit          int(15)                  No          0                   
        points_before_banned          int(15)                  No          0         
        banned_usergroup_id          int(15)                  Yes          0         
        protected_usergroups          varchar(50)                  Yes          NULL         
        aprotected_usergroups          varchar(50)                  Yes         
        troll_usergroup_id          varchar(10)                  Yes          NULL         
        restore_groupid          smallint(5)        UNSIGNED        Yes         
        incr_ban_days          char(3)                  Yes          NULL         
        max_no_bans          int(5)                  Yes          NULL                    Change
        bans_mature          int(10)                  Yes          NULL                   
        viewoption          char(3)                  Yes          NULL                   
        multiple_per_post          char(3)                  Yes          NULL         
        send_pm_warning          char(3)                  Yes          NULL         
        send_em_warning          char(3)                  Yes          NULL         
        email_on_ban          char(3)                  Yes          NULL                   
        historical          char(3)                  Yes          NULL                   
        allowoffpost          char(3)                  Yes          NULL                   
        warnings_per_page          int(3)                  Yes          NULL
I don't understand why it's saying the "collector" field isn't there..

sv1cec 01-05-2005 05:53 AM
Quote:
Originally Posted by Torqued
John,

Getting an error after upgrading from 3.0 to 3.0.3



Here is what is in my warning_options table:
Code:
          oid          int(15)                    No                      auto_increment
        version          varchar(10)                  Yes          NULL                   
        hierarchical          char(3)                  Yes          NULL                   
        automatic          char(3)                  Yes          NULL                   
        automaticpm          char(3)                  Yes          NULL                   
        autocomments          char(3)                  Yes          NULL                   
        automatic_warner          int(10)        UNSIGNED        Yes         
        warner          int(10)        UNSIGNED        Yes          NULL         
        collector          int(10)        UNSIGNED        Yes          NULL         
        banned_limit          int(15)                  No          0                   
        points_before_banned          int(15)                  No          0         
        banned_usergroup_id          int(15)                  Yes          0         
        protected_usergroups          varchar(50)                  Yes          NULL         
        aprotected_usergroups          varchar(50)                  Yes         
        troll_usergroup_id          varchar(10)                  Yes          NULL         
        restore_groupid          smallint(5)        UNSIGNED        Yes         
        incr_ban_days          char(3)                  Yes          NULL         
        max_no_bans          int(5)                  Yes          NULL                    Change
        bans_mature          int(10)                  Yes          NULL                   
        viewoption          char(3)                  Yes          NULL                   
        multiple_per_post          char(3)                  Yes          NULL         
        send_pm_warning          char(3)                  Yes          NULL         
        send_em_warning          char(3)                  Yes          NULL         
        email_on_ban          char(3)                  Yes          NULL                   
        historical          char(3)                  Yes          NULL                   
        allowoffpost          char(3)                  Yes          NULL                   
        warnings_per_page          int(3)                  Yes          NULL
I don't understand why it's saying the "collector" field isn't there..
That's strange. Where did you get the list of the columns? Did you do a "describe warning_options" or did you copy it from the hack instructions?

Rgds

sv1cec 01-05-2005 05:56 AM
Quote:
Originally Posted by T3MEDIA
I have been getting error from the database but I assumed it was something else. What exactly was your errors? Please let me know
T3Media, what errors are you getting?

sv1cec 01-05-2005 06:09 AM
Version 3.0.4 has been released. It allows you to warn a user directly from your AdminCP, or to be more precise, from the User Manager section of AdminCP. Obviously, only non-post-related warnings can be issued from there.

I hope you enjoy.

Vixion 01-05-2005 08:54 AM
I have version 2.3.5 but I don't understand how to update it from version 2.3.5 tot 3.0.4.

Do I need to update from 2.3.5 tot 3.0 and then 3.0 tot 3.0.4?

sv1cec 01-05-2005 09:42 AM
Quote:
Originally Posted by Vixion
I have version 2.3.5 but I don't understand how to update it from version 2.3.5 tot 3.0.4.

Do I need to update from 2.3.5 tot 3.0 and then 3.0 tot 3.0.4?
You have to update from 2.3.5 to the next release. Then from that one to the next etc.

Torqued 01-05-2005 11:54 AM
Quote:
Originally Posted by sv1cec
That's strange. Where did you get the list of the columns? Did you do a "describe warning_options" or did you copy it from the hack instructions?

Rgds
I copied it from PHPMyAdmin. I had uninstalled a v 1.x (including removing the tables) and then successfully ran the 3.0 installer before this upgrade.

sv1cec 01-05-2005 12:34 PM
Quote:
Originally Posted by Torqued
I copied it from PHPMyAdmin. I had uninstalled a v 1.x (including removing the tables) and then successfully ran the 3.0 installer before this upgrade.
And what are you trying to do when you get that error message? Update the Warning Options? That's strange. I am not sure what to say. I assume you applied all changes from 3.0 to 3.0.1, to 3.0.2, to 3.0.3, right?

If this is a new installation, and you do not have any warnings you want to preserve, try running the uninstaller and then reinstall from scratch. It just does not make sense.

JayJay 01-05-2005 12:35 PM
Code:
Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/-/public_html/forum/includes/init.php on line 522



 
Unable to add cookies, header already sent.
File: /home/-/public_html/forum/includes/init.php
Line: 522

Any idea what would be causing that error when loading 'mod_warn.php' in the modCP?


All times are GMT. The time now is 04:44 PM.
Page 54 of 105 « First 4445253 54 555664104 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.01676 seconds
  • Memory Usage 1,776KB
  • 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
  • (4)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
  • (4)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