4.50c Email Signatures don't work?

[Elmerbug]

I can create plain-text or HTML signatures, but when I Save, I get a blank web page, and nothing happens.

[malcolmh]

I can create plain-text or HTML signatures, but when I Save, I get a blank web page, and nothing happens.

There has already been a thread opened for this:

http://www.sugarcrm.com/forums/showthread.php?t=16876

Bug reported to Sugar

[Elmerbug]

Thanks, Malcolm!

[clint]

We will try and reproduce this issue in the QA lab tomorrow. Stay tuned.

Clint

[chrisky]

I have reproduced this bug and wouldn't have caught it or known about it (at least for awhile) had I not seen this thread complaining about such. I won't finish up working on this until tommorrow as I'm kinda wrapping it up for the night with an early medical appointment & treatment tommorrow, thus I haven't quite worked up the solution or recoded the bug yet and will save that for tommorrow.

I was about to tackle the naming of the table and probably recode that bugger properly, but for the curious this was the extent of todays (tonight) work.

Note that I reproduced this bug in 450c-1155, while 450b-1144 does not contain this bug and has its email signatures functioning properly.

Below I'm pasting (cut & paste) my notes related to this bug.

-----------the following is pasted from my personal text notes related to the email signatures bug in 450c------

cd ..

450c - 1155
the blank page/screen that is not working has the following address:
https://blanked.com/crm450/index.php...7-450fcc55bb1b

It breaks at 'Locale Settings' in the My Account' edit view

I tried replacing the editView.html with that from the working copy of 450b sugar, and the page is still blank and has the following address:
https://blanked.com/crm450/index.php...7-450fcc55bb1b




450b - 1144
the working page has the following address:
https://blanked.com/crm450-org/index...7-450fcc55bb1b

----
Attempted replacement of crm450/modules/Users directory & its contents with that of the funcitoning crm450-org/modules/Users

This results in the following being displayed as the contents of the edit signature page/screen:
Retrieving record by id users_signatures:b3409cf2-37e1-e61f-a297-450fcc55bb1b found Query Failed:SELECT users_signatures.* , users_signatures_cstm.* FROM users_signatures LEFT JOIN users_signatures_cstm ON users_signatures.id = users_signatures_cstm.id_c WHERE users_signatures.id = 'b3409cf2-37e1-e61f-a297-450fcc55bb1b' LIMIT 0,1::MySQL error 1146: Table 'crm450.users_signatures_cstm' doesn't exist

While the 'My Account' DetailView page breaks after the Locale Settings table and has this text immediately following it:
Retrieving record by id users_signatures:b3409cf2-37e1-e61f-a297-450fcc55bb1b found Query Failed:SELECT users_signatures.* , users_signatures_cstm.* FROM users_signatures LEFT JOIN users_signatures_cstm ON users_signatures.id = users_signatures_cstm.id_c WHERE users_signatures.id = 'b3409cf2-37e1-e61f-a297-450fcc55bb1b' LIMIT 0,1::MySQL error 1146: Table 'crm450.users_signatures_cstm' doesn't exist

----

Attempted replacement of UserSignature.php with the one from crm450-org/modules/Users and this results in the signature edit page/screen displaying nothing but the following:
Retrieving record by id users_signatures:b3409cf2-37e1-e61f-a297-450fcc55bb1b found Query Failed:SELECT users_signatures.* , users_signatures_cstm.* FROM users_signatures LEFT JOIN users_signatures_cstm ON users_signatures.id = users_signatures_cstm.id_c WHERE users_signatures.id = 'b3409cf2-37e1-e61f-a297-450fcc55bb1b' LIMIT 0,1::MySQL error 1146: Table 'crm450.users_signatures_cstm' doesn't exist

---

damnit, should have started with looking at logs

Sun Oct 1 23:01:26 2006,701 [24412] FATAL SugarCRM - MySQL error 1146: Table 'crm450.users_signatures_cstm' doesn't exist
Sun Oct 1 23:01:58 2006,117 [3180] FATAL SugarCRM - MySQL error 1146: Table 'crm450.users_signatures_cstm' doesn't exist
Sun Oct 1 23:09:07 2006,041 [24416] FATAL SugarCRM - MySQL error 1146: Table 'crm450.users_signatures_cstm' doesn't exist
Sun Oct 1 23:09:24 2006,527 [23074] FATAL SugarCRM - MySQL error 1146: Table 'crm450.users_signatures_cstm' doesn't exist
Sun Oct 1 23:09:45 2006,498 [16371] FATAL SugarCRM - MySQL error 1146: Table 'crm450.users_signatures_cstm' doesn't exist
Sun Oct 1 23:10:06 2006,313 [5234] FATAL SugarCRM - MySQL error 1146: Table 'crm450.users_signatures_cstm' doesn't exist
Sun Oct 1 23:21:16 2006,418 [1571] FATAL SugarCRM - MySQL error 1146: Table 'crm450.users_signatures_cstm' doesn't exist
Sun Oct 1 23:21:30 2006,768 [24414] FATAL SugarCRM - MySQL error 1146: Table 'crm450.users_signatures_cstm' doesn't exist

