Jump to:
| Project: | Drupal ajaxIM |
| Version: | 4.7.x-1.x-dev |
| Component: | Code |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | needs review |
Issue Summary
I like it very much and I am now considering using it in my drupal site. This module can help with my current project tremendously!
But I find some bugs, for example, it can not send messages to the buddies, and the error is:
* user warning: Field 'stamp' doesn't have a default value query: INSERT INTO ajaxim_messages (id, message, type, sender, recipient) VALUES (28, 'status,2', 'event', '1', '2') in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal-4\includes\database.mysql.inc on line 121.
* user warning: Field 'stamp' doesn't have a default value query: INSERT INTO ajaxim_messages (id, message, type, sender, recipient, room) VALUES (29, 'Hi', 'msg', '1', '2', '') in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal-4\includes\database.mysql.inc on line 121.
Could someone help me with this?
Thanks in advance!
Comments
#1
I fixed it:
in the default install file:ajaxim_server.install
db_query("CREATE TABLE {ajaxim_messages} (
recipient int(11) NOT NULL,
sender int(11) NOT NULL,
message text NOT NULL,
type text NOT NULL,
stamp text NOT NULL,
id bigint(20) NOT NULL,
room varchar(255) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */");
the stamp and room field are "NOT NULL"
I change the table, and delete the "NOT NULL" reqirement for "stamp" and "room", and it works.
#2
Made some progress..