UBBCentral
Posted By: Daryl Fawcett Error Messages - What to do??? - 06/20/2019 1:05 PM
What can I do to correct this?

I am using 7.5.8

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Smarty has a deprecated constructor in /home4/maritim5/public_html/forums/libs/smarty/Smarty.class.php on line 64

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; bbcode has a deprecated constructor in /home4/maritim5/public_html/forums/libs/bbcode.inc.php on line 5

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; mailer has a deprecated constructor in /home4/maritim5/public_html/forums/libs/mailer.inc.php on line 7

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home4/maritim5/public_html/forums/libs/mysql.inc.php:22 Stack trace: #0 /home4/maritim5/public_html/forums/libs/ubbthreads.inc.php(88): sql->connect() #1 /home4/maritim5/public_html/forums/ubbthreads.php(41): require_once('/home4/maritim5...') #2 {main} thrown in /home4/maritim5/public_html/forums/libs/mysql.inc.php on line 22
Posted By: Ruben Re: Error Messages - What to do??? - 06/20/2019 2:22 PM
If I had to guess.
It would be your host upgraded your php version to 7.XX
Your version of ubb is not compatible.
I recall that php 5.6 is pretty much the highest you can go. with ubb7.5.8
Posted By: Gizmo Re: Error Messages - What to do??? - 06/20/2019 5:50 PM
Originally Posted by Daryl Fawcett
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home4/maritim5/public_html/forums/libs/mysql.inc.php:22 Stack trace: #0 /home4/maritim5/public_html/forums/libs/ubbthreads.inc.php(88): sql->connect() #1 /home4/maritim5/public_html/forums/ubbthreads.php(41): require_once('/home4/maritim5...') #2 {main} thrown in /home4/maritim5/public_html/forums/libs/mysql.inc.php on line 22

Its quite simple really; someone upgraded PHP on the server. PHP7 does not have the mysql_connect function (as the mysql_ functions have been depreciated and replaced by their mysqli_ counterparts), and any scripts that rely on it will present this error (anything coded prior to PHP7 without MySQLi support); you'll need to either roll PHP back to PHP5 or upgrade to UBB.threads 7.7.x.

You'll probably also want to check any PHP scripts installed on your server as there are likely other scripts showing the same behavior.
Posted By: isaac Re: Error Messages - What to do??? - 06/20/2019 6:51 PM
Sorry that you had to wake up and find your site is now throwing errors. Its never fun when that happens.

Good news though, you can easily upgrade to the current version of UBB.threads, which fully supports PHP 7 and MySQLi.

Below are some versioning explanations you may find helpful:

The versions of PHP which UBB.threads 7.5.8 is compatible with, are PHP 5.2 - PHP 5.6.
The current version of UBB.threads is 7.7.1, and is compatible with PHP 5.4 - PHP 7.3.
https://www.php.net/manual/en/migration70.incompatible.php

PHP 4 can connect to a MySQL database using the MySQL extension.
PHP 5 can connect to a MySQL database using either MySQL or MySQLi extension.
PHP 7 can connect to a MySQL database using the MySQLi extension (the "i" stands for improved)
https://phppot.com/php/mysql-vs-mysqli-in-php/

UBB.threads 7.0.0 to UBB.threads 7.6.2 uses the MySQL extension.
UBB.threads 7.7.0 and newer uses the MySQLi extension.

--

When your host emails you that they are upgrading critical services, telling you to upgrade your hosted scripts to compatible versions; at the risk of any down time, its highly advised that you find out what that means, and resolve any potential issues before their date.

An example of what that email may have looked like:
Quote
[WEBHOST] is dedicated to providing you with the best resources for you and your website. So, we’re excited to announce that we will be upgrading all of our servers to newer versions of Apache and providing newer versions PHP (including PHP 7.2 & 7.3). The upgraded versions provide better data processing, which can improve the performance and speed of your website.

When will maintenance begin? We will start the maintenance process on [DATE] and will continually monitor your website. We anticipate less than 5 minutes of slowness/downtime during the upgrade itself.

We recommend updating all of your web installations to the latest version--including WordPress, Joomla, Drupal or any other Content Management Tool that you may use--as soon as possible. For custom or unique PHP code, please see the PHP Migration Guide [php.net].
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/20/2019 8:16 PM
I did receive that notice, but didn't realize that it would affect version 7.5.8.

