[Bug / Issue] Error when adding a new usergroup

[medialps]

Hello,
when I try to add an user group from admincp/usergroup.php?do=add&

I always get this error

È stato restituito un errore imprevisto: 'Cannot use object of type vB_dB_MYSQL_Result as array'

Same problem copying permissions from an existing group or creating a new group from basis.

Already tried to change PHP from 8.2 to older versions, no results.
How could I solve?

Thanks
BR

[Mark.B]

What exact vBulletin version is this please?

[medialps]

5.7.4, latest

[Wayne Luke]

As always, we need to see the complete error with the file name and line number to understand what is going on within your system. This will be logged in your PHP Error Log on the server. You can see where your Error Log is stored by visiting Maintenance → View PHP Error and using your browser's search tool to search for error_log.

You may also be able to see the full error and stack trace if you put your site into Debug Mode.

[medialps]

So, here it is,

An unexpected error was returned: 'Cannot use object of type vB_dB_MYSQL_Result as array'

Exception trace:

## phar:///web/htdocs/www.funiforum.org/home/funiforum/core/vb/vb.phar/db/assertor.php(389) Exception Thrown
#0 phar:///web/htdocs/www.funiforum.org/home/funiforum/core/vb/vb.phar/api/usergroup.php(476): vB_dB_Assertor->insert()
#1 phar:///web/htdocs/www.funiforum.org/home/funiforum/core/vb/vb.phar/api/wrapper.php(205): vB_Api_UserGroup->save()
#2 /web/htdocs/www.funiforum.org/home/funiforum/core/admincp/usergroup.php(716): vB_Api_Wrapper->__call()
#3 /web/htdocs/www.funiforum.org/home/funiforum/includes/api/interface/collapsed.php(149): require_once('...')
#4 /web/htdocs/www.funiforum.org/home/funiforum/includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay()
#5 /web/htdocs/www.funiforum.org/home/funiforum/index.php(65): vB5_Frontend_Controller_Relay->admincp()
#6 {main}​

[medialps]

Any news?

[Wayne Luke]

No.. Sorry. We have not received either the full MySQL Error or the entire PHP error from Debug Mode or the PHP Error Log. An exception trace isn't sufficient. It just says an error happened at this line, not what the specific error is.

Please submit a Support Ticket. In the ticket provide complete access to your server (SFTP, MySQL, and AdminCP) and the specific steps to reproduce the error.

[Wayne Luke]

We have a fix for this issue…

If there is a vb.phar file in your /core/vb directory, then

1. Go to the Member's Area.
2. Click "Download vBulletin 5"
3. Select "More Download Options"
4. Set "Use Compressed PHP Archive" to No.
5. Download vBulletin.
6. Remove the contents of /core/vb
7. Upload the contents of the new download to your server.

Then take the attached file, unzip it, and upload it to /core/vb/api

[medialps]

Sorry, it is not totally clear,

Yes, i have the vb.phar file in my /core/vb directory.
Should I remove the vb.phar from the server?

6. Remove the contents of /core/vb

From my server or from the downloaded pack?
The downloaded pack has inside 70 elements.

Upload the contents of the new download to your server.

Should I before remove the existing content or only overwrite?

This will be fixed automatically on a next release or is a problem of my single configuration?
Eventually future updates could make problems with this configuration?

Thank you very much.

[Wayne Luke]

From your server. Delete the existing files before uploading new ones.

It is a problem with legacy data in your database. The fix however will be in the next version. Probably released next week.

You can also fix the issue by running the query "truncate table forumpermission" on your database. vBulletin 5 doesn't appear to use this as it uses the permission table instead. I suspect this table will be completely removed in the future.

[medialps]

Thanks, I will change the files now, and will wait for the official update to fix the database.

It is a very old forum from 2003, migrated in 2007 from PHPBB to Vbulletin, but is still very active and visited.

[medialps]

OK, it works, changing the files, without the query, thank you very much for your help!

So I think that the next update will come with an update vb.phar so I can again delete all the files (except config) and re-upload the updated compressed version?

[Wayne Luke]

You just have to delete the contents of the /core/vb directory. You do not need to delete every file.