[Forum] Clean Install Localhost SQL Error BBCODE_VIDEO

[anthonyparsons]

A slight issue on a clean install, localhost, test dev:

Database error in vBulletin :

Invalid SQL:

				INSERT INTO bbcode_video
					(tagoption, provider, url, regex_url, regex_scrape, embed)
				VALUES
					('hulu', 'Hulu', 'http://www.hulu.com', 'http:\\/\\/www\\.hulu\\.com\\/watch\\/', '<link rel=\"video_src\" href=\"http://www.hulu.com/embed/([^\"]+)\"', '<object class=\"restrain\" type=\"application/x-shockwave-flash\" width=\"512\" height=\"296\" data=\"http://www.hulu.com/embed/{vb:raw code}\">\r\n	<param name=\"movie\" value=\"http://www.hulu.com/embed/{vb:raw code}\" />\r\n	<param name=\"wmode\" value=\"transparent\" />\r\n	<!--[if IE 6]>\r\n	<embed width=\"512\" height=\"296\" type=\"application/x-shockwave-flash\" src=\"http://www.hulu.com/embed/{vb:raw code}\" />\r\n	<![endif]--></object>'), ('youtube', 'YouTube', 'http://www.youtube.com', 'http:\\/\\/www\\.youtube\\.com\\/watch\\?.*v=([a-z0-9-_]+)', '', '<object class=\"restrain\" type=\"application/x-shockwave-flash\" width=\"640\" height=\"385\" data=\"http://www.youtube.com/v/{vb:raw code}\">\r\n	<param name=\"movie\" value=\"http://www.youtube.com/v/{vb:raw code}\" />\r\n	<param name=\"wmode\" value=\"transparent\" />\r\n	<!--[if IE 6]>\r\n	<embed width=\"640\" height=\"385\" type=\"application/x-shockwave-flash\" src=\"http://www.youtube.com/v/{vb:raw code}\" />\r\n	<![endif]--></object>'), ('vimeo', 'Vimeo', 'http://www.vimeo.com', 'http:\\/\\/(?:www\\.)?vimeo\\.com\\/([0-9]+)', '', '<object class=\"restrain\" type=\"application/x-shockwave-flash\" width=\"640\" height=\"360\" data=\"http://vimeo.com/moogaloop.swf?clip_id={vb:raw code}\">\r\n	<param name=\"movie\" value=\"http://vimeo.com/moogaloop.swf?clip_id={vb:raw code}\" />\r\n	<param name=\"wmode\" value=\"transparent\" />\r\n	<!--[if IE 6]>\r\n	<embed width=\"640\" height=\"360\" type=\"application/x-shockwave-flash\" src=\"http://vimeo.com/moogaloop.swf?clip_id={vb:raw code}\" />\r\n	<![endif]--></object>'), ('dailymotion', 'Dailymotion', 'http://www.dailymotion.com', 'http:\\/\\/www\\.dailymotion\\.com(?:\\/[^\\/]+)?\\/video\\/([a-z0-9]+)', '', '<object class=\"restrain\" type=\"application/x-shockwave-flash\" width=\"420\" height=\"339\" data=\"http://www.dailymotion.com/swf/{vb:raw code}\">\r\n	<param name=\"movie\" value=\"http://www.dailymotion.com/swf/{vb:raw code}\" />\r\n	<param name=\"wmode\" value=\"transparent\" />\r\n	<!--[if IE 6]>\r\n	<embed width=\"420\" height=\"339\" type=\"application/x-shockwave-flash\" src=\"http://www.dailymotion.com/swf/{vb:raw code}\" />\r\n	<![endif]--></object>'), ('metacafe', 'Metacafe', 'http://www.metacafe.com', 'http:\\/\\/www\\.metacafe\\.com\\/watch\\/([0-9a-z_\\-\\/]+)', '', '<object class=\"restrain\" type=\"application/x-shockwave-flash\" width=\"400\" height=\"345\" data=\"http://www.metacafe.com/fplayer/{vb:raw code}.swf\">\r\n	<param name=\"movie\" value=\"http://www.metacafe.com/fplayer/{vb:raw code}.swf\" />\r\n	<param name=\"wmode\" value=\"transparent\" />\r\n	<!--[if IE 6]>\r\n	<embed width=\"400\" height=\"345\" type=\"application/x-shockwave-flash\" src=\"http://www.metacafe.com/fplayer/{vb:raw code}.swf\" />\r\n	<![endif]--></object>'), ('google', 'Google', 'http://video.google.com', 'http:\\/\\/video\\.google\\.com\\/videoplay\\?docid=([0-9\\-]+)', '', '<object class=\"restrain\" type=\"application/x-shockwave-flash\" width=\"400\" height=\"326\" data=\"http://video.google.com/googleplayer.swf?docid={vb:raw code}\">\r\n	<param name=\"movie\" value=\"http://video.google.com/googleplayer.swf?docid={vb:raw code}\" />\r\n	<param name=\"wmode\" value=\"transparent\" />\r\n	<!--[if IE 6]>\r\n	<embed width=\"400\" height=\"326\" type=\"application/x-shockwave-flash\" src=\"http://video.google.com/googleplayer.swf?docid={vb:raw code}\" />\r\n	<![endif]--></object>'), ('facebook', 'facebook', 'http://www.facebook.com', 'http:\\/\\/www\\.facebook\\.com\\/video\\/video.php\\?v=([0-9]+)', '', '<object class=\"restrain\" type=\"application/x-shockwave-flash\" width=\"576\" height=\"432\" data=\"http://www.facebook.com/v/{vb:raw code}\">\r\n	<param name=\"movie\" value=\"http://www.facebook.com/v/{vb:raw code}\" />\r\n	<param name=\"wmode\" value=\"transparent\" />\r\n	<!--[if IE 6]>\r\n	<embed width=\"576\" height=\"432\" type=\"application/x-shockwave-flash\" src=\"http://www.facebook.com/v/{vb:raw code}\" />\r\n	<![endif]--></object>');

