Global Topics

[Ninja ZX-10RR]

Hi ,

This message show on my site.

"Unknown column 'b.global_topics' in 'field list'"

Please tell margarett in which file it happens (a screenshot of your error log would be a good thing), when it happens, if it happens with all users, if you have a custom theme (and which one), if the installation was all successfull or not and also which version of SMF you are using.

[1985]

Hi ,

This message show on my site.

"Unknown column 'b.global_topics' in 'field list'"

Please tell margarett in which file it happens (a screenshot of your error log would be a good thing), when it happens, if it happens with all users, if you have a custom theme (and which one), if the installation was all successfull or not and also which version of SMF you are using.

It' s my fault. I didn't automatic install this mod . But I fix my site already.
And now I don't know how to post the global topic.

[Ninja ZX-10RR]

See the screenshots in here --> http://custom.simplemachines.org/mods/index.php?mod=1723
And also you just have to edit a post and you will find a button for it if the permissions are set properly

[1985]

I set it already. But I just don't know how to post. And then I find the button below the topic. Thank for chat with me.

[Ninja ZX-10RR]

Just post as any other post and click on that button it should set the topic as global and make it first in each board of your forum

[RSI]

Hello, I found an issue with this mod.

When you make a topic global it adds a "1" in the is_global column within the smf_topics table in the database. Then if you go back and make the topic not global is changes that value to "0". The problem is it needs to make it a blank again and not a "0"

Once you go back and make a topic not global and it changes the value to "0" the forum sort order is messed up and that topic always stays at the top of the forum. I had to go into my db manually and remove the "0" to correct those topics.

Is there a way to manually edit the modification code in my existing install to correct the problem?

Thanks

[Arantor]

Thing is, is_global is a signed tinyint, that means its range of values is numbers only from -128 to +127. If you 'remove the 0' as you put it, all it's going to do is become 0 again... (the column is defined as NOT NULL, or should be, so it *will* be a number)

[RSI]

Thing is, is_global is a signed tinyint, that means its range of values is numbers only from -128 to +127. If you 'remove the 0' as you put it, all it's going to do is become 0 again... (the column is defined as NOT NULL, or should be, so it *will* be a number)

But.., that's not what is happening. When you create a topic the value in the is_global column is blank by default. No "0" or "1" It does not create that value until you make a topic global. As soon as I remove the "0" is corrects the forum sort order.

I understand what you are saying, but this mod does create the problem nevertheless. If you go back and make any topic not global that topic will just stay at the top of the forum for life.

[Arantor]

I just created a topic with this mod installed, and it defaulted to 0 in the database. If you don't specify it in the PHP, it's going to be set to the table default which is 0.

Dude, I do not know what you're doing but I physically cannot put any value other than a number into that column.

Also, the mod works fine for me.

[margarett]

Check that you're using the latest version. This was in fact an issue in previous version but it was fixed meanwhile.

[RSI]

Attached below is a screenshot of my smf_topics table and the is_global column is blank in each row. If I create a global topic it makes the value in the column a "1" If I go back and make it not global it changes it to "0" I have to make it blank again to correct the sort order.

I no longer know which version I have installed. Backup files have been delete since then. I believe it was the second one uploaded a few weeks ago right after the first initial update. If it was corrected can you please tell me which file to check. I can parse it for v2.0.7 via the mod's page and see what's missing, etc.

[margarett]

Yes, you are not running the latest version. Please uninstall that (remember to choose to remove associated data) and install the newest one from the modsite.
If you check the latest posts, that same issue was discussed

Edit: reference http://www.simplemachines.org/community/index.php?topic=301482.msg3693935#msg3693935

[RSI]

Yes, you are not running the latest version. Please uninstall that (remember to choose to remove associated data) and install the newest one from the modsite.
If you check the latest posts, that same issue was discussed

I cannot auto uninstall it. Those backup files have been deleted and other mods have been installed since. I must do it manually.

I just need to know where to look, which file(s). I can run a query to make all of the blanks "0", but that's not going to help if I create standard topics that still leave the rows blank.

Thanks

[margarett]

Yup, one of the latest issues was exactly the same
http://www.simplemachines.org/community/index.php?topic=301482.msg3698052#msg3698052

[RSI]

Yup, one of the latest issues was exactly the same
http://www.simplemachines.org/community/index.php?topic=301482.msg3698052#msg3698052

Surprisingly all of the code in each of the pages was up to date so I must have the latest version already installed. I ran the queries and it corrected the problem. The is_global column must have gotten screwed up and defaulted back when I ran the repair_settings.php tool about 2 weeks ago. I have a few of my own custom mods installed and I had an issue one day and had to remove all of the hooks then reinstall them.

Just out of curiosity why is it that several of the mods I've looked at on the mod page have been updated several times, but only one file exists for download? If you guys are making changes and even due to a mistake you should really leave all of the files there even with the mistakes so people can go back and figure out what to do. Without a trail backwards its often hard to correct problems.

[Ninja ZX-10RR]

So basically he wants to see the changes log...

[RSI]

So basically he wants to see the changes log...

No, what I mean is...
   
GlobalTopics_v1.0.0.zip
GlobalTopics_v1.0.1.zip
GlobalTopics_v1.0.2.zip

or

GlobalTopics_v1.0.0.zip
GlobalTopics_v1.0.1a.zip
GlobalTopics_v1.0.1b.zip

etc.

It's just an observation, but I've noticed a lot of people are not doing that and are just overwriting the same file and all of the previous versions are gone

[Arantor]

Yes because experience teaches us that users invariably just click the first link on the list, which is usually the old one.

I would love to know how come you don't have the old version... since the zip file should be in your Packages folder, or failing that, something useful should be in Packages/backups which should include a backup before any mod installation/uninstallation.

[RSI]

Yes because experience teaches us that users invariably just click the first link on the list, which is usually the old one.

I would love to know how come you don't have the old version... since the zip file should be in your Packages folder, or failing that, something useful should be in Packages/backups which should include a backup before any mod installation/uninstallation.

Well, many of the mods do have several versions and it comes up with the radio button already selected for the latest version, but I do understand its not a full proof solution. Maybe having an archive link that would bring up the older files instead or something.

I only have a few select mods on my board some of which I found here and the rest are my own mods so once everything is working properly I really have no reason to keep outdated versions. I guess I should probably rethink though and just keep a special archive folder on the server for everything I have installed old or new.

[Arantor]

That requires major rewriting of the software in question and that's been attempted at least 3 times over the last 5 years and not happened yet.

I still do not understand why you don't have the mods you installed in the packages folder on your site.