after checking the db, I see the signatures are stored in the table users_signatures opposed to users_signatures_cstm

[chrisky]

I got about thirty minutes in today (remotely) in which I was trying to finish up tackling this issue, and for either the Sugar team or anyone else that finds it helpful, heres cut & paste again of my 'funky' notes:

10-02-06 one pm @ Starbucks (Esco) -Chris

start of Monday's work on email signature bug -Chris

the table name for UserSignature.php of users_signatures_cstm is having the _cstm appended onto what should be the table name of users_signature, by SugarBean

I believe function getJoin at line 125 of DynamicFields is the code actually responsible for adppending the cstm onto the table name
the table name users_signatures needs to be removed from and not included in the variable $modules (an array of table names)

the table is not listed in the custom_modules array of modules.php
hmm, this table should not be getting that _cstm appendation

the table name not being a custom table, the sugarbean is not being over-riden by UserSignature.php where it should be taking precendance and pushing the table name of users_signature
problem is between the three files UserSignature.php, DynamicField.php, and possibly SugarBean.php.

40 minutes into jumping back and forth between various files in attempt to follow the code logic

this would be easier from console, argh, opposed to remotely on the notebook via cdma.
15 mins till my appointment, I'm gonna have to finish this tonight,
goal is to make sure that users_signatures table name doesn't get pushed to the modules array of custom table names
OR
I could just take the approach of changing the table name in the SQL db to this users_signatures_cstm name and then ensure that all code of which accesses
and retrieves this tables data is functioning, i.e. email's modules IS and DOES access without problem the table data and attach the appropriate signatures onto outbound emails.

Today, also need to open a route to server 6 allowing me remote access to secure shell, as I spaced that and couldn't get into server 6 remotely today.

[chrisky]

ahahahahah,

I was sitting here, renaming the original (450c1155) files back to the proper names so that they were used opposed to the 450b1144 files I individually replaced them with..
Funniest thing happened, Sugar is sitting there on that hard drive rolling on the floor while laughing its a$$ off at making me look like an idiot!

As if running a man over with a semi-truck isn't enough, ol'Sug threw that big bad boy in reverse.. kep-plop! over my already smashed body before stopping, staring at me and
laughing some more...

Then Sug gets that look in the eye'.. Ya know, the one... where Sug is plotting and planning the curve ball of a lifetime; the biggest challenge for ya that ol'Sug can come up
with, just before throwin'er back in drive and floorin' it!!

KER-THUMP!! Crrrruuuuunnnnccccchhhhhhhhhhhhh....



I'm gonna fix that bugger good! Sug's gonna pay!@! Just watch me.. *evily chuckling*
I'll fdisk Sug's LVM; roflmao... We'll see who's the boss!

Okay, the story is that I was just renaming the original 450c1155 files back to their correct filenames so that Sug was using the 450c files opposed to the 450b1144 files I had
indidviually replaced them with for a little experiement in attempt to sidestep alot of debuggin since I'm kinda of a fruit loop leprachaun today, no thanks to all the meds,
treatment, pain, suffering, dosed with liquor since early this evening in attempt to reduce this, argh..

After more than halfway finishing, I went to load/reload a sugar page.. and got a nice, clean, WHITE BLANK SCREEN.
That's a first, EVER aside from the blank screen on the email signature bug in which I just learned of yesterday thanks to a SugarForums post and have been working on (for a few
last night and a very short time twice today).

Real funny I must say... Too bad I got the last laugh!

Back and working again, at least as much as 450c was working before.
Screw messing around with trying to figure out which file I broke somehow as I' intended on winning that battle before going to sleep.

