Bug Database error

[Bassinurface]

Database error in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO `dbtech_registration_field_nonprofilefield`
(fieldid, varname)
VALUES
(12, 'username');

MySQL Error : Duplicate entry 'username' for key 'varname'
Error Number : 1062
Request Date : Saturday, July 21st 2012 @ 03:51:14 AM
Error Date : Saturday, July 21st 2012 @ 03:51:21 AM
Script : Log in - Master Assassins =MAG= - vBulletin Admin Control Panel
Referrer : Log in - Master Assassins =MAG= - vBulletin Admin Control Panel
IP Address : 75.72.157.94
Username : Bassinurface
Classname : vB_Database
MySQL Version : 5.1.63-cll

 

[Pandemikk]

That's odd.

Can you describe what you did previously before encountering this error?

Was this encountered on install?

 

[Bassinurface]

Yeah, I run the install after I got the importer to work. When I ran it I got this

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Friday, July 20th 2012 @ 11:29:05 PM
Error Date : Friday, July 20th 2012 @ 11:29:09 PM
Script : Log in - Master Assassins =MAG= - vBulletin Admin Control Panel
Referrer : Log in - Master Assassins =MAG= - vBulletin Admin Control Panel
IP Address : 75.72.157.94
Username : Bassinurface
Classname : vB_Database
MySQL Version : 5.1.63-cll

I get this a lot. I just uninstalled and wait a few hours and it works most the time.

When I tried to run the install again I got that.

I looked in my phpadmin. I see tables that where not removed when I uninstalled the product. Can I remove the tables manually? with out breaking something?

 

[Pandemikk]

Ah I see. I've updated the product install file to compensate for failed installs.

The uninstall file should remove the tables for you, but if there was some more problems on your server with uninstalling you can remove any table prefixed with dbtech_registration manually and it will be just fine. Alternatively, you can re-download the dbtech/registration/install/ files and re-upload which will also work if the product has been uninstalled already.

 

[Bassinurface]

I was able to get it working. Pandemikk Thanks!

Sorry for the delay in the response.