Importing data:
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Database error: Incorrect string value: ‘\xAE’ for column ‘description’ at row 1 (1366)
Invalid query: INSERT INTO cscart_shipping_service_descriptions (service_id, description, lang_code) VALUES (‘18’, ‘FedEx 2nd Day®’, ‘EN’)
Backtrace:
File: D:\Domains\xx.com\wwwroot\store\core\fn.database.php
Line: 233
Function: db_error
File: D:\Domains\xx.com\wwwroot\store\install\core\install.php
Line: 477
Function: db_query
File: D:\Domains\xx.com\wwwroot\store\install\core\install.php
Line: 116
Function: fn_parse_sql
File: D:\Domains\xx.com\wwwroot\store\install\index.php
Line: 25
Function: include
Hosting Company Says
“The error is being generated by the code itself. Please double check the collation type that the database needs to use because the special character of the “registered” symbol is causing the error.”
Anything?
Thanks
Hovik
Hosting Says
“The requirements are all satisfied. It does not give any specific collation. This is a question you might want to check their support for, as it is being thrown due to the script, not anything on the server.
Thank you,
Matt Johnson”
Did you remove the registered symbol?
[quote name=‘Tool Outfitters’]Did you remove the registered symbol?[/QUOTE]
No, where would i remove that?
thanks
Hovik
Shipping service description: FedEx 2nd Day[COLOR=“Red”]®[/COLOR]
[quote name=‘Tool Outfitters’]Shipping service description: FedEx 2nd Day[COLOR=“Red”]®[/COLOR][/QUOTE]
thank you for the help.
where file is that located in is what i meant.
thanks
hovik
[cscartfolder] => install => database => data.sql
It may take a while to delete all the uncompatible characters, your best bet is to find out how to change the character encoding on your database.
[quote name=‘hovik’]thank you for the help.
where file is that located in is what i meant.
thanks
hovik[/QUOTE]
I am guessing that is what you put in for a shipping method? If so, then go to shipping methods and delete the registered symbol.
[quote name=‘Tool Outfitters’]I am guessing that is what you put in for a shipping method? If so, then go to shipping methods and delete the registered symbol.[/QUOTE]
This is an installation error. He hasn’t put in any shipping methods.