News:

SMF 2.1.3 has been released! Take it for a spin! Read more.

Main Menu

Global Topics

Started by margarett, March 27, 2009, 10:15:33 AM

Previous topic - Next topic

Ninja ZX-10RR

Quote from: Mr.Bet on June 15, 2014, 10:20:31 AM
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.
Quote from: BeastMode topic=525177.msg3720020#msg3720020
It's so powerful that on this post and even in the two PMs you sent me,you still answered my question very quickly and you're apologizing for the delay. You're the #1 support I've probably ever encountered man, so much respect for that. Thank you, and get better soon.

I'll keep this in my siggy for a while just to remind me that someone appreciated what I did while others didn't.

♥ Jess ♥

STOP EDITING MY PROFILE

1985

Quote from: Flavio93Zena on June 15, 2014, 11:58:32 AM
Quote from: Mr.Bet on June 15, 2014, 10:20:31 AM
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 ;)
Quote from: BeastMode topic=525177.msg3720020#msg3720020
It's so powerful that on this post and even in the two PMs you sent me,you still answered my question very quickly and you're apologizing for the delay. You're the #1 support I've probably ever encountered man, so much respect for that. Thank you, and get better soon.

I'll keep this in my siggy for a while just to remind me that someone appreciated what I did while others didn't.

♥ Jess ♥

STOP EDITING MY PROFILE

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 :)
Quote from: BeastMode topic=525177.msg3720020#msg3720020
It's so powerful that on this post and even in the two PMs you sent me,you still answered my question very quickly and you're apologizing for the delay. You're the #1 support I've probably ever encountered man, so much respect for that. Thank you, and get better soon.

I'll keep this in my siggy for a while just to remind me that someone appreciated what I did while others didn't.

♥ Jess ♥

STOP EDITING MY PROFILE

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

Quote from: ‽ on June 16, 2014, 02:41:38 PM
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.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

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
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

RSI

Quote from: margarett on June 16, 2014, 05:12:07 PM
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

Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

RSI

#94
Quote from: margarett on June 16, 2014, 05:23:54 PM
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...
Quote from: BeastMode topic=525177.msg3720020#msg3720020
It's so powerful that on this post and even in the two PMs you sent me,you still answered my question very quickly and you're apologizing for the delay. You're the #1 support I've probably ever encountered man, so much respect for that. Thank you, and get better soon.

I'll keep this in my siggy for a while just to remind me that someone appreciated what I did while others didn't.

♥ Jess ♥

STOP EDITING MY PROFILE

RSI

Quote from: Flavio93Zena on June 16, 2014, 08:44:54 PM
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

Quote from: ‽ on June 16, 2014, 09:13:37 PM
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.

Advertisement: