report to moderator error

[euripides]

sorry you meant this:
id_comment   id_report   id_member   member name   comment

[Arantor]

Yes, that's what I mean. I'm curious how come your table is missing multiple columns.

The structure of that table is:

Code Select Expand

id_comment mediumint(8) UNSIGNED AUTO_INCREMENT
id_report mediumint(8) default 0
id_member mediumint(8)
membername varchar(255)
email_address varchar(255)
member_ip varchar(255)
comment varchar(255)
time_sent int(10) UNSIGNED

(at least that's what in my local test DB, may not be exactly the same, but certainly there's multiple columns missing and I'm intrigued as to why you're missing two columns in the middle of the table)

[euripides]

can it be fixed?

[Arantor]

Sure, by adding the columns back into the table. But I want to know why they disappeared.

[euripides]

how the heck do I add them?
as to why they disappeared....
I have no idea.
Any help how to to fix it?
my most humble thanks.

[Orangine]

Sure, by adding the columns back into the table. But I want to know why they disappeared.

my guess is they were never created, something went wrong during the upgrade process

[Arantor]

That's the part that *REALLY* confuses me. The table doesn't even exist in 1.1.x and it's been there in pretty much every release of 2.0 for years now. There is no reason the upgrade should have created the table and managed to ignore lines *in the middle of the create statement* which suggests something else went wrong.

[euripides]

can it be fixed?

[Colin]

Sure, by adding the columns back into the table.

[euripides]

any other easy fix?

[Arantor]

No.

[euripides]

so what do I do?

[Orangine]

upgrade, perhaps?

[euripides]

but I am on 2.0.2 ....?

[Arantor]

Nope, the upgrade won't actually deal with that situation. It doesn't know how to fix that, all it knows how to do is create the table if it doesn't exist. I *guess* you could drop the table then run the large upgrade but any mods installed will then need to be reinstalled.

Even recreating the table manually is going to be awkward because the exact statement is going to depend on the DB collation. It's all fixable it's just that it takes more time than I have right now to fix it.

[euripides]

can you fix it for a price?

[Arantor]

If I were doing it personally, I'd be charging my standard consulting rate of $70/hour (minimum 1 hour, like everyone else)

It would be easier to provide help if you provided more details from the page I asked you to go to before.