Nuclear General

I had a different experience when upgrading from 3.4.9 to 4.x.x. I had to upgrade to 4.4.10 first, and then upgrade to 4.5.x afterwards. 4.5.x would not work properly for me when converting my database to the new format they implemented in 4.x. I tried several attempts and all failed with 4.5.x but 4.4.10 worked (almost) flawlessly, but it did get me 3/4 of the way to upgrade to 4.5.x, and then the last upgrade of 4.5.4 months ago.

Hello, What version of MySQL are you using? Is it MariaDB 5.x.x or MariaDB 10.x.x? MariaDB 5.x.x uses ROW_FORMAT= 'COMPACT' , or 'REDUNDANT'. MariaDB 10.x.x uses ROW_FORMAT= 'COMPACT' , 'REDUNDANT' , 'DYNAMIC' , or 'COMPRESSED'. The ROW_FORMAT can be easily changed with a simple MySQL Statement. I'll show you how. 1) First, make a backup of your Database, i.e.: use phpMyAdmin, go to your database and use the OPERATIONS tab and use the "Copy Database To" section to create an exact copy, name what it whatever you'd like. Then run the following query on your copied database (Change the "DATABASE_NAME_HERE" to your copied database name) : This code will print out everything that has a table engine of "InnoDB". SELECT CONCAT('ALTER TABLE ', table_schema, '.', table_name, ' ENGINE=InnoDB;') AS sql_statements FROM information_schema.tables AS tb WHERE table_schema = 'DATABASE_NAME_HERE' AND `ENGINE` = 'InnoDB' AND `TABLE_TYPE` = 'BASE TABLE' ORDER BY table_name ASC; It will print out something similar to this: ALTER TABLE DATABASE_NAME_HERE.ibf_advertise_advertisements ENGINE=InnoDB; ALTER TABLE DATABASE_NAME_HERE.ibf_advertise_hits ENGINE=InnoDB; ALTER TABLE DATABASE_NAME_HERE.ibf_advertise_paypal ENGINE=InnoDB; ALTER TABLE DATABASE_NAME_HERE.ibf_autowelcome_members ENGINE=InnoDB; ALTER TABLE DATABASE_NAME_HERE.ibf_axenserverlist_servers ENGINE=InnoDB; ALTER TABLE DATABASE_NAME_HERE.ibf_bbcode_mediatag ENGINE=InnoDB; ALTER TABLE DATABASE_NAME_HERE.ibf_blog_blogs ENGINE=InnoDB; ALTER TABLE DATABASE_NAME_HERE.ibf_blog_categories ENGINE=InnoDB; ALTER TABLE DATABASE_NAME_HERE.ibf_blog_comments ENGINE=InnoDB; ALTER TABLE DATABASE_NAME_HERE.ibf_blog_entries ENGINE=InnoDB; In the below picture, you will get this: (As stated above) Click the +OPTIONS link, you will now see this: Make sure you click the "Full texts" radio button, leaving everything else alone, then click on 'GO'. You will now see this appear: It will show only 25 rows per page by default, but you can change that by doing this: After you have all your rows appear, copy all the text to a text editor, and do a FIND & REPLACE option for: Find: Engine=InnoDB Replace with: (If MariaDB 5.x.x) ROW_FORMAT=REDUNDANT Replace with: (If MariaDB 10.x.x) ROW_FORMAT=DYNAMIC Example: ALTER TABLE tibtech.ibf_advertise_advertisements ROW_FORMAT=DYNAMIC; ALTER TABLE tibtech.ibf_advertise_hits ROW_FORMAT=DYNAMIC; ALTER TABLE tibtech.ibf_advertise_paypal ROW_FORMAT=DYNAMIC; ALTER TABLE tibtech.ibf_autowelcome_members ROW_FORMAT=DYNAMIC; ALTER TABLE tibtech.ibf_axenserverlist_servers ROW_FORMAT=DYNAMIC; ALTER TABLE tibtech.ibf_bbcode_mediatag ROW_FORMAT=DYNAMIC; ALTER TABLE tibtech.ibf_blog_blogs ROW_FORMAT=DYNAMIC; ALTER TABLE tibtech.ibf_blog_categories ROW_FORMAT=DYNAMIC; ALTER TABLE tibtech.ibf_blog_comments ROW_FORMAT=DYNAMIC; ALTER TABLE tibtech.ibf_blog_entries ROW_FORMAT=DYNAMIC; Once the FIND & REPLACE has been done, copy all your edits and go to your database SQL tab in phpMyAdmin, and paste it in there and run SQL Statements. Your tables with now have the proper ROW_FORMAT that will satisfy Invision Community Suite and the error will go away. I hope this helps you and others with this annoying issue. Best of luck, -Donald

You're welcome. :-) and good luck with your little girl man. :-)

I don't have plans at the moment to upgrade my modifications. I'm currently busy with trying to support my 2 1/2 month old son and my girlfriend. I do not know when I'll be available to do upgrades on my modifications. Regards, -Donald :-)

It's possible the google code has changed the submission date. This mod is several years old now. Regards, -Don :)

This was designed for IP.Board version 3.1.x. If you're trying to use this on a newer version such as 3.3.x or 3.4.x, then it may not work. I have not upgraded this for the newer IP.Board versions. I am currently working on my other app that does exactly what this simple hook does and more. My global ads mod is near completion. About another two weeks or so and it should be finished. -Don :)

It seems to be showing up on my Chrome at the top. It must be a setting in your Chrome that is preventing it from showing at the top. Also, it seems to be showing two(2) google ads there..

You're not bothering me at all man. :) Would you mind sending me a link to your site please? So I can see the issue in action. Thanks, -Don :)

Which browser are you using? it seems to be working for me. Here is a screenshot of my Chrome browser with it showing up at the top: <td align="center" valign="top" width="10%">

I'll go ahead and take a look at this issue on my dev site and see what I can do for you. That code should have worked but idk.. I'll get back to you tomorrow with a possible solution. :) Regards, -Don :)

Hello, Yes it is possible. I have just checked my template bit and have it setup wrong. For a quick fix, please go to ACP -> Look & Feel -> Skin Templates -> Select Skin -> skin_ng30globalads -> hookTopicGlobalAds4_Right_2 Find: <td align="center" valign="top" width="10%" nowrap="nowrap"> Replace with: <td align="top" valign="top" width="10%"> The nowrap code was removed because I have been fiddling with my app the few weeks getting it upgraded for 3.4 and keeping it compatible with 3.3, and have noticed the nowrap causes some issues. But anywho... replacing the code with the new one should fix your issue. :) If you still have issues, please do not hesitate to ask. :) Regards, -Donald :)

Got it figured out lmao it was something called media player installed on my laptop lol :)

What is up with the ads on the forums now? They keep popping up windows and other crap... why do you have ads now IPS?? It gets annoying.. lol -Don :)

It should work with IP.Content, yes. Just copy the contents of the skin template over to your IP.Content page and it should get everything you have setup in your ACP. -Don :)

Dmacleo is correct. The mod only works with IP.C 2.2. The recent update was because of market changes as well. The actual file was not updated. Hope this clarifies things up. -Don :)