[QUOTE]Originally posted by snyx
I tired to copy paste the queries into phpmyadmin and I get errors?

I obviously tried that genius!

How do you expect anyone to help you when you don't even tell what error you get?!? And do you always respond like that when people try to help you? :(

whatvere, I got it myself
but now Im getting this when I try to modify my smilies

Database error in vBulletin Control Panel: Invalid SQL: SELECT smilietext,smilieid,title,smiliepath,showid FROM smilie ORDER BY showid LIMIT 0,15
mysql error: Unknown column 'showid' in 'field list'
mysql error number: 1054
Date: Tuesday 21st of August 2001 07:06:03 PM
Script: /forums/admin/smilie.php?action=modify
Referer: http://www.xxxx-xxxx.com/forums/admi...php?action=nav


Ideas?

You didn't create the new field, showid.
Hold on a bit, I'll come up with a file to do everything itself.

sweet, thx

Try this file, upload it to your admin folder. Tell me if it worked!

I get this man
Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE smilie DROP showid
mysql error: Can't DROP 'showid'. Check that column/key exists
mysql error number: 1091
Date: Wednesday 22nd of August 2001 04:34:55 AM
Script: /forums/admin/orsmin.php
Referer: http://www.xxxx-xxxx.com/forums/admin/orsmin.php?

Use the second option.