charliedelong

(I updated my post to have the list of items from the sticky post. Sorry I missed that the first time around...)

• X2EngineCRM Version - 4.1.1
• Module the Bug is Located In (Contacts, Actions, etc.) - UPDATE
• Copy/Paste of the PHP Error (if there is one) - BELOW
• HTML Error Code (if there is one)- BELOW
• A Brief Description of what you were doing when the bug occurred (bonus points if the bug is reproducible - I attempted an update (to 4.1.3) this morning and recieved this error
• A list of files that you have modified (if any) - NONE
• Your PHP version - 5.3.18

I attempted an update (to 4.1.3) this morning and recieved this error:

Error Code: 500
Error Message: CDbCommand failed to execute the SQL statement: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'createDate' in 'field list'
Stack Trace: [click to toggle display]
X2Engine Version: 4.1.1
PHP Version: 5.3.18

I am unable to submit the error report because the page has lost all of its styling and when I click any of the links it just links me to index.php/admin/updater?scenario=update# and takes me to the top of the page. I took (and attached) a screenshot of what the page looks like. (appears as if it has lost it's CSS)

I am in the process of restoring the files from my daily backups, so no data should be lost.

Thanks in advance for your help!

-Charlie

UPDATE - I am back up and running after the restore, but still on the old version (4.1.1)

I stumbled across a feature called "Create Activity Feed Report Email" that states:

"Please note that this report will not function if you do not have the Cron service turned on, please check with your administrator if you are unsure."

I verified that my host has the capabilities, and I have used with with another portion of our website. But when I choose options and save i just get the following error:

Oops!

Send Error Report

Here's a quick list of what will be included in the report:

Error Code: 500
Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'giertsen_x2engine.x2_cron_events' doesn't exist
Stack Trace: [click to toggle display]
X2Engine Version: 4.1.1
PHP Version: 5.3.18

UPDATE: I tested it in Firefox/Chrome and Internet Exploder . Same result across the board. I have been hunting for this type of feature because then we can have our field people entering stuff and at the end of the week all of their notes go to an admin person to keep our other systems up t date with what changes and new contacts have been made.

UPDATE2: I found the file /protected/models/CronEvent.php listed on the internets and verified that I had it in my install and that it was in the correct folder. it all checked out fine. It seems to me that it is a MySQL issue, and I am unsure with a lot of that stuff, so any help is greatlu appreciated!  Thanks!

Occasionally I am getting an odd half screen when I try to use the login screen.  Either after hitting the logoff button, or just manually loading up the URL. It happens when using Chrome 31.0.1650.63 m.

It sort of looks like I just need to scroll up but there are no scroll bars, and the scroll on the mouse doesn't go that far up.

Sometimes a CRTL-F5 will fix it, otherwise I can just press enter to logon to the system, because my username and password are saved...

Not a big issue, I just thought I would try and help by sharing what I found.  let me knowif you need any more information on the setup, or issue!  Screenshot.PNG   25.14KB   121 downloads