Now that I know, I guess I had better set about doing the upgrade, which when done, I assume will resolve these issues???
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/20/2019 8:16 PM
In other words, I should have been paying closer attention to that notice.
Posted By: Ruben Re: Error Messages - What to do??? - 06/20/2019 8:32 PM
yes,
You can request your host to revert your php version back to php5.6 if they will o and or upgrade ubb to the current version.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/20/2019 8:44 PM
Can I upload directly from 7.5.8 to 7.7.1 or should I upload to a prior version first???

I guess I should also ask if I need to upload those files manually, or is there an upgrade.php that will do this for me???
Posted By: Ruben Re: Error Messages - What to do??? - 06/20/2019 11:10 PM
You should be able to upload directly without issue if you have member access.
Posted By: Gizmo Re: Error Messages - What to do??? - 06/21/2019 12:37 AM
Yes, you'd simply follow the standard upgrade instructions; the mysqli_ functions are used by default in 7.7.0+, no mysql_ functions exist in the 7.7 series.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/21/2019 1:30 AM
Thank you.

I now have the 7.7.1 zip files in my computer and will take a look at them tomorrow, as it is past my bedtime where I am.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 2:42 PM
I uploaded the 7.7.1 files and changed the permissions for all of the directories and files as stated, but when I try to use the upgrade.php file I receive the following error:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster@maritime-sda-online.com to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 2:46 PM
Is it a permissions problem???

I have the Install Directory set as 777 and the php and tmpl files also set at 777, but were previously at 666 but still didn't work, which is why I changed them all to 777.
Posted By: isaac Re: Error Messages - What to do??? - 06/23/2019 2:52 PM
HTTP 500 - Internal Server Error
https://blog.hubspot.com/marketing/http-500-internal-server-error

Can you run YOURSITE.com/forums/install/phpinfo.php ?

If not, a general guess is that your server may not be able to properly run PHP files.

Contact your webhost. Your server may be incorrectly configured.

Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 3:18 PM
Do you mean http://mysite,com/forums/install/phpinfo.php ?

If so, it shows the following:

Not Found

The requested URL /forums/install/phpinfo,php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 4:18 PM
I am going to change the 777 permissions one at a time to 755 to see if that makes any difference.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 4:25 PM
I changed the permissions of the forums directory that contains all the 7.7.1 files and it made a difference.

Check it out at http://mysite.com/forums/ubbthreads.php?ubb=cfrm

Will now try the upgrade.php file again.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 4:27 PM
I am still getting the following error when using http:/mysite.com/forums/install/upgrade.php

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster@maritime-sda-online.com to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 4:28 PM
Sounds like I may need to do the same permissions change in the install directory.
Posted By: Ruben Re: Error Messages - What to do??? - 06/23/2019 4:32 PM
If you are upgrading then there should not have been a need to change file/folder permissions.
You would have just overwrote the files when you uploaded them.
Normally the file permissions would not be changed.
But some host do not allow 777 and you would need to change it to 755.
And even though you will navigate to the install folder it would be upgrade.php you run not install.php.

So if you got lost on file permissions follow the install guide
https://www.ubbcentral.com/doc_install.php
Then if needed use 755 where it indicates 777.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 4:35 PM
I am in the process of changing all the directory permissions to 755 and the files within to 644.

I am actually able to access the datebase including the forums and threads, but can't do anything else besides that.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 4:36 PM
I was trying to use the upgrade.php file that is in the install directory.

I am aware that I shouldn't be using the install.php file.
Posted By: Ruben Re: Error Messages - What to do??? - 06/23/2019 4:38 PM
Read the notes on the install guide first before you get crazy with permission changes.

and of course you would follow the upgrade guide for upgrading and copying the files.
Posted By: Gizmo Re: Error Messages - What to do??? - 06/23/2019 4:41 PM
Cpanel will not allow scripts to execute under a directory with 777 permissions for "security".

Under cpanel your install and admin directories should be 755, the rest should follow standard install instructions. I'm not sure the setting offhand (still in the middle of the forest) but this is a setting that generally only happens in cpanel instances (I'm sure you could find it in the search).
Posted By: Ruben Re: Error Messages - What to do??? - 06/23/2019 4:49 PM
Giz,
The install guide covers the file/folder permissions and exceptions. perfectly.
But it has no mention of the install folder.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 4:58 PM
The Install Guide said to use 777 for directories and 666 for files, but said later below that it may need to be 755 and 644 respectively instead of 777 and 666.

