Woodsman Posted June 27, 2016 Author Share Posted June 27, 2016 8 minutes ago, russur said: Thank you, I`ll do it when I get access to phpmyadmin. Now I can`t open phpmyadmin and my community site because of 502 and 504 error At this point it sounds more like a sever issue getting the same errors Link to comment Share on other sites More sharing options...
russur Posted June 27, 2016 Share Posted June 27, 2016 4 minutes ago, Woodsman said: At this point it sounds more like a sever issue getting the same errors Yes, it is server issue, but server is busy because of some big queries from ip.board software (wrote about it on previous page). Maybe it is rebuilding indexes... I dont know what it is, I cannot change or fix it. I can only create ticket to support (do it) and write here Link to comment Share on other sites More sharing options...
DesignzShop Posted June 27, 2016 Share Posted June 27, 2016 15 minutes ago, russur said: Yes, it is server issue, but server is busy because of some big queries from ip.board software (wrote about it on previous page). Maybe it is rebuilding indexes... I dont know what it is, I cannot change or fix it. I can only create ticket to support (do it) and write here Email your host and have them look at the error page. They should be able to figure this for you. Make sure your host is also running MySQL 5.6 for innodb Link to comment Share on other sites More sharing options...
russur Posted June 28, 2016 Share Posted June 28, 2016 Thanks a lot, solve all my troubles last evening/night: 1. using .htaccess allow connections only from my IP 2. system - search - set "30 days ago" and press "rebuild search index". Index was created very fast. It is temporally. 3. Allow all connections using .htaccess 4. Upgrade MySQL to 5.6 5. Convert tables to InnoDB 6. Set caching with Xcache Now, i`m happy Working fast. For the future, will try to build big search index (my community is 11 years old, about 1,5 millions posts) Link to comment Share on other sites More sharing options...
Wizatek Posted July 23, 2016 Share Posted July 23, 2016 (edited) I have tried to upgrade from 3.4.9 to 4.1.13.1 a few times now, but what ever i try, i always get this result: http://forum2.lhgenericname01.lc/ips4.php Edited July 23, 2016 by Wizatek Link to comment Share on other sites More sharing options...
Woodsman Posted July 25, 2016 Author Share Posted July 25, 2016 Quote PHP setting suhosin.max_vars is set to . This can cause problems in some areas. We recommended a value of 4096 or above. You should contact your hosting provider or system administrator to ask for this to be changed I do not use suhosin on my test sites but this seems to be another issue you have on this test site. Whether this is directly related is unsure so I think you may need to contact your hosting provider about both errors. Link to comment Share on other sites More sharing options...
cofee_iv Posted July 27, 2016 Share Posted July 27, 2016 I version 3.4.5. How do I back up my skin and images? I did go into the tools and backed up the sql. Thanks! Link to comment Share on other sites More sharing options...
Woodsman Posted July 27, 2016 Author Share Posted July 27, 2016 Unfortunately previous 3rd party 3.4.x Skin themes, Mods, Hooks and Applications will not work with IPS 4.0 and above due to the new framework. You will need to contact the 3rd party developers and designers to see if what you need has been upgraded. Link to comment Share on other sites More sharing options...
cofee_iv Posted July 27, 2016 Share Posted July 27, 2016 Thank you! Link to comment Share on other sites More sharing options...
leonovich_J Posted September 3, 2016 Share Posted September 3, 2016 Hello, help to solve the problem on my test forum. After running the task, the conversion takes less than 2 seconds and crashes You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL ORDER BY msg_id DESC LIMIT 0,50' at line 1 SELECT * FROM `ibf_core_message_posts` AS `core_message_posts` WHERE msg_id < IS NULL ORDER BY msg_id DESC LIMIT 0,50 | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | /system/Db/Db.php | [IPS\Db\_Exception].__construct | 388 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Db/Select.php | [IPS\_Db].preparedQuery | 346 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Db/Select.php | [IPS\Db\_Select].runQuery | 408 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [IPS\Db\_Select].rewind | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/core/extensions/core/Queue/RebuildPosts.php | [IteratorIterator].rewind | 98 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Task/Task.php | [IPS\core\extensions\core\Queue\_RebuildPosts].run | 48 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/core/modules/admin/system/background.php | [IPS\_Task].runQueue | 76 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [IPS\core\modules\admin\system\_background].IPS\core\modules\admin\system\{closure}| | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Helpers/MultipleRedirect/MultipleRedirect.php | [].call_user_func | 93 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/core/modules/admin/system/background.php | [IPS\Helpers\_MultipleRedirect].__construct | 122 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [IPS\core\modules\admin\system\_background].process | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Controller.php | [].call_user_func | 85 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/core/modules/admin/system/background.php | [IPS\Dispatcher\_Controller].execute | 33 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Dispatcher.php | [IPS\core\modules\admin\system\_background].execute | 129 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /admin/index.php | [IPS\_Dispatcher].run | 13 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Link to comment Share on other sites More sharing options...
Joy Rex Posted September 12, 2016 Share Posted September 12, 2016 On 9/3/2016 at 3:59 AM, leonovich_J said: Hello, help to solve the problem on my test forum. After running the task, the conversion takes less than 2 seconds and crashes You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL ORDER BY msg_id DESC LIMIT 0,50' at line 1 SELECT * FROM `ibf_core_message_posts` AS `core_message_posts` WHERE msg_id < IS NULL ORDER BY msg_id DESC LIMIT 0,50 | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | /system/Db/Db.php | [IPS\Db\_Exception].__construct | 388 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Db/Select.php | [IPS\_Db].preparedQuery | 346 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Db/Select.php | [IPS\Db\_Select].runQuery | 408 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [IPS\Db\_Select].rewind | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/core/extensions/core/Queue/RebuildPosts.php | [IteratorIterator].rewind | 98 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Task/Task.php | [IPS\core\extensions\core\Queue\_RebuildPosts].run | 48 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/core/modules/admin/system/background.php | [IPS\_Task].runQueue | 76 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [IPS\core\modules\admin\system\_background].IPS\core\modules\admin\system\{closure}| | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Helpers/MultipleRedirect/MultipleRedirect.php | [].call_user_func | 93 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/core/modules/admin/system/background.php | [IPS\Helpers\_MultipleRedirect].__construct | 122 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [IPS\core\modules\admin\system\_background].process | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Controller.php | [].call_user_func | 85 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/core/modules/admin/system/background.php | [IPS\Dispatcher\_Controller].execute | 33 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Dispatcher.php | [IPS\core\modules\admin\system\_background].execute | 129 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /admin/index.php | [IPS\_Dispatcher].run | 13 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' I would open a ticket with Support if you haven't already as it appears there is incompatible syntax in the upgrader related to your use of MariaDB. leonovich_J 1 Link to comment Share on other sites More sharing options...
HomerSimpson Posted September 21, 2016 Share Posted September 21, 2016 Do not try this tutorial , you will kill your board Link to comment Share on other sites More sharing options...
Boomer12 Posted September 21, 2016 Share Posted September 21, 2016 Please explain this. russur 1 Link to comment Share on other sites More sharing options...
media Posted September 21, 2016 Share Posted September 21, 2016 50 minutes ago, HomerSimpson said: Do not try this tutorial , you will kill your board When you say something like this you need to explain and give other option or options... Thanks Boomer12 1 Link to comment Share on other sites More sharing options...
bern5 Posted September 25, 2016 Share Posted September 25, 2016 is there any checklist or advice on what ACP settings to double check after the upgrade to V4 ? Link to comment Share on other sites More sharing options...
Woodsman Posted September 26, 2016 Author Share Posted September 26, 2016 (edited) On 9/21/2016 at 8:39 AM, HomerSimpson said: Do not try this tutorial , you will kill your board What didn't work for you? For so many this tutorial was very helpful and a small few had trouble. What is more curious are those who missed a step or just thought some steps were unnecessary ended up in trouble. Funny - Quote is there any checklist or advice on what ACP settings to double check after the upgrade to V4 ? In the beginning of the up grade there is a check list showing pass, fail or FYI. Edited September 26, 2016 by Woodsman Link to comment Share on other sites More sharing options...
Woodsman Posted September 26, 2016 Author Share Posted September 26, 2016 On 9/21/2016 at 8:39 AM, HomerSimpson said: Do not try this tutorial , you will kill your board Another thing that strikes my funny bone..... This is the only comment from you in 17 pages and not one saying you were in trouble or asking for help. Link to comment Share on other sites More sharing options...
CarBuilders Posted November 4, 2016 Share Posted November 4, 2016 Hi, When upgrading I get many DB tables named orig_ibf_* After verifying everything, can I drop these tables? Link to comment Share on other sites More sharing options...
Boomer12 Posted November 5, 2016 Share Posted November 5, 2016 I can recommend you asking the support within the client area, they can give you a definitive answer on that case. Link to comment Share on other sites More sharing options...
Morgin Posted November 12, 2016 Share Posted November 12, 2016 I'm getting closer and closer to feeling ready to do this. There's a lot of info in this thread. Is there a post I should be looking for that compiles most of it, or should I make sure to go through all 20 pages? My biggest area of need is a tutorial to convert myISAM tables to Innodb. Link to comment Share on other sites More sharing options...
Woodsman Posted November 14, 2016 Author Share Posted November 14, 2016 On 11/12/2016 at 2:39 PM, Morgin said: I'm getting closer and closer to feeling ready to do this. There's a lot of info in this thread. Is there a post I should be looking for that compiles most of it, or should I make sure to go through all 20 pages? My biggest area of need is a tutorial to convert myISAM tables to Innodb. The first page of this article should get you on your way just fine. Remember though to always make a backup of both your site and database just in case anything goes south on you. Good Luck and Have Fun! Link to comment Share on other sites More sharing options...
Roughdawg4 Posted November 14, 2016 Share Posted November 14, 2016 Hi, Is there a way of running a dummy site with ver 4 on it so we can see what our site will look like going from 3.4 to 4 we had some issues last time had to go back to 3.4 so would like to know these are resolved first before hitting live Thanks Link to comment Share on other sites More sharing options...
Woodsman Posted November 14, 2016 Author Share Posted November 14, 2016 Yes you are allowed one test site with your license. This test site has to be offline to the general public. Link to comment Share on other sites More sharing options...
Adriano Faria Posted January 17, 2017 Share Posted January 17, 2017 (edited) On 22/10/2015 at 9:28 AM, Ibragim Pupkevich said: Did anyone face following error message during Upgrade from 3.4 to 4.1? Is this one critical? lang_not_exists____app_cms C:\Winginx\home\localhost\public_html\system\Lang\Lang.php::657 BLOB/TEXT column 'a_short' used in key specification without a key length C:\Winginx\home\localhost\public_html/applications/core/setup/upg_101001/queries.json - query #2 I got this error on a client's board. Any idea? EDIT: I got same error if I try to change column definition on DB: Edited January 17, 2017 by Adriano Faria Link to comment Share on other sites More sharing options...
Adriano Faria Posted January 17, 2017 Share Posted January 17, 2017 6 hours ago, Adriano Faria said: I got this error on a client's board. Any idea? EDIT: I got same error if I try to change column definition on DB: Anyone from IPS support: does the client needs to submit a ticket to update his test board ? He doesn't want to update the main board before test it on a test install. @Jim M @Rhett @Mark H, etc. Link to comment Share on other sites More sharing options...
Recommended Posts