• Welcome to Simple Machines Community Forum. Please login or sign up.
September 21, 2021, 07:23:01 PM

News:

Follow SMF on Twitter.


SQL error in Upgrade

Started by GRIMPMASTER, November 10, 2009, 09:05:54 PM

Previous topic - Next topic

GRIMPMASTER

Hi,

I have tried to update my forum from 2.0 rc1.2   to 2.0 rc2

but in , "Database Changes" step they get an sql error

"Error
BLOB/TEXT column 'real_name' used in key specification without a key length"


can you explain me wat is ? and how to solve the problem.

Oldiesmann

This is likely caused by MySQL being compiled with "strict mode" enabled. The "strict mode" option makes MySQL complain about even the most minor issues, including things like this that it would normally ignore...

Try replacing your copy of upgrade_2-0_mysql.sql with the version I've attached, then run upgrade.php again (you will be given an option to continue from the previous spot, which should be fine).
Michael Eshom
Cincy Space - now open!

GRIMPMASTER

 thanks
i'm replacing the attached upgrade_2-0_mysql.sql , then i run upgrade.php again but not option to continue from the  spot,
>:(
Error!
BLOB/TEXT column 'poster_ip' used in key specification without a key length

ekfaysal

same thing is with me. please help

GRIMPMASTER

November 11, 2009, 06:39:41 AM #4 Last Edit: November 11, 2009, 07:14:52 AM by GRIMPMASTER
the upgrade is stoped in "Database Changes"  at  97%
Error!
BLOB/TEXT column 'poster_ip' used in key specification without a key length

when i reload the board , it work fine but somme text change example : "é " appear "é"
why ?

ekfaysal

Quote from: Oldiesmann on November 10, 2009, 09:49:56 PM
This is likely caused by MySQL being compiled with "strict mode" enabled. The "strict mode" option makes MySQL complain about even the most minor issues, including things like this that it would normally ignore...

Try replacing your copy of upgrade_2-0_mysql.sql with the version I've attached, then run upgrade.php again (you will be given an option to continue from the previous spot, which should be fine).

After using ure file and tried upgrading it shows me t his error Pleas check screenshot.
try to respond as soon as possible coz its my active forum on stake. please.

Oldiesmann

Quote from: GRIMPMASTER on November 11, 2009, 06:39:41 AM
the upgrade is stoped in "Database Changes"  at  97%
Error!
BLOB/TEXT column 'poster_ip' used in key specification without a key length

Sorry. Overlooked that index. Try the new version that I've attached.

Quote from: GRIMPMASTER on November 11, 2009, 06:39:41 AM
when i reload the board , it work fine but somme text change example : "é " appear "é"
why ?

The character issue is probably due to not having the proper language packs installed. You can install additional languages by going to Admin -> Configuration -> Languages and clicking on "Add Language".

Quote from: ekfaysal on November 11, 2009, 10:25:47 AM
Quote from: Oldiesmann on November 10, 2009, 09:49:56 PM
This is likely caused by MySQL being compiled with "strict mode" enabled. The "strict mode" option makes MySQL complain about even the most minor issues, including things like this that it would normally ignore...

Try replacing your copy of upgrade_2-0_mysql.sql with the version I've attached, then run upgrade.php again (you will be given an option to continue from the previous spot, which should be fine).

After using ure file and tried upgrading it shows me t his error Pleas check screenshot.
try to respond as soon as possible coz its my active forum on stake. please.

Sorry. That's my fault. It's trying to create an index on the first 255 characters of that column, but the column is only 80 characters long. Fixed in the attached version.
Michael Eshom
Cincy Space - now open!

ekfaysal

@  Oldiesmann
Thanx man. your file did the trick. its done 100% .
now im stucked. whenever i tried to open my forum it says

Maintenance Mode
Okay faithful users...we're attempting to restore an older backup of the database...news will be posted once we're back!

I shoud display my forum not this message. please help . thanx

ekfaysal

i had just run repair setting file. and now my forum is back.
thanx guys.

GRIMPMASTER

thanks , fine & flawless work  ;D
but if the probleme is in  "strict mode" enabled ,, how to disable the sql strict mode , this error can appear in anny server.

AndreT

Thank you. Really useful help topic and files!

JoannaMarie

Thanks so much for the file, can I suggest that it be included in the upgrade and install packages. It would save much headaches

Ajay

Thank you. This file worked perfectly.
Ajay D'Souza [nofollow]

amandato

This version of the upgrade_2-0_mysql.sql was not included in the RC3 that was released this week. Can these changes be included in the next releases of 2.0? There are many of us who have this strict mode MySQL server and would appreciate the fix being permanently added to the install/upgrades.

AndreT

Good point indeed. I posted a topic about this yesterday and also posted a working .sql which did the trick for me.

Truja

tnks.. i need this to fix DB to RC4

:)

airguard

December 20, 2011, 10:50:17 AM #16 Last Edit: December 21, 2011, 05:38:49 AM by airguard
great this worked for me today even if it a year since you guys posted this and new versions of uppgrade is up.


Advertisement: