|
|
|
|
Joined: Nov 1999
Posts: 132
Member
|
|
Member
Joined: Nov 1999
Posts: 132 |
This may be due to a misconfiguration on our part...we're just barely starting to test out the program. Also, I haven't read through the backlog of bug reports, so this might be a known issue. I'm just throwing this out there in case it helps.
With that in mind....
i deleted a thread, and before an automatic reload cleared it, I got this weird message atop the page:
SQL ERROR: Unable to do_query: UPDATE w3t_Boards SET Bo_Total = Bo_Total - 2, Bo_Threads = Bo_Threads - 1, Bo_Poster = '', Bo_LastNumber = , Bo_LastMain = WHERE Bo_Keyword = 'Cookware'
You have an error in your SQL syntax near ' Bo_LastMain = WHERE Bo_Keyword = 'Cookware' ' at line 6
Threads expired.
All threads you marked to expire have been purged from the database.
|
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
|
Guru
Joined: May 1999
Posts: 3,039 |
This one pops up when you delete the very last thread in a forum. It tries to recalculate the last post for the forum but since it can't find it, it generates the error. Still working on a fix.
UBB.threads Developer
|
|
|
|
|
Joined: Mar 2002
Posts: 15
Newbie
|
|
Newbie
Joined: Mar 2002
Posts: 15 |
I just stepped into this also deleting the only thread in a forum. Now the count for the forum is off having a count of one where there isn't one. Any suggestions on how to fix the count ?
Thanks.
Greg
|
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
|
Guru
Joined: May 1999
Posts: 3,039 |
You'll need to know the board keyword to fix. Basically if you need to fix the count and you know the total # of threads and posts you can use the following SQL command:
UPDATE w3t_Boards SET Bo_Threads='#ofthreads', Bo_Total='#ofposts' WHERE Bo_Keyword='boardkeyword'
UBB.threads Developer
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 449
Joined: February 2008
|
|
|
Forums63
Topics37,575
Posts293,930
Members13,823
| |
Most Online6,139
Sep 21st, 2024
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
