Bug #67831 TypeError: cannot concatenate 'str' and 'NoneType' objects
| Submitted: | 6 Dec 2012 20:48 | Modified: | 28 Feb 2017 15:20 |
|---|---|---|---|
| Reporter: | Willie Johnson | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Workbench: Migration | Severity: | S3 (Non-critical) |
| Version: | 5.2.44 CE | OS: | Windows (TypeError: cannot concatenate 'str' and 'NoneType' objects) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | MySQL CE | ||
[11 Dec 2012 13:07]
Sergio Andres De La Cruz Rodriguez
Hi: Can you paste here the content of your log file (Help --> Show Log File)?
[22 Mar 2013 16:46]
Armando Lopez Valencia
Hello. It will be very helpful if you can include the following data: Source OS: Source DB: Target OS: Target DB: A dump of the DB that you are trying to migrate. Besides that you can try with our latest WB version and let us know if the problem persist. Thanks.
[23 Apr 2013 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[20 May 2016 22:50]
Mamta Upadhyay
Reopening this bug because I am getting the same error with version 6.3 Source OS: Centos 6 Source DB: MySQL Target OS: Centos 6 Target DB: MySQL I am trying to migrate from one database into another on the same machine. Source database is case insensitive and target is case sensitive collation. Please help
[1 Aug 2016 18:51]
Dan Downs
In db_mysql_re_grt.py, reverseEngineer() function under the following sections:
Line 335: if get_routines:
After the lines "sql = result.stringByName("Create Procedure")" and "sql = result.stringByName("Create Function")" there needs to be check for if sql is valid before updating the progress bar. I fixed mine by putting the grt. lines under a "if sql and sql is not None:".
The error will happen if the user doesn't have ALTER ROUTINE grant as mysql will return null for the "Create Procedure" or "Create Function" fields when asked for a SHOW CREATE PROCEDURE or SHOW CREATE FUNCTION.
I got this last week on workbench 6.3.7, OS X 10.11.6, and mysql 5.6.26-74.
A proper fix might ask for the user's grants and just skip the two sections if its not possible, but I didn't go so far as to parse the SHOW GRANTS syntax, as applying the correct context might be "fun".
[31 Jan 2017 15:20]
MySQL Verification Team
Please try version 6.3.8. Thanks.
[1 Mar 2017 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.058 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: Received error while performing migration: TypeError: cannot concatenate 'str' and 'NoneType' objects ----------------------- LOGS ------------------------ Starting... Connect to source DBMS... - Connecting... Connecting to Mysql@gator391.hostgator.com:3306... Connected Connect to source DBMS done Reverse engineer selected schemata.... Reverse engineering hbirn_ODASoftwareDB from def - Preparing... - Preparing... Reverse engineering tables from hbirn_ODASoftwareDB - Retrieving table hbirn_ODASoftwareDB.EmailTemplates... - Reverse engineering hbirn_ODASoftwareDB.EmailTemplates... - Parsing MySQL SQL Script... - Processing object: EmailTemplates - Creating foreign key references... - Finished parsing MySQL SQL script. - Retrieving table hbirn_ODASoftwareDB.Emails... - Reverse engineering hbirn_ODASoftwareDB.Emails... - Parsing MySQL SQL Script... - Processing object: Emails - Creating foreign key references... - Finished parsing MySQL SQL script. - Retrieving table hbirn_ODASoftwareDB.Test... - Reverse engineering hbirn_ODASoftwareDB.Test... - Parsing MySQL SQL Script... - Processing object: Test - Creating foreign key references... - Finished parsing MySQL SQL script. - Retrieving table hbirn_ODASoftwareDB.Winks... - Reverse engineering hbirn_ODASoftwareDB.Winks... - Parsing MySQL SQL Script... - Processing object: Winks - Creating foreign key references... - Finished parsing MySQL SQL script. - Retrieving table hbirn_ODASoftwareDB.XXX... - Reverse engineering hbirn_ODASoftwareDB.XXX... - Parsing MySQL SQL Script... - Processing object: XXX - Creating foreign key references... - Finished parsing MySQL SQL script. - Retrieving table hbirn_ODASoftwareDB.rud3pProfileService... - Reverse engineering hbirn_ODASoftwareDB.rud3pProfileService... - Parsing MySQL SQL Script... - Processing object: rud3pProfileService - Creating foreign key references... - Finished parsing MySQL SQL script. - Retrieving table hbirn_ODASoftwareDB.rud3pService... - Reverse engineering hbirn_ODASoftwareDB.rud3pService... - Parsing MySQL SQL Script... - Processing object: rud3pService - Creating foreign key references... - Finished parsing MySQL SQL script. - Retrieving table hbirn_ODASoftwareDB.rudProfile... - Reverse engineering hbirn_ODASoftwareDB.rudProfile... - Parsing MySQL SQL Script... - Processing object: rudProfile - Creating foreign key references... - Finished parsing MySQL SQL script. - Retrieving table hbirn_ODASoftwareDB.rudProspect... - Reverse engineering hbirn_ODASoftwareDB.rudProspect... - Parsing MySQL SQL Script... - Processing object: rudProspect - Creating foreign key references... - Finished parsing MySQL SQL script. - Retrieving table hbirn_ODASoftwareDB.rudSearch... - Reverse engineering hbirn_ODASoftwareDB.rudSearch... - Parsing MySQL SQL Script... - Processing object: rudSearch - Creating foreign key references... - Finished parsing MySQL SQL script. - Retrieving table hbirn_ODASoftwareDB.rudSearchProspects... - Reverse engineering hbirn_ODASoftwareDB.rudSearchProspects... - Parsing MySQL SQL Script... - Processing object: rudSearchProspects - Creating foreign key references... - Finished parsing MySQL SQL script. Reverse engineering triggers from hbirn_ODASoftwareDB Reverse engineering stored procedures from hbirn_ODASoftwareDB - Retrieving stored procedure hbirn_ODASoftwareDB.GetAllTest... - Reverse engineering hbirn_ODASoftwareDB.GetAllTest... Traceback (most recent call last): File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\modules\db_mysql_re_grt.py", line 294, in reverseEngineer grt.modules.MysqlSqlFacade.parseSqlScriptString(catalog, wrap_sql(wrap_routine_sql(sql), schema_name)) File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\modules\db_mysql_re_grt.py", line 237, in wrap_routine_sql return "DELIMITER $$\n"+sql TypeError: cannot concatenate 'str' and 'NoneType' objects Traceback (most recent call last): File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\workbench\wizard_progress_page_widget.py", line 191, in thread_work self.func() File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\modules\migration_schema_selection.py", line 160, in task_reveng self.main.plan.migrationSource.reverseEngineer() File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\modules\migration.py", line 332, in reverseEngineer self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData) SystemError: TypeError("cannot concatenate 'str' and 'NoneType' objects"): error calling Python module function DbMySQLRE.reverseEngineer ERROR: Reverse engineer selected schemata: TypeError("cannot concatenate 'str' and 'NoneType' objects"): error calling Python module function DbMySQLRE.reverseEngineer Failed How to repeat: 1) Main form click data migration 2) specify source connection (remote) 3) specify target connection 4) select schema 5) click next 6) error occurs Suggested fix: Not Sure, suppose to perform the migration.