[c] Error messages when sending private messages

[Alexandrea]

Could I ask that everyone reading this makes a mental note of how many PMs they are able to send before this error message comes up? If I can start to get an idea of the average, I can probably nail down the culprit modification.

3.

(I think )

[Alexandrea]

just happened again after exchanging about 6 messages with someone who was online at the time

[Alexandrea]

so this time I had just logged in for the first time today and was replying to a pm that had been waiting for me for a few hours

General Error
SQL ERROR [ mysql4 ]

Unknown column 'root_level' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: david@mooncalfstudios.com

Powered by phpBB® Forum Software © phpBB Group

Note that it's now '1054' and not '1146'

[Alexandrea]

just now I got the error message when trying to send and it's the first pm of the day.
(1054)


eta

pretty sure the recipient of it was online at the time I hit submit, too.

[Azraeth]

General Error
SQL ERROR [ mysql4 ]

Unknown column 'root_level' in 'field list' [1054]

SQL

INSERT INTO phpbb_potvprivmsgs (root_level, author_id, icon_id, author_ip, message_time, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, message_subject, message_text, message_attachment, bbcode_bitfield, bbcode_uid, to_address, bcc_address, message_reported) VALUES (0, '92', 0, '####', 1558039265, 1, 1, 1, 1, 'Testing [Error Message Bug]', 'Bleep bloop', 0, '', '29ona5x0', 'u_9939', '', 0)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 193
CALL: dbal->sql_error()

FILE: [ROOT]/includes/functions_privmsgs.php
LINE: 1486
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/ucp/ucp_pm_compose.php
LINE: 739
CALL: submit_pm()

FILE: [ROOT]/includes/ucp/ucp_pm.php
LINE: 133
CALL: compose_pm()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: ucp_pm->main()

FILE: [ROOT]/ucp.php
LINE: 327
CALL: p_master->load_active()


Got that after sending 17 messages to McTesty. Going to keep doing it to see if I can find a pattern of some kind.

[Azraeth]

11 that time

[Azraeth]

27 times

[Azraeth]

@ David:

Is it possible there's some kind of error in the table triggers?

[Alexandrea]

On the first try when replying to a pm after just logging in for the first time all day. The recipient was not online at the time and there was nothing of note to mention.


General Error
SQL ERROR [ mysql4 ]

Unknown column 'root_level' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: david@mooncalfstudios.com

Powered by phpBB® Forum Software © phpBB Group

[Alexandrea]

1054 again.