[BETA] AJAX Chat MOD

[nicholasalipaz]

for my last post for help
here the error when i try to install the ajax chat

Code: Select all

General Error
SQL ERROR [ sqlite ]

SQL logic error or missing database [1]

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/sqlite.php
LINE: 123
CALL: dbal->sql_error()

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

can some one help me with this issue

thanks

did you follow all instructions and make sure to browse to chat_install.php?mode=install to install the chat database? If not then your database doesn't contain the chat table.

[acidrain]

There used to be a error in this Chat Mod. The people that selected to stay hidded and not display their online status were also shown in the chat list, this lead to people being able to know whos online or not.. Has this been fixed on this new release yet ?

[nicholasalipaz]

I don't think the hidden user's thing was ever fixed.

[acidrain]

I don't think the hidden user's thing was ever fixed.

Then Somebody (handy man) gotta really look into this and fix it because its annoying for people like us.. others think we are always online while we are out of the house and the Pc is logged on

[spaceace]

There used to be a error in this Chat Mod. The people that selected to stay hidded and not display their online status were also shown in the chat list, this lead to people being able to know whos online or not.. Has this been fixed on this new release yet ?

as nicholasalipaz stated, it has not been fixed yet.

Then Somebody (handy man) gotta really look into this and fix it because its annoying for people like us.. others think we are always online while we are out of the house and the Pc is logged on

Handyman has stated that there will be a fix for this in the next release. just have to wait for it.

also, the mod in this topic is NOT new. it has just been moved over to the MODDB so it can be managed better

[yais]

Does anyone know how I can make the height of each message smaller, so i can have more messages visible without having to scroll down...if you get what i mean.

[Sniper_E]

The latest, smallest it can get in prosilver, chat_body.html template is posted here: viewtopic.php?p=92509#p92509

[mjochagavia]

Can someone help me to fix the problem with IE? What I need to change to make refresh more slow?

Thanks

[locoloco Ron]

[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3761: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3763: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3764: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3765: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)


i tried to install the chat... but a got this error ?


i dont know how to fix it

When editing language files, such as common.php:

Make sure, if you edit the language file, that your text editor saves the language file as Unicode (UTF8) and WITHOUT a BOM signature.
If your text editor saves the language file with a BOM signature, you will see an error on your forums.

List of text editors that are capable of saving without BOM signature (this list is small since I just started compiling it)
note: if you are using a Mac, you can use almost any file editor available to you.

1. ZEND
2. Dreamweaver
3. Rapid PHP 2007
4. Notepad++

I'm still have the same problem, i used ZEND and notepad already.

[nicholasalipaz]

...
I'm still have the same problem, i used ZEND and notepad already.

Not "notepad," Notepad++

if using Notepad++ to do the file edit, then select from the menu "Format -> Encode in UTF-8 without BOM" then save and upload to your server.