Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Post server change bug found

Quote Reply
Post server change bug found
First week of May my isp's server re-directs managed to scramble my MySql
table. The Guests table needed to be repaired. When I logged out as ADMIN
from GForum Admin... I couldn't even get back in either!

After fixing the table via my isp server supplied utils, I was able to re-gain access
and full control.
BUT.... It's been noted that the MySQl table still has the added field of information
I added, but no longer links in, or displays that field when looking at user information
in the admin panel.

So I'm assuming that is a backup problem and they restored a file, predating
my editing to add the extra field i nthe MySql and Gfroum system.

MY PROBLEM NOW is also the system seems to be accepting (or at least listing)
doulble posts into the Forums from the email interface. Before May31, no posts
are duplicated. After the 'field' info loss... after May the Froums list two
of each incoming email post.

QUESTION
Is there a way to check if the system 'slipped a field' and is doubling up info
in the database fields? Idea? question? suggestions?
Quote Reply
Re: [ptegler] Post server change bug found In reply to
I'd do a "DESCRIBE gforum_Post" query in the SQL Monitor, then compare the listed columns to the columns shown in the Post table editor. If the database has extra columns that the Post table properties does not show, you can resync the table to make GForum recognize them.

However, if the database doesn't have all the proper columns, you'll probably need to add those columns in via a couple queries - if this is the case, let me know and I'll help you with the queries.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Post server change bug found In reply to
   
ok double posts fixed..... BUT ....I've added a field to the database... and had previously...via your suggestions.... setup the templates and global varialbes to add that field. Apparently looking at my database with MySQlman the data field is there and the fields contain info as they should. It's just now the added field does not appear on the users info page when brought up. Not just the data point, the boxes and etc doe not show up o nthe pages. So I'm assuming it's also template changes I had maded to have that field show up.
Quote Reply
Re: [ptegler] Post server change bug found In reply to
Is it a user-side page where it isn't showing up, or on the admin pages? If user-side, you'll need to make the template change again.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Post server change bug found In reply to
It's not showing up in the admin stuff.

If I call up say.. a users full info, whether it be the 'display' of info
of the full page will active text boxs readt for editing the info...
... the field I had added, was at the bottom (obviously)...after the
Yahoo and MSN ID fields... I had added a 'Member Number:' field.

The admin pages are no longer bringing up that filed of info via the normal
cgi functions in the admin panel, even though the table in the datbase
has that field there and the info is there. Now that one table in the db
did need 'repair' which worked fine. I haven't read through every record
to see if that field (member number) has valid data in for record.
But I can't see why that would stop the script from bring up the field
on the adim users modify.
Quote Reply
Re: [ptegler] Post server change bug found In reply to
Do a "resync" of the table - go to Tools -> Table Editor -> User -> Resync database (at the very bottom of the page). That should make GForum pick up the column.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Post server change bug found In reply to
That worked. Thanks again!