I have now changed the permissions to 755 and 644, but upgrade.php still isn't working yet.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 4:59 PM
Originally Posted by Ruben
Giz,
The install guide covers the file/folder permissions and exceptions. perfectly.
But it has no mention of the install folder.

I noticed that, but will now change the files to 644 to see if that makes a difference, as I forgot to do that.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 5:01 PM
Originally Posted by Daryl Fawcett
Originally Posted by Ruben
Giz,
The install guide covers the file/folder permissions and exceptions. perfectly.
But it has no mention of the install folder.

I noticed that, but will now change the files to 644 to see if that makes a difference, as I forgot to do that.

That did make a difference and am now able to use the upgrade.php file. smile
Posted By: Ruben Re: Error Messages - What to do??? - 06/23/2019 5:03 PM
Okay I think you have it now.
phpinfo is running
after you are done delete the install contents.

And do you want me to edit the urls you posted so nobody can find the install folder and hose you up.

You know what I am going to edit them any way.
somebody could jump in while you are doing the upgrade.
Posted By: Gizmo Re: Error Messages - What to do??? - 06/23/2019 5:12 PM
Originally Posted by Daryl Fawcett
Originally Posted by Ruben
Giz,
The install guide covers the file/folder permissions and exceptions. perfectly.
But it has no mention of the install folder.

I noticed that, but will now change the files to 644 to see if that makes a difference, as I forgot to do that.
Like I said, it literally only affects cpanel, and is a setting within whm to allow this behavior like every other system. BUT the install directory itself needs no special permissions in any case.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 5:55 PM
Shouldn't these have been included in the 7.7.1 files???

The following files do not exist in your install (Make sure these are uploaded):
images/general/ventura/all.gif
images/general/ventura/announce.gif
images/general/ventura/ascend.gif
images/general/ventura/birthday.gif
images/general/ventura/blank.gif
images/general/ventura/calevent.gif
images/general/ventura/descend.gif
images/general/ventura/editpost.gif
images/general/ventura/email.gif
images/general/ventura/favicon.ico
images/general/ventura/file.gif
images/general/ventura/gotonew.gif
images/general/ventura/homepage.gif
images/general/ventura/hottopic.gif
images/general/ventura/info.gif
images/general/ventura/jumpnew.gif
images/general/ventura/lock.gif
images/general/ventura/moved.gif
images/general/ventura/new.gif
images/general/ventura/newfolder.gif
images/general/ventura/newimageposts.gif
images/general/ventura/newimages.gif
images/general/ventura/newpm.gif
images/general/ventura/newposts.gif
images/general/ventura/next.gif
images/general/ventura/nonewfolder.gif
images/general/ventura/nonewimageposts.gif
images/general/ventura/nonewimages.gif
images/general/ventura/nonewposts.gif
images/general/ventura/nopicture.gif
images/general/ventura/notify.gif
images/general/ventura/page.gif
images/general/ventura/poll.gif
images/general/ventura/posticon.gif
images/general/ventura/previous.gif
images/general/ventura/quickquote.gif
images/general/ventura/quickreply.gif
images/general/ventura/quote.gif
images/general/ventura/reply.gif
images/general/ventura/rss_icon.gif
images/general/ventura/star.gif
images/general/ventura/sticky.gif
images/general/ventura/toggle_closed.gif
images/general/ventura/toggle_open.gif
images/general/ventura/wait.gif
images/general/ventura/watch.gif
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 5:56 PM
Originally Posted by Ruben
Okay I think you have it now.
phpinfo is running
after you are done delete the install contents.

And do you want me to edit the urls you posted so nobody can find the install folder and hose you up.

You know what I am going to edit them any way.
somebody could jump in while you are doing the upgrade.

Yes, please edit out those URLs.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 6:13 PM
Looks like I forgot to upload those images.

Doing that now.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 6:27 PM
It says upgrade to 7.7.1 is complete, however, when I click on the Admin Dashboard link I receive the following error message:

Not Acceptable!

An appropriate representation of the requested resource could not be found on this server. This error was generated by Mod_Security.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 6:27 PM
As this could be another permissions problem, I am looking into that now.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 6:34 PM
This one is confusing me.

Any help regarding this would be appreciated.
Posted By: Gizmo Re: Error Messages - What to do??? - 06/23/2019 6:38 PM
Mod security is a php module, contact your host with the exact error from your logs (and not the error printed to your browser, as the logs will include the mod security rule).

