PhotoPost Community - View Single Post

gotvenm · July 1st, 2005, 08:32 PM

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

July 1st, 2005, 08:32 PM	#1 (permalink)
gotvenm Member Verified Customer Join Date: Mar 2004 Posts: 30	moved to new server, have issues 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