Search Result

[kh99]

If that's the complete list of tables that failed, it might be worth trying to restore only those tables from the old backup, since those tables aren't the ones that store posts or users.

[kh99]

What does the error say?

[kh99]

It's not safe.

[kh99]

SELECT username, email FROM user WHERE (options & 16) AND NOT usergroupid IN(X, Y)

You can fill in the usergroup ids in place of X and Y. That only checks primary usergroup, but I'm...

[kh99]

That feature is only available in the blog (or in vb5).

[kh99]

I believe it's the error handler that changed, so that the issue always existed, but in vb3.8.7 you weren't seeing the warning displayed. It could be that it's not really a problem, but it does mean there's...

[kh99]

That "illegal string offset" warning is a problem from a plugin. You could temporarily disable your products one at a time until it goes away to figure out which one it is, then contact the...

[kh99]

OK, and you already tried downloading again? That's strange, it should be in the zip you download, obviously. I have seen a couple posts here about people having problems with incomplete distributions,...

[kh99]

Is this 4.2.3? Did you check the zip on our local computer to see if those files are there (ajax.php, for instance)?...

[kh99]

Comparing the beginning of the error list with the image you posted, it looks like files are in fact missing. You can see that ajax.php, apichain.php, asset.php, and assetmanage.php aren't there. So it...

[kh99]

Edit: nvm, I read the complete entry from the manual you linked to above.

[kh99]

There are mysql CONVERT() and CAST() functions that convert character set, but I don't know the details of what you'd need to do. It would be something like:

SELECT CONVERT(post.pagetext

...

[kh99]

I think this works:

SELECT post.pagetext
   FROM thread LEFT JOIN post ON(post.postid = thread.firstpostid)
   WHERE thread.postuserid = 1 AND thread.forumid = 2

But it...

[kh99]

It doesn't look like there's a limit other than the max size of an option value, which is a mysql mediumtext, around 16Mb (the entire size of all the options, in serialized array format, also has to fit...

[kh99]

So you're saying that you have an existing forum only, version 4.2.0, and now you have the 4.2.0 publishing suite and you want to install only the blog?

I'm pretty sure I won't know the answer,...