There isn't anything we can do regarding server security modules.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 6:50 PM
I also receive this same error when just trying to log in:

Not Acceptable!

An appropriate representation of the requested resource could not be found on this server. This error was generated by Mod_Security.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 6:50 PM
Will look for it in the error log and then give them a call.

Thank you for all your help.

Much appreciated.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 7:01 PM
Where is this particular error log supposed to be located?
Posted By: Gizmo Re: Error Messages - What to do??? - 06/23/2019 7:44 PM
It's a part of your server logs, it isn't related to the UBB, nor is this PHP module...

It's basically seeing a text string and refusing to parse the script because of it.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 8:28 PM
I called the host and both of us couldn't find any error log dealing with this particular "Not Accepted" message.

I said I would call them back just as soon as I find out where this particular error log is supposed to be located that shows what rule is involved.
Posted By: Ruben Re: Error Messages - What to do??? - 06/23/2019 8:28 PM
There is a server log feature in UBB but it is only for mysql and it would need to be enabled.

For mod_security it is a php module..
So it would be a error log for php.
You may not have access to it depending on your hosting plan.
But I would look in cpanel or whm. whichever is available.
Look for something about logs and php.

Or try file manager in cpanel and see if you have a similar folder above the root if you are able.

Or you may need to just call the host to check.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 8:30 PM
Originally Posted by Gizmo
It's a part of your server logs, it isn't related to the UBB, nor is this PHP module...

It's basically seeing a text string and refusing to parse the script because of it.

Just noticed this now after posting.

We also searched the server logs and couldn't find anything there.

I am going to call them back again.
Posted By: Gizmo Re: Error Messages - What to do??? - 06/23/2019 8:54 PM
Should be an entry for every 406 error in the webserver log, additionally they could disable mod security, it's more of a hindrance than anything else in my experience.

If it's not in your error logs it could be in a combined set of logs in the access logs, but isn't something related to the UBB.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 9:14 PM
It is a shared server with Blue Host.

I called them back and they had me on hold for awhile before telling me that the error log is in the root directory, and, as they don't even have access to that, they have issued a ticket for the Level 2 Techs to look at sometime tomorrow, this being Sunday.

I hope they will resolve the issue tomorrow.

Why do they have Mod Security in the first place??? Does it actually protect them???
Posted By: Gizmo Re: Error Messages - What to do??? - 06/23/2019 9:24 PM
If some of the rules in the modules matched in scripts that preform malicious behaviors it could, but in my experience hosts don't edit the default rule set which will trigger on a significant amount of legitimate scripts.

You can search these forums for "not acceptable"and 406 to see several instances that we've had to deal with troubleshooting in the past.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 11:47 PM
I just found another way to successfully log in, after which I can access the Admin CP.

Interesting!!!!
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/23/2019 11:50 PM
I am receiving the following WARNING in Admin CP and wondering how to fix that:

WARNING: Your PHP max_input_vars setting is set to a low value. Your current setting is 1000; the default setting is 1000. Based on your current number of forums, a minimum setting of 3540 is recommended. Your forum may have issues such as a blank configuration file, missing settings, or unexpected script behavior if you continue. Please see the "Issues with the PHP 'max_input_vars' Setting" entry on the UBB.Wiki for more information.
Posted By: Gizmo Re: Error Messages - What to do??? - 06/24/2019 12:00 AM
That is a UBB warning about a detected server configuration issue; the System Requirements Test [ubbwiki.com] can fully test your server configuration vs recommended options.

If you click the link in the warnings they will open a page with more information...
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/24/2019 12:37 AM
Why not simply increase it from 1000 to 4000?

Is that something I can do, or does my host need to do it for me???
Posted By: Gizmo Re: Error Messages - What to do??? - 06/24/2019 12:52 AM
You don't seem to understand; the UBB is detecting that your server value is low, too low to write all of the configuration values in one stream for all of the forums you have. The effect here is to make your server not write a 0 byte configuration (clearing out your configuration when you make changes) as the server is currently configured to only allow a small value.

Again, this is reporting that YOUR SERVER (not UBB.threads) has a low value... The goal is to have your host increase any low values, the System Requirements Test [ubbwiki.com] tool will report any other values that may need changed as well; most shared hosts will not allow users to make server level configuration changes.
Posted By: isaac Re: Error Messages - What to do??? - 06/24/2019 12:58 AM
Daryl, you can edit your php.ini.