And for a good number of the Sugar users out their, take notes as I'm going to the point of posting a screenshot as to how easily you can restore sugar's installation (sug's db is a seperate topic though just as easy).

Every single person that has posted, might post, or does post something along the lines of:
'help me, it's broken NOW....(after doing or performing some act, such as module install, modification, upgrade, patch, etc.)'

...should have such posts deleted while be referred/point towards some adequate backup & restore manual (help, how-to, guideline, etc).

[root@VoIP7 html]# ls crm* -d -al
drwxr-xr-x 17 asterisk asterisk 4096 Jun 7 17:06 crm
drwxr-xr-x 16 asterisk asterisk 4096 Sep 11 03:35 crm20d
drwxr-xr-x 17 asterisk asterisk 4096 Sep 11 09:19 crm420dtst
drwxrwxrwx 17 asterisk asterisk 4096 Sep 20 13:14 crm45
drwxr-xr-x 18 asterisk asterisk 4096 Oct 3 00:22 crm450
drwxr-xr-x 16 asterisk asterisk 4096 Sep 21 02:06 crm450-92606-3am
drwxr-xr-x 18 root root 4096 Sep 30 02:21 crm450-92706-1pm
drwxr-xr-x 18 root root 4096 Sep 30 21:23 crm450-93006-9pm
-rw-r--r-- 1 root root 9964317 Sep 26 20:21 crm450-backup-92606-820pm.tar.gz
-rw-r--r-- 1 root root 15774060 Sep 27 06:47 crm450bckup-92706-7am.tar.gz
-rw-r--r-- 1 root root 23929538 Oct 2 22:10 crm450c1155-notworking.100206.tar.gz
drwxr-xr-x 18 asterisk asterisk 4096 Sep 25 12:21 crm450-org
-rw-r--r-- 1 root root 28477440 Sep 17 15:38 crm450original.tar
drwxrwxr-x 16 asterisk asterisk 4096 Sep 20 13:55 crm45b1
drwxr-xr-x 17 asterisk asterisk 4096 Sep 11 03:53 crmold420d
[root@VoIP7 html]# mv crm450 crm450-broken-100306-1230am
[root@VoIP7 html]# tar zxf crm450c1155-notworking.100206.tar.gz
[root@VoIP7 html]# chmod -R asterisk.asterisk crm450
chmod: invalid mode string: `asterisk.asterisk'
[root@VoIP7 html]# chown -R asterisk.asterisk crm450
[root@VoIP7 html]#


And since I had to bring it up, I rightfully have to be thorough and share the command for creating the backup (that I examplify above) for those
incapable of seeking out (figuring out) on their own how to perform such, so here it is:

[root@VoIP7 html]# tar zcf /WhereEverYouWantToStoreTheCompressedSugarCRMBackup File/crm-date-time.tar.gz /WhatEverThePathIsToYourSugarCRMInstallation/var/www/html/crm450/

Note: whereby you need to change the paths accordingly to your specific machine, and the date & time portions of the compressed sugar backup (do as you please, but I have a
very good, undebatable, and logical reason behind putting the date and time in the filename).

Note: also be sure that the path & directory name for your sugarcrm installation (in my personal example above where on that server {7} I had it in a directory named crm450)
INCLUDES THE TRAILING FORWARD SLASH! THIS IS NECESSARY and is responsbile for including all the directories contents and its sub-directories and their contents as well.

I used full path names in my example above, thus if you utilize that method you are able to perform such from any directory that you may be located in, so long as you're at a
shell prompt.

And as for how to do it on windows machines... I equate running using windows as the OS for these types of applications (various internet based daemons and services) to that of
trying to dig a grave or trench with a SPOON. I sure can't debate the fact that it can be done and is possible... yeapers, you can dig a trench with a spoon; however, it's the
wise man that would go get a shovel. It's the wiser man that would go get a little 'ditch witch' or similar small earth moving/digging machine, while it's the wisest man that
would go a CATERPILLAR, sit in comfort drinking an ice cold drink while excavating such grave or trench in the blink of an eye.. and without breaking a sweat..

[chrisky]

I went ahead and created a sql file with the exported signatures from
users_signatures table, of which sql file was instructed to create a new table
named users_signatures_cstm with identicial spec to that of the non _cstm table

no go,

I' just dropped the table and modified my sql file whereby I appended an _c to
the id column so that it is now named id_c and about to run this
tried... ooops, missed a spot... had to rename the id field also in the insert
command.. too tired for this and should be going to bed though fighting the
exhaustion and not wanting to.
did it again, missed the primary key.. wow

How curious..

This worked.. well kinda..the DetailView doesn't break now where it attempts to
display the signature;
Signatures can be edited and for editing already created signatures, they're
pulled from the _cstm table;
Signatures can be created (heres where it gets interesting) however, they get
stored in the users_signatures table opposed to the _cstm table..

and of course, as you could guess, when I attempt to edit what was a 'newly
created' signature, though the Edit page comes up & displays properly, the
signature is not retrieved nor displayed.

Frustrating that I havn't a clear head as a result of todays events, which has
prevented me from really being able to think, focus, or debug.

Though this detail will help me later in tracking down that issue, and now I'm
more than even sold on my little theory that the Studio bugs are directly
related to this or at least in the manner than their caused by similar or equal
things.

It's nice to finally have a lead on Studio, as until today, I hadn't a clue on
it and have just gottten extremely familiar with Sugar in regards to custom
fields, and acutally have a full notebook sheet of paper (as my cheat sheet,
memory wise) listing each file/spot in which relates to such, so when I have to
run around fixing them I don't spend minutes or longer trying to figure out
again what & where..

For those curious, at least in regards to the Leads module and character for
character below I've typed portions of my note sheet:

-----------------
* cache/dynamic_fields/Leads/fields.php

modules/Leads/DetailView.html
*displayed to end user of the crm
*DO NOT edit this but rather the cache/studio/working/~~files (studio templates)
modules/Leads/tpls/DetailView.html


cahce/studio/custom/working/modules/Leads/DetailView.html
*this is the actual (user template display file) which sugar Studio edits &
creates/publishes the /modules/Leads/DetailView file from.
custom/working/modules/Leads/DetailView.html


custom/modules/Leads/language/en_us.lang.php
* holds the actual field labels displayed to the end user


SQL table holding the custom fields data is leads_cstm


SQL table is named fields_meta_data
--------------