vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/forumdisplay.php?f=105)
-   -   Fresh installed AWS 3 Database errors (https://vborg.vbsupport.ru/showthread.php?t=78684)

ShadowFun 03-24-2005 08:42 AM
Fresh installed AWS 3 Database errors
 
Hello...
Thank you for the conducted enormous work above AWS. ;)

There are problems after the fresh install on a
clean forum.
Installed version is 3.3.1 ... then upgraded to 3.3.2

Admin CP -> Warning System ->
1. View Warned Users
Warning: Division by zero in \admincp\admin_warn.php on line 704
Code:
Invalid SQL: select * from
        user u where warnings>0 ORDER BY userid ASC LIMIT 0,
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 2
mysql error number: 1064
2. Statistics - Warnings per User
Warning: Division by zero in \admincp\admin_warn.php on line 704
Code:
Invalid SQL: select * from
        user u where warnings>0 ORDER BY userid ASC LIMIT 0,
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 2
mysql error number: 1064
3. Statistics - Bans per User
Warning: Division by zero in \admincp\admin_warn.php on line 1988
Code:
Invalid SQL: select b.*, u.*, a.username AS warner, w.*, wt.* 

from ban_dates as b
        LEFT JOIN user AS u ON(u.userid = b.banned_user)
        LEFT JOIN user AS a ON(a.userid = b.banned_by)
        LEFT JOIN warnings AS w ON(w.wid = b.banned_warning)
        LEFT JOIN warning_types AS wt ON(wt.tid =
w.warned_warning_id)
        ORDER BY b.banned_user, b.banned_ban LIMIT 0,
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 6
mysql error number: 1064
How is it possible to correct ?

Rgds.

Delphiprogrammi 03-24-2005 12:25 PM
hi,

i've checked those things.I upgraded to the latest version and all seems to be working fine here.I would suggest you check your file edits you must have missed something (in any edited file) did you do the bigchange recently all of the aws parameters where moved to $vboptions instead of the warning_options table.In the zip there is a script dat updates this for you

also make sure you uploaded the latest admin_warn.php and Warn.php files

ShadowFun 03-24-2005 03:51 PM
hm...
fresh reinstalled with v3.3.2
The same errors of DB.
I`m currently confused........ :)

sv1cec 03-25-2005 04:52 AM
You have not set your Warning Options properly. The division by zero error is because you have not set, how many lines per page you want to see in reports. You have to set this option to a number, like 10, 15 whatever, but you should not leave that empty.

I added some checks for this in the admin_warn.php file, and I'll upload a new zip file later today.

Rgds

ShadowFun 03-25-2005 05:16 AM
I can`t save any options...
After set them they return by default. :o

sv1cec 03-25-2005 05:21 AM
Have your run the warn_install_setting.php file as specified in the upgrade instructions?

Point your browser to :

http://www.yourforumdomain.com/admin...ll_setting.php

Change yourforumdomain, to whatever your domain is in the line above.

Rgds

ShadowFun 03-25-2005 08:46 AM
Thank you that specified a way where to search the error of installation...
I not quite understand as happened so (when I run warn_install_setting first time), that in a base was added only on two first phrases from every group is this and was reason of errors.
All works now. :)
Many thanks all for the spent time on this remarkable hack.
Success ! ;)

sv1cec 03-28-2005 12:28 PM
Glad I was able to help.

Rgds


All times are GMT. The time now is 06:39 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.01068 seconds
  • Memory Usage 1,725KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete