Yetiforcecrm: Unable to create Lead/Organisation on 3.2.6

[Raggazzoo]

I upgrade my 3.1.629 to 3.2.0 without problem, a lot of things are solved but I still can't create a Lead or an Organisation.

After validate the form I got "HTTP ERROR 500".

In #3404 @paula-w talks about an additional package for people whose version is higher than 3.1.247.
When do you think It could be available?

I got a lot of pressure in my company for the features of the 3.2!

Thank's!

[Raggazzoo]

No one have a clue? (Test on 3.2.36)

[Raggazzoo]

There is the console output on dashboard

And after validation of the creation form

[nic86]

active log php:
set 'LOG4PHP_DEBUG' => true, in config/debug.php
restart webservice
navigate to the page that not permit to create record
and analyze cache/logs/system.log

the error also appears as an administrator?
the problem may be in the files user_privileges or in profile permission.
in the files user_privileges in array $profileActionPermission verify if the save action is equal 0 (0=>0) for the module idaccount(6) and idlead(7)

[Raggazzoo]

I activated apache log display
Fatal error: Call to a member function rowCount() on boolean in /var/www/yetiforce/include/database/PearDatabase.php on line 446

There is the file cache/logs/system.log
system.log

The problem is also here in administrator, I will check user_privileges thank's!

[Raggazzoo]

I don't see the value 0(0=>0) on my fisrt user

My admin got this

[nic86]

this is your error:

Thu Sep 1 14:05:58 2016,314 [27295] ERROR DB - Query Failed: INSERT INTO u_yf_crmentity_search_label (crmid,searchlabel,setype) VALUES (?,?,?) | Unknown column 'setype' in 'field list' | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'setype' in 'field list'(/var/www/yetiforce/include/database/PearDatabase.php : 445)
Thu Sep 1 14:05:58 2016,314 [27295] ERROR DB -

0 LoggerCategory->error('Query Failed: INSERT INTO u_yf_crmentity_search_label (crmid,searchlabel,setype) VALUES (?,?,?) | Unknown column 'setype' in 'field list' | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'setype' in 'field list'(/var/www/yetiforce/include/database/PearDatabase.php : 445)') in include/database/PearDatabase.php(175):

1 PearDatabase->log('Query Failed: INSERT INTO u_yf_crmentity_search_label (crmid,searchlabel,setype) VALUES (?,?,?) | Unknown column 'setype' in 'field list' | SQLSTATE[42S22]: Column not found: 1054 Unknown column 'setype' in 'field list'','error') in include/database/PearDatabase.php(377):

2 PearDatabase->pquery('INSERT INTO u_yf_crmentity_search_label (crmid,searchlabel,setype) VALUES (?,?,?)',[12916,TEST,Leads]) in include/database/PearDatabase.php(445):

3 PearDatabase->insert('u_yf_crmentity_search_label',[12916,TEST,Leads]) in include/Record.php(230):

4 includes\Record->updateLabel('Leads','12916','') in modules/Vtiger/handlers/RecordLabelUpdater.php(20):

5 Vtiger_RecordLabelUpdater_Handler->handleEvent('vtiger.entity.aftersave') in include/events/VTEventTrigger.inc(158):

6 VTEventTrigger->trigger() in include/events/VTEventsManager.inc(125):

7 VTEventsManager->triggerEvent('vtiger.entity.aftersave') in include/CRMEntity.php(849):

8 CRMEntity->save('Leads') in modules/Vtiger/models/Module.php(181):

9 Vtiger_Module_Model->saveRecord() in modules/Vtiger/models/Record.php(294):

10 Vtiger_Record_Model->save() in modules/Vtiger/actions/Save.php(81):

11 Vtiger_Save_Action->saveRecord() in modules/Vtiger/actions/Save.php(58):

12 Vtiger_Save_Action->process() in include/main/WebUI.php(220):

13 Vtiger_WebUI->process() in index.php(25):

