Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

site transfer


brimasta

Recommended Posts

I am currently having our site hosted free by 000webhost but unfortunately the free hosting does not support ssl certificates and therefore i have had to upgrade my subscription, yet again, unfortunately i cannot transfer my free domain over to the premium hosting site even though the premium site owns and runs the free site. so they registered me a free domain and here is the problem, i am really struggling to upload the database and i keep getting the following error.......

 

 

"localhost

Error

There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:

----BEGIN CUT----

eNoBFATr+0VSUk9SOiBDMSBDMiBMRU46IDMgNCA1NTYKU1RSOiADCgpTVk46ICRJZCQKTXlTUUw6

IDUuMC45Mi1jb21tdW5pdHkKVVNSIE9TLCBBR0VOVCwgVkVSOiBXaW4gTU9aSUxMQSA1LjAKUE1B

OiAzLjMuMTAuMgpQSFAgVkVSLE9TOiA1LjIuOSBMaW51eApMQU5HOiBlbi11dGYtOApTUUw6IApQ

SwMEFAAAAAgAEUr2Jmd0O69/gcQkKAIANU4OABMAAABhMjY2Mzg5Nl9teXNxbDguc3Fs5L3tduJI

0jD4f65C5zkzj6veU3ahlITA8/S8gzG26cI2Criqq/bdQwsQRm1AjCTscv/cW9m/+2dvYfdO9ko2

IyZxdW90OyUkIexMhLvm3Z3To3YDGYqMjIzvjCZsdDsmZ3Q71laz1fVzY7Lwllr/l452vl6s/nJ8

rD26Qej5S42d6PqJCZ/Momh1+vHj09PTCR+zeHZgzMnSjfiX8P2VH0an2twfO/MZ/xMmZ3Q7unSX

buBEAGfgLdxT7ef1XGPsg8Yquq45kVapn+pVrXEKP+67AX9p/OJTzTrRTywbvuledbXPm485SvZf

/tJvCgDh4fXteeun/7i5HTbuBrfDz43OXWt4ezP81urd/sff/yZxdW90O3A7dyZxdW90O2fkhByD

3xxWrRq1enW4eA7/Na/9Br+Anxzv+b/4FQNnNHe1MArW42gduNrUD7QIP/vNmUwCNwyHI99/oPc1

e63GoKUKGmedVu577d1ftOxHQ2/ym+Yto3e6/l67uR1oN3edjobTbd9wSNetm8EHGDReh5G/4IQq

HIE/cZdR8CZsdDu8d5cTN/hNG8+c4B3/SfO20wF85nytljp8zZdtJmd0Oxx7RYPH/mLlLJ9/0x6d

AAEY7CUI562Lxl1nC8rUC8Jo6SxcWTgFmMyd0iD4erluNBTk3gCqmqqA1qN1MCpJlBXfN2N/kpqQ

XlFdHS+SXppCejiRND13zGLsr/HfhWwbjzmqHKWG/OEvXanfd3vt60bvq/ap9VV7t7VL3sNP4Kvf

vMn3Yebb7N54l90r7//yXmvdXLZvWj9dP7f7jWsteW/zqtHjouYnmn1MjJ+2iZHdjz/pTNtIHy5T

veW9NuFS6GW50L7pt3oDrX0zuM2LBZRs/XfVDxr/5+joA1FdOxoFnrMEWTrj0+EfH4WR++guQ/hT

10aBM+FvnGiRGwTOGH/QmfPtu3heuuMZ/v6ZMa3qzuFvP3xy+ZZ4hr9X/tMzQGEgsCvv/y6BnPlB

MzPIXTtRNHOfANwVZwo3gL8uOPG0Op+HduMmZ3Q7addOEGnducAK/t+60k1NH/yKf0+8Jd9Y94jp

tTeZ+9GMz1cKLV3/oMH/U4gF3vgBZ/m7OzqD8lk=

----END CUT----

----BEGIN RAW----

 

ERROR: C1 C2 LEN: 3 4 556

STR:

 

SVN: $Id$

MySQL: 5.0.92-community

USR OS, AGENT, VER: Win MOZILLA 5.0

PMA: 3.3.10.2

PHP VER,OS: 5.2.9 Linux

LANG: en-utf-8

SQL:

PKJ>$(5Na2663896_mysql8.sqlvH0B93Sv16

CFm@$r[ٿgoaNJ6#"%$!Lݝӣv<>VscZv^r|=AK ̢hu xv`ҍF;>tnDg-S\c*9VUq

?iS:O,^uϛ9J_o

y6ύ]kx{3"p;w"gVzux5g4w0

h?͙L7#5{Ơ

gV{_GCo-w^h7wmpH׭4^*?qQ<w7MϜI||:|͗m>{Eb,%筋]gh,\Y8̝ zn4֣u0*I7c^Q]/^Bz84=wb߅l9/]w{FU{KO߼ax+^k\oZ?]?k-yo'}Lݏ?LH.S6Reоz}3͋lwQ];Y:.CSF3ohЙx^1o?|rxW3@a +.A33];Q4sg

7.8:v>iNiݹ

ߺMMO%X7ьW

-]Sg;

 

----END RAW----

 

SQL query:

 

PKJ>$(5Na2663896_mysql8.sqlvH0B93Sv16 CFm@$r[ٿgoaNJ6#"%$!Lݝӣv<>VscZv^r|=AK ̢hu xv`ҍF;>tnDg-S\c*9VUq ?iS:O,^uϛ9J_o y6ύ]kx{3"p;w"gVzux5g4w0 h?͙L7#5{Ơ gV{_GCo-w^h7wmpH׭4^*?qQ<w7MϜI||:|͗m>{Eb,%筋]gh,\Y8̝ zn4֣u0*I7c^Q]/^Bz84=wb߅l9/]w{FU{KO߼ax+^k\oZ?]?k-yo'}Lݏ?LH.S6Reоz}3͋lwQ];Y:.CSF3ohЙx^1o?|rxW3@a +.A33];Q4sg 7.8:v>iNiݹ ߺMMO%X7ьW -]Sg;

 

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 'PK' at line 1"

 

the hosting company cant/wont help, can one of my fellow os commerce compatriots please tell me where i am going wrong?

kind regards, Brian

Link to comment
Share on other sites

It looks like you are trying to upload something that is not valid. What program are you using to do the upload? Where did you get the database file you are trying to upload?

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

It looks like you are trying to upload something that is not valid. What program are you using to do the upload? Where did you get the database file you are trying to upload?

Thanks for the reply....

I tried the upload through php my admin and as for the database, it is a downloaded zipped backup of the database for my existing site. I made the database backup through php my admin on the free hosting site. I know I am no web guru or anything but this has got me feeling very thick indeed.

Link to comment
Share on other sites

Thanks for the reply....

I tried the upload through php my admin and as for the database, it is a downloaded zipped backup of the database for my existing site. I made the database backup through php my admin on the free hosting site. I know I am no web guru or anything but this has got me feeling very thick indeed.

Would you flippin believe it???!!!

my new hosting site has made the transfer for me now, after about 30 tickets with the helpdesk regarding uploading my old site site, they finaly said " if you give us the details about your account, we will do it for you"

so its all done now, but thank you for helping.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...