The Forums database has encountered a problem
The Forums database has encountered a problem
t3qil4all - 05-19-2008 06:23 PM
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:
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.
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ź
WoG - 05-19-2008 08:39 PM
MySQL Error : Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'if'
Error Number : 1267
Mamy tutaj problem z błędnym połączeniem systemem rozpoznawania znaków.
A wziąłeś najpierw odchudziłeś phpby przemo od wersji phpbb?
Jeśli potrzebujesz pomocy - mogę zaoferować swoją prywatną pomoc :)
t3qil4all - 05-20-2008 07:53 AM
witam a ile kosztowała by panska pomoc?? moge wydać 15pln jesli miesci sie w tym zakresie to prosze o kontakt na gg: 9062402