vb.org Archive
Page 34 of 105 « First 243233 34 35364484 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)

mcyates 12-15-2004 03:25 PM
I keep getting this error:

Code:
Invalid SQL:
            INSERT INTO userban
            (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)
            VALUES
            (1033, 8, 0, 0, 'Ball boy', 1, 1103129995, 1103734795, 'User exceeded the Warning Limit and was banned.')
mysql error: Unknown column 'reason' in 'field list'

mysql error number: 1054
It obviouslyt because i haven't got the column reason added. What is the SQL query to add this? The warning points are still given to the user when you select which warning but this error comes up when you submit it.

sv1cec 12-15-2004 03:46 PM
Quote:
Originally Posted by mcyates
I keep getting this error:

Code:
Invalid SQL:
            INSERT INTO userban
            (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)
            VALUES
            (1033, 8, 0, 0, 'Ball boy', 1, 1103129995, 1103734795, 'User exceeded the Warning Limit and was banned.')
mysql error: Unknown column 'reason' in 'field list'

mysql error number: 1054
It obviouslyt because i haven't got the column reason added. What is the SQL query to add this? The warning points are still given to the user when you select which warning but this error comes up when you submit it.
ALTER TABLE `".TABLE_PREFIX."userban` ADD COLUMN `reason` mediumtext

Sorry about that, that's what happens when one doesn't keep notes of all the changes.

mcyates 12-15-2004 03:51 PM
Quote:
Originally Posted by sv1cec
ALTER TABLE `".TABLE_PREFIX."userban` ADD COLUMN `reason` mediumtext

Sorry about that, that's what happens when one doesn't keep notes of all the changes.
thansks. Its pretty hard work keeping up with this hack. Everytime i return to the page its been updated. Last time it was 2.3.1 now its 2.3.3. Madness. ok thanks for the help.

sv1cec 12-15-2004 04:18 PM
Quote:
Originally Posted by mcyates
thansks. Its pretty hard work keeping up with this hack. Everytime i return to the page its been updated. Last time it was 2.3.1 now its 2.3.3. Madness. ok thanks for the help.
I know, don't you want it improved?

Ah and a correction, it will be in 2.3.4 in a minute, I haven't noted down the changes required in the file modcp/banning.php. I 've added a column in the userban table, where the hack stores a special message, when it bans a user.

Give me 5 minutes to upload the instructions.

mcyates 12-15-2004 04:28 PM
Yeah i'm just saying its hard work. lol

sv1cec 12-15-2004 04:50 PM
Quote:
Originally Posted by mcyates
Yeah i'm just saying its hard work. lol
I know and I really feel bad about it. I keep doing small things, here and there, adding some more functionality etc. and it grows and it grows.

What you want me to do? Do you folks are overwhelmed with it? Do you want me to stop adding things for a while?

Just let me know.

For the time being, I have one more thing I want to do, in the admin_warn.php, and then I'll be ... looking for new ideas.

Rgds and sorry if I cause you trouble.

jluerken 12-15-2004 05:30 PM
I've found two smaller errors in 2.3.4

1. In the upgrade instructions youve forgotten a small line

PHP Code:
UPDATE `".TABLE_PREFIX."warning_options` SET version='2.3.4' WHERE oid=1 
:D

2. In the AdminCP the colspan has to be increased somewhere. (see attachment!)

and btw. you have to update the version numbers in the files also :nervous:

sv1cec 12-15-2004 06:13 PM
Quote:
Originally Posted by jluerken
I've found two smaller errors in 2.3.4

1. In the upgrade instructions youve forgotten a small line

PHP Code:
UPDATE `".TABLE_PREFIX."warning_options` SET version='2.3.4' WHERE oid=1 
:D

2. In the AdminCP the colspan has to be increased somewhere. (see attachment!)

and btw. you have to update the version numbers in the files also :nervous:
You are right. I've updated the instructions, if you do not mind, please download and apply the section which is marked with :

// COMMENT: CHANGES BELOW AFFECT THE COLSPAN IN THE BANNED USERS REPORT //

in the UpgradeToLatestVersion.txt file.

Don't forget to run that query as well.

Rgds and tnx

jluerken 12-15-2004 06:32 PM
Quote:
Originally Posted by sv1cec
You are right. I've updated the instructions, if you do not mind, please download and apply the section which is marked with :

// COMMENT: CHANGES BELOW AFFECT THE COLSPAN IN THE BANNED USERS REPORT //

in the UpgradeToLatestVersion.txt file.

Don't forget to run that query as well.

Rgds and tnx
I updated everything.
This seems to be the most-supported Hack here on vb.org :D

Hopefully we come to a final state within the next days or do you have already more plans for future releases? haha

SamirDarji 12-16-2004 12:51 AM
I still can't find out why the warning options aren't appearing the member profile. I checked the template and member.php and they're both correct. This is the only thing I have left to test before I install on the live server (which will go much smoother since that setup is cleaner). Any assistance appreciated.


All times are GMT. The time now is 07:55 PM.
Page 34 of 105 « First 243233 34 35364484 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.02247 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
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (6)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