SMF Support > SMF 2.0.x Support

Problems Converting to UTF-8

(1/3) > >>

stormiecub:
I want to convert to UTF-8 on my forum, but I'm getting the following error:


--- Quote ---You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc desc blob NOT NULL,
CHANGE COLUMN module module tinyblob NOT NULL,
' at line 3
File: /home/becki79/public_html/birchwoodisle.com/Sources/ManageMaintenance.php
Line: 666
--- End quote ---

The problem is that I don't really know what I'm doing with SQL and the databases and I'm terrified of messing something up. I've run a backup of the database and I tried calling my host for help with resolving this but they don't know what I need to do. Web searches have turned up nothing in terms of how to upgrade other than to go through the forum maintenance. I can't find manual instructions for doing so.

Any help would be appreciated.

Storman™:
Do you have SMF Shop installed ?

MrPhil:
desc desc blob NOT NULL looks very strange. Any idea why there are two copies of the field name (desc)? Also, since DESC is a reserved keyword, it will probably have to be put in backticks:

--- Code: ---`desc` blob NOT NULL
--- End code ---
Very poor coding by whoever wrote this conversion code (or mod that adds this to the database). You will need to go into phpMyAdmin and find the table in question, and see how this is declared. It might take a change to the SMF conversion code to properly handle these odd cases. In the meantime, you might have to convert this entry by hand.

Note that depending on far along in the process you got in converting to UTF-8, part of your database may be in UTF-8 and part may still be in Latin-1. You will need to finish the job, and not wait too long!

stormiecub:
I do have the SMF shop installed and there's an error on uninstallation of it. What do I need to do to take it out in order to run the conversion, if this is indeed the problem?

If necessary, what do I need to do with the backup that I ran last night prior to attempting conversion? I really do know NOTHING about this stuff!

stormiecub:
I got the shop uninstalled correctly now by editing the files on the server, but now I still can't convert to UTF-8 and I'm not sure what I need to do in order to do this through phpMyAdmin since I'm not educated in using php and mySQL.

Navigation

[0] Message Index

[#] Next page