Installation Problems + Integration (MSSQL & ASP.NET)
PostPosted: 19 Jul 2013, 03:17
Hello Everybody,
I've just downloaded and tried to install the trial version of ArrowChat and I have a lot of problems.
It is installed over Apache in Windows2003 in a different port (Port: 100).
Our solution is in IIS over port 80 (ASP.NET).
Our DB is MSSQL 2005.
- First of all, the admin page in the main server doesn't work properly. Each several seconds it shows: "the tab has recovered" with an IE v8.0. It works from my notebook with Chrome and IE10.
- I put the code in our solution. No bar shows.
Before make a real integration, I have put in integration.php, function get_user_id a fixed value (userid = 844)
- I have used the profiler tool of SQL Server to see the activity of ArrowChat and I can see next:
SELECT theme, status, popout, hash_id, hide_bar, is_admin, play_sound, window_open, chatroom_window, chatroom_stay, chatroom_block_chats, only_names, unfocus_chat, focus_chat, apps_bookmarks, apps_other, block_chats, chatroom_sound, apps_open, guest_name
FROM arrowchat_status
WHERE userid = '844'
If I execute it on SQL Server it shows:
(Translation from Spanish): chatroom_sound column doesn´t exist.
I created it. Like I don't know the field type I used integer.
After that the app makes the previous query and after that makes:
INSERT INTO arrowchat_status (userid, chatroom_window, chatroom_stay, hash_id, session_time)
VALUES ('844', '-1', '-1', 'tKwea5JYk6bfZe6xzKmm', '1374228078')
Error on SQL Server: (Translation) Can't introduce value NULL in (several fields). The columns doesn't accept NULL.
If I check that table, all of the fields have the "NOT NULL" characteristic, and in the previous INSERT doesn´t appear all of the fields.
I tried to change all of the fields to accept NULL. After that there is no error, but bar doesn´t show.
I'm very dissappointed with this app.... I'm thinking to try other solutions...
I've just downloaded and tried to install the trial version of ArrowChat and I have a lot of problems.
It is installed over Apache in Windows2003 in a different port (Port: 100).
Our solution is in IIS over port 80 (ASP.NET).
Our DB is MSSQL 2005.
- First of all, the admin page in the main server doesn't work properly. Each several seconds it shows: "the tab has recovered" with an IE v8.0. It works from my notebook with Chrome and IE10.
- I put the code in our solution. No bar shows.
Before make a real integration, I have put in integration.php, function get_user_id a fixed value (userid = 844)
- I have used the profiler tool of SQL Server to see the activity of ArrowChat and I can see next:
SELECT theme, status, popout, hash_id, hide_bar, is_admin, play_sound, window_open, chatroom_window, chatroom_stay, chatroom_block_chats, only_names, unfocus_chat, focus_chat, apps_bookmarks, apps_other, block_chats, chatroom_sound, apps_open, guest_name
FROM arrowchat_status
WHERE userid = '844'
If I execute it on SQL Server it shows:
(Translation from Spanish): chatroom_sound column doesn´t exist.
I created it. Like I don't know the field type I used integer.
After that the app makes the previous query and after that makes:
INSERT INTO arrowchat_status (userid, chatroom_window, chatroom_stay, hash_id, session_time)
VALUES ('844', '-1', '-1', 'tKwea5JYk6bfZe6xzKmm', '1374228078')
Error on SQL Server: (Translation) Can't introduce value NULL in (several fields). The columns doesn't accept NULL.
If I check that table, all of the fields have the "NOT NULL" characteristic, and in the previous INSERT doesn´t appear all of the fields.
I tried to change all of the fields to accept NULL. After that there is no error, but bar doesn´t show.
I'm very dissappointed with this app.... I'm thinking to try other solutions...