Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Error UPDATING FORUM COUNTS in Admin.Count.asp		  New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

ramongece
Starting Member

Bhutan
40 Posts
Posted - 18 January 2006 :  08:47:03  Show Profile
Hi.
Somebody can help me?
Thank you.
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 18 January 2006 :  16:56:02  Show Profile
I'm sorry, I have no more ideas. Maybe your server is too slow and the script is timing out? Just a wild guess.
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

tsnyder91
Starting Member

3 Posts
Posted - 11 January 2007 :  13:34:32  Show Profile
http://bugs.mysql.com/bug.php?id=10527

The issue may be with the MyODBC 3.51 and using the SUM() function in a MySQL query.

It will not work on values that are not set to a data type of DOUBLE according to the article

A post mentions changing Integer field types to Double. I tried it and it WORKS!!

Below are the tables that are query'd in steps 4 and 5. The fields just need to be changed to a datatype of DOUBLE and they worked for me!


FORUM TABLE
===========
F_TOPICS
F_COUNT
F_A_TOPICS
F_A_COUNT

TOPICS TABLE
============
T_LAST_POST_AUTHOR
T_REPLIES

A_TOPICS TABLE
================
T_REPLIES
T_LAST_POST_AUTHOR * Not query'd but done for consistency when archiving data.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07