Now we Get SQL error when a user tries to subscribe

[macromotion]

My admin ran an SQL utility and fixed it. all set. thanks!

[macromotion]

My system admin just checked. He said there was one file that was in debug mode so he turned that off and rebooted the server. We're still getting the same error. Also, we not getting emails when this...

[macromotion]

This started happening this week. Is any user tries to subscribe to a thread, they now get a lightbox error instead:

• Error Invalid SQL: INSERT INTO subscribediscussion (`userid`,`discussionid`) VALUES(35205,'1269199')

...

[macromotion]

Our IT guy figured it out. The server was out of drive space. He made some room and everything started working again. Thanks

[macromotion]

We've gotten the error "Error fetching forums" a couple times in the past 2 weeks. The first time, I was able to access the admin area and clear the system cache. That fixed things. This time,...

[macromotion]

We reverted the css and that fixed things. Thanks for your help!

[macromotion]

Yup, found that in the template list. it's not in red so that means it's not modified, correct?

...

[macromotion]

I don't... however, I removed all the css_additional styles and saved/reloaded and that didn't help.

header template? is that bare_header?

Actually, I changed to a completely...

[macromotion]

We're on 5.51 now. Not sure what we were on before but we install vb5 back in August of last year. If we can fix the search box, that would be enough. it looks like the search button is...

[macromotion]

Take a look at our search box at the top of the page and also the links at the bottom. Seems like we have a css issue after our update!
https://forums.homeseer.com/index.php

Thank...

[macromotion]

Edit: Thanks Wayne Luke... just saw your post...

[macromotion]

I figured it out. Thought each promotion would be run on the same "approved users" group. Not the case. the 10K+ promotion would only be run on the 5K+ usergroup. Makes a lot of sense now....

[macromotion]

If there's built-in logic that handles that, that's good to know. I'll try it and see. thanks...

[macromotion]

Right but that doesn't ensure that the promotion will put "Pete" in the correct primary usergroup! If the 10k promotion runs first and THEN the 5k or 1k promotion runs after that, he'll end...

[macromotion]

would that actually work? Wouldn't that create a different problem? If a user (like "Pete" above) qualifies for 3 different user groups, what detemines which one would become his primary usergroup....

[macromotion]

We have 3 usergroups that represent posting milestones and we've created promotions that add them to these usergroups.

• 1,000 posts club
• 5,000 posts club
• 10,000 posts club

When someone is promoted,...

[macromotion]

OK, should have been more precise. Sorry. I have no idea how to do that....

[macromotion]

I have no idea what that means! ...

[macromotion]

Every new post of topic? OMG, no! That would be even more inefficient. We get hundreds of new posts a day. No, we'd just want to know about the new moderated topics or new topics from the moderated usergroup....

[macromotion]

I've searched the forum and found a number of topics related to this but it doesn't appear to be a feature yet.

Here's my scenario:

1. New user registers and is added to "Registered Users"

...