Page 1 of 1

Well upgraded to your chat

Posted: Mon Feb 01, 2010 8:51 pm
by Rustynail
But now I'm having an sql error maybe u can help. Damm I'm a pain in the ass lol
Code: Select all
SQL ERROR [ mysql4 ]

Table 'phpbb_chat' already exists [1050]

SQL

CREATE TABLE phpbb_chat ( message_id int(11) unsigned NOT NULL auto_increment, chat_id int(11) unsigned NOT NULL default '0', user_id int(11) unsigned NOT NULL default '0', username varchar(255) NOT NULL default '', user_colour varchar(6) NOT NULL default '', message text NOT NULL, bbcode_bitfield varchar(255) NOT NULL default '', bbcode_uid varchar(8) NOT NULL default '', bbcode_options tinyint(1) unsigned NOT NULL default '7', time int(11) unsigned NOT NULL default '0', PRIMARY KEY (message_id) )

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: chat_install.php
LINE: 88
CALL: dbal_mysql->sql_query()

Allready had the old version installed then I upgraded and now I get that error so anything ya can do would be great thanks


And it is not showing up on the board which it usually will do no matter if ya have an sql problem

Re: Well upgraded to your chat

Posted: Mon Feb 01, 2010 9:02 pm
by spaceace
if you already had the chat installed, you don't have to run the installer again. just overwrite the files with the ones in the download and refresh the imageset, template, and theme of the style. you don't even have to do any file edits.