tomms
05-01-2008, 02:35 PM
im having an SQL error on my home page
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 'ASC limit 0,1' at line 1
the rest of the site works fine, for example
http://www.blursurfing.com/index.php?showimage=7
will show the corresponding image
This was a fresh install about a month ago. I should also note that i have not gone live with my blog yet, im still doing testing. So it would not be a big deal to reinstall the whole thing. However i would feel a lot better if i could solve the problem in case it should happen again.
i have searched the forums, and looked in my database (pixelpost_visitors) for any refferer errors. Also of note is that this happened on the 1st of the month when the stats are supposed to be dumped.
where do i go from here?
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 'ASC limit 0,1' at line 1
the rest of the site works fine, for example
http://www.blursurfing.com/index.php?showimage=7
will show the corresponding image
This was a fresh install about a month ago. I should also note that i have not gone live with my blog yet, im still doing testing. So it would not be a big deal to reinstall the whole thing. However i would feel a lot better if i could solve the problem in case it should happen again.
i have searched the forums, and looked in my database (pixelpost_visitors) for any refferer errors. Also of note is that this happened on the 1st of the month when the stats are supposed to be dumped.
where do i go from here?