Nuclear General

The new portal looks good.. but I did notice that the renewal price has gone up by $100 dollars. Is there a reason for this? I have tried to look around for a topic about it, but cannot find one anywhere on the site or forums about the increased price to $310 a year. That seems a little too steap now..

On 6/9/2021 at 1:49 PM, Adlago said:

Just to add - upgrade from ipb 3.1 to 4.5.2 is done without any problems. The upgrade works perfectly.

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.

On 6/9/2021 at 7:03 PM, Marco Junior said:

Hello dears,

I have a warning on my admincp this warning show-me a information refers to my database mode.

What's this ? Compact mode ?

 

Error:

Your server does not meet our recommendations. This may prevent you from upgrading to future versions of Invision Community.

You have one or more InnoDB tables that are using the `Compact` row format. This may limit the amount of data that can be stored within the table. We recommend changing it to 'Dynamic'. If you are not sure how to do this, you should contact your hosting provider or system administrator for assistance.
You should contact your hosting provider or system administrator and ask them to resolve these issues.

 

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

Yes it does. I have released beta 1 to all customers and future buyers.

-Donald :)

There is a demo of this in action at my site at http://forums.tiberiumstudios.net/

This has not yet been updated for 3.1.

Quick Update On Global Ads!

Not quite sure I understand exactly.

Please use a regular browser. The Andriod doesn't know how to handle fixed content.

Yeah, to do that you can just copy the code from the templates directly into your IP.Content pages. When you purchase, I can provide further assistance in how to make it work for your IP.Content. :)

Buy One Get One Free Promotional Sale!!!

Buy One Get One Free Promotional Sale!!!

How can I check it? Does phpinfo.php script will show that info? Can you PM or msn or any instant messenger contact so I can talk to you on weekend and get it installed?

Thanks.

You might still be able to use the ionCube on your PHP 5.2.x. If you would like for me to give it a shot, PM me some details so I can use to get it done for you. Or I can walk you through it.

EDIT: Hey, does your server have any Zend Extensions installed into the php.ini file?

What are the exact Apache and PHP versions. I ask because ionCube will not work on Apache 2.2.x or PHP 5.3. If you have either of those, ionCube won't work. ionCube hasn't been updated to work on PHP 5.3 yet. Please PM me the versions k.

Sure thing man. I can show you how to install ionCube. It is a simple task to do. Is your dedicated server a Linux or Windows?

No. Not that I am aware of. I've never used TrafficRevenue or even heard of them. I've just used Google for years and never tried anyone else.

Yes, you can use TrafficRevenue with this mod. If you purchase, you can use either the Yahoo! or the WidgetBucks settings groups for your advert company. The mod supports raw HTML so that any advert company is supported.

Does your host not support ionCube? Most common hosts support ionCube loaders. Please ask your if they support it and if they have the latest version of PHP 5 installed.

Hello Julia,

I sent an email reply to you.

Regards,
Donald :)

Hello Julia,

What kind of trouble were you having with the products system? If you need some help with the purchase, I am always available on my MSN(WLM): mod_making_maniac_2005@hotmail.com Just drop me a message and I'll be glad to help.

Regards,
Donald :)

Alright, I just took a look at your settings and figured out why it won't work they way he has it set up.

1.) He has a Full web template in the HEAD tag section; EX: <HTML><HEAD><BODY> ect... those won't work because the script is re-adding all that into IPB's default <HEAD> tag.
2.) This script does not support raw PHP in the HEAD or BODY sections of the mod; nor in IPB's templates unless you use the <php> tags in the actual templates.

My script was designed for JavaScript and HTML use only. You maybe able to accomplish what you still need to do if you can find or create some JavaScript and HTML code and place that into the mods proper HEAD and BODY sections.

Regards,
Donald

Alright, well go ahead and send me some ACP details here on IPS in a PM k and I'll see what it's doing k. :)

What seems to be the issue with it? And I'll need some details for ACP access to troubleshoot your issue. Just have Shawn send me the details in a PM at my site k. And I'll see what I can do. :)

Regards,
Donald

Hello,

For the Christmas holiday, I will be having a sale on all my products. I am doing this sale for one purpose, paying my Cell Phone bill because I am still currently unemployed. So, for the first 30 (total) purchases of either (NG30) Global Ads or (NG30) Rotating Banners, you will receive the (NG30) BuyNow BBCode free of charge. I am doing that as an incentive for the buyers. So if you want the "buy one get one" free, you'd better act now because this sale ends Christmas day at 11:59 PM GMT -7 Mountain Time (USA & CANADA). These products will be sale for $10 USD.

Product Listings:
(NG30) Global Ads
(NG30) Rotating Banners

Best Regards,
Donald :)