Witam przekonwentowałem dzisiaj forum z Phpbb przemo do vB 3.6.8.Na oko wszystko działa.. ale mi jako adminowi nie zliczyło postów.. w profilu... oprócz tego po kliknięciu w:
Kod php:
Znajdź wszystkie posty, których autorem jest DANY UZYTKOWNIK
wyskakuje:
Database error
The Forums database has encountered a problem.
Please try the following:
* Load the page again by clicking the Refresh button in your web browser.
* Open the globalsat.nazwa.pl home page, then try to open another page.
* Click the Back button to try another link.
The globalsat.nazwa.pl forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
Kod:
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT post.postid, post.title AS posttitle, post.dateline AS postdateline,
post.iconid AS posticonid, post.pagetext, post.visible, post.attach,
IF(post.userid = 0, post.username, user.username) AS username,
thread.threadid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.replycount,
IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.firstpostid,
thread.pollid, thread.sticky, thread.open, thread.lastpost, thread.forumid, thread.visible AS thread_visible,
user.userid
,pdeletionlog.userid AS pdel_userid, pdeletionlog.username AS pdel_username, pdeletionlog.reason AS pdel_reason
,tdeletionlog.userid AS tdel_userid, tdeletionlog.username AS tdel_username, tdeletionlog.reason AS tdel_reason
FROM post AS post
INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
LEFT JOIN deletionlog AS tdeletionlog ON(thread.threadid = tdeletionlog.primaryid AND tdeletionlog.type = 'thread')
LEFT JOIN deletionlog AS pdeletionlog ON(post.postid = pdeletionlog.primaryid AND pdeletionlog.type = 'post')
LEFT JOIN user AS user ON(user.userid = post.userid)
WHERE post.postid IN(7415, 14756, 14649, 14641, 14621, 14587, 14586, 14582);
MySQL Error : Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'if'
Error Number : 1267
Date : Monday, May 19th 2008 @ 06:22:47 PM
Script : http://globalsat.nazwa.pl/sat/search.php?searchid=28
Referrer : http://globalsat.nazwa.pl/sat/member.php?find=lastposter&f=37
IP Address : 83.22.75.169
Username : Black_Tabus
Classname : vb_database
co z tym zrobic? z góry dziekuje za odpowiedź