Originally Posted by chadi (Post 1568333)

I'm getting this error:


Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT g.dateline AS sonmesajtarih, g.gmid, s.description, g.pagetext, g.postuserid, g.postusername, s.groupid, s.dateline, s.name, s.lastposter, s.lastposterid, g.state, s.visible, s.lastgmid, s.lastpost, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM groupmessage AS g
LEFT JOIN socialgroup AS s ON (g.gmid = s.lastgmid)
LEFT JOIN user AS user ON(user.username = g.postusername)
WHERE g.state = 'visible' AND s.visible > '0'
ORDER BY g.dateline DESC
LIMIT 0, 10;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Sunday, July 6th 2008 @ 02:08:35 PM
Error Date : Sunday, July 6th 2008 @ 02:08:35 PM
Script : http://www.talkjesus.com/group.php
Referrer : http://www.talkjesus.com/
IP Address : *****
Username : Chad
Classname : vB_Database
MySQL Version : 5.0.51a-community

Originally Posted by MarkoP (Post 1619461)

I finally discovered why the pagination isn't working on my installation...

The paginated pages list like this:
http://www.mydomain.com/groups/index2.html

But they don't go to the next page.

They should list like this:
http://www.mydomain.com/groups/index-page2.html

I use VBSEO and that is probably causing the problem. Does anyone know what I need to modify to make the pagination work correctly?

I'll send you $100 by paypal if so....