havin a problem with help center live

trying to add on the module OsTicket, but when i go to the main page it says the table ticket_conig doesnt exist, so i opened the tables.sql file and found where it said to insert table_config, and then i ran that sql on the DB.. it gives me this error in phpmyadmin:

SQL query:

CREATE TABLE `ticket_config` (

`accept_attachments` int( 1 ) NOT NULL default '0',
`answer_method` enum( 'pop3', 'automatic' ) NOT NULL default 'automatic',
`attachment_size` int( 10 ) NOT NULL default '1048576',
`attachment_dir` varchar( 255 ) NOT NULL default 'attachments',
`attachment_url` varchar( 255 ) NOT NULL default 'attachments',
`search_disp` int( 1 ) NOT NULL default '1',
`umq` int( 3 ) default '3',
`save_headers` int( 1 ) NOT NULL default '0',
`time_format` varchar( 255 ) NOT NULL default 'l, F j Y g:ia',
`min_interval` int( 20 ) default '0',
`ticket_max` int( 3 ) NOT NULL default '20',
`remove_original` int( 1 ) NOT NULL default '1',
`remove_tag` varchar( 255 ) NOT NULL default '-- do not edit --',
`ticket_response` int( 1 ) NOT NULL default '1',
`ticket_msg` text NOT NULL ,
`ticket_subj` varchar( 255 ) NOT NULL default '',
`limit_response` int( 1 ) NOT NULL default '1',
`limit_email` varchar( 75 ) NOT NULL default '',
`limit_subj` varchar( 255 ) NOT NULL default '',
`limit_msg` text NOT NULL ,
`alert_new` int( 1 ) NOT NULL default '0',
`alert_email` varchar( 255 ) NOT NULL default '',
`alert_user` varchar( 255 ) NOT NULL default '',
`alert_subj` varchar( 255 ) NOT NULL default '',
`alert_msg` text,
`message_response` int( 1 ) NOT NULL default '1',
`message_subj` varchar( 255 ) NOT NULL default '',
`message_msg` text NOT NULL ,
`trans_response` int( 1 ) NOT NULL default '1',
`trans_subj` varchar( 255 ) NOT NULL default '',
`trans_msg` varchar( 255 ) NOT NULL default '',
`timezone` varchar( 255 ) NOT NULL default '',
`tickets_per_page` int( 3 ) NOT NULL default '20',
`root_url` varchar( 255 ) NOT NULL default '',
`filetypes` TEXT NOT NULL ,
FULLTEXT KEY `message_subj` ( `message_subj` )
)
MySQL said: 

#1214 - The used table type doesn't support FULLTEXT indexes

Execute this and it will work :

Code:

CREATE TABLE `ticket_config` (

`accept_attachments` int( 1 ) NOT NULL default '0',
`answer_method` enum( 'pop3', 'automatic' ) NOT NULL default 'automatic',
`attachment_size` int( 10 ) NOT NULL default '1048576',
`attachment_dir` varchar( 255 ) NOT NULL default 'attachments',
`attachment_url` varchar( 255 ) NOT NULL default 'attachments',
`search_disp` int( 1 ) NOT NULL default '1',
`umq` int( 3 ) default '3',
`save_headers` int( 1 ) NOT NULL default '0',
`time_format` varchar( 255 ) NOT NULL default 'l, F j Y g:ia',
`min_interval` int( 20 ) default '0',
`ticket_max` int( 3 ) NOT NULL default '20',
`remove_original` int( 1 ) NOT NULL default '1',
`remove_tag` varchar( 255 ) NOT NULL default '-- do not edit --',
`ticket_response` int( 1 ) NOT NULL default '1',
`ticket_msg` text NOT NULL ,
`ticket_subj` varchar( 255 ) NOT NULL default '',
`limit_response` int( 1 ) NOT NULL default '1',
`limit_email` varchar( 75 ) NOT NULL default '',
`limit_subj` varchar( 255 ) NOT NULL default '',
`limit_msg` text NOT NULL ,
`alert_new` int( 1 ) NOT NULL default '0',
`alert_email` varchar( 255 ) NOT NULL default '',
`alert_user` varchar( 255 ) NOT NULL default '',
`alert_subj` varchar( 255 ) NOT NULL default '',
`alert_msg` text,
`message_response` int( 1 ) NOT NULL default '1',
`message_subj` varchar( 255 ) NOT NULL default '',
`message_msg` text NOT NULL ,
`trans_response` int( 1 ) NOT NULL default '1',
`trans_subj` varchar( 255 ) NOT NULL default '',
`trans_msg` varchar( 255 ) NOT NULL default '',
`timezone` varchar( 255 ) NOT NULL default '',
`tickets_per_page` int( 3 ) NOT NULL default '20',
`root_url` varchar( 255 ) NOT NULL default '',
`filetypes` TEXT NOT NULL
)

nope now it gives me this error

Fatal Error: Could not retrieve configuration from database.

[Promote your blog for free....]

This error is propably from phpMyAdmin or from the sql tool that you use for executing queries.

Is there an error number with it?

nope no number

[Promote your blog for free....]

If there is no number this is not a mySQL problem.

Check the program that you use to connect with mysql

if i install this script on the WSS server, the icon that shows if live support is online or offline stays offline no matter what, and the ticket system works. but on the tlove server, the icons work, but the tickets dont. this is ridikolas

[Promote your blog for free....]

This is propably because of your session configuration of php.

well the online icons used to work on WSS.. is there anyway to get around this? ive tried contacting support for the script but they keep telling me to do the same thing which doesnt work, add assignments, & that works on tlove but not WSS

[Promote your blog for free....]

If you want to make it work on your WSS you should make some kind of configuration for cookies.

The easiest thing that you can do, is load it to your real server and code it from there.

i added a new user with DBA privileges, meth0d@someip#forjustinlove.net and it still wont work,i thought maybe it was blocking the conn. but i have allow anon. conn. and remote conn. both enabled so that should be no problem.. how would i do this with a cookie?

[Guest]

[35.533]

adsense, Yahoo crawler, Gigabot, Baidu Spider