Bug import error using thanksimport.php

[LarryEitel]

Trying to run thanksimport. I get:

Database error in vBulletin 4.1.1:

Invalid SQL:

				INSERT INTO dbtech_thanks_entry
					(entrytype, userid, contenttype, contentid, dateline)
				VALUES (
					'thanks',
					'1',
					'post',
					'9088',
					'1197569692'
				);

MySQL Error   : Unknown column 'entrytype' in 'field list'
Error Number  : 1054
Request Date  : Monday, January 17th 2011 @ 12:20:53 PM
Error Date    : Monday, January 17th 2011 @ 12:20:53 PM
Script        : http://v4/admincp/thanksimport.php?do=doimport
Referrer      : http://v4/admincp/thanksimport.php
IP Address    : 127.0.0.1
Username      : LarryEitel
Classname     : vB_Database
MySQL Version : 5.1.41

 

[Fillip H.]

Like stated in the release thread for the Beta version, the importer is not currently supported to import into the Beta version.

Out of curiosity though, when did you download the importer?

 

[LarryEitel]

Like stated in the release thread for the Beta version, the importer is not currently supported to import into the Beta version.

Out of curiosity though, when did you download the importer?

Turns out I had a slightly earlier version. However, although the import got further along, I DID get an error:

Database error in vBulletin 4.1.1:

Invalid SQL:

				INSERT INTO dbtech_thanks_entry
					(varname, userid, contenttype, contentid, dateline)
				VALUES (
					'thanks',
					'11225',
					'post',
					'11360',
					'1222737629'
				);

MySQL Error   : Duplicate entry 'thanks-11225-post-11360' for key 'unique_entry'
Error Number  : 1062
Request Date  : Tuesday, January 18th 2011 @ 09:54:52 AM
Error Date    : Tuesday, January 18th 2011 @ 09:54:52 AM
Script        : http://v4/admincp/thanksimport.php?do=doimport&startat=1154&pp=15
Referrer      : http://v4/admincp/thanksimport.php?do=doimport&startat=1139&pp=15
Classname     : vB_Database
MySQL Version : 5.1.41

 

[Fillip H.]

I see. Try re-downloading the importer again, I changed it to ignore duplicate entries.

I guess that means the post thanks hack allows more than 1 thanks per user per post =/

 

[LarryEitel]

I deleted the dups as it ran into a few of them. Then refreshed to continue. It is now working. Thank you