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
This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 02-05-2008, 05:40 AM
NCangler's Avatar
NCangler NCangler is offline
Member
 
Join Date: Oct 2005
Posts: 31
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 
Question Database error after upgrading to 2.0

I just installed the upgrade to 2.0 and when I click on the "Banners" or "Stats" menu item, I get this MySQL error.

Quote:
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT id, title FROM GAB_cats WHERE isactive=1 ORDER BY ordinal,title ASC;

MySQL Error : Unknown column 'isactive' in 'where clause'
Error Number : 1054
Date : Tuesday, February 5th 2008 @ 01:33:08 AM
Script : http://www.mysite.net/forums/admincp...?do=displayads
Referrer : http://www.mysite.net/forums/admincp/index.php?do=nav
IP Address : xx.xxx.xxx.xxx
Username : xxxxxxxxx
Classname : vb_database
Any suggestions?

Thanks for any input.
Reply With Quote
  #2  
Old 02-05-2008, 03:23 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
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

That looks to be a query from an old file. ReFTP all the GAB PHP files to the server to ensure that the new files are there.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #3  
Old 02-05-2008, 03:31 PM
NCangler's Avatar
NCangler NCangler is offline
Member
 
Join Date: Oct 2005
Posts: 31
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

I reloaded the files and all transferred except the index.htm in the GAB folder. It says that it could not upload that file: Permission deniedError -160. I'm still getting the same error.
Reply With Quote
  #4  
Old 02-05-2008, 03:32 PM
NCangler's Avatar
NCangler NCangler is offline
Member
 
Join Date: Oct 2005
Posts: 31
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

I changed the permissions on the index.htm file and was then able to overwrite it. Now it works. Thanks for your help.
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
database error beduino Geek Gazette 1 06-24-2008 05:43 PM
Database error good2laugh Geek Article and Review System 1 08-27-2006 07:35 AM
Database Error!! PabloAM Geek Article and Review System 1 03-26-2006 08:11 PM
Upgrading to 3.7 error... Fleabag GeekMart 5 11-28-2005 12:42 AM
database error agiacosa Geek Auto-Linker 7 10-15-2005 05:19 PM


All times are GMT. The time now is 01:37 PM.


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