The vB Geek

The vB Geek (http://www.thevbgeek.com/index.php)
-   Geek Gazette (http://www.thevbgeek.com/forumdisplay.php?f=56)
-   -   RC1 Feedback (http://www.thevbgeek.com/showthread.php?t=3130)

Milad 04-28-2007 12:31 PM

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!!!

Milad 04-28-2007 12:33 PM

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


Milad 04-28-2007 12:59 PM

I reinstall it, it's fine now.

for the email title in the gmail, it's OK too.


All times are GMT. The time now is 03:33 AM.

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