Database Conversion Tools [Support Thread]

[swguy]

It doesn't matter how long the current data is. The field is sized for 255 characters. When a character takes 4 bytes (UTF), you can see this is > 1000.

[gernot]

Ah, now I understand. I need to reduce the size of the field definition to be < 1000 chars(=bytes) when using 4-bytes per character.

[swguy]

Correct - or change the index to work on less than 1,000 characters.

[Bubbadood]

Evening all,

I ran the tool and I believe corrected prior mismatch. However I'm still seeing the following message and unsure if it needs to be addressed.

Next Action

The database's character-set doesn't match DB_CHARSET.
Congratulations, no database issues were found.

Here is what my current output states after using the tool:

MySQL Version:
8.0.36

Zen-Cart Database Version:
2.1.0

Database Name:
dbs12804405

Database Prefix:
'zencrt_'

Database Character Set:
utf8mb4

DB_CHARSET:
utf8

Database Collation:
utf8mb4_general_ci

Number of Tables:
115

I checked all my configure and language files and they are set to utf8 and utf-8 accordingly.

[Bubbadood]

Unless this is relevant, found this under server info:

Database Variables: MySQL 8.0.36

Variable Name	Value

character_set_client	utf8mb3
character_set_connection	utf8mb3
character_set_database	utf8mb4
character_set_filesystem	binary
character_set_results	utf8mb3
character_set_server	utf8mb4
character_set_system	utf8mb3

[lat9]

Evening all,

I ran the tool and I believe corrected prior mismatch. However I'm still seeing the following message and unsure if it needs to be addressed.

Next Action

The database's character-set doesn't match DB_CHARSET.
Congratulations, no database issues were found. 

Here is what my current output states after using the tool:

MySQL Version:
8.0.36

Zen-Cart Database Version:
2.1.0

Database Name:
dbs12804405

Database Prefix:
'zencrt_'

Database Character Set:
utf8mb4

DB_CHARSET:
utf8

Database Collation:
utf8mb4_general_ci

Number of Tables:
115

I checked all my configure and language files and they are set to utf8 and utf-8 accordingly.

Right, you need to change the DB_CHARSET (in both the /admin/includes/configure.php and /includes/configure.php to read

define('DB_CHARSET', 'utf8mb4');

[Bubbadood]

Thank you Cindy. I swear FileZilla makes me nuts. I knew I did that so I had to go back and look at the logs. One of these days I'm going to start paying closer attention to the output window of FZ. I have no idea why FZ sometimes cannot overwrite files. I'm all good now... apologies for the noob mistake.

Status:    Starting upload of C:\Users\Bubba\Downloads\database-converter-2.0.1\configure.phpCommand:    cd "/collector/includes"
Response:    New directory is: "/collector/includes"
Command:    put "C:\Users\Bubba\Downloads\database-converter-2.0.1\configure.php" "configure.php"
Error:    /collector/includes/configure.php: open for write: permission denied
Error:    File transfer failed
Status:    Starting upload of C:\Users\Bubba\Downloads\database-converter-2.0.1\configure.php
Status:    Retrieving directory listing of "/collector/includes"...
Status:    Listing directory /collector/includes
Command:    put "C:\Users\Bubba\Downloads\database-converter-2.0.1\configure.php" "configure.php"
Error:    /collector/includes/configure.php: open for write: permission denied
Error:    File transfer failed

[torvista]

>I swear FileZilla makes me nuts

Try Beyond Compare, you'll never look back.

[NWCE]

I am in the process of upgrading my current site from v.1.5.8 to v.2.10

I have done all of the merging of files and installing of plugins and have tested and work well.

I then imported my live site (Zen Cart v.1.5.8) in and test, and everything works well.

I then ran v.2.0.1 of this plugin successfully (choosing utf8mb4_general_ci) and it breaks the Instant Search plug in that previously worked. My includes/config and Admin/includes/config files are already set to utf8mb4 in my live 1.5.8 site and database and current upgraded site....just wanted to run this to emoji errors, etc.

I received this error in the Debug Logs:

PHP Fatal error: MySQL error 1191: Can't find FULLTEXT index matching the column list ::
SELECT
p.*,
pd.products_name,
m.manufacturers_name,
MATCH(pd.products_name) AGAINST('love*' IN BOOLEAN MODE) AS name_relevance_boolean,
MATCH(pd.products_name) AGAINST('love' WITH QUERY EXPANSION) AS name_relevance_natural , MATCH(pd.products_description) AGAINST('love' WITH QUERY EXPANSION) AS description_relevance
FROM
zen_products_description pd
JOIN zen_products p ON (p.products_id = pd.products_id)
LEFT JOIN zen_manufacturers m ON (m.manufacturers_id = p.manufacturers_id)
WHERE
p.products_status <> 0
AND pd.language_id = 1
AND p.products_id NOT IN (1459,1458)
AND (
( MATCH(pd.products_name) AGAINST('love*' IN BOOLEAN MODE) + MATCH(pd.products_name) AGAINST('love' WITH QUERY EXPANSION) ) > 0 OR MATCH(pd.products_description) AGAINST('love' WITH QUERY EXPANSION) > 0
)
ORDER BY
name_relevance_boolean DESC,
name_relevance_natural DESC,
description_relevance DESC,
p.products_sort_order,
pd.products_name
LIMIT
38
==> (as called by) /home/mysite/public_html/new210/zc_plugins/InstantSearch/v4.0.3/classes/SearchEngineProviders/MysqlSearchEngineProvider.php on line 174 <== in /home/mysite/public_html/new210/includes/classes/db/mysql/query_factory.php on line 733.

In this error where is references the word "love"....that was the word I inputted into my search when testing...
Not only do I get this Debug Log error, but the Instant Search no longer works....in fact none of the Search works.

Any ideas why this happened and how to fix it???

[NWCE]

I have tried uninstalling the Instant Search Plugin completely by removing all of the files and then checking the Admin->Modules->Plugin Mgr to verify that it has been uninstalled...and it has.

I then reinstalled the plugin by uploading all of the files....I now see the plugin in Admin->Modules->PluginMgr and when I press the Install button, I receive the error at the top of my Admin page of:

Duplicate key name 'idx_products_name'
Duplicate key name 'idx_products_description'

The plugin will not install.

Hoping this helps to decipher what took place when using the database converter tool...and how to fix it?

Thanks for your help!