Site Links
Home
Features
Pricing & Order
Documentation
Support Options
Member Area
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (BlackMale), 73 guests, and 177 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Landyphil
Landyphil
Germany
Posts: 29
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
isaac 24
Gizmo 18
Ruben 10
driv 9
Conrad 3
JAISP 2
Latest Photos
Trees
Retreats
Rooms
Big stuff
Test
Previous Thread
Next Thread
Print Thread
SQL error in editbasic.inc.php? #262470 03/04/19 03:55 PM
Joined: Oct 2008
Posts: 92
PianoWorld Offline OP
Journeyman
OP Offline
Journeyman
Joined: Oct 2008
Posts: 92
I've had a few members complaining that they can no longer edit or post.

When i look at the SQL error logs, I see this message along side these members names...

Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
and GROUP_IMAGE <> ''' at line 3

Could this be causing the problem?
Suggestions?

Thanks,
Frank B.
Piano World]
http://forum.pianoworld.com

Express Hosting
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262471 03/04/19 04:26 PM
Joined: Dec 2003
Posts: 5,881
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,881
I just tried it in, just for the fun of it.
Created a post, edited the post then deleted it.
Worked fine.
Now I did notice due to I used the lost password . You have a new required field " how did you hear about us"
I had to populate the field.to get past editing my temp password.

Maybe the new registration required field is the culprit?

For thrills maybe have one of the members that have the issue check their profile and add data to the field if it is missing save and see if it works now
.

Last edited by Ruben; 03/04/19 04:34 PM. Reason: Added Comment.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262472 03/04/19 04:32 PM
Joined: Oct 2008
Posts: 92
PianoWorld Offline OP
Journeyman
OP Offline
Journeyman
Joined: Oct 2008
Posts: 92
Thanks Ruben,
The odd thing is, it appears to only be happening to people who are triggering the sql error I listed.

Mon, Mar 04 2019 14:37:07 +0000
DFR Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
and GROUP_IMAGE <> ''' at line 3

Mon, Mar 04 2019 14:48:01 +0000
CharlieBlue Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
and GROUP_IMAGE <> ''' at line 3

Mon, Mar 04 2019 15:28:22 +0000
ap215 Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
and GROUP_IMAGE <> ''' at line 3

Mon, Mar 04 2019 15:29:13 +0000
ap215 Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
and GROUP_IMAGE <> ''' at line 3

Mon, Mar 04 2019 15:32:10 +0000
ap215 Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
and GROUP_IMAGE <> ''' at line 3
Mon, Mar 04 2019 15:40:15 +0000

ap215 Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
and GROUP_IMAGE <> ''' at line 3
Mon, Mar 04 2019 15:48:17 +0000

ap215 Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
and GROUP_IMAGE <> ''' at line 3

Mon, Mar 04 2019 15:57:33 +0000
ap215 Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
and GROUP_IMAGE <> ''' at line 3

Mon, Mar 04 2019 18:42:36 +0000
SFB Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
and GROUP_IMAGE <> ''' at line 3

Mon, Mar 04 2019 18:47:57 +0000
Piano42 Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')


Best,
Frank B.


Founder/Host
Piano World
https://PianoWorld.com
Home of the world famous Piano Forums.
http://forum.PianoWorld.com
88,000+ registered members
Over 2.5 million posts, and growing...
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262473 03/04/19 05:00 PM
Joined: Dec 2003
Posts: 5,881
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,881
Maybe your host upgraded your server without your knowledge beyond what ubb supports.
It appears you are on ubb 7.6.2.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262474 03/04/19 05:17 PM
Joined: Jun 2006
Posts: 15,827
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,827
Quote
where GROUP_ID in ()
do your users not belong to any groups?


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262475 03/05/19 11:51 AM
Joined: Oct 2008
Posts: 92
PianoWorld Offline OP
Journeyman
OP Offline
Journeyman
Joined: Oct 2008
Posts: 92
It appears there is some problem with the database(s), Corrupted maybe?

Getting these emails from members...
============================
I can sign in with waxwing2019 plus password, and my profile name is waxwing.

But if I click on edit profile, I get “database error only visible to administrators “

============================================================
I'm a new user. And I can't seem to find where to post a thread or even reply a user on a thread. I started thinking maybe its exclusive. Please help
=================================================
When I log in with my id “jpzapu10” and select forums a message says “there are no forums available for you to view”.
===========================================

Frank B.


