Previous Thread
Next Thread
Print Thread
Rate Thread
#212029 10/04/2001 4:47 AM
Joined: Feb 2001
Posts: 31
User
User
Offline
Joined: Feb 2001
Posts: 31
Getting this SQL error when viewing the control panel in the friends online section:

SQL ERROR: Unable to do_query: DELETE FROM w3t_Online WHERE O_Last <
You have an error in your SQL syntax near '' at line 4: 2000

Do not get this error when viewing the Who's Online page though.

Here's the section in online.php in question:

// -------------------------
// Delete the inactive users
$html = new html;
$Outdated = $html -> get_date() - 600;
$query = "
DELETE FROM w3t_Online
WHERE O_Last < $Outdated
";
$dbh -> do_query($query);

Looks good to me...anyone see the error or have an idea where to check to fix this?

Here's the URL to the board to see for yourself:
http://www.sweetleaf.cc/wwwthreads/wwwthreads.php

Sponsored Links
Joined: May 1999
Posts: 3,039
Guru
Guru
Offline
Joined: May 1999
Posts: 3,039
Ok, try this one. Line 914 of main.inc.php looks like this:

$Outdated = $html -> get_date;

Try changing that, to this:

$Outdated = $html -> get_date();


UBB.threads Developer

Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Gizmo
Gizmo
Portland, OR, USA
Posts: 5,833
Joined: January 2000
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)