![]() |
|
|||||||
| Geek Gazette GAZ is a community newsletter management system. |
| Advertisement | |
|
|
| Learn how to remove ads | |
![]() |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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' |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
I reinstall it, it's fine now.
for the email title in the gmail, it's OK too. |
![]() |
| Thread Tools | |
| Display Modes | |
|
|
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 |