Yellow Swordfish said:

no connection between the show tables query and the notices and warnings…

As soon as I have code for the options table ‘show’ query I will let you have it.

Thank you! I guess the query being in the same file is indeed just a coincidence then.

As to innoDB tables then the only negative I am aware of is that at one point they did not support FULL TEXT indexing which SP makes use of on the sfposts table.

According to my server guy, apparently innodb still does not support full-text search.

InnoDB uses row-level rather than table-level locking. If a row is being inserted, updated or deleted, only changes to the same row are held up until that request has completed. Tables that receive more updates than selects may be faster with InnoDB.

With this being the case, might a user benefit by converting all SF tables except sfposts to InnoDB? Is that the only table using FULLTEXT? Steve?

sfposts is the only table using a full text index.

a very quick search seems to suggest that it is mySQL 5.6 that support full text indexing using innoDB tables.

Personally I like innoDB and hope we can all move to them one day as a matter of course.

With reference to the 3 notices shown in post #3 of this thread – could you check something for me. In particular the email settings (foirum admin > Options > Email Settings) nad those settings over on the right hand side of the panel.

Do you have values in for those and is the ‘use’ item checked on or off please? And if unchecked – could you check it, save and then uncheck it again  and save. See if the notices disappear?

OK Jim.

You need the sp-api-primitives.php file as you already know.

Locate the function sp_load_alloptions() which is the one with the SHOW TABLES query.

Comment out or remove these two lines of code in that function:

//    $optionstable = spdb_select('var', "SHOW TABLES LIKE '".SF_PREFIX."sfoptions'");
//    if($optionstable == false) return '';

and that should be just fine

See if the notices disappear?

Thank you for the pointer… there were indeed no settings for those three SF email options, and the Use box was indeed unchecked. I entered values, checked the box and saved settings, then posted in the forums and loaded a few pages without the error showing up (if logged in realtime). I then turned the Use option back off as suggested.

The senders name: Tripawds
The email from name: Jerry
The email domain name: tripawds.com

It was just unclear if from name should be in the form of an address. Is this correct?

FYI: I took the same steps for the New User Email options which were also blank.

Since I am currently troubleshooting with my server guy too, I’m making changes one at a time and checking logs before proceeding. I may comment out the SHOW query later.

Thanks again for the guidance!

Fixes to stop those notices will be in the next update.