Can't execute batch file

Results 1 to 9 of 9
  1. #1
    Member Leriss is offline
    MemberRank
    Sep 2006 Join Date
    PolandLocation
    33Posts

    Can't execute batch file

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:25:01
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:25:20
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:25:33
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:25:59
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:27:14
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:33:31
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:34:36
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:35:19
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:35:24
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:35:25
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:35:25
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

    Query:
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

    Error occured at:2006-11-16 16:41:08
    Line no.:8
    Error Code: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1


    i get this error...i have mysql 5.0 server and sqlyog.


  2. #2
    Grand Master [lexx] is offline
    Grand MasterRank
    Nov 2004 Join Date
    LithuaniaLocation
    4,620Posts
    all those errors are on the same line, so I don't see your point of posting it 15 times or so...

    and there was a thread recently with the same issue. I don't remember the solution, but I think it was fixed. please search

  3. #3
    Member Leriss is offline
    MemberRank
    Sep 2006 Join Date
    PolandLocation
    33Posts
    I used navicat and it worked...but there are no NPC now...what can be the problem?

  4. #4
    Grand Master [lexx] is offline
    Grand MasterRank
    Nov 2004 Join Date
    LithuaniaLocation
    4,620Posts
    SDB not applied

  5. #5
    Member Leriss is offline
    MemberRank
    Sep 2006 Join Date
    PolandLocation
    33Posts
    i applied the 0.52 thingy.

  6. #6
    Member Leriss is offline
    MemberRank
    Sep 2006 Join Date
    PolandLocation
    33Posts
    Ok,i'be got the 2117 SDB,i must apply it to mangos or realmd?

  7. #7
    Grand Master [lexx] is offline
    Grand MasterRank
    Nov 2004 Join Date
    LithuaniaLocation
    4,620Posts
    Quote Originally Posted by Leriss View Post
    Ok,i'be got the 2117 SDB,i must apply it to mangos or realmd?
    db:mangos

  8. #8
    Member Leriss is offline
    MemberRank
    Sep 2006 Join Date
    PolandLocation
    33Posts
    i uploaded the 2117 revision but there are still no npc

    When im trying to execute 281 revision of 0.52 SDB it stops at 132 queries and doesnt want to run,why?
    Last edited by [lexx]; 16-11-06 at 06:54 PM.

  9. #9
    Elite Member anatem is offline
    Member +Rank
    Oct 2006 Join Date
    169Posts
    apply version before 281. 272 and 277 are stable. also if you get this error after applying database try reinstalling your mysql server



Advertisement