Alon Jacobi Posted February 9 Share Posted February 9 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 Link to comment Share on other sites More sharing options...
Afrodude Posted February 9 Share Posted February 9 (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 by Afrodude Link to comment Share on other sites More sharing options...
Marc Stridgen Posted February 9 Share Posted February 9 Indeed as mentioned below, you would be best to remove tapatalk entirely before you proceed. You would need a new version of tapatalk anyway Link to comment Share on other sites More sharing options...
Alon Jacobi Posted February 9 Author Share Posted February 9 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? Link to comment Share on other sites More sharing options...
Jim M Posted February 9 Share Posted February 9 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. Link to comment Share on other sites More sharing options...
Alon Jacobi Posted February 9 Author Share Posted February 9 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} Link to comment Share on other sites More sharing options...
Jim M Posted February 9 Share Posted February 9 Please ensure that you're not missing any files there. Looks like something may be missing. Link to comment Share on other sites More sharing options...
Alon Jacobi Posted February 9 Author Share Posted February 9 Which file? the capcha.php file seems to be there. Link to comment Share on other sites More sharing options...
Jim M Posted February 9 Share Posted February 9 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. Link to comment Share on other sites More sharing options...
Alon Jacobi Posted February 9 Author Share Posted February 9 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? Link to comment Share on other sites More sharing options...
Jim M Posted February 9 Share Posted February 9 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. Link to comment Share on other sites More sharing options...
Alon Jacobi Posted February 9 Author Share Posted February 9 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? Link to comment Share on other sites More sharing options...
Alon Jacobi Posted February 9 Author Share Posted February 9 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? Link to comment Share on other sites More sharing options...
Jim M Posted February 9 Share Posted February 9 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. Link to comment Share on other sites More sharing options...
Alon Jacobi Posted February 10 Author Share Posted February 10 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. Link to comment Share on other sites More sharing options...
Jim M Posted February 10 Share Posted February 10 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 . Link to comment Share on other sites More sharing options...
Alon Jacobi Posted February 10 Author Share Posted February 10 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. Link to comment Share on other sites More sharing options...
Solution Alon Jacobi Posted February 10 Author Solution Share Posted February 10 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 Stridgen 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted February 10 Share Posted February 10 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. Link to comment Share on other sites More sharing options...
Recommended Posts