Sir Osis of Liver did a clean install for me--after I tried and got errors.
I have reinstalled my theme and am working through my mod list, reinstalling and reviewing. I have a few issues I have already discovered and will also have some questions as I go. I will post those I know about now in this first post--just so I can get them listed.
I can PM, but cannot post (replies or start a thread). I got this error:
QuoteField 'topic_note' doesn't have a default value
File: /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php
Line: 1816
I also received an error when trying to install the topic and board note mod mentioned in that error:
QuoteBLOB/TEXT column 'board_note' can't have a default value
File: /home/rollerco/public_html/mlcforum/Packages/temp/add_settings2.0.php
Line: 73
I then looked up that mod here and it is no longer supported. It is not essential, but I had hoped installing would fix the error. This issue is priority right now since no one can post at the forum.
Next I am going to list the mods in my packages folder.
1. TopicStarter Mod 1.7 [ Uninstall ] [ List Files ] [ Delete ]
2. Topic & Board Note 1.0.3 [ Install Mod ] [ List Files ] [ Delete ]
3. SMFPacks Popup Pro Mod 1.0.3 [ Uninstall ] [ List Files ] [ Delete ]
4. Register At Post View v.1.1 1.1 [ Uninstall ] [ List Files ] [ Delete ]
5. Search Sent PMs 1.4 [ Install Mod ] [ List Files ] [ Delete ]
6. Personal Messages to Membergroups 1.4.3 [ List Files ] [ Delete ]
7. Move Old Topics 1.3.8 [ Uninstall ] [ List Files ] [ Delete ]
8. Last Active On MemberList 1.4 [ Uninstall ] [ List Files ] [ Delete ]
9. Join Reason 1.3 [ Uninstall ] [ List Files ] [ Delete ]
10. Global Headers Footers 2.0.1 [ Uninstall ] [ List Files ] [ Delete ]
11. Default_Membergroup 1.0.1 [ Uninstall ] [ List Files ] [ Delete ]
12. Board Notification Mod 1.2.2 [ Uninstall ] [ List Files ] [ Delete ]
13. Bad Behavior mod 1.5.17 [ Install Mod ] [ List Files ] [ Delete ]
14. Anti-Spam Links 1.0.1 [ Uninstall ] [ List Files ] [ Delete ]
15. Alternative Menu With Top Menu Icon & Button Remover 1.4.2 [ Uninstall ] [ List Files ] [ Delete ]
16. Advanced Topic Prefix Mod 4.0.3 [ Install Mod ] [ List Files ] [ Delete ]
17. Ad Managment 3.1a [ Install Mod ] [ List Files ] [ Delete ]
18. Gender on Memberlist 1.5 [ List Files ] [ Delete ]
19. SMFPacks Shoutbox Pro 1.0.9 [ Install Mod ] [ List Files ] [ Delete ]
20. SMFPacks WYSIWYG Editor 2.0.7 [ Uninstall ] [ List Files ] [ Delete ]
21. SMFPacks Personal Conversations 1.0.3 [ Install Mod ] [ List Files ] [ Delete ]
22. Stop Spammer 2.3.9 [ Install Mod ] [ List Files ] [ Delete ]
Red: these mods errored when I tried to install. Since one of these is a stop spam mod, any advice on a good replacement would be much appreciated. Other than the topic and board note, these are not yet the priority so I am not listing the specific errors...yet.
Pink: Perhaps no big deal...as you can see, these did not offer an install link. Does this mean they are active? What does it mean? These may have been like this before--there were a couple, but I cannot recall which ones.
#13. Bad BehaviorI have not yet installed Bad Behavior because it warned that I need to set my timezone in .htacess. Seems simple--it gave an example. I searched in cpanel and it showed me where .htaccess is, but when I went there I could not see it. Is it hidden?
#16. Advanced Topic Prefix ModQuote from: Sir Osis of Liversave the topic prefix mod for last if you must have it, it was screwed up and blocking access to your ACP.
What is ACP?
This is a mod I purchased from smfpacks and it is very important to me--it gives me a function I had been dreaming about. I use the topic prefixes to sort threads unto personal stories (storybook icons) versus a few discussion topics and some boards have their own. I did this with basic icons before, but the system did not understand they had meaning other than that they were images. But with this mod I can sort them and view only a certain icon or a few at a time. Just that has been amazing for me--I'd love more advanced features, but this is still great.
I really want to be able to reinstall this mod AND my big concern is for the threads--will the prefixes be restored? As for that, will the topic icons (which match the prefixes) also be able to be restored? I know that I will need to re-upload my custom images, but once that is done, is the basic info still stored in the db? I kept the topic icons (instead of finding a way to get rid of or hide them) in case something happened and I could no longer use the prefix mod...but right now I have neither since the icons are the default.
I think those are the issues on my mind thus far.
Your error is caused by the Topic & Board Note mod. You can try to uninstall it and see if the errors will go away.
"What is ACP?"
That would be Admin Control Panel. As doug_lps suggests, try to uninstall the Topic and Board Notes mod, if it uninstalls successfully that error will no longer occur. Sometimes you can follow the error messages e.g. this one:
"Field 'topic_note' doesn't have a default value
File: /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php
Line: 1816"
You could edit the file Subs-Post.php and remove the field 'topic_note'. Then try to post again. You would either be able to post or receive another error messages, you can then edit the file for that error message and so on. This is what I did to remove problems caused by the Board Color and Icons Mod. You may also have to drop some DB columns if you get relevant error messages. However, first thing to try is an uninstall of Topic and Board Notes.
the error is related to your database. you need to find the tables that have those columns and if you dont plan on using the mods again you can remove the column from the table and the error will go away.
you said you have a clean set of files so the mods should not be installed.
Thank you Illori...the topic and board note mod is not installed--I thought I had made that clear in my post since I said the red mods error when I attempted to install them. The hope was that the error would be resolved when the mod was installed, but that did not happen--I did not continue to install any mods that showed an error.
I know that it is in the database--as I have another issue that has not been resolved for an entire year that has a similar message--different mod. I have not looked to see if that is the same since the clean install, but a year ago you guys helped me to try to do a few fixes in the db--like dropping the tables. That particular issue has not been resolved, but it is unrelated.
Since I don't want to make a mistake when messing with the database, could you give me some instructions for removing the necessary tables--or is it as easy as finding it and deleting it?
Did you have that mod installed at any point? Because the error message points to it. Anyways, can you check your boards table in the database and see if it contains the board_note column?
Quote from: PenelopeQ on February 25, 2018, 02:53:20 AM
I can PM, but cannot post (replies or start a thread). I got this error:QuoteField 'topic_note' doesn't have a default value
File: /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php
Line: 1816
I also received an error when trying to install the topic and board note mod mentioned in that error:QuoteBLOB/TEXT column 'board_note' can't have a default value
File: /home/rollerco/public_html/mlcforum/Packages/temp/add_settings2.0.php
Line: 73
HI PenelopeQ ... you appear to have at least two errors:
1. One is the column board_note in your boards table, you need to have a look, perhaps with PhpMyAdmin, find that column and drop it.
2. The second is left over code in your Subs-Post.php file. This is puzzling if, as you say, you now have a clean install ... so that code shouldn't be in that file.
Regardless, first drop the column from your boards table and see if that resolves your error. You may need to then have a look at your Subs-Post.php file at line 1816 and delete the field "topic_note".
I have found the board_note column. Can I rename it board_note_bak or something so that I am saving it in case it is needed? Or do I need to delete it completely to test if it works?
Regarding the field in subs_post.php, there is no topic_note filed anywhere--not at or near line 1816 or anywhere else. I searched the entire file and then even searched just for the word note and just for the word topic to see if there was something similar...I found nothing.
Quote from: PenelopeQ on February 25, 2018, 04:26:52 PM
I have found the board_note column. Can I rename it board_note_bak or something so that I am saving it in case it is needed? Or do I need to delete it completely to test if it works?
Regarding the field in subs_post.php, there is no topic_note filed anywhere--not at or near line 1816 or anywhere else. I searched the entire file and then even searched just for the word note and just for the word topic to see if there was something similar...I found nothing.
OK, just being cautious regarding the field in Subs-Post.php, good that it isn't there.
You won't need the board_note column as it was installed by Topic and Board Notes which you say you don't want to install again, you can safely drop it.
I dropped the column.
So now what about the missing field? Sure, good it's not there except that the error makes it sound as though it is there and how can I remove the field so I don't get an error if the field is not there.
And you are right...with a clean install that code shouldn't be there.
There must be something somewhere else that perhaps is expecting that field to be in that file??? Something that is still leftover from the Topic and Board Note mod???
As of now I am at a loss regarding what to do since the logical step seemed to be to remove the field from the file.
if the column is dropped the error should no longer happen. it was happening because no default was set for that column so even though the code did not call it, the database had no idea what to fill in that space. now it does not need to fill it as it is gone.
Quote from: PenelopeQ on February 25, 2018, 04:53:34 PM
I dropped the column.
So now what about the missing field? Sure, good it's not there except that the error makes it sound as though it is there and how can I remove the field so I don't get an error if the field is not there.
And you are right...with a clean install that code shouldn't be there.
There must be something somewhere else that perhaps is expecting that field to be in that file??? Something that is still leftover from the Topic and Board Note mod???
As of now I am at a loss regarding what to do since the logical step seemed to be to remove the field from the file.
Indeed, if that field is removed the error should not happen anymore.
Can you check the temp folder inside the packages directory btw, and see if it contains a file named: add_settings2.0.php?
Quote from: doug_ips on February 25, 2018, 05:19:00 PM
Quote from: PenelopeQ on February 25, 2018, 04:53:34 PM
I dropped the column.
So now what about the missing field? Sure, good it's not there except that the error makes it sound as though it is there and how can I remove the field so I don't get an error if the field is not there.
And you are right...with a clean install that code shouldn't be there.
There must be something somewhere else that perhaps is expecting that field to be in that file??? Something that is still leftover from the Topic and Board Note mod???
As of now I am at a loss regarding what to do since the logical step seemed to be to remove the field from the file.
Indeed, if that field is removed the error should not happen anymore.
Can you check the temp folder inside the packages directory btw, and see if it contains a file named: add_settings2.0.php?
There may also be a column "allow_topic_note" and another ""topic_note" in your board table, it would have been added by the file doug_lps mentions above "add_settings2.0.php".
Quote from: pepa on February 25, 2018, 05:25:21 PM
Quote from: doug_ips on February 25, 2018, 05:19:00 PM
Quote from: PenelopeQ on February 25, 2018, 04:53:34 PM
I dropped the column.
So now what about the missing field? Sure, good it's not there except that the error makes it sound as though it is there and how can I remove the field so I don't get an error if the field is not there.
And you are right...with a clean install that code shouldn't be there.
There must be something somewhere else that perhaps is expecting that field to be in that file??? Something that is still leftover from the Topic and Board Note mod???
As of now I am at a loss regarding what to do since the logical step seemed to be to remove the field from the file.
Indeed, if that field is removed the error should not happen anymore.
Can you check the temp folder inside the packages directory btw, and see if it contains a file named: add_settings2.0.php?
There may also be a column "allow_topic_note" and another ""topic_note" in your board table, it would have been added by the file doug_lps mentions above "add_settings2.0.php".
Yes, that is correct. That file adds the custom fields in the database. If the mod is uninstalled, and the custom fields have been removed from the database, it is strange that the error still happens. The only thing that I can think of is that the installer file of that mod has not been deleted and it might be the culprit.
P.s. To make real sure that everything of that mod has been gone, it is worth going through the parser and double check all the files that it has edited are indeed gone.
Smf does not typically remove databae columns when removing a mod...
As for the error, it is due to your MySQL version. MySQL fixed it in some future version from the one you are using.
Sorry, I should have said that I tried to post after dropping the column and got the same error.
Quote from: pepa on February 25, 2018, 05:25:21 PMThere may also be a column "allow_topic_note" and another ""topic_note" in your board table, it would have been added by the file doug_lps mentions above "add_settings2.0.php".
dropped allow_topic_note and did not find topic_note. Tried to post and got the same error.
Quote from: doug_ips on February 25, 2018, 05:19:00 PMCan you check the temp folder inside the packages directory btw, and see if it contains a file named: add_settings2.0.php?
How do I find the temp directory--I just looked in my packages folder and did not see a temp folder.
Quote from: Kindred on February 25, 2018, 06:03:24 PMSmf does not typically remove databae columns when removing a mod...
As for the error, it is due to your MySQL version. MySQL fixed it in some future version from the one you are using.
So am I just chasing my tail then? Maybe that is the problem with the issue I had last year that is not resolved--can't add new boards.
Is this something I need to talk to my host about? Or what?
Whew, thanks to all of you staying with me...
post the error from the error log you are getting. it should be a different error if you removed that column.
The error log in cpanel?
Maybe I'm at the wrong place...it is short--extremely short given that we are having a big issue and lots of people should be getting the error.
[Sun Feb 25 17:55:54.840066 2018] [:error] [pid 426278] [client 197.221.253.26:24419] File does not exist: /home/rollerco/public_html/mlcforum/wp-login.php
[Sun Feb 25 17:49:54.908516 2018] [:error] [pid 420493] [client 37.228.231.153:26401] File does not exist: /home/rollerco/public_html/mlcforum/wp-login.php
[Sun Feb 25 17:40:40.283189 2018] [:error] [pid 412646] [client 190.163.124.157:59416] File does not exist: /home/rollerco/public_html/mlcforum/wp-login.php
[Sun Feb 25 17:27:04.466963 2018] [:error] [pid 400208] [client 188.206.106.176:3491] File does not exist: /home/rollerco/public_html/mlcforum/wp-login.php
Quote from: Illori on February 25, 2018, 07:52:20 PM
post the error from the error log you are getting. it should be a different error if you removed that column.
PenelopeQ, post the current error message, although you did say it's the same, but please just to confirm.
The temp folder that doug_lps refers to would be in Packages/temp but you'd have to ftp there. I doubt that'd be the problem though.
Perhaps post your host's version of MySQL so Kindred can confirm that it is indeed the issue you are encountering. I have not heard of this issue myself.
Quote from: PenelopeQ on February 25, 2018, 09:38:50 PM
The error log in cpanel?
Maybe I'm at the wrong place...it is short--extremely short given that we are having a big issue and lots of people should be getting the error.
[Sun Feb 25 17:55:54.840066 2018] [:error] [pid 426278] [client 197.221.253.26:24419] File does not exist: /home/rollerco/public_html/mlcforum/wp-login.php
[Sun Feb 25 17:49:54.908516 2018] [:error] [pid 420493] [client 37.228.231.153:26401] File does not exist: /home/rollerco/public_html/mlcforum/wp-login.php
[Sun Feb 25 17:40:40.283189 2018] [:error] [pid 412646] [client 190.163.124.157:59416] File does not exist: /home/rollerco/public_html/mlcforum/wp-login.php
[Sun Feb 25 17:27:04.466963 2018] [:error] [pid 400208] [client 188.206.106.176:3491] File does not exist: /home/rollerco/public_html/mlcforum/wp-login.php
The original error which you say hasn't changed and which you described as:
"I can PM, but cannot post (replies or start a thread). I got this error:"
This will be in your Admin/Maintenance/Logs/Error Log
Just getting back to this, server errors -
[25-Feb-2018 13:55:15 US/Pacific] PHP Warning: in_array() expects parameter 2 to be array, null given in /home/rollerco/public_html/mlcforum/Sources/Security.php on line 831
[25-Feb-2018 13:55:15 US/Pacific] PHP Notice: Undefined index: permissions in /home/rollerco/public_html/mlcforum/Sources/Security.php on line 831
[25-Feb-2018 13:55:15 US/Pacific] PHP Warning: in_array() expects parameter 2 to be array, null given in /home/rollerco/public_html/mlcforum/Sources/Security.php on line 831
[25-Feb-2018 13:55:15 US/Pacific] PHP Notice: Undefined index: permissions in /home/rollerco/public_html/mlcforum/Sources/Security.php on line 831
[25-Feb-2018 13:55:15 US/Pacific] PHP Warning: in_array() expects parameter 2 to be array, null given in /home/rollerco/public_html/mlcforum/Sources/Security.php on line 831
[25-Feb-2018 13:55:15 US/Pacific] PHP Notice: Undefined index: permissions in /home/rollerco/public_html/mlcforum/Sources/Security.php on line 831
[25-Feb-2018 13:55:15 US/Pacific] PHP Warning: in_array() expects parameter 2 to be array, null given in /home/rollerco/public_html/mlcforum/Sources/Security.php on line 831
[25-Feb-2018 16:00:28 US/Pacific] PHP Notice: Undefined index: server in /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php on line 627
[25-Feb-2018 16:00:28 US/Pacific] PHP Notice: Undefined index: utf8 in /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php on line 1262
[25-Feb-2018 16:00:28 US/Pacific] PHP Notice: Undefined index: utf8 in /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php on line 1264
[25-Feb-2018 16:00:28 US/Pacific] PHP Notice: Undefined index: server in /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php on line 627
[25-Feb-2018 16:00:28 US/Pacific] PHP Notice: Undefined index: utf8 in /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php on line 1262
[25-Feb-2018 16:00:28 US/Pacific] PHP Notice: Undefined index: utf8 in /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php on line 1264
[25-Feb-2018 16:00:28 US/Pacific] PHP Notice: Undefined index: server in /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php on line 627
[25-Feb-2018 16:00:28 US/Pacific] PHP Notice: Undefined index: utf8 in /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php on line 1262
[25-Feb-2018 16:00:28 US/Pacific] PHP Notice: Undefined index: utf8 in /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php on line 1264
She's running php 7.0.27, mysqli 5.6.35, reinstalling mods from old zips from previous install. Mods may be having problems with php 7. I currently have ftp access only, not much I can do.
Quote from: pepa on February 25, 2018, 09:51:06 PMPenelopeQ, post the current error message, although you did say it's the same, but please just to confirm.
Field 'topic_note' doesn't have a default value
File: /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php
Line: 1816
Quote from: Illori on February 25, 2018, 07:52:20 PM
post the error from the error log you are getting. it should be a different error if you removed that column.
Today at 08:42:48 PM
Apply Filter: Only show the error messages of this session 103ad93ee6e772589a55446ce3cc8303
Apply Filter: Only show the errors of this type Type of error: Database
Apply Filter: Only show the error messages of this URLhttp://mlcforum.theherosspouse.com/index.php?action=post2;start=0;board=1Apply Filter: Only show the errors with the same messageDatabase Error: Field 'topic_note' doesn't have a default valueApply Filter: Only show the errors from this file File: /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php
Line: 1816
Those Undefined index errors happen when you're trying to access items in an array that doesn't exist. But those other errors about that mod fields are starnge. If the mod has been completely uninstalled they should not happen. Did you go through the parser and double checked all the files that that mod edits?
Quote from: doug_ips on February 26, 2018, 03:38:20 AM
Those Undefined index errors happen when you're trying to access items in an array that doesn't exist. But those other errors about that mod fields are starnge. If the mod has been completely uninstalled they should not happen. Did you go through the parser and double checked all the files that that mod edits?
Yep, I've been trying to understand this and doesn't make any sense to me if, as you say, you have a completely clean set of files and haven't installed any mods. I also don't understand what Kindred means when he says that's a MySQL error from an earlier version, perhaps he can enlighten us now that we know the version is 5.6.35.
Still I don't understand how a completely clean set of files could be throwing out those mod field errors, especially as you say you've dropped all the related columns from the DB. Surely there has to be some vagrant mod code still in your files?
are you sure you modified the correct database table to drop the column? sometimes if you upgraded SMF over time you may have had backup tables. what was the name of the database and table you modified?
Quote from: Illori on February 26, 2018, 05:09:02 AM
are you sure you modified the correct database table to drop the column? sometimes if you upgraded SMF over time you may have had backup tables. what was the name of the database and table you modified?
I am sure of nothing. ???
I just went to the table people said to and deleted the columns people said to--accept there was not a topic_note column.
Table Name: rollerc3_boards
Columnsallow_topic_note
board_note
Only on for a minute, will be on for a while tonight. Just for background, here (https://www.simplemachines.org/community/index.php?topic=558696.0) is the original topic. As you can see, OP was mixing files which probably broke mods. As recommended, she tried uploading clean set of files, but got partial upload due to account exceeding disk capacity limit. This made the mixed file problem worse. She had host increase disk capacity, I moved forum from root to subdir to clear root, uploaded 2.0.15 upgrade package, reset theme to Curve and got forum running, squeaky clean install. OP reinstalled theme, and has been reinstalling mods. I do not have sufficient access at this point to help much.
Not sure if this is any help but I get this message when I try to post.
Field 'topic_note' doesn't have a default value
File: /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php
Line: 1816
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.1. The above error might possibly go away if you execute the latest version of upgrade.php.
Quote from: oldpilot on February 26, 2018, 01:13:52 PM
Not sure if this is any help but I get this message when I try to post.
Field 'topic_note' doesn't have a default value
File: /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php
Line: 1816
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.1. The above error might possibly go away if you execute the latest version of upgrade.php.
You must upgrade the database as it appears to be of a lower version that does not match your forum files.
But your error points to the board note as well. You can read some of the suggestions posted here on this topic about that error.
Quote from: doug_ips on February 26, 2018, 02:01:09 PM
Quote from: oldpilot on February 26, 2018, 01:13:52 PM
Not sure if this is any help but I get this message when I try to post.
Field 'topic_note' doesn't have a default value
File: /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php
Line: 1816
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.1. The above error might possibly go away if you execute the latest version of upgrade.php.
You must upgrade the database as it appears to be of a lower version that does not match your forum files.
But your error points to the board note as well. You can read some of the suggestions posted here on this topic about that error.
no you dont need to upgrade the database, as there are no changes. please research before you tell people what to do.
Quote from: PenelopeQ on February 26, 2018, 11:18:46 AM
Quote from: Illori on February 26, 2018, 05:09:02 AM
are you sure you modified the correct database table to drop the column? sometimes if you upgraded SMF over time you may have had backup tables. what was the name of the database and table you modified?
I am sure of nothing. ???
I just went to the table people said to and deleted the columns people said to--accept there was not a topic_note column.
Table Name: rollerc3_boards
Columns
allow_topic_note
board_note
What Ilori means is if you dropped those columns from the right database. i.e. the database that you have used to install your forum. If you are not sure about its name, you can see it at the Settings.php file.
Quote from: Illori on February 26, 2018, 02:02:22 PM
Quote from: doug_ips on February 26, 2018, 02:01:09 PM
Quote from: oldpilot on February 26, 2018, 01:13:52 PM
Not sure if this is any help but I get this message when I try to post.
Field 'topic_note' doesn't have a default value
File: /home/rollerco/public_html/mlcforum/Sources/Subs-Post.php
Line: 1816
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.1. The above error might possibly go away if you execute the latest version of upgrade.php.
You must upgrade the database as it appears to be of a lower version that does not match your forum files.
But your error points to the board note as well. You can read some of the suggestions posted here on this topic about that error.
no you dont need to upgrade the database, as there are no changes. please research before you tell people what to do.
Why is that error message happening then, with the suggestion that it needs an upgrade?
it was thought that it would be useful, but it is not necessary any longer.
Quote from: Illori on February 26, 2018, 02:07:42 PM
it was thought that it would be useful, but it is not necessary any longer.
What was thought that it would be useful, the error message? Anyways, if it is not necessary, why not remove it as it can be confusing.
it has been removed from SMF 2.1.
Quote from: Illori on February 26, 2018, 02:12:48 PM
it has been removed from SMF 2.1.
That is good to know. What about the latest version(s) of 2.0? Will it be removed from there as well?
no.
Emailed the host--I have an open support ticket, so we've been going back-and-forth for a few weeks.
Quote from: hostYou wont' find that column in the file, it's in your MySQL database. You can't view the database directly (you have to use a tool like phpMyAdmin).
This is not a MySQL bug, it's just bad coding (they may disagree).
...
The 'topic_note' column is defined as a 'text' column (can store a large volume of text) and required. The database is rejecting the data because SMF is not giving the column a value, but it's been told that the column requires a value. Normally you can fix this with what is called a default value (something that will get filled in if nothing is given) but text columns can not have default values.
Again, none of this is a MySQL bug because the database is doing exactly what it's been told to do. If you would like we can modify that column to change it from be required to being not required and that 'may' fix your issue (or there may be other issues just like this).
This column appears to be part of the SMF private messages so I would think that the forum would work, but not the private message system.
I gave him the go ahead to modify the column. He then asked me for the error message and where I see it and I sent that.
He said he is going to make the column not required.
Quote from: PenelopeQ on February 26, 2018, 07:11:28 PM
Emailed the host--I have an open support ticket, so we've been going back-and-forth for a few weeks.
Quote from: hostYou wont' find that column in the file, it's in your MySQL database. You can't view the database directly (you have to use a tool like phpMyAdmin).
This is not a MySQL bug, it's just bad coding (they may disagree).
...
The 'topic_note' column is defined as a 'text' column (can store a large volume of text) and required. The database is rejecting the data because SMF is not giving the column a value, but it's been told that the column requires a value. Normally you can fix this with what is called a default value (something that will get filled in if nothing is given) but text columns can not have default values.
Again, none of this is a MySQL bug because the database is doing exactly what it's been told to do. If you would like we can modify that column to change it from be required to being not required and that 'may' fix your issue (or there may be other issues just like this).
This column appears to be part of the SMF private messages so I would think that the forum would work, but not the private message system.
I gave him the go ahead to modify the column. He then asked me for the error message and where I see it and I sent that.
He said he is going to make the column not required.
Hi PenelopeQ ... we may be making some genuine progress here ... hopefully : )
Looks like Illori may be right on the money, in a previous post you said:
Quote from: PenelopeQ on February 26, 2018, 11:18:46 AM
Quote from: Illori on February 26, 2018, 05:09:02 AM
are you sure you modified the correct database table to drop the column? sometimes if you upgraded SMF over time you may have had backup tables. what was the name of the database and table you modified?
I am sure of nothing. ???
I just went to the table people said to and deleted the columns people said to--accept there was not a topic_note column.
Table Name: rollerc3_boards
Columns
allow_topic_note
board_note
But now your host says the column "topic_note" is in the database. So not sure where you were looking, but, as your host says, you needed to be looking for that column in your database using PhpMyAdmin. Now if that is what you were doing then I can only presume you were looking in the wrong database .. therefore Illori's suggestion that you could have more than one database may be correct ... his previous comment was:
"are you sure you modified the correct database table to drop the column? sometimes if you upgraded SMF over time you may have had backup tables. what was the name of the database and table you modified?"
If all of that makes sense to you then ask your host if there are other 'backup' databases?
Also your hosts comment, "This column appears to be part of the SMF private messages so I would think that the forum would work, but not the private message system."
.... needs to be considered, sorry I don't have spare time at the moment ... the comment doesn't sound right, I'm unfamiliar with the mod concerned. Can someone check this please?
Lastly doug_ips ... I agree that error message about the database needing an upgrade is confusing. I've encountered it before and learned to ignore it.
It is actually a known bug in the MySQL version that they are using. Look it up... the bug existed for a few versions and then MySQL fixed it in later versions.
They are partially right... in a strict environment, the column should have a default value, but MySQL admitted that it was actually a problem and deemed it a bug.
Our forum is now up and running, although their are some issues that I am sure Penelope will address but at least we can post and send PM's until the bells and whistles can get addressed.
Thanks for everyones help.
Happy to hear that the error has been fixed.
Quote from: oldpilot on February 27, 2018, 09:58:45 AM
Our forum is now up and running, although their are some issues that I am sure Penelope will address but at least we can post and send PM's until the bells and whistles can get addressed.
Thanks for everyones help.
Good to hear and also that you can send PM's, couldn't see how the column 'topic_note', as your host was saying, was part of the PM system.
Quote from: pepa on February 27, 2018, 04:48:24 PM
Quote from: oldpilot on February 27, 2018, 09:58:45 AM
Our forum is now up and running, although their are some issues that I am sure Penelope will address but at least we can post and send PM's until the bells and whistles can get addressed.
Thanks for everyones help.
Good to hear and also that you can send PM's, couldn't see how the column 'topic_note', as your host was saying, was part of the PM system.
That was strange indeed. As far as I could see at that mod 's code, the custom fieelds that it added were to the board table. It did not add anything to tables related to personal messages.
Next issue after clean install...
Let me know if I should make this a new topic. I'm keeping it simply because this is all a continuation of issues from the clean install.
I am resetting my custom message icons. I had to reupload them through ftp and that went well, though it took awhile for them to repopulate through the system.
I had edited a few of them since originally uploading them years ago--making them clearer. Well my original files were now larger and I uploaded those instead of resizing first. I then fixed that and overwrote them. Great, one of the three that were large is still showing up large and it has been two days.
Initially I thought two of the three were not resizing, but I was using the original name that came with the emoticons--Inhad overwritten some emoticons with my images so that back in 2010 I did not have to actually reset the names in admin, they just looked different. Well when I changed the name just now to the name of the actual image, it showed up with the resized image. Great--though odd that the other file with an identical image, but different name is still showing large.
So I then tried to change the final icon that is showing large to its appropriate name and it errors:
QuoteThe icon image could not be found in the default theme - please ensure the image has been uploaded and try again.
I have double checked that I uploaded the icons to the correct location--I did a search in cpanel to find all instance of the files and they were in the proper place.
I feel confident I have because the other icons are in that file and working perfectly. I also did a search in cpanel for the files and they were all together (those that work and those that do not work). I then viewed them in cpanel and all the images are the appropriate size--those with emoticon names and my image and those with the names I gave them.
If I have confused antone with this naming and renaming it is pretty simple. Here is an example: angry.gif and Green_Monster.gif are identical images of a green monster face.
Which icon is not working? Green_Monster.gif and angry.gif are identical, both are 40x40. The icons must be in /Themes/Curve_Multi_Color/images/post.
Quote from: PenelopeQ on February 28, 2018, 01:05:55 PM
Next issue after clean install...
Let me know if I should make this a new topic. I'm keeping it simply because this is all a continuation of issues from the clean install.
I am resetting my custom message icons. I had to reupload them through ftp and that went well, though it took awhile for them to repopulate through the system.
I had edited a few of them since originally uploading them years ago--making them clearer. Well my original files were now larger and I uploaded those instead of resizing first. I then fixed that and overwrote them. Great, one of the three that were large is still showing up large and it has been two days.
Initially I thought two of the three were not resizing, but I was using the original name that came with the emoticons--Inhad overwritten some emoticons with my images so that back in 2010 I did not have to actually reset the names in admin, they just looked different. Well when I changed the name just now to the name of the actual image, it showed up with the resized image. Great--though odd that the other file with an identical image, but different name is still showing large.
So I then tried to change the final icon that is showing large to its appropriate name and it errors: QuoteThe icon image could not be found in the default theme - please ensure the image has been uploaded and try again.
I have double checked that I uploaded the icons to the correct location--I did a search in cpanel to find all instance of the files and they were in the proper place.
I feel confident I have because the other icons are in that file and working perfectly. I also did a search in cpanel for the files and they were all together (those that work and those that do not work). I then viewed them in cpanel and all the images are the appropriate size--those with emoticon names and my image and those with the names I gave them.
If I have confused antone with this naming and renaming it is pretty simple. Here is an example: angry.gif and Green_Monster.gif are identical images of a green monster face.
Have you tried a) reuploading the file that is misbehaving, b) forcing a refresh of your browser cache?
Fixed this a while ago, you can mark it solved.
Will do. Mind sharing the solution? What was wrong?
A variety of glitches involving theme and mod installs. Missing icons were due to a combination of missing files (I had backups), incorrect paths, and at least one https image link that wouldn't load in http. She's using Curve Multi Color, the original version installed in /Themes/CurveMultiColor/, newer version installed in /Themes/Curve_Multi_Color/, that didn't help. And we just had another problem with the mysql bug, prevented them from posting new topics. :P