The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Gazette

Geek Gazette GAZ is a community newsletter management system.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 04-28-2007, 01:31 PM
Milad Milad is offline
Member
 
Join Date: Nov 2005
Posts: 58
Geek Article and Review System License Holder Geek Gazette License Holder 
Default RC1 Feedback

Hello

I received this MySQL error when I tried to Syncronize subscription fields

Code:
Invalid SQL:
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'gaz_subscriptions' AND table_schema='database_name';

MySQL Error  : SELECT command denied to user 'database_user'@'localhost' for table 'COLUMNS'
My username has full privileges!!!
Reply With Quote
  #2  
Old 04-28-2007, 01:33 PM
Milad Milad is offline
Member
 
Join Date: Nov 2005
Posts: 58
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

I tried to generate an issue, I had a MySQL error:

Code:
Invalid SQL:

		SELECT 
			thread.threadid, thread.title, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, pollid
			
			,thread.forumid, forum.title AS forumtitle
		FROM thread as thread
		
		LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
		
		
		WHERE open != 10
			AND thread.visible = 1 
			
			AND thread.views >= 150AND thread.replycount >= 15
			AND thread.forumid in (2) 
		ORDER BY thread.dateline DESC 
		LIMIT 10;

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 'thread.replycount >= 15
			AND thread.forumid in (2) 
		ORDER BY thread.dateline' at line 13
Reply With Quote
  #3  
Old 04-28-2007, 01:59 PM
Milad Milad is offline
Member
 
Join Date: Nov 2005
Posts: 58
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

I reinstall it, it's fine now.

for the email title in the gmail, it's OK too.
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
New Member Feedback popowich Geek Article and Review System 1 07-01-2007 10:12 AM
GARS 2 any feedback? Ramses Geek Article and Review System 6 05-10-2006 10:01 AM
feedback kidmercury Geek Article and Review System 0 11-01-2005 05:01 AM


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


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