Jump to content
  • 0

What does this query error mean?


eppc0330

Question


  • Group:  Members
  • Topic Count:  28
  • Topics Per Day:  0.01
  • Content Count:  60
  • Reputation:   0
  • Joined:  11/17/18
  • Last Seen:  

1767598788_2019-10-20(5).thumb.png.7e9f668692524aeb76b7c7204534cf29.png

first I made knew database with heidisql

 

569671545_2019-10-20(6).thumb.png.8317c14ca9306e115fef6b115bd1e4b2.png

1633098688_2019-10-20(7).thumb.png.e3f3183e71694d33aae11a4b3d761b5d.png

open query files and play it

 

239331186_2019-10-20(8).thumb.png.43a03f25b79cbfd7e4d566c1d6bd36c3.png

then I got this error

 

Maybe it's not file problem I guess... some other setting problem? Because I have tested with several other pack, including file from github, and all of results are the errors.

I have no idea how to solve it...?

 

Thank you.

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  308
  • Reputation:   24
  • Joined:  11/26/12
  • Last Seen:  

Im Sorry i cant read Korean Language.. But it happen while importing all the sql files in your newly database?

Base on my experience (using WAMP SERVER for MySQL/PHP/APACHE) i always have error uploading the sql that has a more than 2.5Mb of file size... Because the maximum file to upload in MySQL each query is 2.5Mb.... If you want to upload more than that you have to change the maximum limit in your php.ini

post_max_size

memory_limit

upload_max_filesize

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  28
  • Topics Per Day:  0.01
  • Content Count:  60
  • Reputation:   0
  • Joined:  11/17/18
  • Last Seen:  

11 minutes ago, chatterboy said:

Im Sorry i cant read Korean Language.. But it happen while importing all the sql files in your newly database?

Base on my experience (using WAMP SERVER for MySQL/PHP/APACHE) i always have error uploading the sql that has a more than 2.5Mb of file size... Because the maximum file to upload in MySQL each query is 2.5Mb.... If you want to upload more than that you have to change the maximum limit in your php.ini

post_max_size

memory_limit

upload_max_filesize

Thanks for reply. I'll try it.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  477
  • Reputation:   269
  • Joined:  06/13/17
  • Last Seen:  

it has an outdated query. right now its just a warning. but in the future it will be an error ?

Edited by Haruka Mayumi
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  28
  • Topics Per Day:  0.01
  • Content Count:  60
  • Reputation:   0
  • Joined:  11/17/18
  • Last Seen:  

20 minutes ago, Haruka Mayumi said:

it has an outdated query. right now its just a warning. but in the future it will be an error ?

I solved it by using previous version MySQL. Thank you!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...