I am moving my website to a virtual private server from a shared hosting account. I had to import the database bit by bit. My hit statistics table is very big and when I import it alone I get the following error:
Error
Static analysis:
2 errors were found during analysis.
Variable name was expected. (near "<" at position 54)
Unrecognized statement type. (near "div" at position 1)
SQL query:
<div class="error"><h1>Error</h1><p><strong>SQL query:</strong> <a href="db_sql.php?sql_query=SET+time_zone+%3D+%22SYSTEM%22&show_query=1&db=retinagallery_main"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> 
MySQL said: Documentation
#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 '<div class="error"><h1>Error</h1><p><strong>SQL query:</strong>
<a href="db_sql.' at line 1
My website is:
retinagallery.com
(If you look at it there is clearly another problem but I'll post that separately)
I appreciate any help.
Thanks,
Steve
There seems to be a problem with the table data that you are trying to import. You can scan down the file to see if you can see where the data inserts are mucked and try to correct it. Or you can just have an empty table and let new statistics evolve.
I emptied the hit statistics table. The website is still showing the number of views for each file.
I have another problem with the website after migration. I'm going to start a new thread for that.
Thanks,
Steve
Statistics and view counts are mostly separate. You can turn off keeping statistics tables in the config.