Founder/Host
Piano World
https://PianoWorld.com
Home of the world famous Piano Forums.
http://forum.PianoWorld.com
88,000+ registered members
Over 2.5 million posts, and growing...
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262476 03/05/19 01:04 PM
Joined: Jul 2006
Posts: 95
Philipp Offline
Journeyman
Offline
Journeyman
Joined: Jul 2006
Posts: 95
I would check the ubbt_USER_GROUPS table with Database Tools or phpMyAdmin. Perhaps the table is crashed and needs a repair?

The SQL command to repair this table is:
Code
REPAIR TABLE ubbt_USER_GROUPS;

Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262477 03/05/19 01:34 PM
Joined: Dec 2003
Posts: 5,881
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,881
The first thing I would do is login to the ubb control panel.
Check your os versions on the first page to make sure you have the same server software.
Then I would check the groups to see that they are intact.
Including the permissions for each group.
Then using your log for reference check each user in member management to see that they are in the correct group and everything else looks correct..
Just check don't edit yet. So you can research a comon pattern to what may be wrong.
As far as waxman you can have different login name from display name. Mine is different here.

It could be a corrupted table as stated by Phillip but I would make a backup of the complete database before mucking with it.
You can run it from the database section in the ubb control panel.

What I find a little odd is the last line of your errors.
Quote
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')


That could mean a corrupted script???? I would at least check the includes/config.inc.php file to see it is hosed.


Last edited by Ruben; 03/05/19 01:45 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262478 03/05/19 03:47 PM
Joined: Jun 2006
Posts: 15,827
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,827
When you open these users profiles in the Control Panel, what groups does it display that they belong to?

Originally Posted by Ruben
What I find a little odd is the last line of your errors.
Quote
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')


That could mean a corrupted script???? I would at least check the includes/config.inc.php file to see it is hosed.
If you look at the queries he supplied, the part of the code that checks if they have group images is returning an error because no group ids are being retrieved from the database for the query, which would generally indicate that these users do not belong to any user groups.

