ImpEx Hangs Importing Ranks

[MorrisMcD]

Ok.. Here is my situation.. I got a new server with some extra beef to host everything on.. The new server is Windows 2003 Standard with vBulletin 3.5.3.

I have installed a fresh copy of vBulletin 3.5.3 on it and then started the impex process.

The system that is the source is a Windows 2000 server running vBulletin 3.0.5

The following is step I get stuck on including the error I recieve

Thanks in advance

Importing 13 usergroups


82.76% usergroup -> Unregistered / Not Logged In
82.76% usergroup -> Players
86.21% usergroup -> Draft Prospects
79.31% usergroup -> (COPPA) Users Awaiting Moderation
89.66% usergroup -> Super Moderators
93.10% usergroup -> Head Coach
93.10% usergroup -> Assistant Coaches
86.21% usergroup -> Injured Reserve Players
86.21% usergroup -> Injured - Questionable Players
86.21% usergroup -> Reporters
86.21% usergroup -> Scouts
82.76% usergroup -> Contributors
79.31% usergroup -> Female Member
Importing 4 Ranks

There seems to have been a problem with the database.

ImpEx Database errormysql error: Invalid SQL:
INSERT INTO ranks
(importrankid, minposts, ranklevel, rankimg, usergroupid, type, stack, display)
VALUES
(
1,
1,
1,
'images/ranks/siteartist.jpg',
0,
'0',
'',
''
)

mysql error: Incorrect integer value: '' for column 'stack' at row 1
mysql error number: 1366
Date: Sunday 22nd 2006f January 2006 03:32:32 PM

[Steve Machol]

Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.

[MorrisMcD]

I am workin on this until it works.. I really dont have a need to put in a ticket... Unless that is what I have to do to get the answer

[Jerry]

What version of MySQL are you running ? and if its 5 is it in STRICT mode ?

[MorrisMcD]

What version of MySQL are you running ? and if its 5 is it in STRICT mode ?

The source is MySQL 4 and the new machine is MySQL 5

As for strict mode, I think you mean this... I am amateur at this stuff but getting there. This is what I think says I AM in strict mode... Hopefully I am right

// ****** FORCE EMPTY SQL MODE ******
// New versions of MySQL (4.1+) have introduced some behaviors that are
// incompatible with vBulletin. Setting this value to "true" disables those
// behaviors. You only need to modify this value if vBulletin recommends it.
$config['Database']['force_sql_mode'] = true;

I got past the problem with the ranks by just deleting them. But now it hangs on importing users...

Importing 500 users


From : 0 :: To : 500

There seems to have been a problem with the database.


ImpEx Database errormysql error: Invalid SQL:
INSERT INTO user
(
username, email, usergroupid,
importuserid, password, salt,
passworddate, options, homepage,
posts, joindate, icq,
daysprune, aim, membergroupids,
displaygroupid, styleid, parentemail,
yahoo, showvbcode, usertitle,
customtitle, lastvisit, lastactivity,
lastpost, reputation, reputationlevelid,
timezoneoffset, pmpopup, avatarid,
avatarrevision, birthday, birthday_search, maxposts,
startofweek, ipaddress, referrerid,
languageid, msn, emailstamp,
threadedmode, pmtotal, pmunread,
autosubscribe, profilepicrevision
)
VALUES
(
'danman0011',
'[email protected]',
'15',
'4',
'a195de702797e97b9fd6b711ae6b1bc2',
'7>i',
'2003-11-10',
'3479',
'http://',
'192',
'1068483600',
'',
'10',
'',
'20',
'0',
'0',
'[email protected]',
'',
'1',
'Assistant Coach',
'0',
'1137163155',
'1137385800',
'1133816580',
'5420',
'13',
'-5',
'0',
'',
'1',
'07-09-1974',
'1974-07-09',
'30',
'1',
'137.237.241.34',
'1',
'1',
'[email protected]',
'1081350808',
'0',
'13',
'0',
'1',
''
)

mysql error: Incorrect integer value: '' for column 'avatarid' at row 1
mysql error number: 1366
Date: Sunday 22nd 2006f January 2006 05:57:28 PM

You will notice that is user id 4... I do not have a 2 or 3... And I am 1 which I associated successfully... Yet the information is also not imported into my user after the error

[Jerry]

The config you've quoted :

// ****** FORCE EMPTY SQL MODE ******

Is for vBulletin itself, opposed to ImpEx.

Can you run this SQL on the target database to see what mode its in :

SELECT @@sql_mode;

If you have phpMyAdmin you can use that.

[MorrisMcD]

The config you've quoted :

// ****** FORCE EMPTY SQL MODE ******

Is for vBulletin itself, opposed to ImpEx.

Can you run this SQL on the target database to see what mode its in :

SELECT @@sql_mode;

If you have phpMyAdmin you can use that.

My bad.. Like I said.. I am not a pro at this...

This was the result of what you just gave me to do

STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Thanks a lot.. I appreciate more suggestions.. I am about to just make the new server 3.0.x...

[Jerry]

Thanks a lot.. I appreciate more suggestions.. I am about to just make the new server 3.0.x...

If you run this SQL, does it allow you ?

SET @@sql_mode = '';

If it does it will say :

Query OK, 0 rows affected (0.00 sec)

and you can check it by running the SQL :

SELECT @@sql_mode;

[MorrisMcD]

If you run this SQL, does it allow you ?

SET @@sql_mode = '';

It doesnt say what you said it will say but it does say

Your SQL-query has been executed successfully (Query took 0.0002 sec)

and you can check it by running the SQL :

SELECT @@sql_mode;

After running both, it still says

STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Just FYI.. This is phpMyAdmin 2.6.1-rc2

[Jerry]

Ok, then you don't have permission to change the mode.

Do you have access to another server ?

Is there no data in the vBulletin install yet ? i.e. it's not live ?

[MorrisMcD]

Ok, then you don't have permission to change the mode.

Do you have access to another server ?

Is there no data in the vBulletin install yet ? i.e. it's not live ?

Both the old site and the new site are servers locally to me.. These are not though a host. I have the boxes physically next to me... Whatever I have to do to give myself rights, I can do..

The new server with 3.5 on it has nothing in the database of importance

[Jerry]

Both the old site and the new site are servers locally to me.. These are not though a host. I have the boxes physically next to me... Whatever I have to do to give myself rights, I can do..

The new server with 3.5 on it has nothing in the database of importance

Then log into the vBulletin MySQL database as root and change the mode, or change the my.cnf file to change the mode and restart the MySQL server.

[MorrisMcD]

Then log into the vBulletin MySQL database as root and change the mode, or change the my.cnf file to change the mode and restart the MySQL server.

If I knew what any of that meant, I would do it... lol

I changed MySQL to 4.1 instead of 5.0 on the new server and everything works fine.. So I am fine with it