I don't know if this matters, but I keep getting this error:
Code: Select all
SQL query:
ALTER TABLE alvt_forums ADD forum_last_poster_avatar VARCHAR( 255 ) COLLATE utf8_bin NOT NULL default '';
MySQL said: Documentation
#1060 - Duplicate column name 'forum_last_poster_avatar'
Now, I have the last topic title mod installed ( the one that shows the topics title of course) above the name and date, and I was wondering if that was what was messing it up, as the sql will not inject because that becomes the issue.
And when I go to hit submit when making a new topic I get this:
Code: Select all
SQL ERROR [ mysqli ]
Unknown column 'topic_last_poster_avatar' in 'field list' [1054]
SQL
UPDATE alvt_topics SET topic_first_post_id = 2469, topic_last_post_id = 2469, topic_last_post_time = 1270113156, topic_last_poster_id = 58, topic_last_poster_name = 'Macster', topic_last_poster_colour = 'AA0000', topic_last_poster_avatar = 'http://dmart.uuuq.com/macattack.gif', topic_last_poster_avatar_type = '2', topic_last_poster_avatar_width = '100', topic_last_poster_avatar_height = '100', topic_last_post_subject = 'sss' WHERE topic_id = 449
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: includes/functions_posting.php
LINE: 2102
CALL: dbal_mysqli->sql_query()
FILE: posting.php
LINE: 1179
CALL: submit_post()
I can only assume that is because of the mod again, or I missed a code or so in functions_posting.php. Just wondering if ya know or not if that could be affecting it. I also have 3.0.7PL1 if that makes a difference. lefty doesn't have to respond to this if someone else knows the answer, but I am hoping lefty will respond lol.