Originally Posted by PianoWorld
Mon, Mar 04 2019 14:37:07 +0000
DFR Script: /var/www/html/forum/scripts/editbasic.inc.php - Line: 102
select GROUP_ID,GROUP_IMAGE
from ubbt_GROUPS
where GROUP_ID in ()
and GROUP_IMAGE <> ''
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
and GROUP_IMAGE <> ''' at line 3
The code should display an array of group ids that the user belongs to (such as the users group, GM/Mod groups, and/or the Admin group), his is returning no group ids at all.

This could happen if one purged a default group (such as changing the default group users are added to) without reassigning the users to another group.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262479 03/05/19 04:15 PM
Joined: Dec 2003
Posts: 5,881
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,881
I took a peek for him.
First his database is around 5gb.
90k+ user rows but the user_groups table only has 70k+ rows

all of the questioned users in the log I checked have no group what so ever assigned except for one member that is subscribed to two groups but the default group is not checked.
In fact in member management you have to use the member id # to find them.

The logs are huge but I did not find anything other than more of the same error.
also there is a odd file in the includes folder I question him on. ad.inc.php, it showed in the permissions check.
But I did not find it in the html includes or custom islands so far.

No so sure a table repair will work here, Since there are way to few rows in the user_group table. But ????

I asked if he has any type of backup, waiting on a reply.

Yep Giz I think that it was operator error. They manually move the custom registration group members to the normal user group after a few post for spam security .. Good guess.

Last edited by Ruben; 03/05/19 04:31 PM. Reason: Added Comment

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262480 03/05/19 04:21 PM
Joined: Jun 2006
Posts: 15,827
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,827
Some forums like to setup a postcount group that elevates privileges after X posts; its possible something like this was configured and the base group was removed, its really hard to say without being one that makes changes on a forum.

Any users not in a default group (users) will need to be manually added back, and the setting for the default registration group (CP -> Membership -> Registration -> Basic Tab -> Default Group(s) for New Members) will need to be validated that users are being added to a default group.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: SQL error in editbasic.inc.php? [Re: Ruben] #262481 03/05/19 04:28 PM
Joined: Apr 2004
Posts: 1,377
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,377
Originally Posted by Gizmo
do your users not belong to any groups?
Posted 2019-03-04 @ 1:17 PM

Why is everyone ignoring what Gizmo posted yesterday?


brb. grabbing more popcorn...


isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.7.2 Progress Notes
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262482 03/05/19 04:37 PM
Joined: Oct 2008
Posts: 92
PianoWorld Offline OP
Journeyman
OP Offline
Journeyman
Joined: Oct 2008
Posts: 92
Yes, all members are assigned to a group.

Users start in a group called Newbies (which limits posts to one every 5 minutes).
This helps weed out the spammers who tend to create multiple junk posts in a matter of minutes.

After we've determined they are most likely legit they are manually moved to User group.
There should be over 92,000 Users, it now shows 77,627 assigned to User of the 92650 total.

It's like the Newbies that were moved over suddenly fell out of the User group.


Founder/Host
Piano World
https://PianoWorld.com
Home of the world famous Piano Forums.
http://forum.PianoWorld.com
88,000+ registered members
Over 2.5 million posts, and growing...
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262483 03/05/19 05:32 PM
Joined: Jun 2006
Posts: 15,827
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,827
Well, it sounds like someone removed the "Newbies" group, or attempted to move users to another group, as the system is indicating that they do not have any groups.

The steps are to retrieve the group ids of the users, then grab any enabled group images; the step is failing because it is not identifying that said users belong to any groups.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262484 03/05/19 05:34 PM
Joined: Apr 2004
Posts: 1,377
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,377
Adding this here, since I found it to be extremely relevant.

From an unnamed third-party contractor who was contacted to help resolve PianoWorld/Frank's issue:
Quote
After many questions:
He [Frank/PianoWorld] finally fessed up that somebody had attempted to move 15,000 members to another group. because they have a default group that is temporary then they manually move then to the normal user group after a few posts.

And that is when the problem came up.

I mentioned the [automatic] post count option [built in to stock UBB.threads] but that is the way they want it.

--

A side-observation not really related to PianoWorld/Frank's issue, but its a feature which should be used:

Also from that third-party contractor:
Quote
The logs have never been purged so it takes forever to go over them.

Linking this here, to help anyone else who may stumble across this thread:

From the UBB.threads 7.6.2 Changelog -
[NEW] Admin Logs can be automatically purged to a certain age (Lifetime). The auto-purge feature is disabled by default. (CP > Primary > Logging)
https://www.ubbcentral.com/forums/ubbthreads.php/topics/261663/7-6-2-changelog-discussion


isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.7.2 Progress Notes
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262485 03/05/19 05:48 PM
Joined: Oct 2008
Posts: 92
PianoWorld Offline OP
Journeyman
OP Offline
Journeyman
Joined: Oct 2008
Posts: 92
There's no "fessing up" here, I tried to explain all of this from the beginning, so let's all try to act like grownups.

And there is no "3rd party", it's one of the moderators that's been with me for over ten years.

We've been using this method of starting members as a Newbie and eventually moving them to the User group for about a year with no problems.
Nobody tried to move 15,000 members at once, but that is the number that suddenly showed up as being in the Newbie group and then disappeared, which is when the problems started. And that's why I took a stab at it being a corrupted database.

I'm a marketing person, not a developer (although I did build web sites for McGraw-Hill many years ago).
Which is why I usually pay someone associated with the ubb to do our upgrades.

If someone who knew better had told me I need to purge logs (and how) I would have done it.
Also, I don't remember anyone mentioning the automatic post count feature.

So instead of trying to point out what I'm doing wrong, how about providing some actual helpful information which is what I came here asking for?


Founder/Host
Piano World
https://PianoWorld.com
Home of the world famous Piano Forums.
http://forum.PianoWorld.com
88,000+ registered members
Over 2.5 million posts, and growing...
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262486 03/05/19 06:00 PM
Joined: Jun 2006
Posts: 15,827
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,827
You'll need to restore your database (or at the very least, your groups table) from a time prior to this issue, as managing the database directly (especially with such a large set of data) is impractical. You may have to manually add users who were created between the backup time and the restoration time to the proper groups if you choose to only restore the groups database table.

I attempted to identify this issue with this post, which went unanswered:
Originally Posted by Gizmo
Quote
where GROUP_ID in ()
do your users not belong to any groups?


And further, you specified there was no problems with groups in your later posting, specifically indicating that users are in fact in groups:
Originally Posted by PianoWorld
Yes, all members are assigned to a group.
Which they are not, as the system reported with the error you supplied.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262487 03/05/19 06:30 PM
Joined: Oct 2008
Posts: 92
PianoWorld Offline OP
Journeyman
OP Offline
Journeyman
Joined: Oct 2008
Posts: 92
Ah, but therein lies the rub.
They were all assigned to a group before the trouble started.

We will likely need to roll back to before the problems started, and then as others have suggested, upgrade to latest version.

thanks for your help/input.

- Frank B.


Founder/Host
Piano World
https://PianoWorld.com
Home of the world famous Piano Forums.
http://forum.PianoWorld.com
88,000+ registered members
Over 2.5 million posts, and growing...
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262488 03/05/19 07:13 PM
Joined: Apr 2004
Posts: 1,377
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,377
Originally Posted by PianoWorld
And there is no "3rd party", it's one of the moderators that's been with me for over ten years.
[...]
Which is why I usually pay someone associated with the ubb to do our upgrades.


3-Party - A third party is an entity that is involved in some way in an interaction that is primarily between two other entities. UBBSystems did did not provide this person to you. You are working with that person directly.
https://whatis.techtarget.com/definition/third-party

--
Originally Posted by PianoWorld
We've been using this method of starting members as a Newbie and eventually moving them to the User group for about a year with no problems.
Nobody tried to move 15,000 members at once.


I'm going to quote you on this next one
Originally Posted by PianoWorld
After we've determined they are most likely legit they are manually moved to User group.
There should be over 92,000 Users, it now shows 77,627 assigned to User of the 92650 total.

It's like the Newbies that were moved over suddenly fell out of the User group.


--
Originally Posted by PianoWorld
If someone who knew better had told me I need to purge logs (and how) I would have done it.


From the UBB.threads 7.6.2 Changelog posted to 1/ the portal at the time of 7.6.2's release, 2/ The first post of the changelog discussion, 3/ the second page of the Upgrader you ran when you upgraded your forums, and 4/ located within /forums/install/CHANGELOG.txt
[NEW] Admin Logs can be automatically purged to a certain age (Lifetime). The auto-purge feature is disabled by default. (CP > Primary > Logging)
https://www.ubbcentral.com/forums/ubbthreads.php/topics/261663/7-6-2-changelog-discussion

--
Originally Posted by PianoWorld
Also, I don't remember anyone mentioning the automatic post count feature.


From the very top of the Group Editor. This direction has been there for many many years:
"The Group Editor allows your manage the various user groups on your forum. Filling in the "Posts" field will automatically add users to that group once they reach the designated Post Count. Leave blank or enter 0 to disable this feature per group."

--
Originally Posted by PianoWorld
So instead of trying to point out what I'm doing wrong, how about providing some actual helpful information which is what I came here asking for?


how is "Yes, all members are assigned to a group" not lying about them in fact not being in a group? The system reported that with the error logs you supplied.

It seems to me that you may have moderators doing administrative tasks.

My advice is that you may want to rethink who you are giving access to, and either educate them on how delectate really large databases can be, or lessen their access permissions. forums/admin/group_cpperms.php


isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.7.2 Progress Notes
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262489 03/05/19 07:34 PM
Joined: Oct 2008
Posts: 92
PianoWorld Offline OP
Journeyman
OP Offline
Journeyman
Joined: Oct 2008
Posts: 92
Your advice about limiting admin access is probably a good idea.

"how is "Yes, all members are assigned to a group" not lying about them in fact not being in a group? The system reported that with the error logs you supplied."

You're not making any sense beating this dead horse.
What would I possibly gain by lying?

Before everything blew up everyone was assigned to a group.
As of three days ago there did not seem to be any problem.

that's the reason I'm here asking for help, because it all went south and I don't know what caused it. 15000+ members suddenly fell into a hole.


Founder/Host
Piano World
https://PianoWorld.com
Home of the world famous Piano Forums.
http://forum.PianoWorld.com
88,000+ registered members
Over 2.5 million posts, and growing...
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262491 03/07/19 03:53 PM
Joined: Dec 2003
Posts: 5,881
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,881
Okay,Lets all chill out and come up with a method to help.
I am sure Frank is in panic mode.
Yes , There was a better way to handle this method. But that is the way it was done..
It is all behind us now.
The logs are so many rows it is hard to find what happened..

The longer we wait to resolve it the worse it gets.Due to new members registered and new posts.

My suggestion is if you have a backup prior to the 15,000 member loss then at the very least grab the :
ubbt_USER_GROUPS table and overwrite what you have in the active database
Restoring a 5gb database would probably be a huge chore.
That should restore all newbie groups except for new members since the date of the backup.
That should be a acceptable number to manually fix for registrations after that date.
It may not be clean but at least it won't be 15,000 members. to deal with
I don't know what host it is or what options there are.
but that is what I would start with.

Unless someone can come up with a easier way to get it fixed.

I still think it is a bug somewhat that allows you to move or delete groups in member management and leave them completely orphaned.. Even if it is operator error..

But it has been that way since the beginning days.
The hard part is once it is done the only way to find them by name is in the user list.
Member management will only find them by user ID# which is one at a time.

Sorry I did not jump back in the discussion
But I am preoccupied with a big magento store import to woocommerce right now so I am tied up for a few days..
.

Last edited by Ruben; 03/07/19 04:09 PM. Reason: Added Comment

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262492 03/07/19 04:12 PM
Joined: Oct 2008
Posts: 92
PianoWorld Offline OP
Journeyman
OP Offline
Journeyman
Joined: Oct 2008
Posts: 92
Thanks Ruben,

Panic is a good word for it.
I rely on our web sites for the better part of my income, and the forums are our main attraction.

You are correct that once the members drop out of being assigned to any group, you can only find them through the member list.

Luckily Ken Chase (our IT guy and hosting service) is very good with database work.
He was able to write a script that identified everyone not assigned to a group, and then insert them into the User group.

He did this after rebuilding/repairing some tables that had apparently become corrupted (he'd be able to explain it much better than I can).

As of last night we were back up to showing 92,600+ members.
He then took a dump of the database to make sure we had a backup of good data.

My thanks to everyone who tried to help, sorry if I got a little pissy but at my age (67) I'm too old to look for another job so the forums and Piano World are important to me :-) As it happens I was having some challenges with my WordPress Piano World site at the same time, when it rains...

In a couple of weeks I'll work on updating to the latest version.
We're going to be updating php then as well, and likely moving to a new server.

Best,
Frank B.


Founder/Host
Piano World
https://PianoWorld.com
Home of the world famous Piano Forums.
http://forum.PianoWorld.com
88,000+ registered members
Over 2.5 million posts, and growing...
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262493 03/07/19 04:26 PM
Joined: Dec 2003
Posts: 5,881
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,881
I would also clean up the logs a bit.
They are huge so it may be easier to ftp to the site and delete the files in the folder.
As far as post count promotion. goes try:
https://www.ubbwiki.com/wiki/view/82/groups.html
You already have a flood check so add say 10 posts to promote them.to user.
If you make it to small a number then a spammer could just post several posts back to back and be promoted.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: SQL error in editbasic.inc.php? [Re: Ruben] #262494 03/07/19 04:57 PM
Joined: Oct 2008
Posts: 92
PianoWorld Offline OP
Journeyman
OP Offline
Journeyman
Joined: Oct 2008
Posts: 92
Originally Posted by Ruben
I would also clean up the logs a bit.
They are huge so it may be easier to ftp to the site and delete the files in the folder.
As far as post count promotion. goes try:
https://www.ubbwiki.com/wiki/view/82/groups.html
You already have a flood check so add say 10 posts to promote them.to user.
If you make it to small a number then a spammer could just post several posts back to back and be promoted.


I'm leery of deleting anything at this point.
I'd want to be very sure whatever I was deleting wasn't going to cause other problems. And yes you're right, It would be better for me to ftp in.

As for the automatic moving of new members, we're going to revisit this.
Our primary reason for making it slower for new members to post was an effort to discourage spammers, especially the ones who like to come in about 3:00 a.m. our time and slap up 15 or 20 garbage posts.

I'm thinking of trying it again, keeping the post frequency throttled back for Newbies until they hit say 20 posts, then allowing them to move to User automatically.


Founder/Host
Piano World
https://PianoWorld.com
Home of the world famous Piano Forums.
http://forum.PianoWorld.com
88,000+ registered members
Over 2.5 million posts, and growing...
Re: SQL error in editbasic.inc.php? [Re: PianoWorld] #262495 03/07/19 05:02 PM
Joined: Dec 2003
Posts: 5,881
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,881
20 posts is okay also. It is your call.
If you throttle up the time between posts for newbies. You may upset a couple, But oh well.
Also stop forum spam should help. If enabled.

The only reason I said to ftp to clean up the logs. is because it would take forever in the control panel.for that many files. where ftp access could wipe them really quick.
and you would save over 50 mb's for just the admin logs. when displaying the logs.

Last edited by Ruben; 03/07/19 05:07 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers

ShoutChat Box
Today's Birthdays
M4TT
Recent Topics
7.7.1 forgotten? //$reply = "off";
by BlackMale - 05/13/19 07:25 PM
[FIXED for 7.7.2] 7.7.1 /admin/edit_subscrip
tion.php

by BlackMale - 05/11/19 08:35 AM
http issues
by justwilliams - 05/10/19 09:20 AM
Open div
by AllenAyres - 05/09/19 01:17 PM
Forum Statistics
Forums35
Topics35,292
Posts192,448
Members12,166
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.7.2
(Snapshot build 20190501)