The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Advertising Banner System

Geek Advertising Banner System GAB is a highly configurable banner management system for vBulletin.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 02-12-2006, 03:08 AM
Michael-MI Michael-MI is offline
Member
 
Join Date: Oct 2005
Posts: 44
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default GAB Issue Mark All Forums Read SQL Error

Users are reporting and I can confirm via sql database errors.

The user is doing the following:

- Forum Home
- Click Quick Links
- Click Mark All Forums Read
- Invalid SQL:
SELECT DISTINCT type, adid FROM GAB_listing
WHERE 1=1 AND script = 'forumdisplay' AND forumid= ORDER BY RAND() LIMIT 1;

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 'ORDER BY RAND() LIMIT 1' at line 2
Error Number : 1064
Date : Saturday, February 11th 2006 @ 08:08:34 PM
Script : http://www.mouseinfo.com/forums/foru...hp?do=markread
Referrer : http://www.mouseinfo.com/forums/sear...earchid=361504
IP Address : XXXXXXXXX
Username : Michael
Classname : vb_database

- I temporary removed the forumdisplay script and that did not resolve the issue. Any ideas? Thank you.

Michael
Reply With Quote
  #2  
Old 02-12-2006, 07:46 AM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Thanks... give me a few minutes and ill update the package.
Reply With Quote
  #3  
Old 02-12-2006, 04:07 PM
Michael-MI Michael-MI is offline
Member
 
Join Date: Oct 2005
Posts: 44
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

I updated the files and that resolved my issue. Thank you!

Michael
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
"Mark Category Read" not working guvner Geek Article and Review System 3 06-08-2008 09:27 PM
SQL Error JonnyF Geek Article and Review System 4 07-09-2007 08:50 PM
SQL error trana Geek Article and Review System 1 12-12-2006 10:49 PM
SQL error Scribbller Geek Article and Review System 0 12-12-2006 04:50 PM
TRying to download GAB, but it is downloading it as GAB read on LincolnForums Geek Advertising Banner System 5 06-07-2006 06:29 PM


All times are GMT. The time now is 05:54 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.