Woodsman Posted December 28, 2015 Author Posted December 28, 2015 What happens running the converter on an untouched database using utf8mb4 rather than utf8? Check this to see if it will recognize these characters. If this still acts the same then it should be reported as a bug under Bug Reports - Extras - Converters.
lordi Posted December 28, 2015 Posted December 28, 2015 hello, I try to upgrade my forum in localhost. everything seems find until I got this error on upgrade process : Table 'ipb.ipb_core_view_updates' doesn't exist C:\UniServerZ\www\community/applications/core/setup/upg_101019/queries.json - query #2 TRUNCATE `ipb_core_view_updates` any clue? How should I do? is it save to continue the upgrade?
Woodsman Posted December 28, 2015 Author Posted December 28, 2015 I have also received this message and it is due to the table not being there. Go ahead and hit continue and it will be created. The rest of the install should then be fine. On Wednesday, December 23, 2015 at 4:43 AM, Richard-023 said: Hello, I just upgraded our forum from 3.4.8 to 4.1.5.2. I did run the convert tool with succes, and then runned the GetReadyforips tool and everything whas green, so good to go. Removed all the old hooks, skin, language pack etc.. Then i uploaded everything and performed the upgrade, got 1 issue, ''Table 'nld_farmers_nl.nld_farmerscore_view_updates' doesn't exist /customers/7/0/5/nld-farmers.nl/httpd.www/applications/core/setup/upg_101019/queries.json - query #2 TRUNCATE `nld_farmerscore_view_updates`'' I hit the try again button same error come up. Then i hit the continue button en upgraded whas finished. Now i checked my forum and everything looks fine. All the Members, topics, downloads and gallery looks fine and everything is there. Now i would like to now if this error (issue) is okay or if there is gone something wrong and i need to do everything over.. I hope you understand (my english is not the best) and someone can reply. Kind regards, Richard SaltyBart 1
SecondSight Posted January 26, 2016 Posted January 26, 2016 Hello ! Can you tell me how I can check if the database conversion to UTF-8 worked ? I visited my web site's different topics to see if they loaded well and without any errors, I looked at the size of the database to see if it was about the same as before, and I ran a check in phpmyadmin. What else can I do ? Does IPB 3.4.9 have tools to check the conversion to UTF-8 and the upgrade to IPB 4 ? Thank you.
Woodsman Posted January 26, 2016 Author Posted January 26, 2016 In your database (2nd page usually) Find If you see these 2 tables you should be good to go.
Woodsman Posted January 26, 2016 Author Posted January 26, 2016 (edited) Duplicate Edited January 26, 2016 by Woodsman Duplicate
xplanedotorg Posted February 1, 2016 Posted February 1, 2016 (edited) Anyone have an idea on this one? Quote Table 'forum_test.ibf_cms_page_menu' doesn't exist /xxxxxx/test/httpdocs/system/Db/Select.php:402 SELECT * FROM `ibf_cms_page_menu` AS `cms_page_menu` I looked in /var/lib/mysql/test/ and that table does not exist. I'm trying to upgrade a 3.4.9 forum to the latest 4.1.7. Edited February 1, 2016 by xplanedotorg
ModSquadHockey Posted February 3, 2016 Posted February 3, 2016 (edited) I'm using MAMP on OSX. I exported the database and imported it locally. Created the same DB username and password as on my production forum. I then copied the entire /forums directory from my production site to my MAMP server's htdocs folder. I edited conf_global.php to change the board_url to "http://localhost/forums". I left the DB name, username and pass all the same as these didn't change. When I try to hit http://localhost/forums/admin/ (or just /forums/, or anything else) I get a 500 error. What am I missing or doing wrong? EDIT: I figured it out. Looks like MAMP was trying to use PHP 7.0.0 by default. Switched it to 5.6.10 and then it worked. Well, I at least got the database error... so that's a start. Edited February 3, 2016 by ModSquadHockey
Woodsman Posted February 4, 2016 Author Posted February 4, 2016 From others who have moved over to php 7 the consensus was favorable. It is possible it is just a fluke with Mamp. I really can't offer anymore on this not using the product. I am not sure if Wamp or Xampp are compatible with your system either. You say you received a database error. What was it? Are you now able to access the front end and admin panel?
Boomer12 Posted February 9, 2016 Posted February 9, 2016 (edited) Hi, do I need to convert it UTF-8 or UTF-8 MB4? Which is better? My board isn't that big, just 80 posts and a few threads... Edited February 9, 2016 by jacboy
Jirinex Posted February 13, 2016 Posted February 13, 2016 Hello, Maybe somebody can help me. We did the upgrade and everything went well, about an hour later (and with nothing changed from our side) all the css was gone and it's just loading in text mode. There are a lot of background processes still running, so I am not sure if I need to wait it out. Any ideas?
Boomer12 Posted February 13, 2016 Posted February 13, 2016 Could you please provide a link to your site?
Boomer12 Posted February 13, 2016 Posted February 13, 2016 Could you please provide a link to your site?
Daniel F Posted February 13, 2016 Posted February 13, 2016 5 hours ago, Jirinex said: Hello, Maybe somebody can help me. We did the upgrade and everything went well, about an hour later (and with nothing changed from our side) all the css was gone and it's just loading in text mode. There are a lot of background processes still running, so I am not sure if I need to wait it out. Any ideas? CSS Shouldn't be vanished while the background processes run. Please submit a ticket and i'll take a look media, Boomer12 and Woodsman 3
Woodsman Posted February 13, 2016 Author Posted February 13, 2016 I agree this is unusual and needs looking into.
Jirinex Posted February 13, 2016 Posted February 13, 2016 2 hours ago, Daniel F said: CSS Shouldn't be vanished while the background processes run. Please submit a ticket and i'll take a look Thanks, the ticket was created 8 hours ago
snodrog742 Posted February 23, 2016 Posted February 23, 2016 baseURL: "//teamuscellular.com/Forum2/", jsURL: "//teamuscellular.com/Forum2/applications/core/interface/js/js.php", I'm seeing this in my code and obviously throwing off my CSS and interface because missing "http:". Where would I edit this? I've looked in phpMyAdmin but can't find a thing
Brand Administrator Posted March 5, 2016 Posted March 5, 2016 Just did a clean install and now I am having trouble integrating the database. The install created new tables in the database but kept the old ones so I need to merge/integrate/convert the old tables into the new ones. Tried to do it through upgrade but that didn't work. Is there anything that I did wrong and is there a way to fix it?
P15-D24 Posted April 16, 2016 Posted April 16, 2016 Originally thought my issue was an 3 to 4 upgrade problem but when I back tracked today I discovered my local 3.X clone had the same issue. Running on MAMP, ioncube installed. To verify the environment I have both a vanilla 3.x and 4.x install running on the same server with no issues. Did a reinstall of my production system using the step by step instructions in this thread still end up with access to the ACP and the forum homepage, but when I try any forum I get "requested URL /test_p15d24ph_forum/forum/4-p15-d24-forum/ was not found on this server." I'm stumped at this point. I guess next try is re-download files from my production server and try again. Looking for suggestions.
P15-D24 Posted April 16, 2016 Posted April 16, 2016 Ok I identified the problem, hopefully someone can tell me how to fix it! For example the URL being requested is: http://localhost/test_p15d24ph_forum/forum/4-p15-d24-forum/ and it results in an error. However if I add index.php in the URL it works correctly for example: http://localhost/test_p15d24ph_forum/index.php/forum/4-p15-d24-forum/ I'm assuming this is a config issue somewhere so I hoping someone can get me pointed to the right file(s) for a fix.
P15-D24 Posted April 16, 2016 Posted April 16, 2016 One more bit of info. On my production system the URLs look like http://p15-d24.com/forum/4-p15-d24-forum/ so apparently I haven't set it up correctly for the local host correctly. Any suggestions?
P15-D24 Posted April 18, 2016 Posted April 18, 2016 Found it :-) I got rid of htaccess for local testing and still had on mod_rewrite in the Friendly URL features section. Setting mod_rewrite to no immediately fixed the issue. Hope this helps someone else! media 1
Woodsman Posted April 18, 2016 Author Posted April 18, 2016 Sorry I was gone for an extended weekend. Are you upgrading from 3.4 to 4.1.10? What browser are you using to test with? If you test with a different browser what happens? Are you using SSL? Please post a link or PM me with it. I had an issue after the 4.1.10 that gave me hell for a bit with old browser cache and cookies.
Recommended Posts