[Chadi]

I tried your vgallery importer (both files). Didn't work.





I'm using vb 3.8.1 and PhotoPost vBGallery v2.2.

When I tried the import, vbgallery20_2_umg.php gave me this error:

<!--  /* Font Definitions */  @font-face     {font-family:&quot;Cambria Math&quot;;     panose-1:2 4 5 3 5 4 6 3 2 4;     mso-font-charset:1;     mso-generic-font-family:roman;     mso-font-format:other;     mso-font-pitch:variable;     mso-font-signature:0 0 0 0 0 0;} @font-face     {font-family:Calibri;     panose-1:2 15 5 2 2 2 4 3 2 4;     mso-font-charset:0;     mso-generic-font-family:swiss;     mso-font-pitch:variable;     mso-font-signature:-520092929 1073786111 9 0 415 0;} @font-face     {font-family:Consolas;     panose-1:2 11 6 9 2 2 4 3 2 4;     mso-font-charset:0;     mso-generic-font-family:modern;     mso-font-pitch:fixed;     mso-font-signature:-520092929 1073806591 9 0 415 0;}  /* Style Definitions */  p.MsoNormal, li.MsoNormal, div.MsoNormal     {mso-style-unhide:no;     mso-style-qformat:yes;     mso-style-parent:&quot;&quot;;     margin:0in;     margin-bottom:.0001pt;     mso-pagination:widow-orphan;     font-size:11.0pt;     font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;     mso-ascii-font-family:Calibri;     mso-ascii-theme-font:minor-latin;     mso-fareast-font-family:Calibri;     mso-fareast-theme-font:minor-latin;     mso-hansi-font-family:Calibri;     mso-hansi-theme-font:minor-latin;     mso-bidi-font-family:&quot;Times New Roman&quot;;     mso-bidi-theme-font:minor-bidi;} a:link, span.MsoHyperlink     {mso-style-priority:99;     color:blue;     mso-themecolor:hyperlink;     text-decoration:underline;     text-underline:single;} a:visited, span.MsoHyperlinkFollowed     {mso-style-noshow:yes;     mso-style-priority:99;     color:purple;     mso-themecolor:followedhyperlink;     text-decoration:underline;     text-underline:single;} p.MsoPlainText, li.MsoPlainText, div.MsoPlainText     {mso-style-noshow:yes;     mso-style-priority:99;     mso-style-link:&quot;Plain Text Char&quot;;     margin:0in;     margin-bottom:.0001pt;     mso-pagination:widow-orphan;     font-size:10.5pt;     font-family:Consolas;     mso-fareast-font-family:Calibri;     mso-fareast-theme-font:minor-latin;     mso-bidi-font-family:&quot;Times New Roman&quot;;     mso-bidi-theme-font:minor-bidi;} span.PlainTextChar     {mso-style-name:&quot;Plain Text Char&quot;;     mso-style-noshow:yes;     mso-style-priority:99;     mso-style-unhide:no;     mso-style-locked:yes;     mso-style-link:&quot;Plain Text&quot;;     mso-ansi-font-size:10.5pt;     mso-bidi-font-size:10.5pt;     font-family:Consolas;     mso-ascii-font-family:Consolas;     mso-hansi-font-family:Consolas;} .MsoChpDefault     {mso-style-type:export-only;     mso-default-props:yes;     mso-ascii-font-family:Calibri;     mso-ascii-theme-font:minor-latin;     mso-fareast-font-family:Calibri;     mso-fareast-theme-font:minor-latin;     mso-hansi-font-family:Calibri;     mso-hansi-theme-font:minor-latin;     mso-bidi-font-family:&quot;Times New Roman&quot;;     mso-bidi-theme-font:minor-bidi;} @page Section1     {size:8.5in 11.0in;     margin:1.0in 1.0in 1.0in 1.0in;     mso-header-margin:.5in;     mso-footer-margin:.5in;     mso-paper-source:0;} div.Section1     {page:Section1;} -->   Invalid SQL:
  ALTER TABLE adv_gallery_categories ADD `umgid` INT(11) NOT NULL DEFAULT '0';
   
  MySQL Error   : Table 'admincd_vbulletin.adv_gallery_categories' doesn't exist
  Error Number  : 1146
  Request Date  : Thursday, February 12th 2009 @ 12:06:29 AM
  Error Date    : Thursday, February 12th 2009 @ 12:06:30 AM
  Script        : http://www.talkjesus.com/vbgallery20_2_umg.php?do=convert_a
  Referrer      : http://www.talkjesus.com/vbgallery20_2_umg.php
  IP Address    : xxxxx
  Username      : Chad
  Classname     : vB_Database
  MySQL Version : 5.0.67-community

When I tried vbgallery_2_umg.php, it imported everything fine, however see above screenshots (note: the duplicate categories is only because I ran that file twice).

Also got this db error:

Invalid SQL:
  UPDATE 
                    umg_counts SET 
                    mediacount  =0, 
                    media_date  =, 
                    commentcount=0, 
                    views       =0
                    WHERE catid=1;
   
  MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 
                    commentcount=0, 
                    views       =0
                    WHERE catid=1' at line 4
  Error Number  : 1064
  Request Date  : Thursday, February 12th 2009 @ 12:11:06 AM
  Error Date    : Thursday, February 12th 2009 @ 12:11:06 AM
  Script        : http://www.talkjesus.com/xxxxx/umg_admin.php?do=categorycount
  Referrer      : http://www.talkjesus.com/xxxxx/umg_admin.php?do=maintenance
  IP Address    : xxxxx
  Username      : Chad
  Classname     : vB_Database
  MySQL Version : 5.0.67-community