Advertisement:

Author Topic: Problem with external question  (Read 700 times)

Offline Jimmkos

  • Newbie
  • *
  • Posts: 5
Problem with external question
« on: June 29, 2019, 02:26:11 PM »
Hello all,
a friend of mine is running a smf forum.
Im trying to to connect with his database from my own server (Windows) with asp scripting but Im always getting the following error

[MySQL][ODBC 5.3(w) Driver]Unknown character set: 'utf8mb4'

The connection string Im using is the following

Driver={MySQL ODBC 5.3 UNICODE Driver}; Server=<IP>; uid=<Username>; pwd=<Password>; database=<database>; option=3; port=3306;

Can anyone tell me whats wrong?

Thank you for your time!

Offline Jimmkos

  • Newbie
  • *
  • Posts: 5
Re: Problem with external question
« Reply #1 on: June 29, 2019, 02:27:15 PM »
The title should be "Problem with external server"

My bad, Im sorry.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,500
  • Gender: Male
    • Kindred-999 on GitHub
Re: Problem with external question
« Reply #2 on: July 04, 2019, 01:08:50 PM »
I don't believe that SMF supports that sort of connection....

Also, running two sites, with different connections on the same database just won't work... ever
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Jimmkos

  • Newbie
  • *
  • Posts: 5
Re: Problem with external question
« Reply #3 on: July 06, 2019, 05:46:55 PM »
Can you show me a connection sample smf is using?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,500
  • Gender: Male
    • Kindred-999 on GitHub
Re: Problem with external question
« Reply #4 on: July 06, 2019, 07:29:22 PM »
well, it's not actually an SMF issue... it's an issue with your server(s) and the versions they are using

https://stackoverflow.com/questions/21911733/error-1115-42000-unknown-character-set-utf8mb4
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Jimmkos

  • Newbie
  • *
  • Posts: 5
Re: Problem with external question
« Reply #5 on: July 06, 2019, 07:55:39 PM »
When saying "versions", you mean smf ones?

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,104
  • Gender: Male
    • Macedonian electronics forum
Re: Problem with external question
« Reply #6 on: July 06, 2019, 10:07:24 PM »
No, he means the MySQL version on the server ;).

A quote from the link Kindred shared.

Quote
Your version does not support that character set, I believe it was 5.5.3 that introduced it. You should upgrade your mysql to the version you used to export this file.
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline Jimmkos

  • Newbie
  • *
  • Posts: 5
Re: Problem with external question
« Reply #7 on: July 09, 2019, 05:22:55 AM »
Thank you all