2 to 3 convert error: Unknown system variable 'Names' 1193

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Get Involved
Locked
section44
Registered User
Posts: 6
Joined: Sun Nov 16, 2008 10:03 pm

2 to 3 convert error: Unknown system variable 'Names' 1193

Post by section44 »

Get this when using convert function in 3.03 from older 2.x phpbb board.
Don't know enough about all this to fix myself.. any thoughts to help convert my older 2.x board?

I know my old database on the 2.x is at a different location at godaddy than the newer 3.x database. Different servers.. but both boards are at the same host and domain.

Thanks for the help in advance.

General Error
SQL ERROR [ mysql4 ]

Unknown system variable 'NAMES' [1193]

SQL

SET NAMES 'binary'

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: install/install_convert.php
LINE: 707
CALL: dbal_mysql->sql_query()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()
section44
Registered User
Posts: 6
Joined: Sun Nov 16, 2008 10:03 pm

Re: 2 to 3 convert error: Unknown system variable 'Names' 1193

Post by section44 »

I checked my old db.. it was mysql 4.0 and my new target db is 4.1

I'm copying over my old 4.0 into a new 4.1 db and will try to run the phpbb restore function. perhaps, the issue about 4.0 not dealing with NAMES will go away.. time will tell..

Randall
section44
Registered User
Posts: 6
Joined: Sun Nov 16, 2008 10:03 pm

Re: 2 to 3 convert error: Unknown system variable 'Names' 1193

Post by section44 »

Ok.. good so far..

Copying my old 4.0 to a new 4.1 then pointing the conversion to the new db got me past the NAMES error and I'm converting now.. crossing fingers..

hopes this helps others migrating older 2.x boards.

Randall
lifedeuce
Registered User
Posts: 116
Joined: Fri Jan 28, 2005 10:27 pm

Re: 2 to 3 convert error: Unknown system variable 'Names' 1193

Post by lifedeuce »

section44 wrote:I checked my old db.. it was mysql 4.0 and my new target db is 4.1

I'm copying over my old 4.0 into a new 4.1 db and will try to run the phpbb restore function. perhaps, the issue about 4.0 not dealing with NAMES will go away.. time will tell..

Randall
Can you tell me how to do that and did this help?
davidm999
Registered User
Posts: 12
Joined: Sat Aug 14, 2004 3:14 am

Re: 2 to 3 convert error: Unknown system variable 'Names' 1193

Post by davidm999 »

I've just tried converting from v2 to V3.0.3 and got the same error (see below). I was trying to go from a MySQL V4.0 to a V5.0 database. However I'm not sure this is the problem. I've been trying for a while (unsuccessfully) to upgrade and this particular problem did not occur with phpBB V 3.02

Regards
David


General Error
SQL ERROR [ mysql4 ]

Unknown system variable 'NAMES' [1193]

SQL

SET NAMES 'binary'

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: install/install_convert.php
LINE: 707
CALL: dbal_mysql->sql_query()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: 2 to 3 convert error: Unknown system variable 'Names' 1193

Post by D¡cky »

whidbeytomas,

If you are going to be importing into an empty database, it is not necessary to select ADD DROP TABLES. If you are importing into the phpBB3 database, you want to be sure the phpbB3 tables have a different table prefix from the phpBB2 tables. If you are importing into a separate database, then this is not a concern. I have never used the ADD IF NOT EXISTS option.
Have you hugged someone today?
Locked

Return to “[3.0.x] Convertors”