Views Definition MySQL Error [#806014]

I'm getting the following error when I go to export the views definition:

user warning: 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 'AND twtid IN (1,2,3,4,6,7)' at line 2 query: SELECT twtid, tablename, dbconnection FROM tw_tables AND twtid IN (1,2,3,4,6,7) in /sites/all/modules/tw/tw_tablebuild.inc on line 44.

It looks like it's either missing the first WHERE clause, or needs to remove the AND when there's only one. I saw this as I was about to leave the office, so I'll try to check it out further this weekend and attempt a patch if I find it.

Comment	File	Size	Author
#1	806014.patch	418 bytes	mdorman

Comments

Comment #1

mdorman commented 24 May 2010 at 16:17

Status	File	Size
new	806014.patch	418 bytes

I replaced the AND with WHERE, since there were no previously defined WHERE clauses in the $sql variable. So far this worked for me, but there was obviously another WHERE clause in previous versions, so there might be other issues.

Comment #2

betz commented 11 June 2010 at 23:00

I can confirm the error.

Comment #3

jimmynash commented 17 June 2010 at 04:22

I ran into the error as well. So far the patch in #1 has worked for me.

Comment #4

tom_o_t commented 17 June 2010 at 20:18

Status:

Active

» Reviewed & tested by the community

Confirming both the problem and that the patch in #1 works.

Comment #5

andrewlevine commented 17 June 2010 at 20:23

You can see clearly where this bug came from in the following link. Not quite sure how this bug hasn't seen more activity since it breaks exporting tables in 6.x-1.2.

http://drupalcode.org/viewvc/drupal/contributions/modules/tw/tw_tablebui...