Droidz Posted February 26, 2019 Share Posted February 26, 2019 Hello, I get error: Quote Column 'perm_type' cannot be null /home/sites/wrobot/site/www/applications/cms/setup/upg_104000/upgrade.php::34 UPDATE `ips_core_permission_index` core_permission_index SET perm_type=CONCAT( perm_type, '_', (SELECT category_database_id FROM `ips_cms_database_categories` AS `cms_database_categories` WHERE category_id=perm_type_id) ) WHERE app=? AND perm_type=? Has anyone encountered the same problem? A trick? Thank you Link to comment Share on other sites More sharing options...
Adlago Posted February 26, 2019 Share Posted February 26, 2019 UPDATE `ips_core_permission_index` core_permission_index SET perm_type=CONCAT( perm_type, '_', (SELECT category_database_id FROM `ips_cms_database_categories` AS `cms_database_categories` WHERE category_id=perm_type_id) ) WHERE app=? AND perm_type=? If you know how, run this SQL command in your database. If not, create ticket support in your client area Link to comment Share on other sites More sharing options...
Droidz Posted February 26, 2019 Author Share Posted February 26, 2019 The SQL command was not working. The support saff have resolved my problem. Link to comment Share on other sites More sharing options...
Black Tiger Posted February 26, 2019 Share Posted February 26, 2019 For anybody else wanting to use the MySQL command... it's missing a ; at the end. So the correct one should read: UPDATE `ips_core_permission_index` core_permission_index SET perm_type=CONCAT( perm_type, '_', (SELECT category_database_id FROM `ips_cms_database_categories` AS `cms_database_categories` WHERE category_id=perm_type_id) ) WHERE app=? AND perm_type=?; Link to comment Share on other sites More sharing options...
Stuart Silvester Posted February 26, 2019 Share Posted February 26, 2019 If you run into this issue, you can submit a ticket for support and we'll be able to complete your upgrade. Link to comment Share on other sites More sharing options...
bfarber Posted February 27, 2019 Share Posted February 27, 2019 22 hours ago, Black Tiger said: For anybody else wanting to use the MySQL command... it's missing a ; at the end. So the correct one should read: UPDATE `ips_core_permission_index` core_permission_index SET perm_type=CONCAT( perm_type, '_', (SELECT category_database_id FROM `ips_cms_database_categories` AS `cms_database_categories` WHERE category_id=perm_type_id) ) WHERE app=? AND perm_type=?; Unfortunately, it's not that simple. Firstly, the query posted here is broken (it has ? placeholders for prepared statement values). Secondly, the error itself arises with specific orphaned data that will need to be cleaned up in order to be able to run the query. We have resolved the issue for our next release, but in the mean time you will need to submit a ticket to proceed most likely. Link to comment Share on other sites More sharing options...
Black Tiger Posted February 27, 2019 Share Posted February 27, 2019 A ticket is ofcourse the best way to proceed. I just wanted to inform that the given code was missing a ; at the end. But ofcourse one can better submit a ticket in such case. Link to comment Share on other sites More sharing options...
GoAncestry Posted March 2, 2019 Share Posted March 2, 2019 Seems I have hit a snag similar or the same. I am hosted through another vendor. Is this something I have to do, or can do through WHM ? Link to comment Share on other sites More sharing options...
Black Tiger Posted March 2, 2019 Share Posted March 2, 2019 As said, best is to send in a ticket with Invision support. Link to comment Share on other sites More sharing options...
GoAncestry Posted March 2, 2019 Share Posted March 2, 2019 I have. Hope they get back to me soon. Link to comment Share on other sites More sharing options...
Black Tiger Posted March 3, 2019 Share Posted March 3, 2019 You probably have the same issue as I'm having, which is that it's weekend and then nothing much is happening. 😞 They're very busy with responding to tickets with the new 4.4 coming out and I even discovered a new bug in the convertor (next to two other bugs I found)... One of them is fixed now, but the others not, so still can't convert and start using IPS. I hope for the both of us hey have a bit more time this week. Link to comment Share on other sites More sharing options...
Rhett Posted March 3, 2019 Share Posted March 3, 2019 4 hours ago, Black Tiger said: You probably have the same issue as I'm having, which is that it's weekend and then nothing much is happening. 😞 They're very busy with responding to tickets with the new 4.4 coming out and I even discovered a new bug in the convertor (next to two other bugs I found)... One of them is fixed now, but the others not, so still can't convert and start using IPS. I hope for the both of us hey have a bit more time this week. We're always around, if it helps, there have been over 100 replies to tickets today alone, while support is often slower on the weekends, we have some great staff that recognize the need during release periods and really care about our customers, and do spend some weekend time assisting customers who like to break things during the weekend. We all, of course, recommend you do this during the week for a much faster response time though. 😛 Link to comment Share on other sites More sharing options...
Maksim Posted March 3, 2019 Share Posted March 3, 2019 what was the cause of this error? Conversion? or regular upgrade? How likely is someone to see it? Thanks. (and this is partly why you wait for following releases. =P) Link to comment Share on other sites More sharing options...
Rhett Posted March 3, 2019 Share Posted March 3, 2019 On 2/27/2019 at 5:58 AM, bfarber said: Unfortunately, it's not that simple. Firstly, the query posted here is broken (it has ? placeholders for prepared statement values). Secondly, the error itself arises with specific orphaned data that will need to be cleaned up in order to be able to run the query. We have resolved the issue for our next release, but in the mean time you will need to submit a ticket to proceed most likely. 2 ^^ Just now, Maksim said: what was the cause of this error? Conversion? or regular upgrade? How likely is someone to see it? Thanks. (and this is partly why you wait for following releases. =P) Link to comment Share on other sites More sharing options...
Black Tiger Posted March 3, 2019 Share Posted March 3, 2019 and do spend some weekend time assisting customers who like to break things during the weekend. Ah I'm sorry. I did not see any answer in a weekend a bit before the 4.4 release, when I found a bug in Commerce for somebody else, so hence my thought support ticket staff were closed during the weekend. 😉 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.