If this is your first visit, check our documentation. To post, register or login.
Forums / Installing on a Linux/Unix Server / Moved to vps, transfered database, weird charitures in text and define pages editor..

Moved to vps, transfered database, weird charitures in text and define pages editor..

Started by itcetera on 11 Jan 2013, 5:41 PM · Views: 1,117

Results 1 to 9 of 9
11 Jan 2013, 5:41 PM
#1
itcetera avatar

itcetera

New Zenner

Join Date:
Nov 2010
Location:
Spokane Wa
Posts:
79
Plugin Contributions:
0

Moved to vps, transfered database, weird charitures in text and define pages editor..

I am new to using a VPS I have moved our sit to one and I am remodeling it. When I transferred the current data base over with myphpadmin. I now have weird charitures in the text here and there on the web pages, for example where a trademark should be. Also the define pages editor stopped working, when I activate the pull down list to edit a page no pages are listed.
I have installed ver 15.1 and updated the database after I moved it over from the current site which is ver 3h. Not quite sure how to approach this. I assume it has to do with the coding ( both are utf8). Not sure what is causing the problem with the define pages editor. Any suggestions would be appreciated. Site can be viewed at 50.63.134.98 new site(not set with DNS yet) and current site is Http://theelectricaldepot.com

Thank you.

11 Jan 2013, 10:18 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Moved to vps, transfered database, weird charitures in text and define pages editor..

for example where a trademark should be.
Are you using HTML escape characters for these?

Zen-Venom Get Bitten

12 Jan 2013, 2:21 AM
#3
itcetera avatar

itcetera

New Zenner

Join Date:
Nov 2010
Location:
Spokane Wa
Posts:
79
Plugin Contributions:
0

Re: Moved to vps, transfered database, weird charitures in text and define pages editor..

The original text was done with the html editor in zencart. I had the data base on my home pc testing upgrade and that is the one I used because the other kills the define pages editor so I didnt use the whole data base just what I needed to get catagories and products to work.

12 Jan 2013, 4:50 PM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Moved to vps, transfered database, weird charitures in text and define pages editor..

so I didnt use the whole data base
That is not the prescribed method

Zen-Venom Get Bitten

12 Jan 2013, 9:52 PM
#5
itcetera avatar

itcetera

New Zenner

Join Date:
Nov 2010
Location:
Spokane Wa
Posts:
79
Plugin Contributions:
0

Re: Moved to vps, transfered database, weird charitures in text and define pages editor..

The reason I did that was because there is something in the database that kills the define pages editor. I inported part at a time so site works has everything and the define pages editor works. The partial data base works fine on my server and on my pc at home. the text showed up when I uploaded the data base on about the third time to the server. If I knew how to fix the data base, I would. I realize that would be better. For now need to get rid of funny text. site is at 50.63.134.98 if you want to look. once I get this cleared up I assume I will have a good data base from that point on. Thanks

12 Jan 2013, 9:54 PM
#6
itcetera avatar

itcetera

New Zenner

Join Date:
Nov 2010
Location:
Spokane Wa
Posts:
79
Plugin Contributions:
0

Re: Moved to vps, transfered database, weird charitures in text and define pages editor..

PS The site has a full data base I only used part of the old one rest is part of the new install. I was not very clear on that:blush:

12 Jan 2013, 10:06 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Moved to vps, transfered database, weird charitures in text and define pages editor..

You've mixed up the character sets, probably by not telling it what character set to export to when taking the data from the old database.

So, you can either redo your export with right settings and import again, starting from scratch. It may require some trial-and-error experimentation on your part. Or you can manually fix all the damaged characters one-by-one.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

13 Jan 2013, 2:28 AM
#8
itcetera avatar

itcetera

New Zenner

Join Date:
Nov 2010
Location:
Spokane Wa
Posts:
79
Plugin Contributions:
0

Re: Moved to vps, transfered database, weird charitures in text and define pages editor..

I would love to do that, but I wouldnt know where to start with correcting the settings. So far I am getting some help and fixing each one. It may take a while but that should get me on the right page. But if you can give me an idea of how to reset everything I would love to do that and save myself a bunch of time. Thank you so much for responding.

18 Jan 2013, 11:00 PM
#9
itcetera avatar

itcetera

New Zenner

Join Date:
Nov 2010
Location:
Spokane Wa
Posts:
79
Plugin Contributions:
0

Re: Moved to vps, transfered database, weird charitures in text and define pages editor..

Well, final update: I went through each entry with the unwanted charitures in the back of the store. I found that all I had to do was open each on to edit then click update without making any changes. When the page updated
everything was corrected. We have about 1400 products so it took a few days working part time my wife and I to go through it all. Alot of work but I know I now have a clean data base. Thanks to those who helped:smile: