Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: migrating to new host - trouble with hit statistics table  (Read 1187 times)

0 Members and 1 Guest are viewing this topic.

scohen125

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 98
    • Retina Gallery
migrating to new host - trouble with hit statistics table
« on: October 15, 2019, 02:34:22 pm »

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&amp;show_query=1&amp;db=retinagallery_main"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" />&nbsp

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
Logged

ron4mac

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Posts: 1342
Re: migrating to new host - trouble with hit statistics table
« Reply #1 on: October 15, 2019, 04:13:04 pm »

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.
Logged

scohen125

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 98
    • Retina Gallery
Re: migrating to new host - trouble with hit statistics table
« Reply #2 on: October 15, 2019, 04:24:15 pm »

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
Logged

ron4mac

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Posts: 1342
Re: migrating to new host - trouble with hit statistics table
« Reply #3 on: October 15, 2019, 04:32:21 pm »

Statistics and view counts are mostly separate. You can turn off keeping statistics tables in the config.
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 21 queries.