DzUser

21 hours ago, teraßyte said:

There is a tool in ACP to rebuild the achievements right away (see the button in the Other Settings screenshot):

 

Before rebuilding, you can change the rules so that they add only 1 point for each content they make. By default, users get 10 points for a new item they post and 5 points for each comment/reply.

Works fine after rebuilding.

Thanks for your help.

11 hours ago, teraßyte said:

There is a tool in ACP to rebuild the achievements right away (see the button in the Other Settings screenshot):

 

Before rebuilding, you can change the rules so that they add only 1 point for each content they make. By default, users get 10 points for a new item they post and 5 points for each comment/reply.

I modified rules to earn 1 point for each content and I launched the rebuild (in progress).

I'm waiting to complete the rebuild to see if the ranks are updated. I'll update this post.

Thanks for your help.

Hi,

I migrated IPB from 4.2.5 to latest 4.7.14 and I try to import my ranks configuration to my new IPB. On 4.2, ranks are configured by number of content items (posts, comments) but on the last version it's by number of point.

There is a tip to switch on "by number content" metric instead of "by number of point" to approve rank to a member ? For the moment, all of my members are newbies rank and lost their rank.

Thank you.

18 minutes ago, Jim M said:

It is an available option to avoid overhead on your MySQL server. Most communities will not need it 🙂 .

20 minutes ago, teraßyte said:

Not really. The setting may speed up things slightly based on the server configuration, but I found it causes problems more often than not. Personally, I suggest leaving it disabling.

Great.

Thanks a lot for your help.

1 hour ago, teraßyte said:

Try disabling completely the template disk caching setting for now. Does that fix the issue?

Yes, it's works when I disable it. 

Do I need to reactivate ?

Hello,

I migrated my old IPB to the latest version. Everything was working perfectly until I changed a parameter and now the site has a 500 error.

The parameters I modified are on Advanced Configuration. I see an error on "Template disk cache path" :

So, I modified with my new directory after migration. I also added the cron indicated on Advanced configuration to my crontab. The error disappeared but, since this modification, my IPB forum is down with error 500. When I switch to Offline mode, the users can see the maintenance message, that's all.

I have no errors logs. I try to put the old value to Template disk cache path but, forum is down.

I don't know what is my mistake but all working fine before this manipulations. I check, my uploads directory is with chmod 777, like datastore.

Thanks for your help.

Got it.

@Jim M and @Randy Calvert you're right, it was mod_rewrite.

I did two actions to URLs work finally :

• I modify, in httpd.conf, the AllowOverride directive from "None" to "All"

. . .
<Directory /var/www/html>
. . .
 # 
 # AllowOverride controls what directives may be placed in .htaccess files.
 # It can be "All", "None", or any combination of the keywords:
 # Options FileInfo AuthConfig Limit
 #
 AllowOverride All
. . .
</Directory>
. . .

• I create a .htaccess file on my Apache Document Root (/var/www/html) and I add this line

RewriteEngine On

I restarted Apache service and all works fine now.

There is the link which help me : How To Set Up mod_rewrite for Apache on CentOS 7 | DigitalOcean

Thanks a lot all guys for your precious help. I can now move forward for my migration.

13 minutes ago, Jim M said:

