[Vtigercrm-developers] vtiger CRM 5.4.0 RC is released !!!
Peter Dimov
phdimov at gmail.com
Fri Mar 30 11:17:31 PDT 2012
--
-- Table structure for table `vtiger_users`
--
CREATE TABLE IF NOT EXISTS `vtiger_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(255) DEFAULT NULL,
`user_password` varchar(128) DEFAULT NULL,
`user_hash` varchar(32) DEFAULT NULL,
`cal_color` varchar(25) DEFAULT '#E6FAD8',
`first_name` varchar(30) DEFAULT NULL,
`last_name` varchar(30) DEFAULT NULL,
`reports_to_id` varchar(36) DEFAULT NULL,
`is_admin` varchar(3) DEFAULT '0',
`currency_id` int(19) NOT NULL DEFAULT '1',
`description` text,
`date_entered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
`date_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_user_id` varchar(36) DEFAULT NULL,
`title` varchar(50) DEFAULT NULL,
`department` varchar(50) DEFAULT NULL,
`phone_home` varchar(50) DEFAULT NULL,
`phone_mobile` varchar(50) DEFAULT NULL,
`phone_work` varchar(50) DEFAULT NULL,
`phone_other` varchar(50) DEFAULT NULL,
`phone_fax` varchar(50) DEFAULT NULL,
`email1` varchar(100) DEFAULT NULL,
`email2` varchar(100) DEFAULT NULL,
`yahoo_id` varchar(100) DEFAULT NULL,
`status` varchar(25) DEFAULT NULL,
`signature` varchar(1200) DEFAULT NULL,
`address_street` varchar(150) DEFAULT NULL,
`address_city` varchar(100) DEFAULT NULL,
`address_state` varchar(100) DEFAULT NULL,
`address_country` varchar(25) DEFAULT NULL,
`address_postalcode` varchar(9) DEFAULT NULL,
`user_preferences` text,
`tz` varchar(30) DEFAULT NULL,
`holidays` varchar(60) DEFAULT NULL,
`namedays` varchar(60) DEFAULT NULL,
`workdays` varchar(30) DEFAULT NULL,
`weekstart` int(11) DEFAULT NULL,
`date_format` varchar(200) DEFAULT NULL,
`hour_format` varchar(30) DEFAULT 'am/pm',
`start_hour` varchar(30) DEFAULT '10:00',
`end_hour` varchar(30) DEFAULT '23:00',
`activity_view` varchar(200) DEFAULT 'Today',
`lead_view` varchar(200) DEFAULT 'Today',
`imagename` varchar(250) DEFAULT NULL,
`deleted` int(1) NOT NULL DEFAULT '0',
`confirm_password` varchar(30) DEFAULT NULL,
`internal_mailer` varchar(3) NOT NULL DEFAULT '1',
`reminder_interval` varchar(100) DEFAULT NULL,
`reminder_next_time` varchar(100) DEFAULT NULL,
`crypt_type` varchar(20) NOT NULL DEFAULT 'MD5',
`accesskey` varchar(36) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `user_user_name_idx` (`user_name`),
KEY `user_user_password_idx` (`user_password`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=642 ;
--
-- Dumping data for table `vtiger_users`
--
On Fri, Mar 30, 2012 at 12:30 PM, Pratim <pratim at vtiger.com> wrote:
> Hi,
>
> There is no known issue with this,Have you customized vtiger 5.2.0.Can you
> run the following command in your database and let us know what it shows
>
> desc vtiger_users;
>
>
> On Fri, Mar 30, 2012 at 9:57 PM, Peter Dimov <phdimov at gmail.com> wrote:
>
>> Hi Pratim,
>>
>> So if I upgrade to 5.4.0. RC from 5.2 following all the steps that should
>> get fixed?
>>
>> I have been banging my head on this for a few weeks now and I gave it to
>> a developer too.
>>
>> The problem is when I upgrade and login there is white screen.
>>
>> When I turn the errors on I see that the problem lies in the following
>> template code:
>>
>> $date = new DateTimeField(null);
>> $smarty->assign("DATE", $date->getDisplayDateTimeValue());
>>
>> that throws a fatal Error
>>
>> because fields are missing in the user table.
>>
>> Any experience with that?
>>
>>
>>
>>
>>
>> On Fri, Mar 30, 2012 at 11:17 AM, Pratim <pratim at vtiger.com> wrote:
>>
>>> Hi Petar,
>>>
>>> We had issue with date format dd-mm-yyyy and mm-dd-yyyy where standard
>>> filter was not working.This was the only known issue in 5.3.0 related to
>>> date format.This is fixed in 5.4.0 RC.
>>>
>>> You can check trac ticket in the following link
>>>
>>> http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7218
>>>
>>>
>>> On Fri, Mar 30, 2012 at 9:32 PM, Peter Dimov <phdimov at gmail.com> wrote:
>>>
>>>> Pratim
>>>>
>>>> I am trying to updgrade a 5.2 to 5.3 instance we have and once it goes
>>>> to 5.3 we have a problem with date format on user table and the DateTime
>>>> class won't load which crashes everything.
>>>>
>>>> We now want to go to 5.4.
>>>>
>>>> Have you had issues with the date formats and classes going from 5.2 ->
>>>> 5.3?
>>>>
>>>> Petar
>>>>
>>>> On Fri, Mar 30, 2012 at 8:50 AM, Pratim <pratim at vtiger.com> wrote:
>>>>
>>>>> Hi Doug,
>>>>>
>>>>> Yes 5.4.0 RC will be up-gradable to vtger 5.4.0 final release.
>>>>>
>>>>> On Fri, Mar 30, 2012 at 7:15 PM, Doug <sailsfast at gmail.com> wrote:
>>>>>
>>>>>> Will the rc be upgradeable to the final release?
>>>>>> On Mar 30, 2012 9:30 AM, "Asha" <asha at vtiger.com> wrote:
>>>>>>
>>>>>>> Hi All,
>>>>>>>
>>>>>>> We are glad to release 5.4 RC version of vtiger CRM open source
>>>>>>> product today. This version includes many usability improvements, features
>>>>>>> enhancements, and 100+ bug fixes. These changes have been previously
>>>>>>> deployed to our On Demand customers in the past 6 months.
>>>>>>>
>>>>>>> *Usability Enhancements in 5.4.0*
>>>>>>>
>>>>>>> **1. Simpler Top level menu, which can be configured using
>>>>>>> MenuEditor
>>>>>>> 2. Simpler UI for creating custom filters
>>>>>>> 3. Convert Lead UI has been redesigned to offer flexibility to users
>>>>>>> 4. Import Feature has been enhanced to make it robust
>>>>>>> 5. Ability to select records across pages, for Mass Edit or Bulk
>>>>>>> Email
>>>>>>> 6. Account has been renamed to Organization, and Potential to
>>>>>>> Opportunity
>>>>>>> 7. Easy access to hidden default widgets on home page.
>>>>>>>
>>>>>>> *Following are some notable features in 5.4.0 RC release*
>>>>>>>
>>>>>>> 1. Workflow module has been enhanced to allow you to create records
>>>>>>> automatically
>>>>>>> 2. Track who changed what with ‘View History’ for each record in the
>>>>>>> CRM
>>>>>>> 3. Webforms module to easily integration forms on your website with
>>>>>>> vtiger CRM
>>>>>>> 4. Create custom charts and add to Home page
>>>>>>> 5. Customer Portal enhanced for creating better customized settings
>>>>>>> 6. vcard Import for Contacts and Leads
>>>>>>> 7. Include Comments in Leads and Contacts Reports
>>>>>>>
>>>>>>> Please try out this version and email us your feedback to
>>>>>>> support at vtiger.com. We expect to release the 5.4 GA version before
>>>>>>> the end of April.
>>>>>>>
>>>>>>> *vtiger CRM 5.4.0 RC downloads :*
>>>>>>>
>>>>>>> vtiger CRM Source* : *vtiger CRM 5.4.0 – RC. tar.gz
>>>>>>> <http://sourceforge.net/projects/vtigercrm/files/vtiger%20CRM%205.4.0/Core%20Product/vtigercrm-5.4.0-RC.tar.gz/download>Customer
>>>>>>> portal* : *Customer Portal Plugin
>>>>>>> <http://sourceforge.net/projects/vtigercrm/files/vtiger%20CRM%205.4.0/Add-ons/vtigercrm-customerportal-5.4.0-RC.zip/download>Firefox
>>>>>>> Extension* : *vtiger CRM Firefox Plugin<http://sourceforge.net/projects/vtigercrm/files/vtiger%20CRM%205.4.0/Add-ons/vtigercrm-firefox-plugin-5.4.0-RC.xpi/download>
>>>>>>>
>>>>>>> *Documentation *: http://wiki.vtiger.com
>>>>>>>
>>>>>>> *Release Notes :* vtiger CRM 5.4.0 RC release notes<https://wiki.vtiger.com/index.php/Release_Notes_540>
>>>>>>>
>>>>>>> *Demo Links* :
>>>>>>> http://demo.vtiger.com
>>>>>>> http://demo.vtiger.com/portal
>>>>>>>
>>>>>>> *Customer portal login credentials:
>>>>>>> *User name : test at vtiger.com
>>>>>>> <http://www.vtiger.com/blogs/test@vtiger.com>Password : test
>>>>>>>
>>>>>>> *To Report Issues:* Please send email to support at vtiger.com or
>>>>>>> report on trac <http://trac.vtiger.com/>
>>>>>>>
>>>>>>> *Note* : This is release candidate and not encouraged to be used
>>>>>>> on production server.
>>>>>>>
>>>>>>> *Keep Voting! <http://crmmadness.capterra.com/> *vtiger CRM joins
>>>>>>> Salesforce and SugarCRM in Final 4 of CRM Madness competition.
>>>>>>>
>>>>>>> --
>>>>>>> Regards,
>>>>>>> Asha
>>>>>>> vtiger Team
>>>>>>>
>>>>>>> *Connect with us on: *Twitter <http://twitter.com/#%21/vtigercrm> *I
>>>>>>> * Facebook<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
>>>>>>> *I* Blog <http://blog.vtiger.com/>* I* Wiki<http://wiki.vtiger.com/index.php/Main_Page>
>>>>>>> *I *Forums <http://forums.vtiger.com/>*I* Website<http://vtiger.com/>
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> http://www.vtiger.com/
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> http://www.vtiger.com/
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Pratim
>>>>>
>>>>> vtiger Team
>>>>>
>>>>> *Connect with us on: *Twitter <http://twitter.com/#%21/vtigercrm> *I*
>>>>> Facebook<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
>>>>> *I* Blog <http://blog.vtiger.com/>* I* Wiki<http://wiki.vtiger.com/index.php/Main_Page>
>>>>> *I *Forums <http://forums.vtiger.com/>*I* Website<http://vtiger.com/>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> http://www.vtiger.com/
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Best Regards,
>>>>
>>>> Petar Dimov
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> http://www.vtiger.com/
>>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>> Pratim
>>> vtiger Team
>>>
>>> *Connect with us on: *Twitter <http://twitter.com/#%21/vtigercrm> *I*
>>> Facebook <http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
>>> *I* Blog <http://blog.vtiger.com/>* I* Wiki<http://wiki.vtiger.com/index.php/Main_Page>
>>> *I *Forums <http://forums.vtiger.com/>*I* Website <http://vtiger.com/>
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>
>>
>>
>> --
>> Best Regards,
>>
>> Petar Dimov
>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
>
> --
> Regards,
> Pratim
> vtiger Team
>
> *Connect with us on: *Twitter <http://twitter.com/#%21/vtigercrm> *I*
> Facebook <http://www.facebook.com/pages/vtiger/226866697333578?sk=wall> *I
> * Blog <http://blog.vtiger.com/>* I* Wiki<http://wiki.vtiger.com/index.php/Main_Page>
> *I *Forums <http://forums.vtiger.com/>*I* Website <http://vtiger.com/>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
--
Best Regards,
Petar Dimov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20120330/f30621fb/attachment-0002.html
More information about the vtigercrm-developers
mailing list