Database I/O Manager (DbIo) Plugin [Support Thread]

[LadyoftheCave]

Dear lat9,

I have the same issue as one of the first topics. I receive the following message:
The DbIo Manager does not support your installation, due to a mismatch between your DB_CHARSET (DB_CHARSET) and CHARSET (utf-8) values.

You have given a solution in the beginning, to change the configure.php file (define ('DB_CHARSET', 'utf-8'); into define ('DB_CHARSET', 'utf8');)

But.. I do not have that line into my configure file, only in the dis-configure.php file, but there is already the following line:

define('DB_CHARSET', 'utf8');

, is there an another way to solve this?

Best Regards,

[lat9]

@LadyoftheCave, I just posted on the thread that brought you here ... what version of Zen Cart are you running?

[LadyoftheCave]

Ohh thank you, I will check :) I have 1.5.4

[lat9]

Hmm, that's not right; for ZC 1.5.4, you should have a DB_CHARSET definition within both /includes/configure.php and /YOUR_ADMIN/includes/configure.php, towards the bottom, with the other database definitions.

You should check your database via phpMyAdmin to make sure that the "collation" setting for the tables is something on the order of utf8_general_ci. If that's the case, then just edit those two files to add the line

define('DB_CHARSET', 'utf8');

to each. Remember that the /includes/configure.php file is normally marked read-only, so you'll need to change those permissions before editing!

If the collations show latin1_{something}, then there are more corrections needed.

Converting from iso-8859-1 to utf8

[frank18]

Ohh thank you, I will check :) I have 1.5.4

I am guessing that you still use an old configure.php set, one maybe from ZC 1.3.9x, which has never been updated. If you do have a configure.php file with the definition as per above, then, yes, it is the correct one and only needs the definition updated.

[LadyoftheCave]

I am guessing that you still use an old configure.php set, one maybe from ZC 1.3.9x, which has never been updated. If you do have a configure.php file with the definition as per above, then, yes, it is the correct one and only needs the definition updated.

It could be, I have updated once from 1.3.9, I will check this, thank you :)

[LadyoftheCave]

Hmm, that's not right; for ZC 1.5.4, you should have a DB_CHARSET definition within both /includes/configure.php and /YOUR_ADMIN/includes/configure.php, towards the bottom, with the other database definitions.

You should check your database via phpMyAdmin to make sure that the "collation" setting for the tables is something on the order of utf8_general_ci. If that's the case, then just edit those two files to add the line

define('DB_CHARSET', 'utf8');

to each. Remember that the /includes/configure.php file is normally marked read-only, so you'll need to change those permissions before editing!

If the collations show latin1_{something}, then there are more corrections needed.

Converting from iso-8859-1 to utf8

Hi lat9,

I have added the lines to the configure.php files and now it works like a charm :)

Thank you

[LadyoftheCave]

Hi lat9,

Sorry, I have still one more question. You told me that it was possible to select only order files from a certain period, but I cannot find it, could you tell me where I can select this?

Best Regards,

[lat9]

Hi lat9,

Sorry, I have still one more question. You told me that it was possible to select only order files from a certain period, but I cannot find it, could you tell me where I can select this?

Best Regards,

To export orders based on status, date- or id-range:

• Click Tools->Database I/O Manager
• Choose the Orders handler from the top-most dropdown
• Tick the Show/Hide filters box
• Make your selections from the form fields now exposed.
• Click the Export button

[LadyoftheCave]

To export orders based on status, date- or id-range:

• Click Tools->Database I/O Manager
• Choose the Orders handler from the top-most dropdown
• Tick the Show/Hide filters box
• Make your selections from the form fields now exposed.
• Click the Export button

ahhh that is great, I totally missed that one, thank you :)