[Scythe42]

Originally Posted by Vtec44

I got a database error with the latest 2.0.2 fixed.

I see you are using a tableprefix.

There is an "AS userid" and "AS invitation" missing in the FROM and JOIN clauses to make it work with tableprefixes.

To fix this, open the prodcut-invitation.xml before importing and apply the following changes:

Change line 304 and 305 from:

PHP Code:

FROM " . TABLE_PREFIX . "user
LEFT JOIN " . TABLE_PREFIX . "invitation 


to

PHP Code:

FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "invitation AS invitation 


Change line 320 from:

PHP Code:

$invitationcheck = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "invitation 


to

PHP Code:

$invitationcheck = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "invitation AS invitation 


That should do the trick for your guys using table prefixes. Let me know if this works for you.