[Bug / Issue] The software is experiencing a systems error.

[mc0676]

vBulletin Version - 5.6.3
PHP Version - 7.3
MySQL Version - 5.6.49-89.0
Any Addons installed: only one (if i remember)
Does the issue occur in a default style? In any template.
Does the issue occur using the English language provided? In any language.

Error message on the screen.
A System Error has occured.
The software is experiencing a systems error.
You should attempt to repeat your last action. If this error occurs again, please contact the site administrator.

Browser and Browser version used.
Chrome and firefox.

Did you clear the browser cache and did the error continue?
Yes, do not works.

A list of steps that can be used to recreate the issue.
Yesterday all work fine, today there is the problem.
In my website i've a wordpress blog too, that work fine without problem in the same DB. No server or DB issure i think.

Output of the error with vBulletin in Debug Mode.
In debug mode i can read only this:
Error :No contenttypes found on line 458 in phar:///web/htdocs/www.vwgolfcommunity.com/home/vb/core/vb/vb.phar/types.php

I've disable all the hook (define("DISABLE_HOOKS", true) without success.

Forum url is > https://www.vwgolfcommunity.com/vb/

Thank u for support.

[mc0676]

Other information:
vb_test.php say "all is good to run vb".

[mc0676]

If u try to execute:
/core/install/tools.php?do=mysql&type=query

i receive the same error:
A System Error has occured.


The software is experiencing a systems error.

You should attempt to repeat your last action. If this error occurs again, please contact the site administrator.

[Wayne Luke]

Make sure the connection to your database is correct in /core/includes/config.php and that the database server is accepting new connections. If those are correct, then please put the site into Debug Mode and paste the entire new error into a reply.

[mc0676]

He Wayne,
config.php is correct.
With debug on i can read only this ...

Error :No contenttypes found on line 458 in phar:///web/htdocs/www.vwgolfcommunity.com/home/vb/core/vb/vb.phar/types.php

[mc0676]

Sorry, here the full string:

Error :No contenttypes found on line 141 in /web/htdocs/www.vwgolfcommunity.com/home/vb/includes/vb5/frontend/routing.php
Step 0: showErrorPage() called on line 382 in /web/htdocs/www.vwgolfcommunity.com/home/vb/includes/vb5/applicationabstract.php
Step 1: handleException() called
Exception Non-existent template requested: preheader on line 195 in /web/htdocs/www.vwgolfcommunity.com/home/vb/includes/vb5/template/cache.php

[Wayne Luke]

If you run this query in phpMyAdmin what are the results?

SELECT * FROM contenttype;

If you use a table prefix, you need to add that before contenttype. There should be at least 32 rows.

Same with the templates... There should be 589 templates.

SELECT * FROM template;

[mc0676]

SELECT * FROM vb_contenttype;
0 row


select * FROM vb_template
i've about 1,943 row here, but i've some "children" template

[Wayne Luke]

You will need to restore your contenttype table from the most recent backup. Unfortunately, there is no way to restore a single table out of an entire backup. So you'll need to restore the backup into a new database, extract the contents of the contenttype table and insert it into your live database. Your hosting company should be able to help you with the restoration. phpMyAdmin allows you to backup single tables to import into the live database.

[mc0676]

Ok Wayne, i'm restoring the entire backup in another DB to extract that table. Thank u.

[mc0676]

It's normal that contentype table is a "memory" tipe table ?

[Wayne Luke]

No... That is probably why you lost your content types. It should be an INNODB table. vBulletin 5 does not use the Memory table type.

[mc0676]

Wayne Luke i restored that table, but do not works.
If i open tools.php and try do rebuilt theme i receive this:

vBulletin 5 Tools
No contenttypes found

In debug mode the error is the same.
Error :No contenttypes found on line 141 in /web/htdocs/www.vwgolfcommunity.com/home/vb/includes/vb5/frontend/routing.php
Step 0: showErrorPage() called on line 382 in /web/htdocs/www.vwgolfcommunity.com/home/vb/includes/vb5/applicationabstract.php
Step 1: handleException() called
Exception Non-existent template requested: preheader on line 195 in /web/htdocs/www.vwgolfcommunity.com/home/vb/includes/vb5/template/cache.php

[mc0676]

No... That is probably why you lost your content types. It should be an INNODB table. vBulletin 5 does not use the Memory table type.

Modified in innoDB, do not works.

[Wayne Luke]

If this started as a new installation please run these queries:

TRUNCATE TABLE contenttype;
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (1, 'Post', 1, '0', '0', '0', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (2, 'Thread', 1, '0', '0', '1', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (3, 'Forum', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (4, 'Announcement', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (5, 'SocialGroupMessage', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (6, 'SocialGroupDiscussion', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (7, 'SocialGroup', 1, '0', '0', '0', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (8, 'Album', 1, '0', '0', '0', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (9, 'Picture', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (10, 'PictureComment', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (11, 'VisitorMessage', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (12, 'User', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (13, 'LegacyEvent', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (14, 'Calendar', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (15, 'Attach', 1, '0', '0', '1', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (16, 'Photo', 1, '0', '1', '1', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (19, 'BlogEntry', 2, '0', '0', '0', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (20, 'BlogComment', 2, '0', '0', '0', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (21, 'Article', 3, '0', '0', '1', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (22, 'Text', 1, '1', '1', '1', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (23, 'Channel', 1, '1', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (24, 'Poll', 1, '1', '1', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (25, 'Gallery', 1, '1', '1', '1', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (26, 'Video', 1, '1', '1', '1', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (27, 'PrivateMessage', 1, '0', '1', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (28, 'Link', 1, '1', '1', '1', '1', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (29, 'Report', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (30, 'Redirect', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (31, 'Infraction', 1, '0', '0', '0', '0', '0');
INSERT INTO `contenttype` (`contenttypeid`, `class`, `packageid`, `canplace`, `cansearch`, `cantag`, `canattach`, `isaggregator`) VALUES (32, 'Event', 1, '1', '1', '1', '1', '0');

If you upgraded from vBulletin 4, these values may be inaccurate.