SHINE Live Help Install Errors

[Kalendrinn]

I believe SHINE might be a dead project but I hope someone can help me out some.

I had a parse error to begin with on line 2368 with the php commented html. I removed the php comments and commented out the html with html comment tags. That allowed me to get to the installer.

On the second step of installing (after filling out the form and clicking 'Install') I get the following errors after the config output:

Query went bad!
1101: BLOB/TEXT column 'message' can't have a default value

Query went bad!
1101: BLOB/TEXT column 'scratch_space' can't have a default value

Query went bad!
1146: Table 'sugarcrm.livehelp_config' doesn't exist

Query went bad!
1101: BLOB/TEXT column 'opening' can't have a default value

Query went bad!
1101: BLOB/TEXT column 'message' can't have a default value

Query went bad!
1101: BLOB/TEXT column 'question' can't have a default value

Query went bad!
1101: BLOB/TEXT column 'message' can't have a default value

Query went bad!
1101: BLOB/TEXT column 'transcript' can't have a default value

Query went bad!
1101: BLOB/TEXT column 'sessiondata' can't have a default value

I looked and sure enough the tables that those fields refer to didn't get created cause the queries failed. I have a feeling I can get it to work if I can fix the queries. Is it new in 5.0+ that text fields can't have a default value? Are they now treated the same as BLOBs? Those errors make me worry that if I don't give it a default value that it will kill the app in a spot I'm not expecting. Any help is appreciated.

My current setup:
PHP 5.2.3
MySQL 5.0.27-community-nt
IIS 6
Win2k3

Thanks.

[Kalendrinn]

After looking some more and reading a little MySQL documentation, I decided to edit the setup.php. For those of you using MySQL 5.0+ I'm guessing you're gonna get an error with default values for TEXT and BLOB fields as they aren't allowed. So I edited all the text fields by doing a global replace on 'text NOT NULL default ''' and replaced them with just 'text NOT NULL'. After that I had to edit the $insert_query (line 281) to include those fields for livehelp_config that were text. They are: scratch_space, ignoreips, everythingelse. I gave them all ' ' as a default value. The install worked just fine after that. I have yet to see how the actual app works now, but I will keep you posted.

Hope this helps someone.

[susiewilliams]

Thanks for the update and the hints!

[Kalendrinn]

Heh, you're welcome. Though I still can't login yet. I think the admin from setup wasn't inserted but it didn't throw an error. Will get back to you on that...busy trying to do some other stuff at the moment.

[Kalendrinn]

Muahaha, ok. So I needed to go one step further and make sure to hit the other query's that were run. Let me see if I can note them all here. Once you've edited the setup.php to remove all the default values from the TEXT fields, you have to get all the query's that are run as part of the install...this is assuming a new install, not an upgrade.

$insert_query (line 281) as stated before needs the following fields added and default data added to the query:

scratch_space, ignoreips, everythingelse => I used a space (' ') as a default value.

$insert_query2 (line 290):

sessiondata => again used a space for default value

$insert_query3 (line 301):

leavetxt, everythingelse => again used a space for default value

The last query, $insert_query4 is fine as the table it refers to has no text fields.

This has gotten me to where I can login to SHINE Live Help. I have not yet tried to create anything in it.