WebsiteBaker Support (2.12.x) > General Help & Support

Upgrading to 12.2.2 from 2.8.3

<< < (5/6) > >>

hgs:
In addition to the Post from dbs still the reference:
The "SuperAdmin" is entered in the DB with the used name during the first installation and can only occur once.
It is amazing that you could simply change the entry in the DB as user-id 1, this can only work if this user-id did not (no longer) exist in the table "wb_users".
A second user-id 1 would not be accepted by the DB.

svsanchez:
Hello hgs, regarding this:


--- Quote from: hgs on March 03, 2020, 08:10:52 AM ---In addition to the Post from dbs still the reference:
The "SuperAdmin" is entered in the DB with the used name during the first installation and can only occur once.
It is amazing that you could simply change the entry in the DB as user-id 1, this can only work if this user-id did not (no longer) exist in the table "wb_users".
A second user-id 1 would not be accepted by the DB.

--- End quote ---

You are correct, there was no user with ID=1 in the DB, it's a very old site so maybe I removed it for some reason and forgot overtime!

Lucky me it all worked after that  :-)

svsanchez:
Hello guys, hope everybody is doing fine during this difficult time.

While on lockdown, I thought it would be a good time to upgrade my biggest site made with WB from 2.8.3 to 2.12, so the first thing I did was install a copy of the site on another domain to test. The upgrade script went ALMOST perfectly, but now I'm facing two problems:

1) The most pressing problem is that when I click on PAGES in the backend, I get an INTERNAL SERVER ERROR. All other parts of the admin seem to work fine (haven't tried to install / uninstall modules). The site itself works albeit a little slow.

2) The second problem I had it with my previous upgrades: accented characters get messed up during the upgrade, and would like to know if there's a link with instructions to prevent this from happening, so that when I upgrade the real site I won't have the same problem.

Thank you and stay safe everyone!

hgs:
Look here
https://forum.WebsiteBaker.org/index.php/topic,30402.msg212078.html#msg212078

svsanchez:
Hello everybody.

Regarding #1, my host said the request was too big so they increased the memory limit and this solved the Internal Server Error.

Regarding #2, I went to the link you suggested HGS, but didn't understand how to convert the DB so that it won't mess up the accented characters after upgrading. So, I had to run quite a few SQL commands in phpMyAdmin to solve the mess. Here are some of the commads I ran in case anybody else runs into the same problem (only for the pages, you have check every module and change the commands to the appropriate tables and columns)

UPDATE wb_pages
SET menu_title = Replace(menu_title, 'á', 'á');

UPDATE wb_pages
SET menu_title = Replace(menu_title, 'í', 'í');

UPDATE wb_pages
SET menu_title = Replace(menu_title, 'ó', 'ó');

UPDATE wb_pages
SET menu_title = Replace(menu_title, 'é', 'é');

UPDATE wb_pages
SET menu_title = Replace(menu_title, 'ú', 'ú');

UPDATE wb_pages
SET menu_title = Replace(menu_title, 'ñ', 'ñ');

UPDATE wb_pages
SET menu_title = Replace(menu_title, 'Á', 'Á');

UPDATE wb_pages
SET menu_title = Replace(menu_title, 'É', 'É');

UPDATE wb_pages
SET menu_title = Replace(menu_title, 'Ú', 'Ú');

UPDATE wb_pages
SET menu_title = Replace(menu_title, '¿', '¿');



***

UPDATE wb_pages
SET page_title = Replace(page_title, 'á', 'á');

UPDATE wb_pages
SET page_title = Replace(page_title, 'é', 'é');

UPDATE wb_pages
SET page_title = Replace(page_title, 'í', 'í');

UPDATE wb_pages
SET page_title = Replace(page_title, 'ó', 'ó');

UPDATE wb_pages
SET page_title = Replace(page_title, 'ú', 'ú');

UPDATE wb_pages
SET page_title = Replace(page_title, 'ñ', 'ñ');

UPDATE wb_pages
SET page_title = Replace(page_title, 'Á', 'Á');

UPDATE wb_pages
SET page_title = Replace(page_title, 'É', 'É');

UPDATE wb_pages
SET page_title = Replace(page_title, 'Ú', 'Ú');

UPDATE wb_pages
SET page_title = Replace(page_title, '¿', '¿');


***

UPDATE wb_pages
SET description = Replace(description, 'á', 'á');

UPDATE wb_pages
SET description = Replace(description, 'é', 'é');

UPDATE wb_pages
SET description = Replace(description, 'í', 'í');

UPDATE wb_pages
SET description = Replace(description, 'ó', 'ó');

UPDATE wb_pages
SET description = Replace(description, 'ú', 'ú');

UPDATE wb_pages
SET description = Replace(description, 'ñ', 'ñ');

UPDATE wb_pages
SET description = Replace(description, 'Á', 'Á');

UPDATE wb_pages
SET description = Replace(description, 'É', 'É');

UPDATE wb_pages
SET description = Replace(description, 'Ú', 'Ú');

UPDATE wb_pages
SET description = Replace(description, '¿', '¿');

Navigation

[0] Message Index

[#] Next page

[*] Previous page