Adding Alert error

[PamelaE]

When I try to add an alert I received the following error:

Invalid SQL: insert into warning_types values(
'',
'Spam',
'1',
'Unwanted messages',
'60',
'No',
'Yes',
'Yes',
'Dear Soap Chat Member,

You have sent a message to either an open forum or a private individual which breaks our Terms and Conditions.

Continual misuse of the service can result in a ban.

Thank You '
)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

[sv1cec]

Please run the following query and let me know what you got:

describe warning_types

Rgds

[PamelaE]

Sorry to be dumb but I have never run a query before :) Ooops

Anyway I did this and this is what I got back:

SQL-query:
DESCRIBE warning_types
tid int(15) PRI NULL auto_increment
warn_name varchar(255)
warn_points int(15) 0
warn_desc text
warn_maturity int(5) YES NULL
warn_permban char(3) YES NULL
warn_type char(3) YES NULL
warn_alert char(3) YES NULL

Sorry if this is the wrong info.

[sv1cec]

You did just fine. Now, run the following query and your problem will be gone.

ALTER TABLE `warning_type` ADD COLUMN `warn_alertcomment` mediumtext

Let me know if that solves your problem.

Rgds

[PamelaE]

That worked.

Thank you so much

[sv1cec]

The well-known prefix issue I guess, was the reason for your original message.

Glad that everything is sorted out.

Rgds

[PamelaE]

Ahh spoke to soon. Sorry I feel a right pain.

But since I made the above change, when I click on the Alert user from post or from profile I get taken to a white blank page.

[sv1cec]

Are you maybe using more than one style? Were the templates of AWS added in both styles, or just the one. If they do not exist in both styles, there is a thread in this forum, on how to deal with this matter.

Rgds

[PamelaE]

Thanks. I actually redid warn_install and it fixed it. Everything seems to be working fine.

Great work, Im really impressed. :)

[sv1cec]

Glad if you like it.

Rgds