what do i do to resolve this?General Error
SQL ERROR [ mysql4 ]
Unknown column 'pv.vote_time' in 'field list' [1054]
SQL
SELECT u.username, u.user_colour, pv.vote_user_id, pv.vote_time FROM phpbb_poll_votes pv, phpbb_users u WHERE pv.topic_id = 305 AND poll_option_id = 1 AND pv.vote_user_id = u.user_id ORDER BY u.username_clean ASC, pv.vote_user_id ASC
BACKTRACE
FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()
FILE: viewtopic.php
LINE: 859
CALL: dbal_mysql->sql_query()
Code: Select all
ALTER TABLE phpbb_users ADD pv.vote_time INT NOT NULL;
Shorty1968 wrote:I must once again I would like to report that a user will be displayed under the vote, but is in the template with the <br /> not like it, unfortunately I get the point?
has voted the date information is also not true that he shows to the user on 01 Jan 1970 at 1:00 clock?
I get that part... im still pretty new at this though... so i dont know where exactly to do that... would i go into the phpbb_poll datatbase? do i just create a new one? would you be able to give me step by step instructions i just dont know exactly where I am putting the command.Shorty1968 wrote:Hallo camena
the command you need to enter into the database in phpmyadmin or mysqldumper if you use the!
Code: Select all
error
SQL command:
ALTER TABLE ADD phpbb_poll_votes pv.vote_time INT NOT NULL
MySQL said: Documentation
# 1103 - Incorrect table name 'pv'