Recent posts

#61

SMF 2.1.x Support / Re: Upgrading from SMF 2.0.16

Last post by Sir Osis of Liver - December 06, 2023, 09:19:35 PM

#62

SMF 2.1.x Support / Re: Upgrading from SMF 2.0.16

Last post by dpbronco - December 06, 2023, 09:10:25 PM

That may be the wrong table, I'd expect to see karma in members.  Run this query to find the column -

Code Select Expand


SELECT table_name,table_schema
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name='karma_bad'


Don't see a karma mod for 2.1, and 2.0 karma feature was removed from 2.1, so you shouldn't need either karma column.  You can click on "Structure" for the table where you find it, and drop the columns.

Just checking 2.0, karma_good and karma_bad are in members table.

YOU! ARE! THE! MAAAAAAAAAAAAAAAAAAAAAN! THANK YOU!

#63

SMF 2.1.x Support / Mobile Viewport Member Avatars...

Last post by ColinJM - December 06, 2023, 09:07:38 PM

Hi All and Seasons Greetings 

I want to encourage my members to use Avatars. Many of them use mobile/cell phones for viewing the forum, which of course CSS suppresses the display of Avatars in mobile viewports.

Yes, I've read the different views on this is other threads but the css mod to responsive.css doesn't seem to tie in with my SMF 2.1.4 - SMF Default Theme Curve 2?

#64

SMF 2.1.x Support / Re: Upgrading from SMF 2.0.16

Last post by Sir Osis of Liver - December 06, 2023, 08:59:13 PM

That may be the wrong table, I'd expect to see karma in members.  Run this query to find the column -

Code Select Expand


SELECT table_name,table_schema
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name='karma_bad'


Don't see a karma mod for 2.1, and 2.0 karma feature was removed from 2.1, so you shouldn't need either karma column.  You can click on "Structure" for the table where you find it, and drop the columns.

Just checking 2.0, karma_good and karma_bad are in members table.

#65

SMF 2.1.x Support / Re: Upgrading from SMF 2.0.16

Last post by dpbronco - December 06, 2023, 08:47:50 PM

In phpmyadmin, click on your forum database in left panel.  If you don't know your database name, look for $db_name in Settings.php.  When database tables are displayed in right panel, click on "SQL" in top menu, copy Kindred's query into the text box and click "Go" bottom left.  Backup the database before attempting this.

No dice, error message

#66

Modifications and Packages / Re: Drafts

Last post by 22wareagle22 - December 06, 2023, 08:29:37 PM

Since id_draft is autoincrement, why not just insert without even that (no need to truncate the current table if you're not porting draft ids over and you don't need to)

Arantor would it be possible for you to reach out to me? I need your help.

#67

SMF 2.0.x Support / Re: Upgrading SMF 2.0.12 to 2....

Last post by Sir Osis of Liver - December 06, 2023, 08:29:26 PM

https://wiki.simplemachines.org/smf/SMF2.1:Requirements_and_recommendations

#68

SMF 2.1.x Support / Re: Moderator title

Last post by Senkusha - December 06, 2023, 08:26:52 PM

Yeah, I was talking about the line on the board that describes the "Moderator".  Sorry about the confusion.  I should have specified.  I honestly never considered changing the name of the Moderator Membergroup.

#69

SMF 2.1.x Support / Re: Upgrading from SMF 2.0.16

Last post by Sir Osis of Liver - December 06, 2023, 08:26:24 PM

In phpmyadmin, click on your forum database in left panel.  If you don't know your database name, look for $db_name in Settings.php.  When database tables are displayed in right panel, click on "SQL" in top menu, copy Kindred's query into the text box and click "Go" bottom left.  Backup the database before attempting this.

#70

SMF 2.1.x Support / Re: Upgrading from SMF 2.0.16

Last post by dpbronco - December 06, 2023, 08:16:11 PM

most mods do not uninstall the database updates -- because the method to UDPATE most mods is to uninstall the old version and reinstall the new version.

The **CODE** has nothing to do with this issue.  Your issue is that a database column exists and has not had a default defined. The default is required by modern versions of mySQL.

Code (Run in myphpadmin or other mysql tool) Select Expand

ALTER TABLE `smf_messages` ALTER `karma_bad` SET DEFAULT NULL;


or...

That mod doesn't seem to make any edits in Subs-post.php, tho it does add two columns to the DB.

If this were me, I'd delete those two DB columns 'karma_bad' and 'karma_good' from {db_prefix)messages.

Sorry, I wouldn't know how do do either of these.  I can get to my 'phpmyadmin' but am lost after that.