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 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? 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. 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 Link to comment https://forums.phpfreaks.com/topic/167355-error-on-pages/#findComment-882473 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.