The vB Geek

The vB Geek (
-   Geek Gazette (
-   -   RC1 Feedback (

Milad 04-28-2007 12:31 PM

RC1 Feedback

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


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:


Invalid SQL:

                        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:06 PM.

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