vb.org Archive

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)

DS MrSinister 11-23-2004 03:39 PM

I am also having problem with the Upgrade..

Will not goto the 2nd step. It ask me to remove Old templates. than I Click that. then It goes to a Blank screen..

It looks like it remove the templates but did not add anything to the database. mmmmmmmmmmmmmmmmmmmmmm

Revan 11-23-2004 04:11 PM

Since you said this was your first officially released hack, sv1, some encouraging words:
Hang in there, mate ;) All this bs with bugs and installer errors and [insert other errors here] is nothing compared to what the RPG thread looked like in the first 7 pages :p
If there was a possible error, it was there ;)
The first 3 days I think I shipped 5 emails with bugfixes and new versions XD
So it will get better in just a little while, and I promise you my click of install the day I install this :D (Im not clicking just now because I dont need to recieve mails about updates to a hack I havnt installed yet ;))

sv1cec 11-23-2004 05:52 PM

Quote:

Originally Posted by DS MrSinister
I am also having problem with the Upgrade..

Will not goto the 2nd step. It ask me to remove Old templates. than I Click that. then It goes to a Blank screen..

It looks like it remove the templates but did not add anything to the database. mmmmmmmmmmmmmmmmmmmmmm

OK, that's the kind of feedback I want. Let me see what's the issue and I'll get back.

mcyates 11-23-2004 06:38 PM

Quote:

Originally Posted by sv1cec
OK, that's the kind of feedback I want. Let me see what's the issue and I'll get back.

that's what it done to me, i had to install it manually.

sv1cec 11-23-2004 07:10 PM

Quote:

Originally Posted by mcyates
that's what it done to me, i had to install it manually.

Gentlemen,

My apologies, there were indeed some mistakes in the upgrade_warn.php file, which is used to upgrade from Zero Tolerance's Warning Hack V.1.5 to my Advanced Warning System (latest release).

I corrected those mistakes and improved the appearance of the program a little. I managed to test it on my Sun, but one thing I couldn't test, was the database tables changes. Can someone who is using Zero's hack try it and let me know it works in that part as well?

Many thanks and apologies for any inconvenience.

sv1cec 11-23-2004 07:17 PM

Quote:

Originally Posted by Revan
Since you said this was your first officially released hack, sv1, some encouraging words:
Hang in there, mate ;) All this bs with bugs and installer errors and [insert other errors here] is nothing compared to what the RPG thread looked like in the first 7 pages :p
If there was a possible error, it was there ;)
The first 3 days I think I shipped 5 emails with bugfixes and new versions XD
So it will get better in just a little while, and I promise you my click of install the day I install this :D (Im not clicking just now because I dont need to recieve mails about updates to a hack I havnt installed yet ;))

Revan,

Many thanks for the encouraging words. I sincerely appreciate them.

Although I am hardly new to programming, I learned about php last June, when I opened my forums site.

What makes me really happy, is that people are not reporting bugs or errors in the hack's operation, but in the installation (or rather the upgrade) script, which I copied from Zero's thread and did some changes (that proves my total incompetence, I can't even copy properly! LoL). These, I made in a hurry, since people were asking for an installer and Zero had asked me for an upgrade script.

Thank God, nothing difficult to fix, so people have the corrected one now.

As for the e-mails, I didn't even know that I had that option, until earlier today. I am not sure I am going to use it, so don't worry about me flooding your mailbox.

Again, thanks for the encouraging words, I'll hang in there, I like the environment.

Rgds
-------------
John

DS MrSinister 11-23-2004 07:18 PM

Quote:

Originally Posted by sv1cec
Gentlemen,

My apologies, there were indeed some mistakes in the upgrade_warn.php file, which is used to upgrade from Zero Tolerance's Warning Hack V.1.5 to my Advanced Warning System (latest release).

I corrected those mistakes and improved the appearance of the program a little. I managed to test it on my Sun, but one thing I couldn't test, was the database tables changes. Can someone who is using Zero's hack try it and let me know it works in that part as well?

Many thanks and apologies for any inconvenience.

this what i get now

New templates added to styleid 2

Click on "Apply Database Upgrades" to continue.

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: update warning_options set
hierarchical='Yes',
warner='1',
troll_usergroup_id='8',
protected_usergroups='6',
incr_ban_days='Yes',
max_no_bans='2',
multiple_per_post='Yes',
send_pm_warning='Yes',
send_em_warning='No',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='20'
 where oid='1'
mysql error: Unknown column 'warner' in 'field list'

mysql error number: 1054


sv1cec 11-23-2004 07:32 PM

Quote:

Originally Posted by DS MrSinister
this what i get now

New templates added to styleid 2

Click on "Apply Database Upgrades" to continue.

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: update warning_options set
hierarchical='Yes',
warner='1',
troll_usergroup_id='8',
protected_usergroups='6',
incr_ban_days='Yes',
max_no_bans='2',
multiple_per_post='Yes',
send_pm_warning='Yes',
send_em_warning='No',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='20'
 where oid='1'
mysql error: Unknown column 'warner' in 'field list'

mysql error number: 1054



Please download the upgrade_warn.php file again. I corrected that.

Let me know if you face more problems.

By the way, does anyone knows how I can stop seeing the hack's description on the top of every page in this thread? I hate this new feature here.

Thanks

DS MrSinister 11-23-2004 11:05 PM

I get this now..

something is wrong with view log in admin panel and view warning

Code:

Invalid SQL: select w.*,u.username as wusername,u.userid as wuserid,wt.* from
warnings w
left join user u on(u.userid=w.warned_by)
left join warning_types wt on(wt.tid=w.warned_warning_id)
where w.warned_user='1' order by w.warned_time DESC
mysql error: Unknown column 'w.warned_user' in 'where clause'

mysql error number: 1054


sv1cec 11-24-2004 05:01 AM

Quote:

Originally Posted by DS MrSinister
I get this now..

something is wrong with view log in admin panel and view warning

Code:

Invalid SQL: select w.*,u.username as wusername,u.userid as wuserid,wt.* from
warnings w
left join user u on(u.userid=w.warned_by)
left join warning_types wt on(wt.tid=w.warned_warning_id)
where w.warned_user='1' order by w.warned_time DESC
mysql error: Unknown column 'w.warned_user' in 'where clause'

mysql error number: 1054


warned_user is a column which exists from the tables of Zero Tolerance. I haven't add it myself. Are you sure you had Zero's hack version 1.5 installed and working properly?

Do this for me:

Run the following queries:

1) describe warnings
2) describe warning_types
3) describe warning_options

Post the results.

One more thing, how on earth did you manage to get this statement? The statement is used when you try to see the warnings of a user (View XYZ'z Warnings" link). And from the error you posted, it looks as if you have that link in a post which is made by userid 1, which is your admin. There is no way that you will get that link in an admin post, with my hack. Are you sure you have followed the instructions, or did you just run upgrade_warn.php and stopped there?

Also, you do not tell me what is your problem in the admincp/view warning logs. I can't guess, you have to tell me the problem.

Rgds


All times are GMT. The time now is 10:38 AM.

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.03615 seconds
  • Memory Usage 1,757KB
  • 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
  • (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