[Scandal]

Originally Posted by socialteenz

For some reasons i am not able to run the Rebuild Statistics.

I am getting a database error!

Database error in vBulletin 4.2.0:

Invalid SQL:

                  SELECT SUM(if(thumb = 1, 1, 0)) AS thumbsup, SUM(if(thumb = -1, 1, 0)) AS thumbsdown
                  FROM vb_sc_thumbs_node;

MySQL Error   : Table 'xxxxxx_smf1.vb_sc_thumbs_node' doesn't exist

Are you sure you have installed the *xml product during the upgrade to v1.8?
Look at your admincp page with your products. What version of Thumbs Up? it says that you have installed?
How to upgrade?
1. Upload and replace the new files.
2. Import XML product with "Allow overwrite" to YES.

Originally Posted by Barbaro

It's the same

Database error in vBulletin 4.2.0:

Invalid SQL:

UPDATE user
SET sc_thumbs_up_received = sc_thumbs_up_received - 1
WHERE userid = 743258;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`foooooo_com`.`user`.`sc_thumbs_up_received` - 1)'
Error Number : 1690

What you try to do and appears this db error?
Also, can you see and tell me how many thumbs up "received" your user with ID 743258?