SMF Support > SMF 2.0.x Support

MySql help required

(1/2) > >>

Tonyvic:
I have recently migrated my SMF 2.0.2 forum to a new hosting company.
Previously I was able to see the text of Ajax Chat in the 'Text' column of the database. Since starting with the new host all I get in that column is [BLOB - **B] on every row, is there an easy way for a total noob to rectify the problem with MySql or other means?

TIA,
Tony

Arantor:
Not reliably, no. What it means is the import facility decided the best way to handle that column was to do so in binary, not text. There is no safe way to convert and guarantee the data won't be damaged.

Bigguy:
Is there a way instead of converting that from this point on he can make it show as text in the database instead of the blob***b or whatever he is getting now. ???

Arantor:
-sigh- No, there isn't.

You have to change the column in its entirety, and you can't safety transfer from BLOB to TEXT without risking integrity of the data. That's kind of the point of using BLOBs.

Tonyvic:
Many thanks,
If I uninstall the chatroom and remove the Ajax Chat tables, then reinstate chat is it likely to still default to BLOB or should it reinstall correctly to include the text?

Sorry if it's a stupid question, I just can't get my head around databases! ???

Tony

Navigation

[0] Message Index

[#] Next page