The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Article and Review System

Geek Article and Review System GARS is the mega popular system for turning forums into articles, tutorials, or even reviews.

Advertisement
This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 04-13-2008, 08:33 AM
Ohiosweetheart Ohiosweetheart is offline
Member
 
Join Date: Aug 2006
Posts: 53
Default Database error when emailing installed...

I have a vB designs site, and require members to click the Install button in order to download a style.

When I try to email these members (by clicking on the # of installs, of course) I get the following database error -

Quote:
Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:
SELECT userid, username, email FROM vb_user WHERE userid in (-1Array,1250,1762,1859,1868,367,1886,1931,1938,1939 ,1950,1176,1543,1102,1963);

MySQL Error : Unknown column '1Array' in 'where clause'
Error Number : 1054
Date : Sunday, April 13th 2008 @ 04:06:22 AM
Script : http://www.themesbydesign.net/forums/marked.php
Referrer : http://www.themesbydesign.net/forums...?do=show&t=613
IP Address : 24.154.105.233
Username : Peggy
Classname : vB_Database
MySQL Version : 5.0.45-community
Any solution for this??
Reply With Quote
  #2  
Old 04-14-2008, 01:34 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 like an error from an old version of GARS but as I'm not sure what code base you are using, you'll need to sync the code in the /forums/marked.php file with the following:
Code:
				$users = '';
				foreach($marked as $key => $value)
				{
					$users .= "," . intval($key);
				}
				if ($users)
				{
					$users = $db->query_read("SELECT userid, username, email FROM " . TABLE_PREFIX . "user WHERE userid in (-1$users)");
__________________
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
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 jiggle Geek Article and Review System 1 01-03-2008 10:54 AM
Database Error Stefan S. Geek Article and Review System 4 01-05-2007 06:47 PM
Database error vitoreis Geek Article and Review System 5 10-01-2006 09:29 PM
Database error good2laugh Geek Article and Review System 1 08-27-2006 07:35 AM


All times are GMT. The time now is 10:33 PM.


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