PDA

View Full Version : Fresh installed AWS 3 Database errors


ShadowFun
24 Mar 2005, 09:42
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
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
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
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
24 Mar 2005, 13:25
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
24 Mar 2005, 16:51
hm...
fresh reinstalled with v3.3.2
The same errors of DB.
I`m currently confused........ :)

sv1cec
25 Mar 2005, 05:52
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
25 Mar 2005, 06:16
I can`t save any options...
After set them they return by default. :o

sv1cec
25 Mar 2005, 06:21
Have your run the warn_install_setting.php file as specified in the upgrade instructions?

Point your browser to :

http://www.yourforumdomain.com/admincp/warn_install_setting.php

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

Rgds

ShadowFun
25 Mar 2005, 09:46
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
28 Mar 2005, 13:28
Glad I was able to help.

Rgds