SQL Error Fix for v117 Public Source (SourceDEV)

Results 1 to 7 of 7
  1. #1
    Account Inactive zPsychotic is offline
    InactiveRank
    Sep 2012 Join Date
    136Posts

    SQL Error Fix for v117 Public Source (SourceDEV)


    RaGEZONE Recommends

    RaGEZONE Recommends

    Find :

    Code:
    PreparedStatement psa = con.prepareStatement("INSERT INTO wz_itemadddata(itemid, `key`, value1, value2) VALUES (?, ?, ?, ?)");
    Replace

    Code:
    PreparedStatement psa = con.prepareStatement("INSERT INTO wz_itemadddata(itemid, `key`, `subKey`, `value`) VALUES (?, ?, ?, ?)");
    this should fix any items dump error,have no idea why it was like this it might be noob proof to stop noob who dont know Java..

    I dont give any ratass about the what goes on anymore it is boring and full of leechers..


  2. #2
    Account Upgraded | Title Enabled! avivii12345 is offline
    True MemberRank
    Jan 2012 Join Date
    276Posts

    Re: SQL Error Fix for v117 Public Source (SourceDEV)

    Very simple..

  3. #3
    Account Inactive smashman186 is offline
    InactiveRank
    Feb 2010 Join Date
    15Posts

    Re: SQL Error Fix for v117 Public Source (SourceDEV)

    Where do i search for this? I cant find preparedstatement psa anywhere...In the sql, or in the scr folder or in the dist folders (Inside every file also)

  4. #4
    Member mintdc12 is offline
    MemberRank
    Feb 2011 Join Date
    61Posts

    Re: SQL Error Fix for v117 Public Source (SourceDEV)

    Quote Originally Posted by smashman186 View Post
    Where do i search for this? I cant find preparedstatement psa anywhere...In the sql, or in the scr folder or in the dist folders (Inside every file also)
    I have the same problem i cant find "preparedstatement"

  5. #5
    Account Inactive EhDaPRo is offline
    InactiveRank
    Jan 2013 Join Date
    23Posts

    Re: SQL Error Fix for v117 Public Source (SourceDEV)

    Quote Originally Posted by avivii12345 View Post
    Very simple..
    Even if its Very Simple, Some Beginners maybe need this uhh

    Keep Up The Simple Work :)
    Good Job

    Quote Originally Posted by mintdc12 View Post
    I have the same problem i cant find "preparedstatement"
    You May find it on \src\tools\wztosql\dumpitems.java
    Have Fun With that

  6. #6
    Member mintdc12 is offline
    MemberRank
    Feb 2011 Join Date
    61Posts

    Re: SQL Error Fix for v117 Public Source (SourceDEV)

    Thanks but now i have this error

    Code:
    [Err] 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 '' at line 1
    [Err] CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `readable_cheatlog` AS select `a`.`name` AS `accountname`,`a`.`id` AS `accountid`,`c`.`name` AS `name`,`c`.`id` AS `characterid`,`cl`.`offense` AS `offense`,`cl`.`count` AS `count`,`cl`.`lastoffensetime` AS `lastoffensetime`,`cl`.`param` AS `param` from ((`cheatlog` `cl` join `characters` `c`) join `accounts` `a`) where ((`cl`.`id` = `c`.`id`) and (`a`.`id` = `c`.`accountid`) and (`a`.`banned` = 0) ;
    [Err] 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 'group by `cl`.`id` order by sum(`cl`.`count`) desc' at line 1
    [Err] CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `readable_last_hour_cheatlog` AS select `a`.`name` AS `accountname`,`a`.`id` AS `accountid`,`c`.`name` AS `name`,`c`.`id` AS `characterid`,sum(`cl`.`count`) AS `numrepos` from ((`cheatlog` `cl` join `characters` `c`) join `accounts` `a`) where ((`cl`.`id` = `c`.`id`) and (`a`.`id` = `c`.`accountid`) and (timestampdiff(HOUR,`cl`.`lastoffensetime`,now() < 1) and (`a`.`banned` = 0) group by `cl`.`id` order by sum(`cl`.`count`) desc ;
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------

  7. #7
    Account Inactive EhDaPRo is offline
    InactiveRank
    Jan 2013 Join Date
    23Posts

    Re: SQL Error Fix for v117 Public Source (SourceDEV)

    Umm But lol you dont need to edit sql in this fix lol :)




Advertisement