moved to new server, have issues

[gotvenm]

Moved my vbb 3.03, pp4.8, rp 2.9, and classifieds 202 to a new server.
all were integrated using the vbb users login.

new server is running mysql 4.1.11 and php 5.04

vbb seems to work fine, but when the photopost, classifieds or reviewpost is used I get mysql error:

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY styleid ASC
LIMIT 1' at line 4

mysql error number: 1064

any ideas ?

Thanks

[gotvenm]

turns out the error is vbb related. it didnt take well to the newer mysql version.