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-05-2008, 12:36 AM
gldtn gldtn is offline
Senior Member
 
Join Date: Oct 2005
Location: Massachusetts, USA
Posts: 122
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder 
Default ACP » GAB Manager » Setting Database Error

Hello morgan I got a database error when I click on ACP » GAB Manager » Settings

Code:
Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

                SELECT profilefieldid, title
                FROM vb3_profilefield;

MySQL Error   : Unknown column 'title' in 'field list'
Error Number  : 1054
Date          : Monday, February 4th 2008 @ 07:33:15 PM
Script        : http://www.mydomain.org/forum/admincp/GAB_admin.php?do=settings
Referrer      : http://www.mydomain.org/forum/admincp/index.php?do=nav
IP Address    : *.*.*.8
Username      : GL
Classname     : vb_database
MySQL Version : 4.1.22-stand
Using vB3.7b4...
Thanks!
__________________
http://www.braziltourism.org/
Reply With Quote
  #2  
Old 02-05-2008, 12:56 AM
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

Sounds like you might have an old file. Is this an update? Try reFTPing all the PHP files, overwriting the ones on the server.
__________________
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, 01:21 AM
gldtn gldtn is offline
Senior Member
 
Join Date: Oct 2005
Location: Massachusetts, USA
Posts: 122
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder 
Default

Oops I thought I had access to the latest update like the other scripts I owned when Geek was still in charge. I was trying to install GAB Beta 4 and didn't notice it wasn't the latest stable version :/

Sorry!
__________________
http://www.braziltourism.org/
Reply With Quote
  #4  
Old 02-07-2008, 01:01 PM
pixie pixie is offline
Senior Member
 
Join Date: Mar 2007
Posts: 190
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

I have the same problem, but it still persists even with all the new files (2.0.2) uploaded.

Code:
Datenbankfehler in vBulletin 3.6.8:

Invalid SQL:
SELECT varname, text
			FROM phrase
			WHERE languageid = 0 AND fieldname = 'cprofilefield' AND varname IN ();

MySQL-Fehler : 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 ')' at line 3
Fehler-Nr.   : 1064
Datum        : Thursday, February 7th 2008 @ 01:57:53 PM
Skript       : http://www.myurl.de/admincp/GAB_admin.php?do=settings
Referrer     : http://www.myurl.de/admincp/index.php?do=nav
IP-Adresse   : 85.181.185.202
Benutzername : admin
Klassenname  : vB_Database
Can you please help? Thanks!
Reply With Quote
  #5  
Old 02-08-2008, 06:44 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

Go to the ACP -> User Profile Fields -> User Profile Field Manager. Do you have any profile fields?
__________________
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
  #6  
Old 02-09-2008, 08:40 AM
pixie pixie is offline
Senior Member
 
Join Date: Mar 2007
Posts: 190
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

No. Not a single one.
Reply With Quote
  #7  
Old 02-09-2008, 08:45 AM
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

GAB is coded to use profile fields, so you'll need to add at least one profile field. Maybe in the next version, I'll remove that requirement so you could then go back to no profile fields.
__________________
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
  #8  
Old 02-10-2008, 10:33 AM
pixie pixie is offline
Senior Member
 
Join Date: Mar 2007
Posts: 190
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Yep. That worked, thanks!
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
GAB Manager does not show henrikhansen Geek Advertising Banner System 0 02-05-2008 07:46 PM
Is there a way to have Reviews accepting more images than the ACP setting? bluesteel Geek Article and Review System 1 11-14-2006 04:40 PM
Database error? cookiepants Geek Article and Review System 3 10-20-2006 08:46 PM
Database error good2laugh Geek Article and Review System 1 08-27-2006 08:35 AM
GAB manager in admincp for other users. keith455 Geek Advertising Banner System 4 07-19-2006 11:42 AM


All times are GMT. The time now is 09:32 AM.


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