Query syntax error help

[Simon Lloyd]

i think you're getting confused because vbulletin has done it's trick of adding a space after x amount of characters, here it is in quotes

$db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX ."unsub_subscribethread LIKE " .TABLE_PREFIX."subscribethread");

so after TABLE_PREFIX. the quotation should be butt up against it because you ar etrying to get mytableprefix_ unsub_subscribethread if there was a space it would look like mytableprefix_ unsub_subscribethread and would create a table that would be called SPACEunsub_subscribethread (the word space wouldn't be there just a blank space )

So, in a nutshell the one in the quote in this post is correct if you dont wnt to introduce any other anomalies.