Guruweb Posted July 25, 2009 Share Posted July 25, 2009 I'm trying to install a site that i owned and recently decided to start up again. When i closed the site everything was working fine. When installing it i got an error on all of the pages. Its been about 2 years since i had the site up , so im thinking it is a database version problem (no idea). We have tried using a new database from the original script then using it for our design and we get the same error. The database works fine with their design , not ours. 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 'out) as tout from hl_traffic where listing_id = 1 and date + interval 7 day > no' at line 1 All we get is this error , nothing else shows. Here is the version. phpMyAdmin - 2.11.9.5 * MySQL client version: 5.0.81 Quote Link to comment https://forums.phpfreaks.com/topic/167355-error-on-pages/ Share on other sites More sharing options...
xtopolis Posted July 25, 2009 Share Posted July 25, 2009 What's the rest of that query look like? Quote Link to comment https://forums.phpfreaks.com/topic/167355-error-on-pages/#findComment-882470 Share on other sites More sharing options...
Third_Degree Posted July 25, 2009 Share Posted July 25, 2009 Yeah, just looks like a quotes issue ', `, " or something. Just show us the full query and I'm sure someone will help you out. Quote Link to comment https://forums.phpfreaks.com/topic/167355-error-on-pages/#findComment-882471 Share on other sites More sharing options...
PFMaBiSmAd Posted July 25, 2009 Share Posted July 25, 2009 http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html Quote Link to comment https://forums.phpfreaks.com/topic/167355-error-on-pages/#findComment-882473 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.