AKadoorah
12-18-2017, 04:19 AM
Hello,
I have an issue after I restore post_thanks table on my database, details:
First of all, I upgrade my vb to 3.8.11 and I face an issue when I try to open a thread it shows up this error:
Invalid SQL:
SELECT * FROM vb_post_thanks AS post_thanks INNER JOIN vb_user AS user USING (userid) WHERE post_thanks.postid IN (0Array) ORDER BY post_thanks.username ASC;
MySQL Error : Unknown column '0Array' in 'where clause'
Error Number : 1054
And I do my research and fix this issue thanks to vbem2 (https://vborg.vbsupport.ru/member.php?u=231182) on his post here:
https://vborg.vbsupport.ru/showpost.php?p=2586995&postcount=2367
After I delete the product the table on database was deleted but I take a copy before 2 months so I don't care, and I reinstall it and restore that table alone on my database correctly and I see all rows
after that all old thanks didn't appears and all what I can do is just make new THANKS
Note that I do rebuild threads and forums from ADMINCP!
What I can do now so old THANKS can appears as usual?
Please advise.
--------------- Added 1513639630 at 1513639630 ---------------
Update
I have an issue after I restore post_thanks table on my database, details:
First of all, I upgrade my vb to 3.8.11 and I face an issue when I try to open a thread it shows up this error:
Invalid SQL:
SELECT * FROM vb_post_thanks AS post_thanks INNER JOIN vb_user AS user USING (userid) WHERE post_thanks.postid IN (0Array) ORDER BY post_thanks.username ASC;
MySQL Error : Unknown column '0Array' in 'where clause'
Error Number : 1054
And I do my research and fix this issue thanks to vbem2 (https://vborg.vbsupport.ru/member.php?u=231182) on his post here:
https://vborg.vbsupport.ru/showpost.php?p=2586995&postcount=2367
After I delete the product the table on database was deleted but I take a copy before 2 months so I don't care, and I reinstall it and restore that table alone on my database correctly and I see all rows
after that all old thanks didn't appears and all what I can do is just make new THANKS
Note that I do rebuild threads and forums from ADMINCP!
What I can do now so old THANKS can appears as usual?
Please advise.
--------------- Added 1513639630 at 1513639630 ---------------
Update