This is a warning notice about your server configuration. it's there to notify you of a potential issue you could have because of that way your server is configured.

all the information is detailed in the warning link you quoted.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/24/2019 1:32 PM
Originally Posted by isaac
Daryl, you can edit your php.ini.

This is a warning notice about your server configuration. it's there to notify you of a potential issue you could have because of that way your server is configured.

all the information is detailed in the warning link you quoted.

I already have it showing 4000 in php.ini
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/24/2019 1:39 PM
Even though there are still a few glitches, including the Log In tab on the top right of the green menu bar, if I click on a private forum link from the right column it will give me a message with the log in option below the message. I am then able to log in using that log in option.

Once I am in I am able to access the Admin Dashboard/CP via the Admin Access tab in the green menu bar.

Could there be a command problem when trying to use the log in tab?

It shows all those weird stuff when you place your mouse over the Log In Tab.

Check it out for yourself at http://www.maritime-sda-online.com/forums
Posted By: isaac Re: Error Messages - What to do??? - 06/24/2019 1:42 PM
as clarification, you said you were using Bluehost as your hosting company?

I also use bluehost, but on a pro account. I have zero of the issues you have mentioned in this thread.

I am curious about the ftp software you use to transfer your files.

or are you using their ftp web online interface?

getting back to your original question, are you modifying the php.ini that in the root of your account, or one that's in a sub directory somewhere? I believe bluehost now only supports php.ini "single mode." and no longer does "directory mode" for boxes they've just updatded to php 7.x

again, the value may be something you can easily ask you host for assistance with
Posted By: isaac Re: Error Messages - What to do??? - 06/24/2019 1:53 PM
as for your website quirks:

your website customizations do not look to be mobile friendly. and you have errors in your HTML.

you'll need to a) update your custom header, custom footer, and b) correct all of your customizations with HTML errors in them.

for A, you can disable viewport at Control Panel > Primary: Advanced settings > Disable Viewport

this will prevent your screen from rearranging things on mobile devices. and they will be locked in to a minimum with of 600px or similar. I don't remember the exact width, but it's a feature toggle that was added for sites that are in transition or that don't want to support layouts for mobile devices.

Attached picture Screenshot_20190624-065721.png
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/24/2019 9:05 PM
I disabled Viewport for now.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/24/2019 9:08 PM
I had it set to 4000 in php.ini in the root directory of my account, but php info is showing local as 1000.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/24/2019 9:15 PM
As I have several inactive forums, if I reduce the number of forums, how much will that lower it closer to the 1000 default?
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/24/2019 11:50 PM
They increased it to 5000. smile
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/25/2019 1:29 PM
They also whitewashed that Mod Rule and now everything seems to be working properly.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/25/2019 1:36 PM
Oops!

I forgot about this glitch when clicking on Forum Help:

Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting '-' or identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in /home4/maritim5/public_html/forums/languages/english/faq.php on line 42

How do I fix this???
Posted By: isaac Re: Error Messages - What to do??? - 06/25/2019 1:42 PM
It looks like your languages/english/faq.php file was not created successfully upon upgrade.

The solution is to copy the faq.php file (mentioned above) from your archive, in to the same directory path on your forum install.

example:
ubbthreads-XXX.zip/ubbthreads-XXX/languages/english/faq.php
to
YOURDOMAIN dot com/ ... /languages/english/faq.php
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/25/2019 1:45 PM
Working now after reloading that file.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 06/25/2019 1:46 PM
Thank you all for your assistance. smile
Posted By: isaac Re: Error Messages - What to do??? - 06/25/2019 1:55 PM
HTML
<td><a href="http://www.maritime-sda-online.com/forums/ubbthreads.php?ubb=cfrm"><img SRC="/ubb/msdaol3.png"></td>


This line you created in your custom "HTML Includes" contains broken HTML, and is causing all of the following page items after it to become links.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 07/01/2019 11:36 AM
When trying to send an email to 24 selected users, I am receiving the following error message:

Script: /home4/maritim5/public_html/forums/admin/dosendemail.php
Line#: 191
SQL Error: Column 'USER_ID' in where clause is ambiguous
SQL Error #: 1052
Query: SELECT COUNT(*) FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3, ubbt_USER_GROUPS as t4 WHERE t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' AND t1.USER_ID <> '1' and t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID and t1.USER_ID = t4.USER_ID AND USER_ID NOT IN ('986') and t3.USER_LAST_VISIT_TIME > '1546300799' GROUP BY t1.USER_ID ORDER BY t1.USER_ID ASC