That is not normal, no. That is an indication further that either the .htaccess is in the wrong spot (make sure it's in the folder you installed the software in) or something is wrong with mod_rewrite on your server.

Yes, I'm sure.

• The software is installed on /var/www/html/forum_ips
• My .htaccess file is in root folder of community : /var/www/html/forum_ips/.htaccess
• The mod_rewrite seems to be good :

[root@srv www]# httpd -M | grep rewrite
 rewrite_module (shared)

I checked the Apache logs, there is no error. I continue to search

30 minutes ago, Jim M said:

You would need to ensure that you're using Apache and mod_rewrite is enabled on it. From the sounds of it, you have implemented .htaccess correctly so now it is just a server issue, I'm afraid. You would want to work with your hosting provider for assistance here.

Yes, I confirm, mod_rewrite is enabled. I'm surprised if it's my Apache configuration or server.

But for the warning message about .htaccess, it's normal ?

The rewriting does not seem to be working. This may be because you have not uploaded the .htaccess file, but may be a false error if your community is not generally accessible. Check friendly URLs are working, and if they are not, ensure you have uploaded the .htaccess file correctly or contact technical support for assistance.

34 minutes ago, Jim M said:

Based on what I am seeing on your community, the .htaccess needs to be completely replaced as our software is now in a folder which is not contained in the lines present, thus it is creating a 404.

I do it, I replaced the .htaccess with the .htaccess file downloaded from ACP but still "Not found" page when I click on URLs. I put the .htacess on my IPB folder : /var/www/html/forum/.htaccess

There is the .htaccess downloaded from ACP

<IfModule mod_rewrite.c>
Options -MultiViews
RewriteEngine On
RewriteBase /forum_ips/
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule \.(js|css|jpeg|jpg|gif|png|ico|map|webp)(\?|$) /forum_ips/404error.php [L,NC]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /forum_ips/index.php [L]
</IfModule>

EDIT : I see an warning message on ACP :

20 hours ago, teraßyte said:

You're missing a couple of rows. The latest .htaccess for 4.7 is this one:

<IfModule mod_rewrite.c>
Options -MultiViews
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule \.(js|css|jpeg|jpg|gif|png|ico|map|webp)(\?|$) /404error.php [L,NC]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

 

Re-download the file from your ACP, or use paste the content above in it.

Done. But links still don't work. I still have "Not found" page.

Actually, my test site is http://my_ip_address/forum_ips. There is a problem ? There is any hard link on DB may be ?

51 minutes ago, Randy Calvert said:

Did you make sure you have a fresh .htaccess file uploaded?

No, I didn't uploed a new .htaccess, I use the old .htaccess. I need to create a new file ? I don't see any specific conf but may be I wrong :

<IfModule mod_rewrite.c>
Options -MultiViews
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

11 minutes ago, Randy Calvert said:

Make sure your conf_global.php reflects the correct URL. Afterwards, clear the system cache in the support section of your ACP. 

Yes, I modified my conf_global.php with the new URL (my test URL actually). I cleared the system cache but same result.

4 hours ago, teraßyte said:

At the end, the upgrade tries to fix any wrong or missing columns/indexes in the database.

To avoid the error be sure that your tables are all InnoDB and with a DYNAMIC row format.

The upgrade completed after modify MySQL engine to InnoDB for several tables, thank you for the tip.

I access AdminCP and forum. But for the forum, all links are broken, because I'll use a new domain name for the migration. There is a hard link in DB I need to modify with my new domain name ?

2 hours ago, teraßyte said:

At the end, the upgrade tries to fix any wrong or missing columns/indexes in the database.

To avoid the error be sure that your tables are all InnoDB and with a DYNAMIC row format.

Some tables are on MyISAM engine, I'm migrating this tables, it takes some time. For the row format, all tables are DYNAMIC.

I'll let you know as soon as I finish.

Thanks

On 10/29/2023 at 12:57 AM, teraßyte said:

Check your conf_global.php file and be sure the ibf_ prefix is properly set:

<?php

$INFO = array (
  [...]
  'sql_tbl_prefix' => 'ibf_',
  [...]
);

 

Sorry for my belated reply.

Yes, it's works when I add the prefix on the conf_global.php.

Now, I run the IPB upgrader on my new VPS, it's works but some SQL queries needed to run manually, what I do but I have some errors on 2 queries :

mysql> ALTER TABLE `ibf_core_search_index` ADD KEY `author_lookup` (`index_author`,`index_class`(249),`index_hidden`,`index_date_updated`);
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes


mysql> ALTER TABLE `ibf_core_search_index` ADD KEY `container` (`index_class`(250),`index_container_id`,`index_date_commented`);
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

I bypassed and in the end of process, I have this error :

I don't know what is this 1000 bytes key length ?

37 minutes ago, teraßyte said:

Just to confirm, when you look at the database on the old VPS, is the table also missing there? Or maybe it's marked as crashed? If it is, I can't see how the forum was working without it.

That said, you're lucky because the table in the error doesn't hold any permanent data, but only temporary caches that can be recreated. You can recreate the table manually on the new server by running this query:

CREATE TABLE `core_store` (
  `store_key` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Key',
  `store_value` longblob DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`store_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

If your tables use a different collation be sure to change "utf8mb4 / utf8mb4_unicode_ci" to whatever other collation the database is using.

 

The only problem now is to understand if this is the only missing table, or if there are others. 🤷‍♂️

The table exists on the old VPS and on new VPS when I reimport the dump. But, I've just noticed, it's "normal" because the tables on the source database has a prefix "ibf_" :

I checked the logs and, like you mentionned, I have others tables with same issue :

SELECT sc.*, sv.sv_value FROM `core_theme_settings_fields` AS `sc`  LEFT JOIN `core_theme_settings_values` AS `sv` ON sv.sv_id=sc.sc_id WHERE sc.sc_set_id=1
IPS\Db\Exception: Table 'forum.core_theme_settings_fields' doesn't exist (1146)

It's logic it can't found the tables because there is no prefix "ibf_" (I don't know why). But why ? I don't know.

2 hours ago, teraßyte said:

Indeed, you're missing a table. Looks like the database wasn't restored properly.

I try to restored a new MySQL DB dump, same issue.

May be I founded a workaround I need confirmation it's a right way : if, on my old VPS, I use my licence key purchased last week to upgrade IPB forum (after upgraded Ubuntu), can I reset my licence key to use to another domain ? In fact, because I get this old forum from another administrator. So, this administrator have his proper IPB licence and forum domain name and I'll transfer the database to my new VPS with my new IPB license.

So, if I do all upgrade process on the old VPS with my IPB licence, I export the DB freshly update with the last version of IPB, after that, can I reset the licensed URL of my IPB license to use it for my new domain ?

I'm not sure if I very clear ?

NB : I have all access on the old VPS/IPB forum granted by the owner to do the migration.

14 minutes ago, teraßyte said:

Unfortunately, a 500 error is too generic. Look at your server's logs to check what the real error is.

Also, version 4.2.5 has a PHP 5.6.0 required version and a 7.0.0 recommended one. Anything higher or lower might be what's causing the error, too.

Yes, sorry, I just founded the IPB logs errors. There is the error when I try to access to /admin or /admin/upgrade :

Sat, 28 Oct 2023 17:41:31 +0000
SELECT * FROM `core_store` WHERE ( store_key IN('cacheKeys','settings','storageConfigurations','themes','languages','groups','applications','modules','widgets','furl','javascript_map','metaTags','bannedIpAddresses','license_data','furl_configuration','rssFeeds','frontNavigation','globalStreamIds','profileSteps','announcements','loginMethods','widgets','defaultStreamData','acpNotifications','emoticons') )
IPS\Db\Exception: Table 'forum.core_store' doesn't exist (1146)
#0 /var/www/html/forum/system/Db/Select.php(388): IPS\_Db->preparedQuery()
#1 /var/www/html/forum/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 /var/www/html/forum/system/Data/Store/Database.php(92): IPS\Db\_Select->rewind()
#3 /var/www/html/forum/system/Data/Store/Database.php(108): IPS\Data\Store\_Database->loadIntoMemory()
#4 /var/www/html/forum/system/Data/Store/Database.php(162): IPS\Data\Store\_Database->get()
#5 /var/www/html/forum/system/Data/AbstractData.php(126): IPS\Data\Store\_Database->exists()
#6 /var/www/html/forum/system/Data/Store.php(303): IPS\Data\_AbstractData->__isset()
#7 /var/www/html/forum/system/Settings/Settings.php(167): IPS\Data\_Store->__isset()
#8 /var/www/html/forum/system/Settings/Settings.php(152): IPS\_Settings->loadFromDb()
#9 /var/www/html/forum/system/Dispatcher/Front.php(39): IPS\_Settings->__isset()
#10 /var/www/html/forum/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Front->init()
#11 /var/www/html/forum/index.php(13): IPS\_Dispatcher::i()
#12 {main}
#0 /var/www/html/forum/init.php(1038): IPS\_Log::log()
#1 [internal function]: IPS\IPS::exceptionHandler()
#2 {main}

It seems it's about forum.core_store which doesn't exist ?

On 10/27/2023 at 3:57 PM, Afrodude said:

Then, I'm certain now that this is the cause of the problem.

I check and I have no plugins on the old IPB. For applications, I have only System, Forum and Calendar. Do I need to uninstall calendar ?

@Afrodude : No, I didn't disabled plugins and apps before upgrade. I'll try thiw way

@Miss_B and @Marc Stridgen Ok, I'll try tonight too.

Thanks

In fact, I didn't perform a manual upgrade. I've just to do it, with a new error on admin/upgrade URL :

My conf_global.php pointed to my old DB I have imported on MySQL

I'm not sure to understand the last sentence : How can I do the upgrade if th web interface doesn't work with PHP 8 ?

I transfered my DB and to my new VPS with the latest IPB version and I tried to reach http://myurl/admin/upgrade but I have this error :

Thanks for your answer.

So, if I understood, I have to do :

• The manual upgrade to my old VPS (with the latest package IPB 4.7.13)
• Export DB upgraded from my old VPS and transfer it to my new VPS

But my subscription on my old VPS is different of my subscription on my new VPS. How can I to this with two differents subscriptions ? I need to reset my licensed URL ?

Hi all,

I'm new with IPB, I'm taking over an old forum running on IPB 4.2.5 version. I purchased a licence to get the forum an do the migration to the latest stable version on a new VPS.

I follow "How To" to moving to new server : 

But, I don't know why, when I try to launch the old IPB version (with the old database, of course) on my new VPS, I have a HTTP Error 500 code. When I try to launch the last version of IPB on my new IPS, it's works fine.

There is my configuration of my new VPS :

OS : Rocky Linux 9.2

DB : MySQL 8.0.32

Webserver : 2.4.53 (I tried with nginx 1.20.1 too, same problem)

PHP 8.0.30

And the old VPS :

OS : Ubuntu 16.04.6 LTS

DB : MySQL 5.7.33

Webserver : Nginx 1.10.3

PHP 7.0.33

Could the big differences in versions explain this error ? I've looked at the logs, but can't find any clues.

Thank you for your help