[Mosh]

Originally Posted by Betablocker

Thanks for this update.

I have this problem when i import the xml file.


Database error in vBulletin 3.7.0:

Invalid SQL:

CREATE TABLE `DTP_mysmiliesvb` (
`mysmiliesvbid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`filename` varchar(100) NOT NULL default '',
`filesize` int(10) unsigned NOT NULL default '0',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
`smilietext` varchar(20) NOT NULL,
`smilietext_parsed` varchar(60) NOT NULL,
PRIMARY KEY (`mysmiliesvbid`)
);

MySQL Error : Table 'DTP_mysmiliesvb' already exists
Error Number : 1050

MySQL Version : 5.0.27

Now i did have the other version installed still....

I did try it after a uninstall also and got the same problem.


I have been up all night so.....good chance it is my fault

Any help would be great.

Cheers Beta.

In your AdminCP:

Click Maintenance -> Execute SQL Query

In the Manual Query box, type the following:
[sql]DROP TABLE DTP_mysmiliesvb;[/sql]

Then click Continue.

That should drop the table. You can then install my hack

You may need to run the following manual queries (run each query individually) if you are still having problems:

[sql]ALTER TABLE DTP_usergroup DROP mysmiliesvb_maxwidth;[/sql]
[sql]ALTER TABLE DTP_usergroup DROP mysmiliesvb_maxheight;[/sql]
[sql]ALTER TABLE DTP_usergroup DROP mysmiliesvb_maxsize;[/sql]
[sql]ALTER TABLE DTP_usergroup DROP mysmiliesvb_totalsmilies;[/sql]
[sql]ALTER TABLE DTP_usergroup DROP mysmiliesvb_totalsize;[/sql]

If anyone else is having problems then they can try the above queries.

NOTE: You will need to replace DTP_ with your Table Prefix if they have one, if you do not use them, then delete the DTP_ bits altogether before running each query.