Unknown column 'setype' in table `u_yf_crmentity_search_label

[nic86]

$profileactionpermission= [idtab=>[idaction=>(0=true,1=false),etc],idtab=>[idaction=>(0=true,1=false),etc],etc];

[Raggazzoo]

I have alter the table structure on my old database
u_yf_crmentity_search_label

But it don't seems to be enought

[nic86]

see the cache/logs/system.log

[Raggazzoo]

I done an alter table on vtiger_modentity_num

And it seems to be good!!!

[Raggazzoo]

I will continue to test all functions to check if everything is OK.

Thank's a lot @nic86 !

[Raggazzoo]

I was too optimistic, now I can't open a lead or an organisation...

On system.log I got this
`Thu Sep 1 17:49:25 2016,787 [29650] ERROR System - LBL_NOT_ACCESSIBLE => /var/www/yetiforce/include/main/WebUI.php:73
Thu Sep 1 17:49:25 2016,787 [29650] ERROR System -

0 LoggerCategory->error('LBL_NOT_ACCESSIBLE => /var/www/yetiforce/include/main/WebUI.php:73') in include/main/WebUI.php(226):

1 Vtiger_WebUI->process() in index.php(25):`

[Raggazzoo]

When I click on a lead I got an other error 500.

This is my system.log
system.log

My record is the 12909

[nic86]

include/main/WebUI.php the error throw in function:

protected function triggerCheckPermission($handler, $request)
        {
                $moduleName = $request->getModule();
                $moduleModel = Vtiger_Module_Model::getInstance($moduleName);

                if (empty($moduleModel)) {
                        throw new \Exception\AppException(vtranslate($moduleName) . ' ' . vtranslate('LBL_HANDLER_NOT_FOUND'));
                }

                $userPrivilegesModel = Users_Privileges_Model::getCurrentUserPrivilegesModel();
                $permission = $userPrivilegesModel->hasModulePermission($moduleModel->getId());

                if ($permission) {
                        $handler->checkPermission($request);
                        return;
                }
                throw new \Exception\NoPermitted('LBL_NOT_ACCESSIBLE');
        }

this return false:
$permission = $userPrivilegesModel->hasModulePermission($moduleModel->getId());

[Raggazzoo]

It's because my column id is null on vtiger_modentity_num...

Hum... I must wait a database patch don't you think?

[nic86]

you've probably had some updating errors in database.
I suggest, if you have a backup, to go back to the previous version, or install a fresh version 3.2 and migrate the database data.

[Raggazzoo]

Ok, which tables have I to import on new database?

I have already install a fresh version my dev environnement but I can't import all my data, only users, workflows, custom module, leads, organisations and opportunities.

Is it possible to import history, reports and events?

[nic86]

it depends if you have maintained the same id of records (table crmentity) during import to the new database. You may install version 3.1 and overwrite your old database and try a new upgrade to 3.2.
It is not an easy job, if you do not know how to do you can ask for help to the shop of yetiforce.

[Raggazzoo]

Do you planned to make the DB patch on the 3.3 release ?

[bpabiszczak]

Such errors require developer's analysis. It would be solved within 1-2 hours and a fix would be uploaded to YetiForce, but you prefer to discuss it for about a week, although it doesn't bring any results. Isn't it a waste of time?

[Raggazzoo]

I will buy a support package you're right.

Does a SILVER Package is enought to do :

• Database upgrade to 3.2.0 from 3.1.629
• Make my CALDav work #3064

Thank's!

[paula-w]

It might take 15 minutes, but it might take 2 hours as well. We have to access the system, enable logs, and verify the problem. We'll need up to 1h for verification and assessment. If it's something simple then we can fix it right away; if it requires more time to fix we'll send you an explanation and ask for instructions on how to proceed.

[Raggazzoo]

Ok I will purchase One Man Hour in this case, is it possible to work on it tomorrow?

[bpabiszczak]

Yes.

[Raggazzoo]

Allright let's go =)

[paula-w]

Full analysis of the problem was sent directly to your email. In our opinion all the problems result from incorrectly executed updates.