Upgrade Error

[Sifaus]

Upgradeing with Large Upgrade pack, from 1.1.x to 2.0.


While this:

Code Select Expand

Executing upgrade script 2 of 2.
Executing: "Changing column names." (1 of 42 - of this script)

Gives this error:

Code Select Expand

!!Error!
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 'binary' at line 11

Middle log:

Code Select Expand

Updating indexes on "messages"...done
Updating table indexes...done
Reordering boards and categories...done
Updating indexes and data on "smileys"...done
Updating indexes on "log_boards"...done
Updating indexes on "log_mark_read"...done
Updating indexes on "themes"...done
Updating data in "settings"...done
Adding new settings...done
Adding PM spam protection settings...done
Cleaning old values from "settings"...done
Encoding SMTP password...done
Adjusting timezone settings...done
Installing theme settings...done
Renaming personal message tables...done
Updating indexes on "pm_recipients"...done
Updating columns on "pm_recipients"...done
Updating columns on "members"...done
Updating columns on "members" - part 2...done
Updating member approval...done
Adding new holidays...done
Updating event start and end dates...done
Converting other date columns...done
Checking for an old table...done
Creating "message_icons"...done
Inserting "message_icons"...done
Creating "package_servers"...done
Inserting "package_servers"...done
Updating flood control log...done
Updating ip address storage...done
Converting "log_online"...done
Updating poll column sizes...done
Updating attachments table...done
Updating boards and topics...done
Updating members...done
Recounting member pm totals (step 1)...done
Recounting member pm totals (step 2)...done
Converting server stored setting...done
Converting avatar upload setting...done
Updating attachments...done
Updating settings...done
Registering thumbs...done
Adding image dimensions...done
Splitting ban table...done
Updating ban statistics...done
Deleting some very old permissions...done
Renaming permissions...done
Upgrading "deny"-permissions...done
Upgrading post based group permissions...done
Upgrading by-board permissions...done
Removing all guest deny permissions...done
Removing guest admin permissions (if any)...done
Creating search cache tables...done
Rebuilding fulltext index...done
Indexing topic subjects...done
Converting settings...done
Creating log table indexes (this might take some time!)...done
Preparing log table upgrade...done
Converting log tables (this might take some time!)...done
Updating last message IDs for boards...done
Cleaning up old log indexes...done
Preparing messages table for strict upgrade...done
Adjusting text fields...............done
Replacing messages index...done
Adding log_topics index...done
Updating the members table ...done
Expanding message column size...done
Sorting the boards...done
Moving to next script file...done
Renaming table columns...............................................................done
Converting "log_online"...done

How can i solve this? Thanks.

[Oldiesmann]

Without the complete query, it's difficult to say what could be causing the issue. The "changing column names" part is at the beginning of upgrade_2-0_mysql.sql, but there is no "binary" anywhere in that file or in upgrade.php.

[Sifaus]

How can i provide you a complete query? :/

I'm trying to update for 3-4 days. I even try to update data manualy. Please help. :/

[Oldiesmann]

Try this and see if it gives you the entire query...

upgrade.php

Find

Code Select Expand

$db_error_message = $smcFunc['db_error']($db_connection);

Replace

Code Select Expand

$db_error_message = $smcFunc['db_error']($db_connection) . '<br />Query: ' . $string;

[Sifaus]

Ok. This is the screenshot [nofollow], and this is the error:

Code Select Expand

Error!
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 'binary' at line 11nullQuery: CREATE TABLE smf_log_online ( session varchar(32) NOT NULL default '', log_time int(10) NOT NULL default '0', id_member mediumint(8) unsigned NOT NULL default '0', id_spider smallint(5) unsigned NOT NULL default '0', ip int(10) unsigned NOT NULL default '0', url text NOT NULL, PRIMARY KEY (session), KEY log_time (log_time), KEY id_member (id_member) ) ENGINE=MyISAM CHARACTER SET binary COLLATE binary

[Sifaus]

Is there no hope? :/

[Sifaus]

Bump :/

[Angelina Belle]

You have an incorrect character set and collation.
update should figure this out from the information already on your database.

Please check your tables to figure out which character set is in use on your database. Collation should not be binary. It should be based on the primary language of your forum at the time you created it.

[alfalfa2606]

Hello to all!

I have this error during upgrating...
Error!

Code Select Expand


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 'binary' at line 11


What I have to do?

[Illori]

please open a separate thread for your issue, this thread belongs to someone else.

also please dont bump old threads.

[alfalfa2606]

ok...but I have the same issue...that's why...

[Illori]

but our rules are one person per thread per issue. so please open a separate thread so we can track your issue, and we dont know that it is the same exact issue.

[alfalfa2606]

Ok I have already open a new one...So I'm waiting for a solution.
I'm sorry.

[Angelina Belle]

Sifaus -- are you still having this problem?
Have you been able to work with anybody to fix the collation on the problem column(s)?