+ Reply to Thread (include dating software, release, and patch number!)
Results 1 to 6 of 6

Thread: dumping sql for Youtubes Video Zone 4.0

  1. #1
    birkenstam's Avatar
    Join Date
    Mar 2006
    Posts
    205

    Default dumping sql for Youtubes Video Zone 4.0

    hi guys,

    i trying to dump the sql file for
    Youtubes Video Zone 4.0
    module but i get an error like this:

    Code:
    SQL-fråga: 
    
    INSERT INTO `AdminMenu` ( `ID` , `Title` , `Url` , `Desc` , `Check` , `Order` , `Categ` , `Icon` ) 
    VALUES ( 84, 'Moderator Video Zone', '../youtubes/moderators/videos/videos.php', 'Moderator Panel', '', 4, 9, 'video.jpg' ) , ( 85, 'Youtubes Video Zone', '../youtubes/admin/videos/videos.php', 'Manage Youtubes Video Zone', '', 4, 4, 'video.jpg' ) , 
    CREATE TABLE `comments` (
    
    `id` int( 30 ) NOT NULL AUTO_INCREMENT ,
    `vidid` int( 20 ) NOT NULL default '0',
    `uid` int( 10 ) NOT NULL default '0',
    `unick` varchar( 30 ) NOT NULL default '',
    `date` varchar( 40 ) NOT NULL default '',
    `text` text NOT NULL ,
    PRIMARY KEY ( `id` ) 
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;
    
    
    
    MySQL sa:  
    
    #1064 - 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 'CREATE TABLE `comments` (
      `id` int(30) NOT NULL auto_increment,
      `vidid` in' at line 6
    any ideas why this happening?

    warm regards Anders
    Regards Anders
    I wish i could code
    My specialities Copy Paste with instruction
    swedish dating version dolphin 6.1.5

  2. #2

    Join Date
    Oct 2008
    Posts
    1

    Default

    try ";" instead of "," at the end of

    INSERT INTO `AdminMenu` ( `ID` , `Title` , `Url` , `Desc` , `Check` , `Order` , `Categ` , `Icon` )
    VALUES ( 84, 'Moderator Video Zone', '../youtubes/moderators/videos/videos.php', 'Moderator Panel', '', 4, 9, 'video.jpg' ) , ( 85, 'Youtubes Video Zone', '../youtubes/admin/videos/videos.php', 'Manage Youtubes Video Zone', '', 4, 4, 'video.jpg' ) ;

  3. #3

    Join Date
    Jan 2009
    Posts
    2

    Default done that

    and getting now:
    SQL query:

    INSERT INTO `LocalizationKeys` ( `ID` , `IDCategory` , `Key` )
    VALUES ( 2865, 3, 'Youtubes' ) ;

    MySQL said: Documentation
    #1062 - Duplicate entry '2865' for key 1

  4. #4
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,642
    Blog Entries
    5

    Default

    Quote Originally Posted by reimeister View Post
    LocalizationKeys
    MySQL said: Documentation
    #1062 - Duplicate entry '2865' for key 1
    Check your database table LocalizationKeys and see what the value for key 2865 is... maybe you tried to run the SQL import several times - and before, it half finished - but had already updated some of the values.

    Smoge
    ModMySite Administrator

    Problems? Questions? Need modifications or other help with your site?

    Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.

  5. #5

    Join Date
    Jan 2009
    Posts
    2

    Default LocalizationKeys

    I've checked that, and there 2 entry

    !st in LocalizationKeys:
    ID IDCategory Key
    2865 100 _day_of_1

    and 2nd in LocalizationStrings:
    IDKey IDLanguage String
    2865 1 {0} January, {1}

    I've test in fresh clean new database,well after got error i've done in fresh new install and dba and same error.

    Tried to change ID to diffrent value, but getting fiew other errors after aswell.
    like for example:
    INSERT INTO `LocalizationKeys` (`ID`, `IDCategory`, `Key`) VALUES
    (3101, 3, 'Youtubes');
    just to check if rest will go though
    but commands from:

    CREATE TABLE IF NOT EXISTS `yvz_settings` (
    and
    INSERT INTO `yvz_categories`
    wont go
    as effect not able to post video becouse there is no categories and can't add cat from page.
    I've checked whole database and no strings for 'yvz_categories' at all
    so i've run just:
    ---
    CREATE TABLE IF NOT EXISTS `yvz_categories` (
    `id` int(10) NOT NULL auto_increment,
    `catname` varchar(60) collate utf8_unicode_ci default NULL,
    `headcat` varchar(60) collate utf8_unicode_ci default NULL,
    `subcat` varchar(60) collate utf8_unicode_ci default NULL,
    `memberrestrict` varchar(255) collate utf8_unicode_ci NOT NULL default '',
    KEY `id` (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=62 ;

    --
    -- Dumping data for table `yvz_categories`
    --

    INSERT INTO `yvz_categories` (`id`, `catname`, `headcat`, `subcat`, `memberrestrict`) VALUES
    (27, 'Children and Family', '', 'head category', ''),
    (22, 'General', '', 'head category', ''),
    (44, 'Autos and Vehicles', '', 'head category', ''),
    (24, 'Movies and Trailers', '', 'head category', ''),
    (25, 'Hobby', '', 'head category', ''),
    (26, 'Funny', '', 'head category', ''),
    (28, 'Music and Entertainment', '', 'head category', ''),
    (29, 'Webcam', '', 'head category', ''),
    (30, 'News', '', 'head category', ''),
    (31, 'Sport', '', 'head category', ''),
    (32, 'Toons and Animations', '', 'head category', ''),
    (33, 'TV and Commercials', '', 'head category', ''),
    (34, 'Games', '', 'head category', ''),
    (35, 'Top 40', 'Music and Entertainment', 'sub category', ''),
    (36, 'R n B', 'Music and Entertainment', 'sub category', ''),
    (37, 'Hip Hop en Rap', 'Music and Entertainment', 'sub category', ''),
    (38, 'Country', 'Music and Entertainment', 'sub category', ''),
    (39, 'Hardcore', 'Music and Entertainment', 'sub category', ''),
    (40, 'Rock', 'Music and Entertainment', 'sub category', ''),
    (41, 'Soul', 'Music and Entertainment', 'sub category', ''),
    (42, 'Others', 'Music and Entertainment', 'sub category', ''),
    (43, 'Animals', '', 'head category', ''),
    (45, 'Movies', 'Movies and Trailers', 'sub category', ''),
    (46, 'Trailers', 'Movies and Trailers', 'sub category', ''),
    (47, 'Toons', 'Toons and Animations', 'sub category', ''),
    (48, 'Animations', 'Toons and Animations', 'sub category', ''),
    (53, 'TV', 'TV and Commercials', 'sub category', ''),
    (54, 'Commercials', 'TV and Commercials', 'sub category', ''),
    (51, 'Autos', 'Autos and Vehicles', 'sub category', ''),
    (52, 'Others', 'Autos and Vehicles', 'sub category', ''),
    (57, 'Featured Videos', '', 'head category', 'view only'),
    (58, 'Reggae', 'Music and Entertainment', 'sub category', ''),
    (59, 'House & Trance', 'Music and Entertainment', 'sub category', ''),
    (60, 'Business', '', 'head category', ''),
    (61, 'Computers & Internet', '', '', '');
    ---
    manually
    says no errors...but still no table for yvz_categories in database?
    weired hm?

    and i've noticed there fiew other lines missing ';' instead of ','

    I can create new database and new dolphin install, if u could send me sql file to put on and i can give it a shot again, what u think?

  6. #6
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,642
    Blog Entries
    5

    Default

    Maybe don't run your SQL files all at once - but break them up into pieces and run in the phpmyadmin SQL box (for the correct database) so you can have some better idea of what is happening as you do it.

    For example, create the table... then do the inserts, then do the next table, and so on.

    Warm regards,
    Smoge
    ModMySite Administrator

    Problems? Questions? Need modifications or other help with your site?

    Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.

+ Reply to Thread (include dating software, release, and patch number!)

LinkBacks (?)

  1. 12-02-2008, 06:36 AM
  2. 12-01-2008, 08:11 AM
  3. 11-27-2008, 09:21 AM
  4. 11-07-2008, 12:44 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Similar Threads

  1. Video upload failed (video Error) help plz
    By watts in forum Boonex Dolphin 7
    Replies: 12
    Last Post: 07-01-2010, 03:14 PM
  2. Widget and Youtubes Video Zone 5.0
    By max1234 in forum Free Mod Exchange
    Replies: 4
    Last Post: 06-30-2010, 05:57 PM
  3. youtubes widget: movies won`t play (see error)!!!
    By koemar in forum Ray Community Widget Suite
    Replies: 1
    Last Post: 01-14-2009, 12:48 AM
  4. Youtubes Video Zone
    By ntenz in forum General Issues, Comments, Questions
    Replies: 1
    Last Post: 04-07-2008, 07:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts