Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

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

0 Members and 1 Guest are viewing this topic.

scohen125

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 100
    • 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

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 2026
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 frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 100
    • 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

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 2026
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.019 seconds with 20 queries.