MySQL Error   : Duplicate entry 'hulu' for key 'tagoption'
Error Number  : 1062
Request Date  : Wednesday, July 14th 2010 @ 10:53:23 PM
Error Date    : Wednesday, July 14th 2010 @ 10:53:23 PM
Script        : http://localhost/vbulletin4.0.5/install/install.php?step=7&startat=50
Referrer      : http://localhost/vbulletin4.0.5/install/install.php?step=7&startat=40
IP Address    : 127.0.0.1
Username      : 
Classname     : vB_Database
MySQL Version : 5.1.41-community-log

Stack Trace:

#0 vB_Database->halt() called in [path]\includes\class_core.php on line 422
#1 vB_Database->execute_query() called in [path]\includes\class_core.php on line 440
#2 vB_Database->query_write() called in [path]\includes\functions_databuild.php on line 45
#3 build_bbcode_video() called in [path]\install\installsteps.php on line 365
#4 require_once([path]\install\installsteps.php) called in [path]\install\install.php on line 23

[anthonyparsons]

Seems more like a random issue actually... I got it when installing with debug active, though wiped it, installed again in normal and debug mode, couple of times, didn't repeat... so totally random at a guess and completely irrelevant.

[nakedanvil]

Does FTP not have very sophisticated error checking? I've occasionally seen files I've downloaded show up as a different size. I usually just load them again and all is well. Filezilla just says "transfer successful". Seems like a simple checksum would catch this.

[anthonyparsons]

Its not the ultimate method for transfer... vs. tarball upon the server itself.

Compression ratios are also different from your system vs. server, which will typically show two different file sizes. My windows file sizes are different to the compressed value on the server.

[nakedanvil]

These were PDF files and they came out the same after a re-do. I'll keep that in mind though, thanks Anthony.