Is this a bug that needs fixing???
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 07/01/2019 11:38 AM
Originally Posted by isaac
HTML
<td><a href="http://www.maritime-sda-online.com/forums/ubbthreads.php?ubb=cfrm"><img SRC="/ubb/msdaol3.png"></td>


This line you created in your custom "HTML Includes" contains broken HTML, and is causing all of the following page items after it to become links.

Just noticed this and will look into fixing that.
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 07/01/2019 11:41 AM
Originally Posted by Daryl Fawcett
When trying to send an email to 24 selected users, I am receiving the following error message:

Script: /home4/maritim5/public_html/forums/admin/dosendemail.php
Line#: 191
SQL Error: Column 'USER_ID' in where clause is ambiguous
SQL Error #: 1052
Query: SELECT COUNT(*) FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3, ubbt_USER_GROUPS as t4 WHERE t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' AND t1.USER_ID <> '1' and t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID and t1.USER_ID = t4.USER_ID AND USER_ID NOT IN ('986') and t3.USER_LAST_VISIT_TIME > '1546300799' GROUP BY t1.USER_ID ORDER BY t1.USER_ID ASC

Is this a bug that needs fixing???

It is also showing up in the mysql log error:

Script: /home4/maritim5/public_html/forums/admin/dosendemail.php - Line: 191 SELECT COUNT(*) FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3, ubbt_USER_GROUPS as t4 WHERE t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' AND t1.USER_ID <> '1' and t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID and t1.USER_ID = t4.USER_ID AND USER_ID NOT IN ('986') and t3.USER_LAST_VISIT_TIME > '1546300799' GROUP BY t1.USER_ID ORDER BY t1.USER_ID ASC - Column 'USER_ID' in where clause is ambiguous
Posted By: isaac Re: Error Messages - What to do??? - 07/01/2019 11:42 AM
Originally Posted by Daryl Fawcett
[quote=Daryl Fawcett]When trying to send an email to 24 selected users, I am receiving the following error message:

Script: /home4/maritim5/public_html/forums/admin/dosendemail.php
Line#: 191
SQL Error: Column 'USER_ID' in where clause is ambiguous
SQL Error #: 1052
Query: SELECT COUNT(*) FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3, ubbt_USER_GROUPS as t4 WHERE t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' AND t1.USER_ID <> '1' and t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID and t1.USER_ID = t4.USER_ID AND USER_ID NOT IN ('986') and t3.USER_LAST_VISIT_TIME > '1546300799' GROUP BY t1.USER_ID ORDER BY t1.USER_ID ASC

Is this a bug that needs fixing???


This has been corrected for 7.7.2 over here
https://www.ubbcentral.com/forums/u...threads-7-7-2-progress-report#Post262789

Changelog 2019-06-16
[FIX] MySQL 5.7+ fixes to correctly handle GROUP BY clauses. This is a code fix, not a band-aid patch, such as reconfiguring your SQL MODE settings to add "TRADITIONAL" or removing "ONLY_FULL_GROUP_BY" from it.


BTW, Are you aware that you can edit your posts. You dont need to reply to yourself over and over again. 50 of the 70 posts in this thread are by you, just replying to yourself.


Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 07/01/2019 12:27 PM
As I successfully sent it to another group of users, why wasn't I able to successfully send it to another group of users this time?

Also, is there a fix that I can use for 7.7.1 as in BUG:..... and FIX:.....?????

I will use the edit feature from now on. eek
Posted By: isaac Re: Error Messages - What to do??? - 07/01/2019 12:30 PM
Originally Posted by Daryl Fawcett
Also, is there a fix that I can use for 7.7.1 as in BUG:..... and FIX:.....?????:


You can upgrade to 7.7.2 when its released. This should be released in about a day or so thumbsup
Posted By: Daryl Fawcett Re: Error Messages - What to do??? - 07/02/2019 12:05 AM
Originally Posted by isaac
HTML
<td><a href="http://www.maritime-sda-online.com/forums/ubbthreads.php?ubb=cfrm"><img SRC="/ubb/msdaol3.png"></td>


This line you created in your custom "HTML Includes" contains broken HTML, and is causing all of the following page items after it to become links.

I fixed this.

Thank you for noticing that.
© 2019 UBB.threads PHP Forum Software Community