WebsiteBaker Support (2.12.x) > General Help & Support
Strange characters after upgrade from 2.8.3 to 2.12.1
Gast:
--- Quote ---ALL my tables have the wb_ prefix. Does that mean that I have to delete ALL my tables before I import the converted DB?
--- End quote ---
YES, thats correct - delete then all tables in this database.
P.S.: if i need a test in a subfolder, i use often the same databese, but different prefix. Other customers / users have only one database, but different installations, maybe also different CMS - thats why, i say: delete (only) the tables with this prefix, in your case, prefix "wb_"
svsanchez:
BAD NEWS!
Unfortunately, after deleting the tables and importing the converted DB, the site broke:
First, there was a message "There was an uncatched exception: CAPTCHA-Settings not found" but I was able to fix that thanks to your SQL injection solution provided here: https://forum.WebsiteBaker.org/index.php?topic=29275.0
Once that worked, I could see that the strange characters were gone, but the whole site wasn't working anymore as it should:
1) The [MINICART] didn't show the minicart, instead it shows the text [MINICART]
2) There was an error saying that the column "ORDER" didn't exist
3) For some reason the site was all messed up, showing things in places it wasn't supposed to, as if the template was messed up!
I had to restore my DB backup and the site is working again, BUT the strange characters are back :-(
svsanchez:
So, since I had offered to have this fixed by today, I tried doing the following via phpMyAdmin:
UPDATE wb_mod_bakery_items SET title = REPLACE(title, 'á', 'á');
UPDATE wb_mod_bakery_items SET title = REPLACE(title, 'é', 'é');
UPDATE wb_mod_bakery_items SET title = REPLACE(title, 'Ã', 'í');
UPDATE wb_mod_bakery_items SET title = REPLACE(title, 'ó', 'ó');
UPDATE wb_mod_bakery_items SET title = REPLACE(title, 'ú', 'ú');
UPDATE wb_mod_bakery_items SET title = REPLACE(title, 'ñ', 'ñ');
UPDATE wb_mod_bakery_items SET title = REPLACE(title, '®', '©');
UPDATE wb_mod_bakery_items SET title = REPLACE(title, '®', '©');
Then I repeated the same commands but used "description" instead of "title".
This allowed me to change the name and description of the products in the Bakery store, however when I go a product's page, the page's <title> is still showing with the strange character. I searched on the different wb_mod_bakery tables but couldn't find where it's taking the <title> tag content?
Gast:
--- Quote from: svsanchez on March 20, 2019, 09:23:04 AM ---There was an uncatched exception: CAPTCHA-Settings not found
--- End quote ---
correct!
if there is no table for the captcha-module inside the backup, the converter cannot build this
--- Quote from: svsanchez on March 20, 2019, 09:23:04 AM ---Hello!
I just upgraded www.distribuidoraal cance.com from version 2.8.3 rev 1645 to 2.12.1 and the upgrade went very well, BUT we are having a problem with strange characters in some of the pages names and on Bakery products:
--- End quote ---
and why did you send me the backup from the old WB 1611??
the backup was for WB 1611, of course, you run in problems, if you use this in WB 2.12.1 :-o :-o
to make it short..... ask me never again for a help. if it's not possible, to send me the complete package (files & database-backup). it make's only trouble for everyone, if it's not possible to test it. trouble for nothing........... :evil: :evil: :evil:
The user from the thread about the WB 2.6.7 version send's me the complete project and has two hours later the latest upgrade finish, wb works, template and something more is repaired - and everybody is happy. - that's the right way
svsanchez:
Mein Gott!!! :-o
I'm so sorry for that, I really didn't think about it, I didn't think about making a new backup after I upgraded to 2.12.1 until I imported the file you sent me! Lesson learned! (But why were the strange characters also in the WB 1611 version?)
So sorry to have bothered you for nothing Jacobi, I hope you can help me converting the right file if I send it to you by mail :-D
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version