Alon Jacobi Posted February 9, 2023 Posted February 9, 2023 Hi, I have a very old 3.X board I am desperately trying to upgrade to 4.7.6. I have followed the instructions in the upgrade guide, copied the new files over the old ones, changed the PHP version to 8.0 and attempted the upgrade. During the conversion to UTF8 phase it gets stuck on a table called "tapatalk_push_data" at 83.97% and get stuck there forever. if I try to refresh the page or resume the conversion, I get an error message saying "Error: Invalid default value for 'updated' File: /system/Db/Db.php Line: 198" Any help here would be appreciated. Thanks Alon Jacobi
Afrodude Posted February 9, 2023 Posted February 9, 2023 (edited) Tapatalk is not a part of IPS system, so you may delete the application along with any tapatalk database tables. Then try to update again. If you want to install it later, you must install the one that compatible with IPS 4.7.7. IPBoard - Download and Install | Tapatalk Edited February 9, 2023 by Afrodude
Marc Posted February 9, 2023 Posted February 9, 2023 Indeed as mentioned below, you would be best to remove tapatalk entirely before you proceed. You would need a new version of tapatalk anyway
Alon Jacobi Posted February 9, 2023 Author Posted February 9, 2023 removing Tapatalk -> delete the mobiquo folder and delete the two tapatalk tables from the DB? Also - would upgrade work if I just take the fresh code of 4.7.6 (not copy over the old folder) and just copy over the conf_global file for the configuration? I know I would lose any add-ons, smileys and such, but I would retain all the DB data?
Jim M Posted February 9, 2023 Posted February 9, 2023 28 minutes ago, Alon Jacobi said: removing Tapatalk -> delete the mobiquo folder and delete the two tapatalk tables from the DB? Also - would upgrade work if I just take the fresh code of 4.7.6 (not copy over the old folder) and just copy over the conf_global file for the configuration? I know I would lose any add-ons, smileys and such, but I would retain all the I would recommend reaching out to Tapatalk for the best way of uninstalling. As it is their application, they are the best source. I can’t remember if it had an ACP component in version 3 so if it did, you’ll want to remove anything there too. Right now, you are getting stuck on a database conversion to UTF8 so nothing in the folder is preventing this from working so I would not go that far yet. However, you only need the database to perform an upgrade. That will carry all your data.
Alon Jacobi Posted February 9, 2023 Author Posted February 9, 2023 Thank you all for your advice. It has worked and I was able to bypass the conversion stage and finish the upgrade. However, after the upgrade I am not able to log in. When I try to click on sign in I get the following error I could not find in the admin CP support tool anything to restore the default theme or anything. This is what I am seeing in the logs: Error: Class "\IPS\Helpers\Form\Captcha\Default" not found in /home/techstu2/public_html/ipb_qa/system/Helpers/Form/Captcha.php:43 Stack trace: #0 /home/techstu2/public_html/ipb_qa/system/Theme/Theme.php(885) : eval()'d code(807): IPS\Helpers\Form\_Captcha::supportsModal() #1 /home/techstu2/public_html/ipb_qa/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_forums_front_topics->post(Object(IPS\forums\Topic), Object(IPS\forums\Topic\Post), 'topic_comment', 'forums', 'forums', 'forums_Topic') #2 /home/techstu2/public_html/ipb_qa/system/Theme/Theme.php(885) : eval()'d code(2654): IPS\Theme\_SandboxedTemplate->__call('post', Array) #3 /home/techstu2/public_html/ipb_qa/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_forums_front_topics->postContainer(Object(IPS\forums\Topic), Object(IPS\forums\Topic\Post), Array, '') #4 /home/techstu2/public_html/ipb_qa/system/Theme/Theme.php(885) : eval()'d code(5101): IPS\Theme\_SandboxedTemplate->__call('postContainer', Array) #5 /home/techstu2/public_html/ipb_qa/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_forums_front_topics->topic(Object(IPS\forums\Topic), Array, NULL, Array, NULL, NULL, Array) #6 /home/techstu2/public_html/ipb_qa/applications/forums/modules/front/forums/topic.php(576): IPS\Theme\_SandboxedTemplate->__call('topic', Array) #7 /home/techstu2/public_html/ipb_qa/system/Dispatcher/Controller.php(118): IPS\forums\modules\front\forums\_topic->manage() #8 /home/techstu2/public_html/ipb_qa/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute() #9 /home/techstu2/public_html/ipb_qa/applications/forums/modules/front/forums/topic.php(39): IPS\Content\_Controller->execute() #10 /home/techstu2/public_html/ipb_qa/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\front\forums\_topic->execute() #11 /home/techstu2/public_html/ipb_qa/index.php(13): IPS\_Dispatcher->run() #12 {main}
Jim M Posted February 9, 2023 Posted February 9, 2023 Please ensure that you're not missing any files there. Looks like something may be missing.
Alon Jacobi Posted February 9, 2023 Author Posted February 9, 2023 Which file? the capcha.php file seems to be there.
Jim M Posted February 9, 2023 Posted February 9, 2023 3 minutes ago, Alon Jacobi said: Which file? the capcha.php file seems to be there. I would recommend uploading the full package because if you’re missing 1 odds are you could be missing several.
Alon Jacobi Posted February 9, 2023 Author Posted February 9, 2023 But I do not see that I am missing any files. When I upgraded I extracted the entire zip file over the old directory of the forum. Which file seems to be missing from this error?
Jim M Posted February 9, 2023 Posted February 9, 2023 11 minutes ago, Alon Jacobi said: But I do not see that I am missing any files. When I upgraded I extracted the entire zip file over the old directory of the forum. Which file seems to be missing from this error? Unfortunately the error means that the class mentioned there cannot be reached, thus a file is missing. You are missing files from the latest release, not your version 3 Community.
Alon Jacobi Posted February 9, 2023 Author Posted February 9, 2023 As far as I can tell I copied over the entire thing though, I am not sure what I should be doing differently. How can I know which file exactly is supposedly missing?
Alon Jacobi Posted February 9, 2023 Author Posted February 9, 2023 I did a full file text search for "IPS\Helpers\Form\Captcha\Default" on the contents of all files in the 4.7.6 directory and I could not find any references to it. Can this be something coming from the DB? looking at the core_themes table I see the following: maybe this key "default" there is what it is looking for?
Jim M Posted February 9, 2023 Posted February 9, 2023 22 minutes ago, Alon Jacobi said: did a full file text search for "IPS\Helpers\Form\Captcha\Default" on the contents of all files in the 4.7.6 directory and I could not find any references to it. Please upload a fresh copy of files from the Client Area. Either something failed or otherwise. This is not from the database.
Alon Jacobi Posted February 10, 2023 Author Posted February 10, 2023 Ok here is exactly what I have done now step by step. 1. I downloaded a fresh copy of the files from my client area (version 4.7.7 now). 2. I copied the zip file over the public_html folder of my server. 3. I extracted the contents of the zip file 4. I entered the folder it created, selected all the files and folders within and copied them over to my forum directory. I refreshed my site and tried to log in, got the same error now.
Jim M Posted February 10, 2023 Posted February 10, 2023 Did you extract and overwrite with the contents of the “ips_****” folder? If you did not do that, then that was not done correctly. If you were previously on 4.7.6, you’ll also need to run the upgrader at /admin/upgrade .
Alon Jacobi Posted February 10, 2023 Author Posted February 10, 2023 Yes, when I extracted I got a folder named ips_c4f41. I went into it, selected all and copied into my forum folder. Before doing that I did try the auto-upgrade from 4.7.6 in the admin CP so my forum did do the upgrade process from 4.7.6 to 4.7.7.
Solution Alon Jacobi Posted February 10, 2023 Author Solution Posted February 10, 2023 I think I managed to fix the issue by going into the capcha settings and updating them. That seems to have reset the issue. Marc and Connor T 2
Marc Posted February 10, 2023 Posted February 10, 2023 Glad to hear you got to the bottom of the problem there. I suspect you may have been using the old recaptcha 1 which was removed by recaptcha quite some time ago.
Recommended Posts