PDA

View Full Version : RC1 Feedback


Milad
04-28-2007, 01:31 PM
Hello

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, 01:33 PM
I tried to generate an issue, I had a MySQL error:

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, 01:59 PM
I reinstall it, it's fine now.

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