[Lee Roberts]

Jaxel, i'v got two things. If you have the time could you give me an idea on what i need to do to fix them please. Great MOD by the way !

1.
When i click the "Click here to restore all services in the "/media/xml" directory to their default settings."

I am getting the following error:

Database error in vBulletin 4.0.6:

Invalid SQL:
UPDATE media_service SET
svcName = 'YouTube',
svcRegex = 'http://[a-z]*?[\\.]?youtube\\.[a-z]*?/watch\\?v=([\\w-]*)',
svcURL = 'http://www.youtube.com/watch?v={serviceVAL}',
svcFeed = 'http://gdata.youtube.com/feeds/api/videos/{serviceVAL}',
svcValue2 = 'null',
svcThumb = '$arr[\'media:group\'][\'media:thumbnail\'][3][\'url\']',
svcTitle = '$arr[\'media:group\'][\'media:title\'][\'value\']',
svcDesc = '$arr[\'media:group\'][\'media:description\'][\'value\']',
svcLength = '$arr[\'media:group\'][\'yt:duration\'][\'seconds\']',
svcTags = 'null',
svcMovie = 'http://www.youtube.com/v/{serviceVAL}?autoplay={ap10}&hd=1&fs=1',
svcWidth = 640,
svcHeight = 385,
svcStream = 'null',
svcType = 'application/x-shockwave-flash',
svcError = '$arr[\'app:control\'][\'yt:state\'][\'value\']'
WHERE serviceID = 1;

MySQL Error : Unknown column 'svcStream' in 'field list'
Error Number : 1054
Request Date : Sunday, August 29th 2010 @ 08:22:25 AM
Error Date : Sunday, August 29th 2010 @ 08:22:25 AM
Script : http://www.mycncuk.com/forums/media....n_host_restore
Referrer : http://www.mycncuk.com/forums/media.php?do=admin_host
Classname : vB_Database
MySQL Version : 5.1.26-rc-5.1.26rc

I have upgraded to 4.1.6 from 4.0.9 by uploading and then importing the xml file, i also set this to overright for both the uploads and the import.

2.
The other thing i have a problem with is this blank space showing up, i think its somthing to do with the custom variable system. I have this turned off so im not sure why its creating this blank space. Also what are the "custom variables" attully for, how do we use them and can you give an example.

Thanks for your time.

Lee