Page 1 of 1

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

Posted: Thu Nov 20, 2008 4:03 am
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()

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

Posted: Thu Nov 20, 2008 4:56 am
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

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

Posted: Thu Nov 20, 2008 5:01 am
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

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

Posted: Fri Nov 21, 2008 7:57 pm
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?

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

Posted: Thu Nov 27, 2008 8:14 pm
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()

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

Posted: Sun Dec 07, 2008 9:02 pm
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.