Guest Posted January 15, 2005 Share Posted January 15, 2005 Hello, First off, I thank everyone for taking time in reading my post. People at this forum are freindly. Let me describe to you what has happened. My freind had to move his website from one host to another. I downloaded all his files and uploaded them to another server. I copied the data structer including the data of the mysql database and put it up on the new server. Everything is the same (config file, db connections- they are all fine) but except when i go to the main page i get this error: 1064 - 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 'MAX_RANDOM_SELECT_NEW' at line 1 select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit MAX_RANDOM_SELECT_NEW [TEP STOP] I have never encoutered this error before, I dont know what it is and I dont know how to fix it. I am a total new b to oscommerce and have searched this forum alot for this help but couldnt find any or maybe i just couldnt understand :(. Thank you in advance for your help. Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.