[Baja]

Ran into a db error after importing vbseo likes and executing any maintenance script:

Database error in vBulletin 4.1.12:

Invalid SQL:
UPDATE vb_dbtech_thanks_statistics SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`likes_received` = '717',
`thanks_given` = '1',
`thanks_received` = '53',
`likes_given` = '12'
WHERE userid = 1;

MySQL Error : Unknown column 'likes_received' in 'field list'

This was caused because we didn't want two buttons (thanks + likes), so we deleted the like button shortly after installing APTL and prior to running the importer. The problem is easy enough to fix by running a mysql query to reset dbtech_thanks_entry [varname] = thanks. Although you might consider adding a new maintenance script to reset the assigned button for existing thanks/likes for customers that aren't comfortable with manually editing their db. Either that or have a prompt during the import asking which button to assign the Abe/vBSEO imports to. Just FYI


We also noticed two glitches in the user profile tab:

1) Imported likes are not sorted chronologically. I believe the import script is ordering via vbseo's l_contentid field (post#) instead of the l_dateline field.

2) Approx half of the pages listed are empty. This appears to be related to Thanks_Received vs Thanks_Given. For example: If a member has 1000 total thanks (600 received + 400 given), there will be 30 populated pages (600 / 20 per page = 30) and 20 empty pages that say "No Results to Show". The bizarre thing is the first 30 populated pages have both received + given feedback listed. So it's not simply an issue of given feedback being hidden.

Any idea what's causing the 2nd issue?